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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6cdaec78-a658-4e29-abc2-d3ea064cf340 | 2026-08-19 15:12 | 2026-08-19 15:12 | 2026-08-19 15:12 | GRPN | GRPN261016C00025000 | call | 25.0000 | 2026-10-16 | 1.1100 | 1.0500 | 1.2000 | 20.6900 | 11116.00 | 0.00 | 11116.00 | 100 | 8 | 106 | 1069 | 0.0991580916744621 | 0.752238170974577 | 0.752238170974577 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 777113807.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 73fb6985-da63-4684-ab0b-8ac6bb77f491 | 2026-08-20 09:40 | 2026-08-20 09:40 | 2026-08-20 09:40 | GRPN | GRPN270115C00023000 | call | 23.0000 | 2027-01-15 | 2.9600 | 2.7000 | 3.7000 | 19.4600 | 11854.00 | 0.00 | 11854.00 | 40 | 5 | 40 | 95 | 0.421052631578947 | 0.829448129334462 | 0.829448129334462 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 777113807.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2a40727f-6b3a-48ee-b06e-1b4e2f986071 | 2026-08-20 15:31 | 2026-08-20 15:31 | 2026-08-20 15:31 | GRPN | GRPN261218C00025000 | call | 25.0000 | 2026-12-18 | 2.1100 | 2.0500 | 2.2000 | 19.5010 | 19160.00 | 0.00 | 11390.00 | 91 | 9 | 2751 | 54 | 50.9444444444444 | 0.843613832622651 | 0.843613832622651 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 777113807.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0cc7ac05-a8aa-4cf4-96ee-c4305edd73c8 | 2026-08-25 14:32 | 2026-08-25 14:32 | 2026-08-25 14:32 | GRPN | GRPN261016C00023000 | call | 23.0000 | 2026-10-16 | 1.2100 | 1.1500 | 1.2500 | 19.8400 | 19478.00 | 3660.00 | 15818.00 | 161 | 30 | 1090 | 826 | 1.31961259079903 | 0.763792866562085 | 0.763792866562085 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 777113807.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T18:54:14.733334Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c4efdaa3-16bd-4c0a-858a-58908c20d219 | 2026-08-25 15:55 | 2026-08-25 15:55 | 2026-08-25 15:55 | GRPN | GRPN261016C00023000 | call | 23.0000 | 2026-10-16 | 1.1200 | 1.1000 | 1.1500 | 19.7800 | 29289.00 | 9061.00 | 20228.00 | 261 | 54 | 1569 | 826 | 1.89951573849879 | 0.746434286509474 | 0.735607624119522 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 777113807.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ef773311-08d6-4339-8ae8-f4b1fcfca61a | 2026-09-01 11:24 | 2026-09-01 11:24 | 2026-09-01 11:24 | GRPN | GRPN260918C00017000 | call | 17.0000 | 2026-09-18 | 2.1000 | 1.9500 | 2.1000 | 18.5595 | 239590.00 | 239590.00 | 0.00 | 1141 | 47 | 1141 | 232 | 4.91810344827586 | 0.741270099635588 | 0.741270099635588 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 777113807.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e215f22a-9693-4723-ad7b-a1e6f095d2a1 | 2026-09-01 14:17 | 2026-09-01 14:17 | 2026-09-01 14:17 | GRPN | GRPN261218C00025000 | call | 25.0000 | 2026-12-18 | 1.4000 | 1.3500 | 1.4500 | 18.3450 | 13900.00 | 0.00 | 13200.00 | 99 | 5 | 269 | 7567 | 0.0355490947535351 | 0.819144770227801 | 0.819144770227801 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 777113807.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8eaad0e0-6dda-4872-9e2d-c821b5ee0116 | 2026-09-18 15:21 | 2026-09-18 15:20 | 2026-09-18 15:20 | GRPN | GRPN270115C00020000 | call | 20.0000 | 2027-01-15 | 2.8100 | 2.7000 | 3.2000 | 18.5000 | 14071.00 | 0.00 | 14071.00 | 50 | 6 | 51 | 2548 | 0.0200156985871272 | 0.796818074766788 | 0.796818074766788 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 775893848.00 | 2026-11-05 | unknown | — | 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 |