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_alerts566,287 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 |
|---|
| 2c9d297a-4fee-4ed7-afa0-d03dbaa2d533 | 2026-09-25 12:16 | 2026-09-25 12:16 | 2026-09-25 12:16 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 3.2700 | 3.2400 | 3.2700 | 771.5700 | 17331.00 | 17331.00 | 0.00 | 53 | 5 | 103 | 8234 | 0.0125091085742045 | 0.204712674983063 | 0.204712674983063 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 818687275738.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T16:18:06.291601Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 2317ec33-818d-4fcb-8aab-bb4870f3d7d2 | 2026-09-22 10:37 | 2026-09-22 10:37 | 2026-09-22 10:37 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 3.1500 | 3.1500 | 3.1600 | 773.8070 | 29610.00 | 0.00 | 29610.00 | 94 | 6 | 122 | 7854 | 0.0155334861217214 | 0.201773674691387 | 0.201773674691387 | false | false | false | true | false | |||||||||||||||
| 3ebc0e31-1c82-41c5-85a5-fd6069dd0974 | 2026-09-21 12:33 | 2026-09-21 12:33 | 2026-09-21 12:33 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 3.4500 | 3.4500 | 3.4700 | 772.4800 | 345000.00 | 0.00 | 345000.00 | 1000 | 17 | 1425 | 8199 | 0.173801683132089 | 0.203055503489744 | 0.203055503489744 | false | false | false | true | false | |||||||||||||||
| 62361daf-8224-458f-9945-b63127e0cc77 | 2026-09-21 11:21 | 2026-09-21 11:21 | 2026-09-21 11:21 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 3.5600 | 3.5500 | 3.5600 | 770.0500 | 36312.00 | 36312.00 | 0.00 | 102 | 5 | 393 | 8199 | 0.0479326747164288 | 0.200358682406195 | 0.200358682406195 | false | false | false | true | false | |||||||||||||||
| 7be99733-b076-4aca-b821-9f22a69481da | 2026-09-01 11:07 | 2026-09-01 11:07 | 2026-09-01 11:07 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 6.0900 | 6.0900 | 6.1000 | 762.9050 | 104162.00 | 14030.00 | 90132.00 | 171 | 8 | 1431 | 6076 | 0.235516787360105 | 0.196007042813994 | 0.196122661035801 | false | false | false | true | false | |||||||||||||||
| 9a163646-63d1-4e78-8530-ae7c96741a5e | 2026-08-31 13:18 | 2026-08-31 13:17 | 2026-08-31 13:17 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 5.8000 | 5.8000 | 5.8300 | 765.9200 | 135140.00 | 0.00 | 135140.00 | 233 | 5 | 305 | 5786 | 0.0527134462495679 | 0.19697705987725 | 0.19697705987725 | false | false | false | true | false | |||||||||||||||
| 53e905ec-c453-443d-9a5d-e97469462017 | 2026-08-25 09:57 | 2026-08-25 09:56 | 2026-08-25 09:56 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 6.8200 | 6.8200 | 6.8400 | 765.8546 | 115940.00 | 0.00 | 115940.00 | 170 | 5 | 270 | 5620 | 0.0480427046263345 | 0.202102530538748 | 0.202102530538748 | false | false | false | true | false | |||||||||||||||
| 128a6b96-b043-423c-84c7-cd036ac17122 | 2026-08-17 14:27 | 2026-08-17 14:26 | 2026-08-17 14:26 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 6.9300 | 6.9300 | 6.9600 | 773.5600 | 623700.00 | 0.00 | 623700.00 | 900 | 16 | 5275 | 7001 | 0.753463790887016 | 0.208625164556272 | 0.20860872452428 | true | false | false | true | false | |||||||||||||||
| 0b14137d-c616-4f8a-8420-77b3c3544628 | 2026-08-17 14:18 | 2026-08-17 14:18 | 2026-08-17 14:18 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 6.9600 | 6.9600 | 6.9900 | 773.6900 | 348110.00 | 0.00 | 348110.00 | 500 | 5 | 4274 | 7001 | 0.610484216540494 | 0.209249674374879 | 0.209142930806383 | false | false | false | true | false | |||||||||||||||
| 62582ebd-87dd-459e-810a-935d1a6962b1 | 2026-08-17 14:13 | 2026-08-17 14:13 | 2026-08-17 14:13 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 6.9800 | 6.9800 | 7.0000 | 773.6200 | 698000.00 | 0.00 | 698000.00 | 1000 | 10 | 3774 | 7001 | 0.539065847736038 | 0.209241187297205 | 0.209241187297205 | true | false | false | true | false | |||||||||||||||
| c8357924-3cd1-4eae-beb2-45eef868d71f | 2026-08-17 14:09 | 2026-08-17 14:09 | 2026-08-17 14:09 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 7.0000 | 6.9900 | 7.0200 | 773.0000 | 404600.00 | 66500.00 | 338100.00 | 578 | 12 | 2574 | 7001 | 0.367661762605342 | 0.209124948975052 | 0.209124948975052 | true | false | false | true | false | |||||||||||||||
| 351c4272-60cc-4406-bcc5-e4497b04d3a2 | 2026-08-17 14:08 | 2026-08-17 14:08 | 2026-08-17 14:08 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 7.0000 | 6.9900 | 7.0200 | 773.0000 | 112000.00 | 70000.00 | 42000.00 | 160 | 6 | 1734 | 7001 | 0.247678903013855 | 0.209157902196453 | 0.209157902196453 | true | false | false | true | false | |||||||||||||||
| dc47181c-c03f-482b-8d83-54475e175494 | 2026-08-17 09:32 | 2026-08-17 09:32 | 2026-08-17 09:32 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 6.5900 | 6.5900 | 6.6200 | 776.1400 | 329500.00 | 0.00 | 329500.00 | 500 | 12 | 1043 | 7001 | 0.148978717326096 | 0.20912984389416 | 0.20912984389416 | true | false | false | true | false | |||||||||||||||
| c217695e-a4a5-4d85-93ec-3b5c1de596fc | 2026-08-17 09:31 | 2026-08-17 09:31 | 2026-08-17 09:31 | SPY | SPY261120P00705000 | put | 705.0000 | 2026-11-20 | 6.5500 | 6.5400 | 6.5700 | 776.6050 | 224665.00 | 28165.00 | 196500.00 | 343 | 6 | 343 | 7001 | 0.0489930009998572 | 0.209439556490058 | 0.209439556490058 | true | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:38:45.745623Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:34:45.939712Z"} |
| 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:22:54.080611Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |