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.
uw_flow_alerts609,118 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 |
|---|
| 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 |
|---|
| ffc836d1-a88a-4011-bc5c-bd84c1bacd99 | 2026-09-25 15:00 | 2026-09-25 15:00 | 2026-09-25 15:00 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 4.9300 | 4.9300 | 4.9500 | 770.0000 | 28594.00 | 0.00 | 28594.00 | 58 | 13 | 8334 | 13303 | 0.626475231150868 | 0.109540225102635 | 0.109540225102635 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 818687275738.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:03:13.684497Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 26d1dd41-e876-4d93-9dbd-9e61b59493ee | 2026-09-28 10:40 | 2026-09-28 10:40 | 2026-09-28 10:40 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 3.2700 | 3.2700 | 3.2900 | 766.3600 | 17985.00 | 0.00 | 17985.00 | 55 | 8 | 4342 | 17109 | 0.253784557835058 | 0.115206863093272 | 0.115206863093272 | false | false | false | true | ||||||||||||||||
| 54199f83-2c96-4969-8d8b-b3470514326c | 2026-09-28 10:45 | 2026-09-28 10:45 | 2026-09-28 10:45 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.9800 | 2.9800 | 3.0000 | 765.0800 | 11026.00 | 0.00 | 11026.00 | 37 | 5 | 4452 | 17109 | 0.260213922496931 | 0.116083853072605 | 0.116083853072605 | false | false | false | true | ||||||||||||||||
| 45d73b07-1ba6-4a37-8688-b0be60467ba4 | 2026-09-28 11:24 | 2026-09-28 11:24 | 2026-09-28 11:24 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.8800 | 2.8800 | 2.9000 | 764.0000 | 40896.00 | 0.00 | 40896.00 | 142 | 7 | 7131 | 17109 | 0.416798176398387 | 0.115726711516834 | 0.115726711516834 | false | false | false | true | ||||||||||||||||
| b92b0a94-d4a4-46ea-8086-19c2720bb3f0 | 2026-09-28 12:21 | 2026-09-28 12:21 | 2026-09-28 12:21 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 3.5500 | 3.5500 | 3.5700 | 767.4650 | 99400.00 | 0.00 | 99400.00 | 280 | 26 | 7576 | 17109 | 0.442807878894149 | 0.114627955931717 | 0.114627955931717 | true | false | false | true | ||||||||||||||||
| 53717e11-006f-4e63-b5a6-b8075a45bc21 | 2026-09-29 10:08 | 2026-09-29 10:08 | 2026-09-29 10:08 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.7500 | 2.7400 | 2.7500 | 764.7600 | 27500.00 | 27500.00 | 0.00 | 100 | 6 | 506 | 17546 | 0.028838481705232 | 0.116978620389862 | 0.116978620389862 | false | false | false | true | ||||||||||||||||
| a90aa83a-72a8-4aa2-8928-7c04e615632c | 2026-09-29 10:09 | 2026-09-29 10:09 | 2026-09-29 10:09 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.7500 | 2.7300 | 2.7500 | 764.9300 | 17050.00 | 17050.00 | 0.00 | 62 | 5 | 573 | 17546 | 0.032657015844067 | 0.116177002652279 | 0.116177002652279 | false | false | false | true | ||||||||||||||||
| d145b673-8a7e-41e6-83a4-42129c59a0c3 | 2026-09-29 10:11 | 2026-09-29 10:11 | 2026-09-29 10:11 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.7000 | 2.6900 | 2.7000 | 764.0000 | 98820.00 | 98820.00 | 0.00 | 366 | 13 | 1078 | 17546 | 0.0614385045024507 | 0.11544649188834 | 0.11544649188834 | true | false | false | true | ||||||||||||||||
| e2a08a2e-c5df-46e3-9888-b93025c312e9 | 2026-09-29 10:13 | 2026-09-29 10:13 | 2026-09-29 10:13 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.8000 | 2.7900 | 2.8000 | 765.0000 | 40320.00 | 40320.00 | 0.00 | 144 | 13 | 1296 | 17546 | 0.0738629887153767 | 0.115381991655241 | 0.115381991655241 | true | false | false | true | ||||||||||||||||
| f520534f-df68-4ccc-a074-d7cb1047dc9c | 2026-09-29 10:21 | 2026-09-29 10:20 | 2026-09-29 10:20 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.7000 | 2.6900 | 2.7000 | 764.8899 | 16200.00 | 16200.00 | 0.00 | 60 | 6 | 1612 | 17546 | 0.0918727915194346 | 0.115399952099089 | 0.115399952099089 | false | false | false | true | ||||||||||||||||
| 3b329395-6cfd-478e-a77c-3e8c4705e91b | 2026-09-29 10:51 | 2026-09-29 10:51 | 2026-09-29 10:51 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.7300 | 2.7300 | 2.7400 | 764.9300 | 12831.00 | 0.00 | 12831.00 | 47 | 17 | 2042 | 17546 | 0.116379801664197 | 0.115744097068957 | 0.115791236692301 | false | false | false | true | ||||||||||||||||
| 8709dbba-a4c4-4516-9469-fe52f715713b | 2026-09-29 11:09 | 2026-09-29 11:09 | 2026-09-29 11:09 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.5300 | 2.5200 | 2.5300 | 764.0000 | 12650.00 | 12650.00 | 0.00 | 50 | 5 | 2471 | 17546 | 0.140829818762111 | 0.115870731811169 | 0.115870731811169 | false | false | false | true | ||||||||||||||||
| b17f14dd-e622-40b8-97e5-a691c263b289 | 2026-09-29 12:41 | 2026-09-29 12:40 | 2026-09-29 12:40 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.2700 | 2.2600 | 2.2700 | 763.1100 | 14982.00 | 14982.00 | 0.00 | 66 | 5 | 4530 | 17546 | 0.258178502222729 | 0.11509097939231 | 0.114912835654337 | false | false | false | true | ||||||||||||||||
| 6af708aa-0c2f-4051-8cbc-3db14e77fa4c | 2026-09-29 12:47 | 2026-09-29 12:47 | 2026-09-29 12:47 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.2700 | 2.2600 | 2.2700 | 762.8700 | 11350.00 | 11350.00 | 0.00 | 50 | 5 | 4611 | 17546 | 0.26279493901744 | 0.115980565785329 | 0.115980565785329 | false | false | false | true | ||||||||||||||||
| 2fc731f3-0e17-4b58-9f9a-3e322ea3f9b8 | 2026-09-29 14:22 | 2026-09-29 14:22 | 2026-09-29 14:22 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.5300 | 2.5100 | 2.5300 | 764.0000 | 18469.00 | 18469.00 | 0.00 | 73 | 5 | 5167 | 17546 | 0.294483073065086 | 0.1154567555473 | 0.1154567555473 | false | false | false | true | ||||||||||||||||
| 7cea7ba5-de7d-45d0-bcbb-d00044e48ce5 | 2026-09-29 14:39 | 2026-09-29 14:39 | 2026-09-29 14:39 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.7000 | 2.7000 | 2.7200 | 764.0000 | 35910.00 | 0.00 | 35910.00 | 133 | 7 | 5445 | 17546 | 0.310327140088909 | 0.11539948197124 | 0.11539948197124 | false | false | false | true | ||||||||||||||||
| 4c9a8298-8f7c-4e3f-bfd2-f22e8073bef7 | 2026-09-29 14:39 | 2026-09-29 14:39 | 2026-09-29 14:39 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.6700 | 2.6700 | 2.6900 | 764.0000 | 77430.00 | 0.00 | 77430.00 | 290 | 15 | 5736 | 17546 | 0.32691211672176 | 0.115146459649719 | 0.115146459649719 | false | false | false | true | ||||||||||||||||
| 5ff45558-3a37-4f5e-9cd9-a90cb7d2cffa | 2026-09-30 10:01 | 2026-09-30 10:01 | 2026-09-30 10:01 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 3.5000 | 3.4900 | 3.5100 | 768.5700 | 21000.00 | 3500.00 | 0.00 | 60 | 6 | 735 | 19501 | 0.0376903748525717 | 0.115684420968574 | 0.115684420968574 | false | false | false | true | ||||||||||||||||
| 1e8feccb-6c90-4e3f-97dd-1ab3740e34ce | 2026-09-30 10:24 | 2026-09-30 10:24 | 2026-09-30 10:24 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 3.5200 | 3.5200 | 3.5300 | 768.4500 | 24992.00 | 0.00 | 24992.00 | 71 | 5 | 1162 | 19501 | 0.0595866878621609 | 0.116685255014181 | 0.116685255014181 | false | false | false | true | ||||||||||||||||
| 21a01e95-8e52-4ee7-9234-ee1cd63d59d9 | 2026-09-30 11:11 | 2026-09-30 11:11 | 2026-09-30 11:11 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 3.5000 | 3.5000 | 3.5100 | 768.3100 | 50050.00 | 0.00 | 50050.00 | 143 | 7 | 1839 | 19501 | 0.0943028562637813 | 0.117075682180049 | 0.117075682180049 | false | false | false | true | ||||||||||||||||
| 924853a9-4b66-4b2b-95ec-9dc781927310 | 2026-09-30 15:44 | 2026-09-30 15:44 | 2026-09-30 15:44 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.7700 | 2.7600 | 2.7800 | 765.7400 | 339325.00 | 20498.00 | 224647.00 | 1225 | 21 | 4288 | 19501 | 0.219886159684119 | 0.116593554440094 | 0.116593554440094 | false | false | false | true | ||||||||||||||||
| 6a19725c-9703-40ed-aae1-3cbd77ddbc4b | 2026-09-30 15:44 | 2026-09-30 15:44 | 2026-09-30 15:44 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.7700 | 2.7600 | 2.7700 | 765.7300 | 35733.00 | 35733.00 | 0.00 | 129 | 10 | 4417 | 19501 | 0.226501205066407 | 0.116642721426978 | 0.116642721426978 | false | false | false | true | ||||||||||||||||
| 0476d6fa-ce17-46bb-9e29-603462d53793 | 2026-09-30 15:44 | 2026-09-30 15:44 | 2026-09-30 15:44 | SPY | SPY261016C00780000 | call | 780.0000 | 2026-10-16 | 2.7700 | 2.7600 | 2.7700 | 765.7200 | 144317.00 | 144317.00 | 0.00 | 521 | 14 | 5063 | 19501 | 0.259627711399415 | 0.116691881963347 | 0.116691881963347 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 817157925289.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:42:23.543990Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 817157925289.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:45:44.474621Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 817157925289.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:26:10.967927Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 817157925289.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:23:11.774661Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:10:17.656675Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:10:17.656675Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:13:29.737020Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:13:29.737020Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:23:29.656550Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:54:53.700318Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:12:41.685966Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:44:24.816424Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:54:42.907148Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:25:38.236356Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:41:07.734173Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 814417940561.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:41:07.734173Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:01:58.194953Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:27:44.285455Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T15:16:14.234864Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:46:40.965849Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:46:40.965849Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:46:40.965849Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |