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
active:option_symbol = SPY261016C00775000×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6376ab49-0f0e-45b9-a91e-dea175550597 | 2026-09-18 15:59 | 2026-09-18 15:59 | 2026-09-18 15:59 | SPY | SPY261016C00775000 | call | 775.0000 | 2026-10-16 | 4.6200 | 4.6100 | 4.6500 | 761.0000 | 162624.00 | 0.00 | 162624.00 | 352 | 10 | 3049 | 13145 | 0.23195131228604 | 0.106795916417336 | 0.106817138179638 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 786947475942.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 23b19369-4735-4146-aecf-7d3bf8906079 | 2026-09-11 09:55 | 2026-09-11 09:55 | 2026-09-11 09:55 | SPY | SPY261016C00775000 | call | 775.0000 | 2026-10-16 | 7.7500 | 7.7200 | 7.7500 | 765.0000 | 118575.00 | 118575.00 | 0.00 | 153 | 7 | 340 | 16627 | 0.0204486678294341 | 0.11411314896232 | 0.114046718509915 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 810275044553.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c866b256-657b-4938-aa8b-f043f6e8f53d | 2026-09-09 09:30 | 2026-09-09 09:30 | 2026-09-09 09:30 | SPY | SPY261016C00775000 | call | 775.0000 | 2026-10-16 | 7.5600 | 7.5600 | 7.6100 | 763.5700 | 238281.00 | 35673.00 | 202608.00 | 315 | 11 | 316 | 15977 | 0.0197784314952745 | 0.115617879669664 | 0.115380147115386 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 810275044553.00 | — | — | — | 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 |
| b169a154-b76e-4f20-bf36-8462413d03d6 | 2026-09-08 13:16 | 2026-09-08 13:16 | 2026-09-08 13:16 | SPY | SPY261016C00775000 | call | 775.0000 | 2026-10-16 | 9.2300 | 9.2300 | 9.2600 | 767.6500 | 111683.00 | 0.00 | 111683.00 | 121 | 6 | 1268 | 15265 | 0.0830658368817556 | 0.113134299844186 | 0.113134299844186 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 810275044553.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 48d466e8-54ab-4343-8409-606720ce0ae6 | 2026-09-08 09:40 | 2026-09-08 09:40 | 2026-09-08 09:40 | SPY | SPY261016C00775000 | call | 775.0000 | 2026-10-16 | 9.6200 | 9.5900 | 9.6200 | 767.9100 | 206830.00 | 206830.00 | 0.00 | 215 | 10 | 334 | 15265 | 0.0218801179168031 | 0.115917533393637 | 0.115917533393637 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 802935622223.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 511a20d2-e162-49cc-bec2-f3d344fa7339 | 2026-09-04 11:00 | 2026-09-04 11:00 | 2026-09-04 11:00 | SPY | SPY261016C00775000 | call | 775.0000 | 2026-10-16 | 10.3700 | 10.3400 | 10.3700 | 769.4500 | 386801.00 | 386801.00 | 0.00 | 373 | 7 | 753 | 15182 | 0.0495982084046898 | 0.109104483365081 | 0.109104483365081 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 802935622223.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3fbf6328-22d1-4d49-8367-a53f14ba29b5 | 2026-08-20 15:05 | 2026-08-20 15:05 | 2026-08-20 15:05 | SPY | SPY261016C00775000 | call | 775.0000 | 2026-10-16 | 11.7200 | 11.6900 | 11.7200 | 763.3650 | 145328.00 | 145328.00 | 0.00 | 124 | 6 | 531 | 4186 | 0.126851409460105 | 0.123886103343378 | 0.123886103343378 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 802935622223.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |