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 = SPY260918P00763000×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6d5093ad-3bd0-4837-9c8f-38bc56dd6a8a | 2026-09-18 16:03 | 2026-09-18 16:03 | 2026-09-18 16:03 | SPY | SPY260918P00763000 | put | 763.0000 | 2026-09-18 | 0.6500 | 0.6400 | 0.6900 | 762.0000 | 128179.00 | 60061.00 | 44263.00 | 1968 | 35 | 43209 | 15755 | 2.74255791812123 | 0.351427808790338 | 0.306187419032683 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 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 |
| db924a11-6768-49e6-b1d1-6ce3931302c1 | 2026-09-18 10:54 | 2026-09-18 10:54 | 2026-09-18 10:54 | SPY | SPY260918P00763000 | put | 763.0000 | 2026-09-18 | 3.4400 | 3.4000 | 3.4300 | 759.7600 | 119286.00 | 119286.00 | 0.00 | 347 | 16 | 16455 | 15755 | 1.04443033957474 | 0.16124686009101 | 0.16124686009101 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 786947475942.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 5fd3bb13-2274-48ce-a620-cde21b3a4533 | 2026-09-17 15:59 | 2026-09-17 15:59 | 2026-09-17 15:59 | SPY | SPY260918P00763000 | put | 763.0000 | 2026-09-18 | 3.1000 | 3.1000 | 3.1700 | 762.0000 | 125614.00 | 315.00 | 125299.00 | 405 | 24 | 35003 | 5013 | 6.98244564133254 | 0.195620968319232 | 0.192482122158178 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 783069852881.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 5b82729c-ad7d-4a23-8c87-b41995949979 | 2026-09-17 15:58 | 2026-09-17 15:58 | 2026-09-17 15:58 | SPY | SPY260918P00763000 | put | 763.0000 | 2026-09-18 | 3.0500 | 3.0500 | 3.1300 | 763.0000 | 122000.00 | 0.00 | 122000.00 | 400 | 28 | 33787 | 5013 | 6.73987632156393 | 0.194183617221398 | 0.194183617221398 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 783069852881.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| c759ef0c-1da4-476c-b457-d11357ebd830 | 2026-09-11 15:50 | 2026-09-11 15:49 | 2026-09-11 15:49 | SPY | SPY260918P00763000 | put | 763.0000 | 2026-09-18 | 4.9300 | 4.9200 | 4.9400 | 764.7500 | 634491.00 | 129659.00 | 504832.00 | 1287 | 27 | 3734 | 4118 | 0.906750849927149 | 0.142698609756603 | 0.142698609756603 | 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-11T19:55:36.907305Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aa0a7a32-902b-4921-b116-07968acefe1d | 2026-09-11 15:49 | 2026-09-11 15:49 | 2026-09-11 15:49 | SPY | SPY260918P00763000 | put | 763.0000 | 2026-09-18 | 4.9300 | 4.9300 | 4.9500 | 764.7600 | 246993.00 | 0.00 | 246993.00 | 501 | 5 | 2447 | 4118 | 0.59422049538611 | 0.142802925435329 | 0.142802925435329 | false | 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-11T19:55:36.907305Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| eac6e95b-557c-4824-9798-cfbd677755d5 | 2026-09-09 09:51 | 2026-09-09 09:51 | 2026-09-09 09:51 | SPY | SPY260918P00763000 | put | 763.0000 | 2026-09-18 | 6.5400 | 6.5400 | 6.5600 | 763.7000 | 157614.00 | 0.00 | 157614.00 | 241 | 17 | 811 | 3821 | 0.212248102590945 | 0.151040165282111 | 0.151186316786576 | false | 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-09T13:57:31.693440Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dfb9101f-bada-4157-bd34-f240b06c6ab4 | 2026-09-01 14:17 | 2026-09-01 14:17 | 2026-09-01 14:17 | SPY | SPY260918P00763000 | put | 763.0000 | 2026-09-18 | 9.1600 | 9.1600 | 9.1900 | 761.4900 | 120055.00 | 0.00 | 120055.00 | 131 | 5 | 1491 | 3769 | 0.395595648713187 | 0.138766027620794 | 0.138613494520161 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 802935622223.00 | — | — | — | 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 |
| ea117e0f-d05d-43f8-8b20-602f70a9016d | 2026-09-01 13:02 | 2026-09-01 13:02 | 2026-09-01 13:02 | SPY | SPY260918P00763000 | put | 763.0000 | 2026-09-18 | 8.9000 | 8.9000 | 8.9300 | 761.9200 | 121040.00 | 0.00 | 121040.00 | 136 | 8 | 1202 | 3769 | 0.318917484743964 | 0.137879863336042 | 0.137879863336042 | 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-01T17:20:15.685951Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6471c19b-bf91-4230-9522-88341555fe76 | 2026-08-27 15:45 | 2026-08-27 15:45 | 2026-08-27 15:45 | SPY | SPY260918P00763000 | put | 763.0000 | 2026-09-18 | 5.8200 | 5.8000 | 5.8300 | 770.6800 | 115236.00 | 115236.00 | 0.00 | 198 | 5 | 790 | 3176 | 0.248740554156171 | 0.130878139268715 | 0.130878139268715 | 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-27T19:52:49.177007Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 921b15e1-71b7-44a1-a2b8-a16b70c40c9c | 2026-08-25 14:43 | 2026-08-25 14:43 | 2026-08-25 14:43 | SPY | SPY260918P00763000 | put | 763.0000 | 2026-09-18 | 8.5600 | 8.5400 | 8.5600 | 765.5600 | 501616.00 | 501616.00 | 0.00 | 586 | 10 | 1126 | 2552 | 0.441222570532915 | 0.136279837605107 | 0.136279837605107 | 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-25T18:54:14.733334Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |