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_alerts326,449 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 |
|---|
| 6ca9b913-51d2-49e6-ac72-7108df02a8a4 | 2026-09-22 16:05 | 2026-09-22 16:04 | 2026-09-22 16:04 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 0.4100 | 0.4100 | 0.4200 | 773.0000 | 24354.00 | 0.00 | 24354.00 | 594 | 12 | 39777 | 7501 | 5.30289294760699 | 0.100025422463894 | 0.100025422463894 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 803326731841.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| bd76894a-fee4-4c02-8db7-71cdf5647a1a | 2026-09-22 15:58 | 2026-09-22 15:58 | 2026-09-22 15:58 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 0.4100 | 0.4000 | 0.4100 | 773.7600 | 40302.00 | 40262.00 | 40.00 | 983 | 26 | 37012 | 7501 | 4.93427542994267 | 0.103159502390082 | 0.103938108238645 | false | false | false | true | false | |||||||||||||||
| 8802474f-c98b-4cf3-8efd-67c69b0661e4 | 2026-09-22 15:56 | 2026-09-22 15:56 | 2026-09-22 15:56 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 0.3800 | 0.3800 | 0.3900 | 773.8200 | 31996.00 | 0.00 | 31996.00 | 842 | 12 | 34697 | 7501 | 4.62564991334489 | 0.101837551493688 | 0.102073777176687 | false | false | false | true | false | |||||||||||||||
| 344ae315-b56e-4921-a690-49725c86d6a3 | 2026-09-22 11:41 | 2026-09-22 11:40 | 2026-09-22 11:40 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 0.7700 | 0.7600 | 0.7700 | 772.7000 | 23100.00 | 23100.00 | 0.00 | 300 | 5 | 15665 | 7501 | 2.08838821490468 | 0.11398057467049 | 0.11398057467049 | false | false | false | true | false | |||||||||||||||
| fbef0c0a-277d-4172-9376-694ec4b87628 | 2026-09-22 09:42 | 2026-09-22 09:42 | 2026-09-22 09:42 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 0.5600 | 0.5500 | 0.5600 | 774.7750 | 11816.00 | 11816.00 | 0.00 | 211 | 9 | 4141 | 7501 | 0.552059725369951 | 0.13518632725435 | 0.13518632725435 | false | false | false | true | false | |||||||||||||||
| 2c30372d-91a3-4257-be9b-818aa9257a78 | 2026-09-22 09:41 | 2026-09-22 09:41 | 2026-09-22 09:41 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 0.6100 | 0.6000 | 0.6100 | 774.4601 | 64172.00 | 64172.00 | 0.00 | 1052 | 27 | 2433 | 7501 | 0.324356752433009 | 0.13421547162419 | 0.13421547162419 | false | false | false | true | false | |||||||||||||||
| e1b9ddf6-7db0-4ec8-be50-93667a892567 | 2026-09-22 09:31 | 2026-09-22 09:31 | 2026-09-22 09:31 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 0.6200 | 0.6100 | 0.6200 | 774.4200 | 24056.00 | 24056.00 | 0.00 | 388 | 13 | 466 | 7501 | 0.0621250499933342 | 0.134030174326983 | 0.134384571291151 | false | false | false | true | false | |||||||||||||||
| 3d45f398-ffd2-4670-b609-72181bd79c83 | 2026-09-21 16:05 | 2026-09-21 16:04 | 2026-09-21 16:04 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.1700 | 1.1700 | 1.1800 | 773.0000 | 52650.00 | 0.00 | 52650.00 | 450 | 10 | 21988 | 139 | 158.187050359712 | 0.108592605718124 | 0.108592605718124 | false | false | false | true | false | |||||||||||||||
| 865b552f-e2e2-457b-97b9-faae6e17268c | 2026-09-21 15:55 | 2026-09-21 15:55 | 2026-09-21 15:55 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.0500 | 1.0300 | 1.0500 | 773.0000 | 27300.00 | 27300.00 | 0.00 | 260 | 5 | 20473 | 139 | 147.287769784173 | 0.112217823294119 | 0.112217823294119 | false | false | false | true | false | |||||||||||||||
| 5d8a7602-49fe-47b1-86bd-c5d5a262677e | 2026-09-21 15:55 | 2026-09-21 15:55 | 2026-09-21 15:55 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.0500 | 1.0400 | 1.0500 | 773.0000 | 25200.00 | 25200.00 | 0.00 | 240 | 8 | 20713 | 139 | 149.014388489209 | 0.112217823294119 | 0.112217823294119 | false | false | false | true | false | |||||||||||||||
| 60288230-83a2-4fa1-bd62-b8f6589c1bef | 2026-09-21 15:52 | 2026-09-21 15:52 | 2026-09-21 15:52 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.0200 | 1.0100 | 1.0200 | 773.8600 | 14484.00 | 14484.00 | 0.00 | 142 | 11 | 19985 | 139 | 143.776978417266 | 0.111535131765321 | 0.111535131765321 | false | false | false | true | false | |||||||||||||||
| 704a3dd7-def1-432e-aeff-6ce40c89764e | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 0.9900 | 0.9900 | 1.0000 | 774.0000 | 14850.00 | 0.00 | 14850.00 | 150 | 9 | 18320 | 139 | 131.798561151079 | 0.11422433948502 | 0.11422433948502 | false | false | false | true | false | |||||||||||||||
| 7cdbaa5c-5021-46dd-b139-ebdf30ed0084 | 2026-09-21 15:07 | 2026-09-21 15:07 | 2026-09-21 15:07 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.0300 | 1.0200 | 1.0300 | 774.0350 | 12463.00 | 12463.00 | 0.00 | 121 | 5 | 16720 | 139 | 120.287769784173 | 0.114524050976472 | 0.114524050976472 | false | false | false | true | false | |||||||||||||||
| 83817b1e-9673-4aed-ac86-ed485065ff29 | 2026-09-21 14:26 | 2026-09-21 14:25 | 2026-09-21 14:25 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.1200 | 1.1100 | 1.1200 | 773.8400 | 16800.00 | 16800.00 | 0.00 | 150 | 5 | 14856 | 139 | 106.877697841727 | 0.116557656351773 | 0.116557656351773 | false | false | false | true | false | |||||||||||||||
| e946cf4a-6759-426e-ad9b-ec7629d267e1 | 2026-09-21 13:12 | 2026-09-21 13:12 | 2026-09-21 13:12 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.4400 | 1.4400 | 1.4500 | 772.5850 | 72000.00 | 0.00 | 72000.00 | 500 | 30 | 11774 | 139 | 84.705035971223 | 0.113574263494616 | 0.113574263494616 | true | false | false | true | false | |||||||||||||||
| 63c88087-41cd-4700-8eca-9b55cd1e3266 | 2026-09-21 13:07 | 2026-09-21 13:07 | 2026-09-21 13:07 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.4900 | 1.4800 | 1.4900 | 772.4800 | 55875.00 | 55875.00 | 0.00 | 375 | 6 | 10960 | 139 | 78.8489208633093 | 0.114271446353033 | 0.114271446353033 | false | false | false | true | false | |||||||||||||||
| 6e001c0f-5ec4-4e40-ab52-17f3a20184c5 | 2026-09-21 13:01 | 2026-09-21 13:01 | 2026-09-21 13:01 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.5500 | 1.5400 | 1.5500 | 772.4600 | 11625.00 | 310.00 | 0.00 | 75 | 6 | 10462 | 139 | 75.2661870503597 | 0.11679921735731 | 0.11679921735731 | true | false | false | true | false | |||||||||||||||
| ae4005b6-f028-45dd-97f0-b8aa16592f0a | 2026-09-21 12:42 | 2026-09-21 12:42 | 2026-09-21 12:42 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.6800 | 1.6800 | 1.6900 | 772.0600 | 13776.00 | 0.00 | 13776.00 | 82 | 6 | 8067 | 139 | 58.0359712230216 | 0.116217819265822 | 0.116217819265822 | false | false | false | true | false | |||||||||||||||
| 9231089e-2cf3-4b6f-9ebe-ee748794c0f8 | 2026-09-21 12:26 | 2026-09-21 12:26 | 2026-09-21 12:26 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.8100 | 1.8100 | 1.8200 | 771.7799 | 51766.00 | 0.00 | 51766.00 | 286 | 11 | 6559 | 139 | 47.1870503597122 | 0.117364275789028 | 0.117364275789028 | true | false | false | true | false | |||||||||||||||
| 40d9fd98-daa7-4044-b032-e7d3ac3467ee | 2026-09-21 12:11 | 2026-09-21 12:11 | 2026-09-21 12:11 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.8000 | 1.7900 | 1.8000 | 771.8050 | 37800.00 | 37800.00 | 0.00 | 210 | 6 | 5623 | 139 | 40.4532374100719 | 0.117346793925149 | 0.117346793925149 | false | false | false | true | false | |||||||||||||||
| 0952712d-15ca-40b5-83d9-f3363b0a388c | 2026-09-21 12:10 | 2026-09-21 12:10 | 2026-09-21 12:10 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 1.8300 | 1.8200 | 1.8300 | 771.6700 | 36600.00 | 36600.00 | 0.00 | 200 | 6 | 5315 | 139 | 38.2374100719424 | 0.116335658967142 | 0.116335658967142 | false | false | false | true | false | |||||||||||||||
| 6db38f0b-70f5-4100-81ca-f009102e7aba | 2026-09-21 11:41 | 2026-09-21 11:40 | 2026-09-21 11:40 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 2.2500 | 2.2400 | 2.2500 | 770.4100 | 112500.00 | 112500.00 | 0.00 | 500 | 30 | 3840 | 139 | 27.6258992805755 | 0.111169052255177 | 0.111169052255177 | true | false | false | true | false | |||||||||||||||
| ed8e5ff9-b66a-459a-b505-3d21511c06bf | 2026-09-21 11:40 | 2026-09-21 11:40 | 2026-09-21 11:40 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 2.2000 | 2.1900 | 2.2000 | 770.5300 | 44000.00 | 44000.00 | 0.00 | 200 | 8 | 3316 | 139 | 23.8561151079137 | 0.111390083470383 | 0.111390083470383 | false | false | false | true | false | |||||||||||||||
| 638d6b4e-3849-4356-b8fc-bcb448337cbc | 2026-09-21 11:17 | 2026-09-21 11:17 | 2026-09-21 11:17 | SPY | SPY260923P00770000 | put | 770.0000 | 2026-09-23 | 2.4400 | 2.4300 | 2.4400 | 769.9000 | 70272.00 | 70272.00 | 0.00 | 288 | 10 | 2295 | 139 | 16.5107913669065 | 0.108801745785757 | 0.108801745785757 | true | false | false | true | false |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:42:55.952799Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:31:35.812482Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:52:57.186278Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:16:02.178873Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:07:15.058898Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:45:57.787225Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:29:13.911862Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:13:06.153982Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:43:39.846801Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:43:39.846801Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:19:12.034191Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |