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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c1cf4537-eecf-4349-9eb3-31beb33318b1 | 2026-09-18 14:55 | 2026-09-18 14:55 | 2026-09-18 14:55 | LION | LION261016P00008000 | put | 8.0000 | 2026-10-16 | 0.3500 | 0.3500 | 0.5500 | 10.9200 | 24500.00 | 0.00 | 3500.00 | 700 | 12 | 700 | 0 | 0 | 1.29816835337537 | 1.29816835337537 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 3195790963.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| ce2b9dd3-c7c3-4ac9-8b4f-a40479f4934a | 2026-09-14 15:55 | 2026-09-14 15:54 | 2026-09-14 15:54 | LION | LION261016C00012000 | call | 12.0000 | 2026-10-16 | 0.5500 | 0.5500 | 0.6500 | 11.0000 | 11000.00 | 0.00 | 2200.00 | 200 | 5 | 859 | 1199 | 0.716430358632194 | 0.489025028494732 | 0.489025028494732 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 737ff34a-d645-4468-a460-066cbb69f865 | 2026-09-14 15:53 | 2026-09-14 15:53 | 2026-09-14 15:53 | LION | LION261016C00012000 | call | 12.0000 | 2026-10-16 | 0.5500 | 0.5000 | 0.6500 | 11.0000 | 11000.00 | 2860.00 | 8140.00 | 200 | 9 | 259 | 1199 | 0.216013344453711 | 0.470349020666522 | 0.470349020666522 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 22dc69c8-32fa-4285-8b2d-a7f4f2120453 | 2026-09-14 10:06 | 2026-09-14 10:05 | 2026-09-14 10:05 | LION | LION261120C00012000 | call | 12.0000 | 2026-11-20 | 0.9000 | 0.7500 | 1.2000 | 11.3900 | 18000.00 | 5400.00 | 12060.00 | 200 | 13 | 1050 | 2531 | 0.414855788225998 | 0.571098943698039 | 0.574780750848574 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| be015653-fa8b-4357-8491-e05179fe9378 | 2026-09-14 10:04 | 2026-09-14 10:04 | 2026-09-14 10:04 | LION | LION261120C00012000 | call | 12.0000 | 2026-11-20 | 0.9000 | 0.9000 | 1.2000 | 11.4100 | 18000.00 | 0.00 | 18000.00 | 200 | 6 | 850 | 2531 | 0.335835638087712 | 0.569870565977783 | 0.569870565977783 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f70b5805-5d57-44e7-9eba-cb7dc19d777f | 2026-09-08 10:57 | 2026-09-08 10:57 | 2026-09-08 10:57 | LION | LION261120C00012000 | call | 12.0000 | 2026-11-20 | 0.9000 | 0.8000 | 1.2500 | 11.3150 | 18000.00 | 2160.00 | 15840.00 | 200 | 13 | 400 | 530 | 0.754716981132076 | 0.568378178061094 | 0.568378178061094 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 26e41945-aa5b-482d-b0ed-ea0f9a6730c4 | 2026-09-04 11:34 | 2026-09-04 11:34 | 2026-09-04 11:34 | LION | LION261120C00014000 | call | 14.0000 | 2026-11-20 | 0.3000 | 0.3000 | 0.4000 | 11.1500 | 12542.00 | 0.00 | 12542.00 | 418 | 14 | 725 | 10635 | 0.0681711330512459 | 0.535229219945561 | 0.528615370022424 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:46:11.944585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5b385af4-e4c4-4a08-8a20-c13dbeaa0b2b | 2026-08-26 12:06 | 2026-08-26 12:06 | 2026-08-26 12:06 | LION | LION261120C00014000 | call | 14.0000 | 2026-11-20 | 0.8000 | 0.5000 | 0.8500 | 11.6500 | 145440.00 | 145440.00 | 0.00 | 1818 | 2 | 1819 | 8816 | 0.206329401088929 | 0.685995608041138 | 0.685995608041138 | false | true | true | false | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e3d8caf1-8131-4d2a-986b-2669fe4333b9 | 2026-08-20 13:39 | 2026-08-20 13:39 | 2026-08-20 13:39 | LION | LION260918C00012000 | call | 12.0000 | 2026-09-18 | 0.5000 | 0.5000 | 0.6500 | 11.5900 | 10000.00 | 0.00 | 10000.00 | 200 | 9 | 1689 | 2271 | 0.743725231175694 | 0.506772770959525 | 0.506772770959525 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4120e5ef-2883-431f-8733-4d14a247714f | 2026-08-20 13:38 | 2026-08-20 13:38 | 2026-08-20 13:38 | LION | LION260918C00012000 | call | 12.0000 | 2026-09-18 | 0.5000 | 0.5000 | 0.6500 | 11.5900 | 10000.00 | 0.00 | 10000.00 | 200 | 11 | 1289 | 2271 | 0.567591369440775 | 0.506772770959525 | 0.506772770959525 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4af85838-d1e9-44df-ad1f-87474dee45f2 | 2026-08-20 13:38 | 2026-08-20 13:38 | 2026-08-20 13:38 | LION | LION260918C00012000 | call | 12.0000 | 2026-09-18 | 0.5000 | 0.3500 | 0.6500 | 11.5900 | 10000.00 | 0.00 | 9000.00 | 200 | 6 | 1089 | 2271 | 0.479524438573316 | 0.506772770959525 | 0.506772770959525 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5d89c60d-40cd-4cc5-8422-8ab3c697f939 | 2026-08-20 13:37 | 2026-08-20 13:37 | 2026-08-20 13:37 | LION | LION260918C00012000 | call | 12.0000 | 2026-09-18 | 0.5000 | 0.3000 | 0.6500 | 11.6400 | 10000.00 | 1800.00 | 250.00 | 200 | 11 | 489 | 2271 | 0.215323645970938 | 0.489603223207782 | 0.489603223207782 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9e160bb9-3f98-4bf7-8854-c3fc07123b44 | 2026-08-18 13:17 | 2026-08-18 13:17 | 2026-08-18 13:17 | LION | LION260918C00012000 | call | 12.0000 | 2026-09-18 | 0.8000 | 0.7000 | 0.9500 | 12.0500 | 17360.00 | 0.00 | 17360.00 | 217 | 7 | 638 | 1531 | 0.416721097322012 | 0.541275198231764 | 0.541275198231764 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 3460619078.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |