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 |
|---|
| a7025ee6-74d2-44e9-91f7-4dd07b6d7670 | 2026-09-22 09:53 | 2026-09-22 09:53 | 2026-09-22 09:53 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 2.0600 | 2.0500 | 2.0600 | 48.7600 | 225776.00 | 225776.00 | 0.00 | 1096 | 5 | 1506 | 3060 | 0.492156862745098 | 0.409482197414075 | 0.409482197414075 | 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-22T13:54:31.756724Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 21397465-5faa-4f3d-b46c-20c9bfbd75c0 | 2026-09-22 09:53 | 2026-09-22 09:53 | 2026-09-22 09:53 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 2.0600 | 2.0500 | 2.0600 | 48.7600 | 62418.00 | 62418.00 | 0.00 | 303 | 13 | 410 | 3060 | 0.133986928104575 | 0.409482197414075 | 0.409482197414075 | false | false | false | true | ||||||||||||||||
| cccebda0-4d4c-47c2-9c78-f1a35ff74a8f | 2026-09-22 09:54 | 2026-09-22 09:54 | 2026-09-22 09:54 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 2.0500 | 2.0300 | 2.0500 | 48.7400 | 30545.00 | 30545.00 | 0.00 | 149 | 16 | 1655 | 3060 | 0.540849673202614 | 0.410623984332465 | 0.410623984332465 | false | false | false | true | ||||||||||||||||
| 1e371365-68cf-4bcc-9b93-4eb35ab0f526 | 2026-09-22 09:54 | 2026-09-22 09:54 | 2026-09-22 09:54 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 2.0500 | 2.0300 | 2.0500 | 48.7400 | 30545.00 | 30545.00 | 0.00 | 149 | 10 | 1804 | 3060 | 0.589542483660131 | 0.410623984332465 | 0.410623984332465 | false | false | false | true | ||||||||||||||||
| 6f49ffe9-ea15-40bb-80bb-db0789527250 | 2026-09-22 09:54 | 2026-09-22 09:54 | 2026-09-22 09:54 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 2.0600 | 2.0500 | 2.0600 | 48.7600 | 26368.00 | 26368.00 | 0.00 | 128 | 5 | 2216 | 3060 | 0.724183006535948 | 0.409482197414075 | 0.409482197414075 | false | false | false | true | ||||||||||||||||
| 1a0de9b5-def2-4ef0-80a7-36c26cb1e494 | 2026-09-22 09:54 | 2026-09-22 09:54 | 2026-09-22 09:54 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 2.0600 | 2.0500 | 2.0600 | 48.7600 | 27604.00 | 27604.00 | 0.00 | 134 | 10 | 1960 | 3060 | 0.640522875816993 | 0.409482197414075 | 0.409482197414075 | false | false | false | true | ||||||||||||||||
| 625fcee8-ddc5-4577-b40e-5557dd8a30d5 | 2026-09-22 15:10 | 2026-09-22 15:10 | 2026-09-22 15:10 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 2.2100 | 2.1900 | 2.2100 | 49.0160 | 66300.00 | 66300.00 | 0.00 | 300 | 26 | 2610 | 3060 | 0.852941176470588 | 0.400746709794461 | 0.400746709794461 | false | false | false | true | ||||||||||||||||
| b77b4f7e-c9cb-42c6-8fe2-47d40e009de7 | 2026-09-22 15:12 | 2026-09-22 15:12 | 2026-09-22 15:12 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 2.2000 | 2.1800 | 2.2000 | 49.0000 | 32780.00 | 32780.00 | 0.00 | 149 | 22 | 2759 | 3060 | 0.901633986928105 | 0.402394546044087 | 0.401163533196316 | false | false | false | true | ||||||||||||||||
| ebb779ef-b0bf-4020-8a97-36530a456f17 | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 1.7700 | 1.7700 | 1.8000 | 48.0000 | 11328.00 | 0.00 | 11328.00 | 64 | 16 | 463 | 5586 | 0.0828857858933047 | 0.384645944306986 | 0.384645944306986 | false | false | false | true | ||||||||||||||||
| 33fe4c86-a420-4bd9-8175-614ba5cc9ba2 | 2026-09-23 10:31 | 2026-09-23 10:31 | 2026-09-23 10:31 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 1.2400 | 1.2300 | 1.2400 | 47.5250 | 55056.00 | 55056.00 | 0.00 | 444 | 6 | 1499 | 5586 | 0.268349445041174 | 0.404754981464293 | 0.404754981464293 | true | false | false | true | ||||||||||||||||
| 03dea55f-fcae-4500-bd0c-5b90090739d6 | 2026-09-23 14:40 | 2026-09-23 14:40 | 2026-09-23 14:40 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 1.2500 | 1.2300 | 1.2500 | 47.6599 | 179875.00 | 179875.00 | 0.00 | 1439 | 52 | 4696 | 5586 | 0.840673111349803 | 0.383988747218236 | 0.384006951065931 | false | false | false | true | ||||||||||||||||
| cad58c99-0ea2-4c5a-a4b5-e0040bf487f1 | 2026-09-23 14:41 | 2026-09-23 14:41 | 2026-09-23 14:41 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 1.2500 | 1.2300 | 1.2600 | 47.6500 | 168046.00 | 157046.00 | 8250.00 | 1343 | 71 | 6141 | 5586 | 1.09935553168636 | 0.385806562790067 | 0.385806562790067 | false | false | false | true | ||||||||||||||||
| 9d4bce6c-32a9-47f6-9c2e-83f87d931bfc | 2026-09-23 14:41 | 2026-09-23 14:41 | 2026-09-23 14:41 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 1.2700 | 1.2400 | 1.2700 | 47.6500 | 14965.00 | 12319.00 | 0.00 | 118 | 13 | 6304 | 5586 | 1.12853562477623 | 0.389172854397771 | 0.392539040074531 | true | false | false | true | ||||||||||||||||
| a1d49bda-845c-428e-a69b-1eff47121f9f | 2026-09-24 09:34 | 2026-09-24 09:34 | 2026-09-24 09:34 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 1.1400 | 1.1400 | 1.1600 | 47.6250 | 16986.00 | 0.00 | 16986.00 | 149 | 25 | 172 | 8192 | 0.02099609375 | 0.375647140849458 | 0.375647140849458 | false | false | false | true | ||||||||||||||||
| 7330e4f1-59bd-4a49-8731-bc0991b7989f | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 1.0500 | 1.0400 | 1.0500 | 47.5000 | 22785.00 | 22785.00 | 0.00 | 217 | 14 | 870 | 8192 | 0.106201171875 | 0.367029646102188 | 0.367029646102188 | true | false | false | true | ||||||||||||||||
| bccb3718-5c4d-41b2-a7bb-6ef546d0fc24 | 2026-09-25 10:07 | 2026-09-25 10:07 | 2026-09-25 10:07 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 0.7700 | 0.7700 | 0.7900 | 47.1600 | 15631.00 | 0.00 | 15631.00 | 203 | 28 | 365 | 8733 | 0.041795488377419 | 0.349608100175288 | 0.349608100175288 | false | false | false | true | ||||||||||||||||
| 6159326d-d24e-45ef-a7a9-562569776c57 | 2026-09-25 10:17 | 2026-09-25 10:17 | 2026-09-25 10:17 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 0.8200 | 0.8200 | 0.8300 | 47.2800 | 13776.00 | 0.00 | 13776.00 | 168 | 11 | 2141 | 8733 | 0.24516202908508 | 0.347277583807154 | 0.347277583807154 | false | false | false | true | ||||||||||||||||
| 223fedf3-ed95-4823-b260-874f0471baa3 | 2026-09-25 10:17 | 2026-09-25 10:17 | 2026-09-25 10:17 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 0.8200 | 0.8200 | 0.8300 | 47.2800 | 10906.00 | 0.00 | 10906.00 | 133 | 7 | 2274 | 8733 | 0.260391618000687 | 0.347277583807154 | 0.347277583807154 | false | false | false | true | ||||||||||||||||
| b91d19ea-4d15-480c-9eaa-a4e4a55226e4 | 2026-09-25 10:18 | 2026-09-25 10:17 | 2026-09-25 10:17 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 0.8100 | 0.8100 | 0.8200 | 47.2800 | 11097.00 | 0.00 | 11097.00 | 137 | 11 | 2547 | 8733 | 0.29165235314325 | 0.343443009049184 | 0.343443009049184 | false | false | false | true | ||||||||||||||||
| e979c0e2-c3c6-4e60-8c9b-b71d8770eecf | 2026-09-25 10:18 | 2026-09-25 10:17 | 2026-09-25 10:17 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 0.7800 | 0.7800 | 0.8000 | 47.2410 | 39385.00 | 4187.00 | 35040.00 | 504 | 54 | 3526 | 8733 | 0.403755868544601 | 0.34285465397561 | 0.339012103904514 | true | false | false | true | ||||||||||||||||
| 3a8028ee-1a54-4e01-bad5-761d257a5665 | 2026-09-25 10:18 | 2026-09-25 10:17 | 2026-09-25 10:17 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 0.7900 | 0.7900 | 0.8100 | 47.2410 | 22815.00 | 0.00 | 21695.00 | 287 | 46 | 3022 | 8733 | 0.346043742127562 | 0.345067724857238 | 0.34285465397561 | false | false | false | true | ||||||||||||||||
| eaec868b-1dfb-4bdd-a787-e5429e547a52 | 2026-09-25 10:54 | 2026-09-25 10:54 | 2026-09-25 10:54 | IBIT | IBIT261002C00047500 | call | 47.5000 | 2026-10-02 | 0.8700 | 0.8600 | 0.8800 | 47.0000 | 16965.00 | 16878.00 | 0.00 | 195 | 14 | 4503 | 8733 | 0.515630367571281 | 0.34400951580892 | 0.34400951580892 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:54:31.756724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:56:25.927111Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:56:25.927111Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:56:25.927111Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:56:25.927111Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-23T13:49:25.662048Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:33:43.718875Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:50:04.558688Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:50:04.558688Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:50:04.558688Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:35:42.562828Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:07:37.625722Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:19:54.895833Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:19:54.895833Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:19:54.895833Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:19:54.895833Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:19:54.895833Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T14:56:21.812618Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |