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 |
|---|
| pricenumeric |
|---|
| 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 |
|---|
| 02589f97-b592-4cee-bb32-6f44cedb5f84 | 2026-09-21 10:42 | 2026-09-21 10:42 | 2026-09-21 10:42 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.8900 | 1.8800 | 1.9100 | 48.6250 | 232470.00 | 12285.00 | 216594.00 | 1230 | 66 | 3114 | 4312 | 0.722170686456401 | 0.43335257944172 | 0.43335257944172 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 64762757065.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 78909757-53b1-4954-af47-620895ef1446 | 2026-09-21 10:42 | 2026-09-21 10:42 | 2026-09-21 10:42 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.8800 | 1.8700 | 1.9000 | 48.6113 | 245152.00 | 0.00 | 244964.00 | 1304 | 41 | 4418 | 4312 | 1.02458256029685 | 0.432479161752031 | 0.432658816047114 | false | false | false | |||||||||||||||||
| e44751d2-5a15-4fa3-8418-11558a729c16 | 2026-09-21 10:42 | 2026-09-21 10:42 | 2026-09-21 10:42 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.8800 | 1.8700 | 1.9000 | 48.6200 | 102272.00 | 86104.00 | 16168.00 | 544 | 12 | 4962 | 4312 | 1.15074211502783 | 0.432236366925381 | 0.432236366925381 | false | false | false | |||||||||||||||||
| c31b417b-3e8f-4ab9-a5a3-e00bea45c835 | 2026-09-21 10:42 | 2026-09-21 10:42 | 2026-09-21 10:42 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.8800 | 1.8700 | 1.9000 | 48.6399 | 57528.00 | 1128.00 | 56400.00 | 306 | 14 | 5268 | 4312 | 1.22170686456401 | 0.43126982882711 | 0.43126982882711 | false | false | false | |||||||||||||||||
| edfb6e88-0cb8-41d6-b2ae-06d5369270c0 | 2026-09-21 10:42 | 2026-09-21 10:42 | 2026-09-21 10:42 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.8700 | 1.8700 | 1.8900 | 48.6350 | 32351.00 | 0.00 | 32351.00 | 173 | 10 | 5441 | 4312 | 1.26182745825603 | 0.430148539046911 | 0.430148539046911 | false | false | false | |||||||||||||||||
| 41783725-f7f0-4d29-b0ea-c85e300caff5 | 2026-09-21 10:58 | 2026-09-21 10:58 | 2026-09-21 10:58 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.8800 | 1.8800 | 1.8900 | 48.6000 | 13724.00 | 0.00 | 13724.00 | 73 | 10 | 5523 | 4312 | 1.28084415584416 | 0.432721935029356 | 0.432721935029356 | false | false | false | |||||||||||||||||
| 1d987b40-1dd8-4a31-b3bc-70a148614da1 | 2026-09-21 10:59 | 2026-09-21 10:59 | 2026-09-21 10:59 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.8800 | 1.8600 | 1.8800 | 48.6050 | 19552.00 | 19552.00 | 0.00 | 104 | 5 | 5627 | 4312 | 1.30496289424861 | 0.432964686814369 | 0.432964686814369 | true | false | false | |||||||||||||||||
| 50e9d59b-10f7-4b6c-a553-3dfbe02828b1 | 2026-09-22 12:51 | 2026-09-22 12:51 | 2026-09-22 12:51 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.8800 | 1.8700 | 1.8800 | 48.9850 | 25756.00 | 25756.00 | 0.00 | 137 | 8 | 606 | 9269 | 0.0653792210594455 | 0.418190500173068 | 0.418190500173068 | true | false | false | |||||||||||||||||
| c4723329-7961-43d2-8a5d-bdd965f13dde | 2026-09-24 10:07 | 2026-09-24 10:07 | 2026-09-24 10:07 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.3500 | 1.3300 | 1.3600 | 47.7550 | 20250.00 | 20250.00 | 0.00 | 150 | 13 | 231 | 8655 | 0.0266897746967071 | 0.408711020821412 | 0.408482536668742 | false | false | false | |||||||||||||||||
| 44e2d8ae-bf0b-40a2-93cf-2e26eaf2fa88 | 2026-09-24 10:53 | 2026-09-24 10:52 | 2026-09-24 10:52 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.2400 | 1.2300 | 1.2400 | 47.3099 | 18724.00 | 18724.00 | 0.00 | 151 | 10 | 483 | 8655 | 0.0558058925476603 | 0.411493424927043 | 0.411493424927043 | false | false | false | |||||||||||||||||
| 87d343ff-6df3-463f-9939-393e3bf17e03 | 2026-09-24 10:54 | 2026-09-24 10:54 | 2026-09-24 10:54 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.2500 | 1.2300 | 1.2600 | 47.3600 | 19750.00 | 18375.00 | 0.00 | 158 | 18 | 641 | 8655 | 0.0740612362796072 | 0.410835847171612 | 0.410835847171612 | false | false | false | |||||||||||||||||
| 5c9be0df-c042-4c8b-9bc2-272ba7890d2e | 2026-09-24 13:46 | 2026-09-24 13:46 | 2026-09-24 13:46 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.3100 | 1.3000 | 1.3100 | 47.0000 | 11004.00 | 11004.00 | 0.00 | 84 | 15 | 828 | 8655 | 0.0956672443674177 | 0.406681935345296 | 0.406681935345296 | true | false | false | |||||||||||||||||
| 5a0e03a7-2481-4672-bcac-9fb4ec65d6e8 | 2026-09-28 14:14 | 2026-09-28 14:14 | 2026-09-28 14:14 | IBIT | IBIT261120C00053000 | call | 53.0000 | 2026-11-20 | 1.0600 | 1.0600 | 1.0800 | 47.5326 | 11130.00 | 0.00 | 11130.00 | 105 | 11 | 303 | 9171 | 0.033038927052666 | 0.387303883148865 | 0.387303883148865 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:02:30.535242Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:52:20.560244Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:08:54.070178Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:53:28.868411Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:56:01.849843Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:47:19.997705Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:20:46.234036Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |