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.
Simplify Analyticsuw_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 |
|---|
| e2d1da8a-0a94-4af7-8d62-1cfc4fcc104e | 2026-09-25 13:40 | 2026-09-25 13:40 | 2026-09-25 13:40 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 1.2100 | 1.2000 | 1.2500 | 281.0000 | 12077.00 | 0.00 | 12077.00 | 100 | 21 | 25236 | 3612 | 6.98671096345515 | 0.207280957713746 | 0.21813920182037 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 77601345973.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| b506f1f6-fc3c-4ca0-af06-9eb016755373 | 2026-09-25 13:18 | 2026-09-25 13:18 | 2026-09-25 13:18 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 0.9200 | 0.9100 | 0.9400 | 282.0000 | 16100.00 | 1840.00 | 14260.00 | 175 | 9 | 24113 | 3612 | 6.67580287929125 | 0.197865287577452 | 0.203382984488382 | false | false | false | true | false | |||||||||||||||
| a7c681da-96fa-4bfc-a955-64b715dc0dfe | 2026-09-25 12:59 | 2026-09-25 12:59 | 2026-09-25 12:59 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 0.8800 | 0.8600 | 0.8900 | 282.3150 | 13213.00 | 13213.00 | 0.00 | 150 | 6 | 22622 | 3612 | 6.26301218161683 | 0.226704515714307 | 0.221036835439888 | false | false | false | true | false | |||||||||||||||
| 147e8763-ec55-4362-a262-04cd31b35692 | 2026-09-25 12:36 | 2026-09-25 12:36 | 2026-09-25 12:36 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 0.6800 | 0.6700 | 0.7000 | 282.7200 | 10131.00 | 2516.00 | 7615.00 | 149 | 6 | 19569 | 3612 | 5.41777408637874 | 0.239175279691642 | 0.239175279691642 | false | false | false | true | false | |||||||||||||||
| 65313e81-a278-48c3-b672-05cf8a8bd45d | 2026-09-25 12:36 | 2026-09-25 12:36 | 2026-09-25 12:36 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 0.6800 | 0.6800 | 0.7000 | 282.7300 | 21964.00 | 0.00 | 21964.00 | 323 | 15 | 19387 | 3612 | 5.36738648947951 | 0.241829043550891 | 0.241829043550891 | false | false | false | true | false | |||||||||||||||
| 62f12f1c-7f6d-45eb-92ea-13852e2db63d | 2026-09-25 12:34 | 2026-09-25 12:34 | 2026-09-25 12:34 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 0.7700 | 0.7600 | 0.8000 | 282.6200 | 16646.00 | 156.00 | 11550.00 | 217 | 5 | 18524 | 3612 | 5.12846068660022 | 0.255614877514879 | 0.256562573877423 | false | false | false | true | false | |||||||||||||||
| 51e2c76d-0b23-448d-ba79-35592eb8cf11 | 2026-09-25 12:34 | 2026-09-25 12:34 | 2026-09-25 12:34 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 0.7100 | 0.6300 | 0.7400 | 282.5800 | 13989.00 | 13989.00 | 0.00 | 196 | 8 | 18188 | 3612 | 5.03543743078627 | 0.197672481841104 | 0.226245860539304 | true | false | false | true | false | |||||||||||||||
| a666f8f6-cce9-4be3-862e-8e096596d3d6 | 2026-09-25 12:29 | 2026-09-25 12:29 | 2026-09-25 12:29 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 0.5500 | 0.5300 | 0.5500 | 283.0000 | 11000.00 | 11000.00 | 0.00 | 200 | 12 | 16335 | 3612 | 4.52242524916944 | 0.252977492503271 | 0.252977492503271 | false | false | false | true | false | |||||||||||||||
| ae1917a4-16a0-4e18-834d-d1c28c630966 | 2026-09-25 12:25 | 2026-09-25 12:25 | 2026-09-25 12:25 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 0.6400 | 0.6300 | 0.6400 | 282.8700 | 12800.00 | 12800.00 | 0.00 | 200 | 10 | 15089 | 3612 | 4.17746400885936 | 0.25210375987989 | 0.25210375987989 | false | false | false | true | false | |||||||||||||||
| aab2b482-432a-41a5-b363-06080645b23c | 2026-09-25 09:31 | 2026-09-25 09:30 | 2026-09-25 09:30 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 1.2300 | 1.2000 | 1.2300 | 282.2100 | 15621.00 | 15621.00 | 0.00 | 127 | 20 | 193 | 3612 | 0.0534330011074197 | 0.253479252115773 | 0.253479252115773 | true | false | false | true | false | |||||||||||||||
| 21c78c8b-3963-4be3-a3dd-dd86eeda8f0c | 2026-09-24 16:04 | 2026-09-24 16:03 | 2026-09-24 16:03 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 2.0900 | 2.0700 | 2.0900 | 281.0000 | 10868.00 | 10868.00 | 0.00 | 52 | 6 | 2667 | 3796 | 0.702581664910432 | 0.205197093640131 | 0.205197093640131 | false | false | false | true | false | |||||||||||||||
| 64828202-e4ba-4d83-83f7-a95088f6c517 | 2026-09-24 16:00 | 2026-09-24 16:00 | 2026-09-24 16:00 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 1.9700 | 1.9700 | 2.0100 | 281.0000 | 10244.00 | 0.00 | 10244.00 | 52 | 9 | 2602 | 3796 | 0.685458377239199 | 0.202981753094569 | 0.202981753094569 | false | false | false | true | false | |||||||||||||||
| f0c2e36c-d09c-415b-8c64-273a076d6e65 | 2026-09-24 15:25 | 2026-09-24 15:25 | 2026-09-24 15:25 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 2.1700 | 2.1700 | 2.2000 | 281.4150 | 13888.00 | 0.00 | 13888.00 | 64 | 7 | 2129 | 3796 | 0.560853530031612 | 0.210650810703672 | 0.210650810703672 | false | false | false | true | false | |||||||||||||||
| f2fc16fd-271e-4884-83c5-f5efefcb9027 | 2026-09-23 15:14 | 2026-09-23 15:14 | 2026-09-23 15:14 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 1.6300 | 1.6300 | 1.6500 | 282.6600 | 10432.00 | 0.00 | 10432.00 | 64 | 11 | 5175 | 4023 | 1.28635346756152 | 0.178011921110565 | 0.178011921110565 | false | false | false | true | false | |||||||||||||||
| 8fafbcb7-8cc4-4f66-a43f-569267b4444f | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 1.3700 | 1.3500 | 1.3800 | 283.0000 | 10823.00 | 10549.00 | 0.00 | 79 | 12 | 3046 | 4023 | 0.75714640815312 | 0.1871552873848 | 0.1871552873848 | false | false | false | true | false | |||||||||||||||
| 0fc67e88-00e0-4a2d-9084-bb266129cbda | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 1.3600 | 1.3400 | 1.3700 | 283.0000 | 14008.00 | 11152.00 | 1904.00 | 103 | 19 | 2967 | 4023 | 0.737509321401939 | 0.186773764981745 | 0.186773764981745 | true | false | false | true | false | |||||||||||||||
| 18622725-4ef9-4bf5-81df-d7630e1629aa | 2026-09-23 10:53 | 2026-09-23 10:53 | 2026-09-23 10:53 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 1.5100 | 1.5100 | 1.5300 | 283.0100 | 20385.00 | 0.00 | 20385.00 | 135 | 5 | 2679 | 4023 | 0.665920954511559 | 0.184948521959067 | 0.184948521959067 | false | false | false | true | false | |||||||||||||||
| cd31873b-6ee5-4d78-b686-da052222c350 | 2026-09-22 13:54 | 2026-09-22 13:54 | 2026-09-22 13:54 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 0.3900 | 0.3700 | 0.3900 | 287.6000 | 12185.00 | 12185.00 | 0.00 | 315 | 7 | 1424 | 3182 | 0.447517284726587 | 0.1794375526515 | 0.181293351558357 | false | false | false | true | false | |||||||||||||||
| 04e864ba-6d1f-45d2-a72a-6acc18efd711 | 2026-09-21 15:53 | 2026-09-21 15:53 | 2026-09-21 15:53 | IWM | IWM260925P00283000 | put | 283.0000 | 2026-09-25 | 0.9200 | 0.8900 | 0.9200 | 285.0000 | 18400.00 | 18400.00 | 0.00 | 200 | 5 | 1045 | 2426 | 0.430750206100577 | 0.172081858752796 | 0.172081858752796 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:23:42.010099Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:04:49.737352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:38:20.208952Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:38:20.208952Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:38:20.208952Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:34:19.672703Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:31:25.590153Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:27:03.681802Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:31:26.059584Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:29:28.297700Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:19:13.860823Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.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 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.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 |