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.
Simplify Analyticsuw_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 |
|---|
| 3118d344-439a-42ba-804f-fae3510f7703 | 2026-09-23 10:13 | 2026-09-23 10:13 | 2026-09-23 10:13 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 1.0800 | 1.0600 | 1.0800 | 47.0000 | 14688.00 | 14688.00 | 0.00 | 136 | 13 | 2320 | 45143 | 0.0513922424296126 | 0.392120718279173 | 0.392120718279173 | true | 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-23T14:14:46.490149Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 50eb9d79-5849-44a7-b3aa-76d89e69d8e6 | 2026-09-23 10:14 | 2026-09-23 10:14 | 2026-09-23 10:14 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 1.1500 | 1.1300 | 1.1500 | 48.0000 | 51750.00 | 51750.00 | 0.00 | 450 | 9 | 2772 | 45143 | 0.0614048689719336 | 0.392837827115335 | 0.392837827115335 | false | false | false | true | ||||||||||||||||
| 223bf83b-118c-4dad-af5b-75dffe8a4906 | 2026-09-23 10:17 | 2026-09-23 10:17 | 2026-09-23 10:17 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 1.0600 | 1.0600 | 1.0700 | 47.8400 | 10600.00 | 0.00 | 10600.00 | 100 | 27 | 2975 | 45143 | 0.0659016901845247 | 0.390029306308415 | 0.390029306308415 | false | false | false | true | ||||||||||||||||
| 254023e6-3d02-4db8-af85-7aa7f214c3d1 | 2026-09-23 10:20 | 2026-09-23 10:19 | 2026-09-23 10:19 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 1.0100 | 1.0100 | 1.0300 | 47.7750 | 20200.00 | 0.00 | 20200.00 | 200 | 19 | 3394 | 45143 | 0.0751833063819418 | 0.383883257009058 | 0.383883257009058 | false | false | false | true | ||||||||||||||||
| 133ec5a0-9d1f-401e-8aca-74f65022806d | 2026-09-23 11:33 | 2026-09-23 11:33 | 2026-09-23 11:33 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 1.0100 | 1.0100 | 1.0300 | 47.7900 | 20200.00 | 0.00 | 20200.00 | 200 | 15 | 5013 | 45143 | 0.111047116939503 | 0.382711079729207 | 0.382711079729207 | false | false | false | true | ||||||||||||||||
| c61999c9-1546-4ae8-8263-254efcbf46db | 2026-09-23 12:01 | 2026-09-23 12:01 | 2026-09-23 12:01 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 0.9000 | 0.8900 | 0.9100 | 47.3800 | 13500.00 | 8370.00 | 540.00 | 150 | 10 | 5494 | 45143 | 0.121702146512195 | 0.388656888888017 | 0.388656888888017 | true | false | false | true | ||||||||||||||||
| 2099ab8d-b7b6-4ea1-a26a-e65b6315869d | 2026-09-23 15:29 | 2026-09-23 15:29 | 2026-09-23 15:29 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 1.0100 | 1.0100 | 1.0300 | 47.0000 | 20200.00 | 0.00 | 20200.00 | 200 | 24 | 7305 | 45143 | 0.161819108167379 | 0.383492643182632 | 0.383492643182632 | false | false | false | true | ||||||||||||||||
| 68101842-9aba-4a1d-b665-ffca5344e7f7 | 2026-09-23 15:30 | 2026-09-23 15:30 | 2026-09-23 15:30 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 1.0300 | 1.0200 | 1.0300 | 47.0000 | 25956.00 | 25956.00 | 0.00 | 252 | 5 | 7572 | 45143 | 0.167733646412511 | 0.38565606507667 | 0.38565606507667 | false | false | false | true | ||||||||||||||||
| 9b3e3e61-eb2b-4ebf-8a04-4ff69ef58413 | 2026-09-24 09:33 | 2026-09-24 09:33 | 2026-09-24 09:33 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 0.9300 | 0.9200 | 0.9400 | 47.6300 | 11520.00 | 0.00 | 11520.00 | 124 | 6 | 313 | 45346 | 0.00690248312971376 | 0.38559664928063 | 0.383233225022013 | true | false | false | true | ||||||||||||||||
| a4fd8284-27b2-471a-a2c6-c90177fc6a6d | 2026-09-24 09:46 | 2026-09-24 09:46 | 2026-09-24 09:46 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 0.8600 | 0.8600 | 0.8800 | 47.4750 | 38792.00 | 0.00 | 38705.00 | 450 | 5 | 854 | 45346 | 0.018832973139858 | 0.383229029483244 | 0.380815869262653 | false | false | false | true | ||||||||||||||||
| 98f049ed-92ec-4679-a3dc-b0e4621103bf | 2026-09-24 12:36 | 2026-09-24 12:35 | 2026-09-24 12:35 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 0.9900 | 0.9800 | 0.9900 | 47.8951 | 10197.00 | 10197.00 | 0.00 | 103 | 6 | 1876 | 45346 | 0.04137079345477 | 0.378639514355392 | 0.378639514355392 | true | false | false | true | ||||||||||||||||
| 9873d348-f1f7-4934-a3cd-237b07b3f48b | 2026-09-24 12:36 | 2026-09-24 12:35 | 2026-09-24 12:35 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 0.9900 | 0.9800 | 0.9900 | 47.8951 | 19503.00 | 19503.00 | 0.00 | 197 | 6 | 1773 | 45346 | 0.0390993692938738 | 0.378639514355392 | 0.378639514355392 | true | false | false | true | ||||||||||||||||
| 5f257d9f-ecc4-4e37-ae04-fec1b6f9ebdb | 2026-09-24 13:46 | 2026-09-24 13:46 | 2026-09-24 13:46 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 0.9100 | 0.9000 | 0.9100 | 47.0000 | 13286.00 | 13286.00 | 0.00 | 146 | 8 | 2240 | 45346 | 0.0493979623340537 | 0.378545049646894 | 0.378545049646894 | true | false | false | true | ||||||||||||||||
| 4ed752d3-d8b5-40f0-ade5-fd68d2b7ea44 | 2026-09-25 15:53 | 2026-09-25 15:53 | 2026-09-25 15:53 | IBIT | IBIT261016C00050000 | call | 50.0000 | 2026-10-16 | 0.7300 | 0.7300 | 0.7500 | 47.5500 | 14381.00 | 0.00 | 14381.00 | 197 | 23 | 2253 | 45238 | 0.049803262743711 | 0.351905986853455 | 0.351905986853455 | false | false | false | true |
| 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-23T14:14:46.490149Z"} |
| 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:18:11.787457Z"} |
| 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:21:45.775363Z"} |
| 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-23T15:35:15.101362Z"} |
| 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-23T16:06:31.927382Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T19:31:17.816750Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T19:31:17.816750Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-24T13:34:09.637313Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T13:47:07.799094Z"} |
| 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-24T16:36:42.025876Z"} |
| 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-24T16:36:42.025876Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T17:47:19.997705Z"} |
| 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-25T19:54:56.567521Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |