core.flow_alerts
Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.
Simplify Analyticsuw_flow_alerts474,253 rowsrestricted — hover for the licence| iduuid | created_at ↑timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric | expirydate | price |
|---|
| bidnumeric |
|---|
| asknumeric |
|---|
| underlying_pricenumeric |
|---|
| total_premiumnumeric |
|---|
| total_ask_side_premnumeric |
|---|
| total_bid_side_premnumeric |
|---|
| total_sizebigint |
|---|
| trade_countinteger |
|---|
| volumebigint |
|---|
| open_interestbigint |
|---|
| volume_oi_rationumeric |
|---|
| iv_startnumeric |
|---|
| iv_endnumeric |
|---|
| has_sweepboolean |
|---|
| has_floorboolean |
|---|
| has_multilegboolean |
|---|
| has_singlelegboolean |
|---|
| all_opening_tradesboolean |
|---|
| alert_ruletext |
|---|
| rule_iduuid |
|---|
| expiry_countinteger |
|---|
| issue_typetext |
|---|
| sectortext |
|---|
| marketcapnumeric |
|---|
| next_earnings_datedate |
|---|
| er_timetext |
|---|
| missing_periscopeboolean |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 70db16e8-dad0-45c0-b232-26d67dcadaff | 2026-09-18 15:10 | 2026-09-18 15:10 | 2026-09-18 15:10 | TECL | TECL270115C00210000 | call | 210.0000 | 2027-01-15 | 32.0000 | 32.0000 | 33.0000 | 208.2300 | 320000.00 | 0.00 | 320000.00 | 100 | 11 | 107 | 97 | 1.10309278350515 | 0.668717173616656 | 0.668717173616656 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 5895795000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 3d6dc897-e056-49ef-b2cc-596e8835cf91 | 2026-09-21 12:59 | 2026-09-21 12:59 | 2026-09-21 12:59 | TECL | TECL270319C00270000 | call | 270.0000 | 2027-03-19 | 29.3000 | 27.5000 | 30.2000 | 226.6000 | 14650.00 | 2930.00 | 11720.00 | 5 | 5 | 5 | 8 | 0.625 | 0.674569739085929 | 0.674569739085929 | false | false | false | true | false | |||||||||||||||
| 9300d6d2-7311-4f6b-b5b3-dabfba6ce919 | 2026-09-21 14:23 | 2026-09-21 14:23 | 2026-09-21 14:23 | TECL | TECL261016P00225000 | put | 225.0000 | 2026-10-16 | 14.2000 | 14.2000 | 14.4000 | 227.9000 | 42600.00 | 0.00 | 42600.00 | 30 | 6 | 42 | 98 | 0.428571428571429 | 0.674031097293003 | 0.674031097293003 | false | false | false | true | false | |||||||||||||||
| ae1e795d-46c2-4d68-b7f0-a862e3c29b11 | 2026-09-21 14:41 | 2026-09-21 14:41 | 2026-09-21 14:41 | TECL | TECL261016P00225000 | put | 225.0000 | 2026-10-16 | 14.1000 | 14.1000 | 14.3000 | 228.2500 | 26790.00 | 0.00 | 26790.00 | 19 | 6 | 124 | 98 | 1.26530612244898 | 0.676162130219562 | 0.676162130219562 | false | false | false | true | false | |||||||||||||||
| 1c30ce51-9908-4768-ac12-1297351a97b1 | 2026-09-22 10:41 | 2026-09-22 10:41 | 2026-09-22 10:41 | TECL | TECL261016P00230000 | put | 230.0000 | 2026-10-16 | 15.1000 | 14.4000 | 15.4000 | 230.4601 | 15100.00 | 6040.00 | 9060.00 | 10 | 5 | 97 | 86 | 1.12790697674419 | 0.665021138597033 | 0.665021138597033 | false | false | false | true | false | |||||||||||||||
| b8e9076d-c510-4656-96d2-da6eba150cad | 2026-09-22 10:41 | 2026-09-22 10:41 | 2026-09-22 10:41 | TECL | TECL261120C00197000 | call | 197.0000 | 2026-11-20 | 45.8000 | 45.7000 | 47.8000 | 230.1600 | 32060.00 | 18320.00 | 13740.00 | 7 | 6 | 7 | 0 | 0 | 0.732201457022547 | 0.732201457022547 | false | false | false | true | false | |||||||||||||||
| 9cddbc3a-edce-43dd-84b2-7bbae9fd7133 | 2026-09-22 10:46 | 2026-09-22 10:46 | 2026-09-22 10:46 | TECL | TECL261016C00225000 | call | 225.0000 | 2026-10-16 | 17.9000 | 17.9000 | 20.0000 | 229.9900 | 10740.00 | 0.00 | 10740.00 | 6 | 6 | 9 | 246 | 0.0365853658536585 | 0.643864828641934 | 0.643864828641934 | false | false | false | true | false | |||||||||||||||
| 743132bb-950a-44c4-9f1e-deb457e9371d | 2026-09-22 11:21 | 2026-09-22 11:21 | 2026-09-22 11:21 | TECL | TECL280121C00300000 | call | 300.0000 | 2028-01-21 | 60.1000 | 57.5000 | 62.5000 | 230.8900 | 1202000.00 | 1202000.00 | 0.00 | 200 | 2 | 200 | 217 | 0.921658986175115 | 0.726623551455097 | 0.726623551455097 | false | true | true | false | false | |||||||||||||||
| a24670f7-d650-47a4-978a-97830ceb9e67 | 2026-09-22 12:51 | 2026-09-22 12:51 | 2026-09-22 12:51 | TECL | TECL270115P00200000 | put | 200.0000 | 2027-01-15 | 21.5900 | 21.0000 | 22.3000 | 232.4800 | 21586.00 | 0.00 | 21586.00 | 10 | 9 | 18 | 46 | 0.391304347826087 | 0.765156049683439 | 0.765156049683439 | false | false | false | true | false | |||||||||||||||
| eafe9104-f906-4e8a-84f9-03ad7b0a2795 | 2026-09-22 13:07 | 2026-09-22 13:06 | 2026-09-22 13:06 | TECL | TECL261016P00235000 | put | 235.0000 | 2026-10-16 | 16.3400 | 16.3000 | 19.0000 | 232.4200 | 49014.00 | 0.00 | 49014.00 | 30 | 8 | 30 | 6 | 5 | 0.641318636329123 | 0.657309487389266 | false | false | false | true | false | |||||||||||||||
| 731acdb1-7a30-4b2d-ab71-1c01d1785204 | 2026-09-23 13:43 | 2026-09-23 13:43 | 2026-09-23 13:43 | TECL | TECL261016C00200000 | call | 200.0000 | 2026-10-16 | 36.0000 | 35.0000 | 37.1000 | 229.0000 | 594000.00 | 442800.00 | 151200.00 | 165 | 26 | 166 | 454 | 0.365638766519824 | 0.778730037979359 | 0.778730037979359 | false | false | false | true | false | |||||||||||||||
| 96981b56-118e-4a33-bd11-513e73e7586c | 2026-09-24 12:15 | 2026-09-24 12:15 | 2026-09-24 12:15 | TECL | TECL261016P00200000 | put | 200.0000 | 2026-10-16 | 6.8000 | 6.8000 | 7.7000 | 224.5200 | 14280.00 | 0.00 | 14280.00 | 21 | 9 | 33 | 225 | 0.146666666666667 | 0.789442338743436 | 0.789442338743436 | true | false | false | true | false | |||||||||||||||
| 9774b138-813a-4dfe-9891-8b144d7e8f96 | 2026-09-25 10:24 | 2026-09-25 10:24 | 2026-09-25 10:24 | TECL | TECL261016C00240000 | call | 240.0000 | 2026-10-16 | 12.2000 | 10.8000 | 12.2000 | 231.7270 | 56120.00 | 56120.00 | 0.00 | 46 | 5 | 47 | 150 | 0.313333333333333 | 0.699971203655572 | 0.699971203655572 | false | false | false | true | false | |||||||||||||||
| 4367945a-1d58-4265-b29e-f4fa3702947b | 2026-09-25 14:24 | 2026-09-25 14:24 | 2026-09-25 14:24 | TECL | TECL261120P00180000 | put | 180.0000 | 2026-11-20 | 8.5000 | 8.5000 | 8.9000 | 236.2500 | 10200.00 | 0.00 | 3400.00 | 12 | 12 | 17 | 54 | 0.314814814814815 | 0.887370530413159 | 0.887370530413159 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6024900000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6024900000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:23:56.707397Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6024900000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:42:48.011261Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6550155000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:42:44.065275Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6550155000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:42:44.065275Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6550155000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:48:37.826382Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| d9769fb4-003b-49e4-9181-c78c9cc101f5 |
| 1 |
| ETF |
| — |
| 6550155000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:21:55.684470Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 6550155000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:52:20.560244Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 6550155000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:14:46.677665Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6691515000.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:45:14.864344Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6583500000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:15:47.773676Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6533055000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6533055000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:27:02.000981Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |