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 |
|---|
| 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 |
|---|
| ddc8d42d-65bf-471c-a68d-4cf9c1f97e4e | 2026-08-19 12:15 | 2026-08-19 12:15 | 2026-08-19 12:15 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 2.2800 | 2.2500 | 2.3100 | 38.9300 | 64296.00 | 14820.00 | 49476.00 | 282 | 8 | 2000 | 27245 | 0.0734079647641769 | 0.422190283324729 | 0.421822817756278 | 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-08-19T16:28:32.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 51ce4998-cfba-440f-af5a-1b2a815c4491 | 2026-08-20 12:52 | 2026-08-20 12:51 | 2026-08-20 12:51 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 3.2900 | 3.2000 | 3.3000 | 41.1300 | 65871.00 | 65871.00 | 0.00 | 200 | 12 | 2721 | 27276 | 0.0997580290365156 | 0.435813538266695 | 0.433883488015338 | false | false | false | true | ||||||||||||||||
| a5601c1b-a2d9-4607-8f97-0b90aaf38902 | 2026-08-20 15:58 | 2026-08-20 15:58 | 2026-08-20 15:58 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 3.2500 | 3.2500 | 3.3000 | 41.1550 | 65000.00 | 0.00 | 65000.00 | 200 | 7 | 3298 | 27276 | 0.120912157207802 | 0.429907513910746 | 0.429907513910746 | false | false | false | true | ||||||||||||||||
| 9afed302-0bc8-4f66-a78b-215cb33cbe0b | 2026-08-28 11:53 | 2026-08-28 11:53 | 2026-08-28 11:53 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 4.6500 | 4.6500 | 4.7000 | 44.0000 | 93000.00 | 0.00 | 93000.00 | 200 | 10 | 508 | 23415 | 0.0216954943412343 | 0.416103780435964 | 0.416103780435964 | false | false | false | true | ||||||||||||||||
| e772356c-13b9-4169-b1eb-773abdf12174 | 2026-09-03 11:28 | 2026-09-03 11:28 | 2026-09-03 11:28 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 5.4000 | 5.3000 | 5.4000 | 45.7350 | 135000.00 | 135000.00 | 0.00 | 250 | 20 | 782 | 22751 | 0.0343721155114061 | 0.430346099276474 | 0.430346099276474 | true | false | false | true | ||||||||||||||||
| 9b0ea932-bf6e-4794-8b92-9d76b036ff13 | 2026-09-03 14:04 | 2026-09-03 14:04 | 2026-09-03 14:04 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 5.6000 | 5.5500 | 5.6000 | 46.0100 | 58800.00 | 58800.00 | 0.00 | 105 | 9 | 1236 | 22751 | 0.0543272823172608 | 0.433542384109528 | 0.433542384109528 | false | false | false | true | ||||||||||||||||
| 30e022da-baab-4dc7-9e66-2880a4e6dacb | 2026-09-10 14:16 | 2026-09-10 14:16 | 2026-09-10 14:16 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 3.8500 | 3.8500 | 3.9000 | 43.6150 | 77000.00 | 0.00 | 77000.00 | 200 | 10 | 901 | 24665 | 0.0365294952361646 | 0.408581059943534 | 0.408581059943534 | true | false | false | true | ||||||||||||||||
| 4a2813ed-3bdf-4709-b701-a83acb94a857 | 2026-09-14 14:03 | 2026-09-14 14:02 | 2026-09-14 14:02 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 4.4000 | 4.3000 | 4.4000 | 44.6800 | 88000.00 | 88000.00 | 0.00 | 200 | 32 | 328 | 23966 | 0.0136860552449303 | 0.412920585770533 | 0.412920585770533 | false | false | false | true | ||||||||||||||||
| 36452254-e110-41b1-8f4f-38af644b84bf | 2026-09-14 15:43 | 2026-09-14 15:43 | 2026-09-14 15:43 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 4.5000 | 4.4500 | 4.5000 | 44.8185 | 134999.00 | 134999.00 | 0.00 | 300 | 8 | 679 | 23966 | 0.0283318033881332 | 0.415092201130243 | 0.414116152326449 | false | false | false | true | ||||||||||||||||
| f1e24af4-aa26-4d14-9b55-187832c7692a | 2026-09-15 11:00 | 2026-09-15 11:00 | 2026-09-15 11:00 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 3.5000 | 3.4500 | 3.5000 | 42.0000 | 227500.00 | 227500.00 | 0.00 | 650 | 30 | 1101 | 24392 | 0.0451377500819941 | 0.414564097898887 | 0.414564097898887 | false | false | false | true | ||||||||||||||||
| 4d20d7c3-8d1f-450f-a076-40639297c765 | 2026-09-18 09:56 | 2026-09-18 09:56 | 2026-09-18 09:56 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 4.5600 | 4.5500 | 4.6500 | 45.3701 | 114061.00 | 0.00 | 114061.00 | 250 | 13 | 948 | 25271 | 0.0375133552293142 | 0.395406932096688 | 0.39879592720005 | false | false | false | true | ||||||||||||||||
| b49094fe-d14f-4295-ba79-a301f08b493e | 2026-09-18 12:42 | 2026-09-18 12:42 | 2026-09-18 12:42 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 4.9000 | 4.8500 | 4.9500 | 45.8501 | 73454.00 | 0.00 | 22494.00 | 150 | 6 | 1439 | 25271 | 0.0569427406909105 | 0.401337560910141 | 0.401337560910141 | false | false | false | true | ||||||||||||||||
| d5996eef-1c42-4cf6-8e37-2fce0f88356c | 2026-09-21 14:37 | 2026-09-21 14:37 | 2026-09-21 14:37 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 6.8500 | 6.8500 | 6.9000 | 48.6600 | 318040.00 | 34400.00 | 283640.00 | 464 | 7 | 1912 | 25270 | 0.0756628413138108 | 0.421167184485546 | 0.424279454512573 | false | false | false | true | ||||||||||||||||
| d0b192da-fcd0-41b9-aae4-92e05b0b4057 | 2026-09-25 10:06 | 2026-09-25 10:06 | 2026-09-25 10:06 | IBIT | IBIT270115C00045000 | call | 45.0000 | 2027-01-15 | 5.6000 | 5.6000 | 5.7000 | 47.1650 | 95200.00 | 0.00 | 95200.00 | 170 | 7 | 309 | 25122 | 0.0122999761165512 | 0.403474540396141 | 0.403474540396141 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T18:16:35.526734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-15T15:09:54.469160Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 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-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-21T18:37:54.025147Z"} |
| 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-25T14:07:37.625722Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |