Options flow alerts (market-wide)
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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 | pricenumeric | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 594b6143-fa44-4589-ac1a-11cd2d93b4de | 2026-08-17 10:09 | 2026-08-17 10:09 | 2026-08-17 10:09 | TSLA | TSLA261016C00350000 | call | 350.0000 | 2026-10-16 | 19.0000 | 18.8500 | 19.0500 | 339.4000 | 114000.00 | 45600.00 | 57000.00 | 60 | 9 | 176 | 3770 | 0.046684350132626 | 0.413663108977169 | 0.413663108977169 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 246db3d1-3077-4626-99d7-c9ebdecc9968 | 2026-08-17 10:09 | 2026-08-17 10:09 | 2026-08-17 10:09 | TSLA | TSLA261016C00350000 | call | 350.0000 | 2026-10-16 | 19.0000 | 18.9000 | 19.0500 | 339.3900 | 190000.00 | 171000.00 | 19000.00 | 100 | 8 | 276 | 3770 | 0.073209549071618 | 0.413749837762472 | 0.413749837762472 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9bbe7c25-5e92-426a-9e3c-267acd86565b | 2026-08-17 10:14 | 2026-08-17 10:14 | 2026-08-17 10:14 | TSLA | TSLA261016C00350000 | call | 350.0000 | 2026-10-16 | 18.6500 | 18.5500 | 18.7000 | 338.7400 | 149200.00 | 130550.00 | 18650.00 | 80 | 13 | 377 | 3770 | 0.1 | 0.412659828496726 | 0.412969815638439 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 64cd5327-656c-4d29-b9fc-72e3c4eed677 | 2026-08-19 10:15 | 2026-08-19 10:15 | 2026-08-19 10:15 | TSLA | TSLA261016C00350000 | call | 350.0000 | 2026-10-16 | 18.3000 | 18.3000 | 18.4500 | 338.3100 | 183000.00 | 0.00 | 183000.00 | 100 | 13 | 457 | 4048 | 0.112895256916996 | 0.417764684666807 | 0.417764684666807 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 511d770f-c1bb-4007-8488-5c55d81202dc | 2026-08-21 13:55 | 2026-08-21 13:55 | 2026-08-21 13:55 | TSLA | TSLA261016C00350000 | call | 350.0000 | 2026-10-16 | 32.1000 | 31.8500 | 32.2000 | 363.0850 | 128400.00 | 35310.00 | 93090.00 | 40 | 5 | 1118 | 3790 | 0.294986807387863 | 0.428649740928919 | 0.428649740928919 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0e0c6c40-275d-407c-a902-69825e3a84a6 | 2026-08-24 14:24 | 2026-08-24 14:24 | 2026-08-24 14:24 | TSLA | TSLA261016C00350000 | call | 350.0000 | 2026-10-16 | 24.8500 | 24.6500 | 24.9500 | 353.3400 | 745500.00 | 745500.00 | 0.00 | 300 | 10 | 507 | 3668 | 0.138222464558342 | 0.415286771979336 | 0.415286771979336 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f2f0f5b8-0280-4eda-b9fb-ad8421c654f9 | 2026-09-08 15:53 | 2026-09-08 15:53 | 2026-09-08 15:53 | TSLA | TSLA261016C00350000 | call | 350.0000 | 2026-10-16 | 30.9000 | 30.7500 | 31.1000 | 368.2950 | 154500.00 | 27810.00 | 126690.00 | 50 | 12 | 1149 | 4282 | 0.268332554880897 | 0.423537170464592 | 0.423537170464592 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |