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_alerts523,327 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 |
|---|
| 4d0f2a74-d1d4-4b9e-a97a-8973c2a1f64c | 2026-09-22 11:10 | 2026-09-22 11:09 | 2026-09-22 11:09 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.6900 | 0.6900 | 0.7000 | 48.0000 | 15111.00 | 0.00 | 15111.00 | 219 | 16 | 4120 | 10223 | 0.403012814242395 | 0.424119831479485 | 0.424119831479485 | false | false | false | true | 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-22T15:10:39.659738Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 6d795d69-47d2-4b84-ae36-95b1a906c706 | 2026-09-22 10:49 | 2026-09-22 10:49 | 2026-09-22 10:49 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.6000 | 0.5900 | 0.6000 | 48.7050 | 27240.00 | 27240.00 | 0.00 | 453 | 21 | 3433 | 10223 | 0.335811405653918 | 0.413850686805298 | 0.413850686805298 | true | false | false | true | false | |||||||||||||||
| c17e5f81-da92-4402-8518-43df2b64d41c | 2026-09-22 10:36 | 2026-09-22 10:35 | 2026-09-22 10:35 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.4800 | 0.4700 | 0.4900 | 48.3922 | 36000.00 | 23472.00 | 0.00 | 750 | 5 | 2637 | 10223 | 0.257947764843979 | 0.419405744145846 | 0.419405744145846 | true | false | false | true | false | |||||||||||||||
| fe992aec-4a7c-4c89-8d4b-25b5820fc36c | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.5900 | 0.5800 | 0.6000 | 48.5700 | 42303.00 | 118.00 | 42185.00 | 717 | 6 | 855 | 10223 | 0.0836349408197202 | 0.44193622142832 | 0.44193622142832 | false | false | false | true | false | |||||||||||||||
| 36870f6b-e7fa-424e-97a5-811c2621ef4f | 2026-09-21 15:24 | 2026-09-21 15:24 | 2026-09-21 15:24 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.8700 | 0.8700 | 0.8900 | 48.8550 | 43500.00 | 0.00 | 43500.00 | 500 | 25 | 16663 | 3604 | 4.62347391786903 | 0.455535388519499 | 0.455535388519499 | false | false | false | true | false | |||||||||||||||
| 94a28954-d14f-4780-a62d-e77835da9a2a | 2026-09-21 13:57 | 2026-09-21 13:57 | 2026-09-21 13:57 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.7600 | 0.7500 | 0.7600 | 48.6351 | 27360.00 | 27360.00 | 0.00 | 360 | 13 | 14938 | 3604 | 4.14483906770255 | 0.452187780169211 | 0.452187780169211 | false | false | false | true | false | |||||||||||||||
| 3cf06bdd-2c75-4c14-8a3d-a8b4d8f90d42 | 2026-09-21 12:17 | 2026-09-21 12:17 | 2026-09-21 12:17 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.8200 | 0.8100 | 0.8200 | 48.7100 | 40344.00 | 40344.00 | 0.00 | 492 | 9 | 12480 | 3604 | 3.46281908990011 | 0.464919633172688 | 0.464919633172688 | true | false | false | true | false | |||||||||||||||
| d373f2b3-ff67-4a69-96ea-b2d9440c19fb | 2026-09-21 10:58 | 2026-09-21 10:58 | 2026-09-21 10:58 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.8300 | 0.8300 | 0.8400 | 48.6100 | 15106.00 | 0.00 | 15106.00 | 182 | 30 | 10224 | 3604 | 2.83684794672586 | 0.492539239257544 | 0.492539239257544 | false | false | false | true | false | |||||||||||||||
| dec9b193-393d-4c5d-9b12-25b5926e2fe4 | 2026-09-21 10:58 | 2026-09-21 10:58 | 2026-09-21 10:58 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.8300 | 0.8300 | 0.8400 | 48.6000 | 12367.00 | 0.00 | 12367.00 | 149 | 14 | 10042 | 3604 | 2.78634850166482 | 0.494779242293011 | 0.494779242293011 | false | false | false | true | false | |||||||||||||||
| 01de448d-7076-4ff5-a6fa-8bff8f47d522 | 2026-09-21 10:38 | 2026-09-21 10:38 | 2026-09-21 10:38 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.8900 | 0.8900 | 0.9000 | 48.6701 | 47170.00 | 0.00 | 47170.00 | 530 | 23 | 9443 | 3604 | 2.62014428412875 | 0.507503783223733 | 0.508626058808316 | false | false | false | true | false | |||||||||||||||
| 5d15bf58-a612-4c51-a0b2-11a0ef133238 | 2026-09-21 10:28 | 2026-09-21 10:28 | 2026-09-21 10:28 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.8200 | 0.8200 | 0.8300 | 48.5499 | 43460.00 | 0.00 | 43460.00 | 530 | 20 | 8362 | 3604 | 2.32019977802442 | 0.500948227015181 | 0.500948227015181 | false | false | false | true | false | |||||||||||||||
| 8c81aa43-c884-4165-bc53-fdaf68d788e2 | 2026-09-21 10:03 | 2026-09-21 10:03 | 2026-09-21 10:03 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.7300 | 0.7300 | 0.7400 | 48.3350 | 10512.00 | 0.00 | 10512.00 | 144 | 9 | 7477 | 3604 | 2.07463928967814 | 0.501858937537181 | 0.501858937537181 | true | false | false | true | false | |||||||||||||||
| e6acad08-f833-4696-8e75-42f181231d1a | 2026-09-09 09:33 | 2026-09-09 09:33 | 2026-09-09 09:33 | IBIT | IBIT260925C00049000 | call | 49.0000 | 2026-09-25 | 0.4600 | 0.4500 | 0.4600 | 45.0300 | 81420.00 | 81420.00 | 0.00 | 1770 | 22 | 1771 | 762 | 2.3241469816273 | 0.449587845154992 | 0.449587845154992 | false | false | false | true | false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:51:29.790694Z"} |
| 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-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 |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:31:35.812482Z"} |
| 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-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T18:00:14.697100Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T16:17:17.704519Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T14:59:04.068372Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T14:59:04.068372Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T14:39:35.705687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T14:29:33.809340Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T14:04:59.983035Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |