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_alerts609,118 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 |
|---|
| 12a90982-7002-4d96-a65b-6ce9cd73dc1e | 2026-09-21 14:14 | 2026-09-21 14:14 | 2026-09-21 14:14 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.2700 | 2.2700 | 2.2900 | 48.7200 | 81721.00 | 0.00 | 81721.00 | 360 | 5 | 1253 | 518 | 2.41891891891892 | 0.413321034359079 | 0.414664702663794 | 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-21T18:15:35.599753Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 31fda29a-88fb-415c-b63e-7cefd7794ba1 | 2026-09-22 09:32 | 2026-09-22 09:32 | 2026-09-22 09:32 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.2900 | 2.2600 | 2.3100 | 48.6500 | 22442.00 | 229.00 | 22213.00 | 98 | 5 | 216 | 948 | 0.227848101265823 | 0.415710028936657 | 0.415710028936657 | false | false | false | |||||||||||||||||
| 5059ee12-bef3-4dd8-94eb-bd1ef655d87e | 2026-09-22 12:44 | 2026-09-22 12:44 | 2026-09-22 12:44 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.1600 | 2.1500 | 2.1700 | 48.8750 | 30456.00 | 0.00 | 28944.00 | 141 | 15 | 512 | 948 | 0.540084388185654 | 0.409216055433433 | 0.409216055433433 | false | false | false | |||||||||||||||||
| 34a45d3d-1dfd-4a8f-b697-bae2ab9cea70 | 2026-09-23 09:46 | 2026-09-23 09:46 | 2026-09-23 09:46 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.2200 | 2.2200 | 2.2400 | 48.0000 | 30192.00 | 0.00 | 30192.00 | 136 | 10 | 216 | 1138 | 0.189806678383128 | 0.401737763831035 | 0.401737763831035 | false | false | false | |||||||||||||||||
| 8a864405-b29a-4620-831a-04ded57102fd | 2026-09-23 12:22 | 2026-09-23 12:22 | 2026-09-23 12:22 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.5100 | 2.4900 | 2.5200 | 47.6450 | 21837.00 | 21837.00 | 0.00 | 87 | 10 | 978 | 1138 | 0.859402460456942 | 0.395082533527695 | 0.395082533527695 | false | false | false | |||||||||||||||||
| db5ee338-b0c7-4cbd-a606-a5fe8f286c22 | 2026-09-24 11:05 | 2026-09-24 11:05 | 2026-09-24 11:05 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.5900 | 2.5700 | 2.5900 | 47.4403 | 31857.00 | 31857.00 | 0.00 | 123 | 11 | 326 | 1309 | 0.249045072574484 | 0.397322870614256 | 0.397322870614256 | false | false | false | |||||||||||||||||
| ada50dff-89f5-4e6e-be47-6e15924bc626 | 2026-09-24 13:45 | 2026-09-24 13:45 | 2026-09-24 13:45 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.5200 | 2.5000 | 2.5200 | 47.0000 | 45360.00 | 45360.00 | 0.00 | 180 | 12 | 616 | 1309 | 0.470588235294118 | 0.39839083949012 | 0.39839083949012 | false | false | false | |||||||||||||||||
| 76081b8d-53f2-44f9-8ca5-d35bb0e7841b | 2026-09-25 10:02 | 2026-09-25 10:02 | 2026-09-25 10:02 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.4500 | 2.4500 | 2.4700 | 47.0000 | 23520.00 | 0.00 | 23520.00 | 96 | 11 | 235 | 1573 | 0.149396058486968 | 0.385774189051409 | 0.385774189051409 | false | false | false | |||||||||||||||||
| 88423662-2940-49fd-88df-f9451b650555 | 2026-09-25 10:32 | 2026-09-25 10:32 | 2026-09-25 10:32 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.5100 | 2.5100 | 2.5300 | 47.4012 | 33885.00 | 0.00 | 33885.00 | 135 | 15 | 431 | 1573 | 0.273998728544183 | 0.387617666999007 | 0.387617666999007 | false | false | false | |||||||||||||||||
| 5b612a2b-efae-4214-8de8-b9054127829d | 2026-09-28 09:47 | 2026-09-28 09:47 | 2026-09-28 09:47 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.4600 | 2.4400 | 2.4600 | 47.4405 | 143588.00 | 124968.00 | 0.00 | 584 | 27 | 606 | 1802 | 0.336293007769145 | 0.392760477669945 | 0.391351752145788 | false | false | false | |||||||||||||||||
| 295356f4-6a53-4c86-9523-ac4e01830309 | 2026-09-28 09:50 | 2026-09-28 09:50 | 2026-09-28 09:50 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.5300 | 2.5200 | 2.5500 | 47.2515 | 17710.00 | 0.00 | 17710.00 | 70 | 9 | 677 | 1802 | 0.375693673695893 | 0.39105006585466 | 0.39105006585466 | true | false | false | |||||||||||||||||
| bd9f6a33-4374-41ea-a1c1-c18d0658ef3d | 2026-09-28 09:53 | 2026-09-28 09:53 | 2026-09-28 09:53 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.4900 | 2.4900 | 2.5100 | 47.0000 | 10707.00 | 0.00 | 10707.00 | 43 | 11 | 731 | 1802 | 0.405660377358491 | 0.390255653019309 | 0.390255653019309 | true | false | false | |||||||||||||||||
| 247fa97b-dd44-44c3-b660-8512423f62c3 | 2026-09-29 09:31 | 2026-09-29 09:31 | 2026-09-29 09:31 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.2700 | 2.2600 | 2.3000 | 47.7287 | 25197.00 | 2497.00 | 22700.00 | 111 | 23 | 111 | 2322 | 0.0478036175710594 | 0.385877961975835 | 0.386390543120812 | false | false | false | |||||||||||||||||
| fcd5f948-a38a-42d4-986f-a5a772087354 | 2026-09-29 09:46 | 2026-09-29 09:46 | 2026-09-29 09:46 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.3000 | 2.3000 | 2.3100 | 47.6600 | 96600.00 | 0.00 | 96600.00 | 420 | 13 | 700 | 2322 | 0.301464254952627 | 0.386601944808553 | 0.386601944808553 | false | false | false | |||||||||||||||||
| 49356662-1dd0-43de-8725-bda0f7e54f29 | 2026-09-29 14:01 | 2026-09-29 14:01 | 2026-09-29 14:01 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.4600 | 2.4400 | 2.4600 | 47.1300 | 27552.00 | 27552.00 | 0.00 | 112 | 16 | 1438 | 2322 | 0.619293712316968 | 0.376797648309259 | 0.376797648309259 | false | false | false | |||||||||||||||||
| 22dd1bb0-e685-4645-849f-d0fb073b9cf2 | 2026-09-29 14:05 | 2026-09-29 14:05 | 2026-09-29 14:05 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 2.4500 | 2.4300 | 2.4500 | 47.1779 | 24500.00 | 24500.00 | 0.00 | 100 | 18 | 1739 | 2322 | 0.748923341946598 | 0.378411837817763 | 0.378411837817763 | false | false | false | |||||||||||||||||
| edb43536-8949-4e06-b788-6196474ebaac | 2026-09-30 09:31 | 2026-09-30 09:31 | 2026-09-30 09:31 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 1.9700 | 1.9700 | 2.0100 | 48.3600 | 20685.00 | 0.00 | 20685.00 | 105 | 21 | 105 | 2885 | 0.0363951473136915 | 0.382433685046185 | 0.382433685046185 | false | false | false | |||||||||||||||||
| a8a66ad6-c9a4-4b47-aba1-06cdfd81ec66 | 2026-09-30 09:31 | 2026-09-30 09:31 | 2026-09-30 09:31 | IBIT | IBIT261120P00047000 | put | 47.0000 | 2026-11-20 | 1.9700 | 1.9700 | 2.0000 | 48.3550 | 80179.00 | 0.00 | 80179.00 | 407 | 16 | 512 | 2885 | 0.177469670710572 | 0.38215879197068 | 0.38215879197068 | 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-22T13:32:27.895939Z"} |
| 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-22T16:48:50.097062Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-23T13:46:41.730175Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T16:24:45.701241Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-24T15:08:24.285262Z"} |
| 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 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:02:31.622340Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-25T14:33:57.900979Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:47:49.736283Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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-28T13:51:57.951192Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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-28T13:54:01.711463Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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-29T13:31:56.202644Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-29T13:48:49.550855Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-29T18:03:04.008551Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-29T18:07:24.158187Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-30T13:31:22.078710Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 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-30T13:31:22.078710Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |