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_alerts474,253 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 |
|---|
| b00121de-4b2c-465f-ac6b-efcfefef5282 | 2026-09-23 10:45 | 2026-09-23 10:45 | 2026-09-23 10:45 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 3.0000 | 2.9900 | 3.0000 | 769.1600 | 28500.00 | 28500.00 | 0.00 | 95 | 5 | 133916 | 7551 | 17.7348695537015 | 0.144682199373997 | 0.136729463988657 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 806184418262.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T14:47:19.358930Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 8dc95693-9cac-4de7-979f-e16eb2a8cb29 | 2026-09-23 10:48 | 2026-09-23 10:48 | 2026-09-23 10:48 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.9400 | 2.9200 | 2.9400 | 769.2900 | 17938.00 | 17645.00 | 0.00 | 61 | 5 | 134363 | 7551 | 17.7940670109919 | 0.146582344183985 | 0.148726860148165 | true | false | false | true | ||||||||||||||||
| 9ab2f1f0-09f7-4131-8aa6-0d10598e7810 | 2026-09-23 10:51 | 2026-09-23 10:51 | 2026-09-23 10:51 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 3.3000 | 3.3000 | 3.3100 | 768.8577 | 27720.00 | 0.00 | 27720.00 | 84 | 5 | 134733 | 7551 | 17.8430671434247 | 0.147252224209545 | 0.147252224209545 | false | false | false | true | ||||||||||||||||
| d2a7de44-f370-4a16-8769-4a401daf361c | 2026-09-23 10:51 | 2026-09-23 10:51 | 2026-09-23 10:51 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.7200 | 2.7100 | 2.8500 | 769.5400 | 11171.00 | 0.00 | 11171.00 | 41 | 7 | 134924 | 7551 | 17.8683618063833 | 0.119255954232734 | 0.142412449226966 | true | false | false | true | ||||||||||||||||
| 2f1dc471-d257-4915-ae98-24576998898a | 2026-09-23 10:53 | 2026-09-23 10:53 | 2026-09-23 10:53 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.3400 | 2.4600 | 2.4700 | 769.9500 | 14491.00 | 0.00 | 14491.00 | 62 | 5 | 135859 | 7551 | 17.9921864653688 | 0.144594492559109 | 0.10886543397371 | true | false | false | true | ||||||||||||||||
| 93b41f2f-c203-46e5-855e-681c6c69399f | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.1100 | 2.1100 | 2.1200 | 770.0000 | 11394.00 | 0.00 | 11394.00 | 54 | 5 | 136416 | 7551 | 18.0659515295987 | 0.146981745635905 | 0.146981745635905 | false | false | false | true | ||||||||||||||||
| 88e339ab-d7e9-4432-aa1e-72b8b10f02a3 | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.1500 | 2.1400 | 2.1600 | 770.0000 | 44434.00 | 216.00 | 44218.00 | 207 | 9 | 136678 | 7551 | 18.1006489206728 | 0.146394319196955 | 0.14474752469751 | false | false | false | true | ||||||||||||||||
| 51c301c8-8ff8-4e5e-b4fb-20b5f359c800 | 2026-09-23 10:57 | 2026-09-23 10:57 | 2026-09-23 10:57 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.4300 | 2.4100 | 2.4300 | 769.9400 | 13846.00 | 13846.00 | 0.00 | 57 | 5 | 137960 | 7551 | 18.2704277579129 | 0.150779290349537 | 0.152544035881748 | false | false | false | true | ||||||||||||||||
| fba75c45-7e6f-4897-a9e2-7434a44790ff | 2026-09-23 11:02 | 2026-09-23 11:02 | 2026-09-23 11:02 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.3200 | 2.3000 | 2.3200 | 769.9700 | 28768.00 | 28768.00 | 0.00 | 124 | 10 | 139119 | 7551 | 18.4239173619388 | 0.1409659341212 | 0.13806525078395 | false | false | false | true | ||||||||||||||||
| 4a752257-ed4e-40ca-90be-4a1479cb2977 | 2026-09-23 11:03 | 2026-09-23 11:03 | 2026-09-23 11:03 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.6100 | 2.6000 | 2.6100 | 769.6400 | 16965.00 | 16965.00 | 0.00 | 65 | 6 | 139517 | 7551 | 18.4766256125017 | 0.148211841701592 | 0.143358599651621 | false | false | false | true | ||||||||||||||||
| 37a6ae2b-0f53-4fe1-adb7-c3792d8413e6 | 2026-09-23 11:06 | 2026-09-23 11:06 | 2026-09-23 11:06 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.6400 | 2.6300 | 2.6400 | 769.5800 | 15047.00 | 14784.00 | 263.00 | 57 | 7 | 140049 | 7551 | 18.5470798569726 | 0.137881947451038 | 0.140041110488892 | false | false | false | true | ||||||||||||||||
| 5f3850a1-4eff-4acf-958e-84b69473813c | 2026-09-23 11:08 | 2026-09-23 11:07 | 2026-09-23 11:07 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.4800 | 2.4700 | 2.4800 | 769.7650 | 23064.00 | 23064.00 | 0.00 | 93 | 5 | 140380 | 7551 | 18.5909151105814 | 0.138599981567862 | 0.138599981567862 | false | false | false | true | ||||||||||||||||
| 42cc67c1-6139-4adf-90b1-323d84e430c5 | 2026-09-23 11:23 | 2026-09-23 11:23 | 2026-09-23 11:23 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.3800 | 2.3800 | 2.3900 | 769.8100 | 16184.00 | 0.00 | 16184.00 | 68 | 9 | 143028 | 7551 | 18.9415971394517 | 0.128648323619192 | 0.128648323619192 | false | false | false | true | ||||||||||||||||
| 14ddb7ed-c7b5-4da2-8b01-a5ed0a33a052 | 2026-09-23 11:26 | 2026-09-23 11:26 | 2026-09-23 11:26 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.3600 | 2.3600 | 2.3700 | 769.8300 | 19116.00 | 0.00 | 19116.00 | 81 | 5 | 143497 | 7551 | 19.00370811813 | 0.128512463527952 | 0.128512463527952 | false | false | false | true | ||||||||||||||||
| 1181d092-eded-452a-8cfc-31e97b5e060f | 2026-09-23 11:27 | 2026-09-23 11:27 | 2026-09-23 11:27 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.5400 | 2.5400 | 2.5500 | 769.6400 | 16510.00 | 0.00 | 16510.00 | 65 | 5 | 143689 | 7551 | 19.029135213879 | 0.133643513456053 | 0.133643513456053 | false | false | false | true | ||||||||||||||||
| f154b6b3-2b91-4ebe-9e00-2dbed91c9e5d | 2026-09-23 11:27 | 2026-09-23 11:27 | 2026-09-23 11:27 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.5800 | 2.5800 | 2.5900 | 769.5713 | 17286.00 | 0.00 | 17286.00 | 67 | 6 | 143775 | 7551 | 19.0405244338498 | 0.129233932898952 | 0.129233932898952 | false | false | false | true | ||||||||||||||||
| 64442549-cdee-449c-b05f-bcdf6fac8104 | 2026-09-23 11:28 | 2026-09-23 11:28 | 2026-09-23 11:28 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 2.8100 | 2.7900 | 2.8100 | 769.0000 | 13207.00 | 13207.00 | 0.00 | 47 | 8 | 144150 | 7551 | 19.0901867302344 | 0.1327768525756 | 0.1327768525756 | false | false | false | true | ||||||||||||||||
| ccb12065-e0b9-40f5-95ec-4a56b1f51750 | 2026-09-23 11:32 | 2026-09-23 11:32 | 2026-09-23 11:32 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 3.1900 | 3.1600 | 3.1900 | 768.9100 | 36359.00 | 36359.00 | 0.00 | 114 | 9 | 145116 | 7551 | 19.2181168057211 | 0.135313656700296 | 0.138630245146011 | true | false | false | true | ||||||||||||||||
| 044bd76d-f68a-4ed9-8f2f-841875bd59a2 | 2026-09-23 12:44 | 2026-09-23 12:44 | 2026-09-23 12:44 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 4.1200 | 4.0900 | 4.1100 | 767.9100 | 41243.00 | 41243.00 | 0.00 | 100 | 5 | 150778 | 7551 | 19.9679512647331 | 0.173008617395573 | 0.142129186310924 | true | false | false | true | ||||||||||||||||
| 6c8c8e80-e600-41e8-8e69-bb07e1b2254e | 2026-09-23 13:03 | 2026-09-23 13:03 | 2026-09-23 13:03 | SPY | SPY260923P00772000 | put | 772.0000 | 2026-09-23 | 5.1900 | 5.2000 | 5.2200 | 766.8050 | 18684.00 | 0.00 | 18684.00 | 36 | 5 | 152164 | 7551 | 20.1515031121706 | 0.151226558527854 | 0.151226558527854 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:51:34.694161Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:51:34.694161Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:53:23.630136Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:54:01.895756Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:57:22.994560Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:04:15.950179Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:04:15.950179Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:23:47.442599Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:31:00.015856Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:35:15.101362Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:47:02.093743Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:06:21.638399Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |