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_alerts728,802 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 | expiry |
|---|
| 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 |
|---|
| fec7f696-014d-45df-a1c5-a698cf79e2b4 | 2026-09-29 12:07 | 2026-09-29 12:07 | 2026-09-29 12:07 | IBIT | IBIT261016P00043500 | put | 43.5000 | 2026-10-16 | 0.3200 | 0.3100 | 0.3200 | 46.0000 | 13888.00 | 13888.00 | 0.00 | 434 | 21 | 1486 | 3509 | 0.423482473639213 | 0.374555037345349 | 0.374555037345349 | 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-29T16:08:27.647293Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 75a749af-a0b5-409a-b14a-0719464a0b48 | 2026-09-29 09:52 | 2026-09-29 09:52 | 2026-09-29 09:52 | IBIT | IBIT261016P00043500 | put | 43.5000 | 2026-10-16 | 0.2500 | 0.2400 | 0.2700 | 47.7050 | 21375.00 | 0.00 | 21375.00 | 855 | 48 | 856 | 3509 | 0.243944143630664 | 0.388499358007208 | 0.388499358007208 | false | false | false | true | ||||||||||||||||
| 418a599c-aeba-489d-923d-96e04f3459da | 2026-09-28 10:14 | 2026-09-28 10:14 | 2026-09-28 10:14 | IBIT | IBIT261016P00043500 | put | 43.5000 | 2026-10-16 | 0.3700 | 0.3500 | 0.3700 | 47.2001 | 14800.00 | 14800.00 | 0.00 | 400 | 22 | 900 | 2665 | 0.337711069418386 | 0.398507947484493 | 0.398507947484493 | false | false | false | true | ||||||||||||||||
| f99e80ca-4f56-4d9b-baeb-fb00b2b98e7f | 2026-09-28 10:06 | 2026-09-28 10:06 | 2026-09-28 10:06 | IBIT | IBIT261016P00043500 | put | 43.5000 | 2026-10-16 | 0.3600 | 0.3500 | 0.3700 | 47.1900 | 18188.00 | 18188.00 | 0.00 | 500 | 41 | 500 | 2665 | 0.187617260787992 | 0.393957253648492 | 0.397872321958274 | false | false | false | true | ||||||||||||||||
| b8db612f-51f2-46a9-8614-e842b83e5173 | 2026-09-21 12:32 | 2026-09-21 12:32 | 2026-09-21 12:32 | IBIT | IBIT261016P00043500 | put | 43.5000 | 2026-10-16 | 0.4000 | 0.4000 | 0.4100 | 48.0000 | 10560.00 | 0.00 | 10560.00 | 264 | 9 | 3095 | 0 | 0 | 0.427261754014647 | 0.427261754014647 | true | false | false | true | ||||||||||||||||
| e420211c-9fe5-41b1-952b-ead2d1977ede | 2026-09-21 09:40 | 2026-09-21 09:40 | 2026-09-21 09:40 | IBIT | IBIT261016P00043500 | put | 43.5000 | 2026-10-16 | 0.4600 | 0.4400 | 0.4600 | 48.2000 | 55200.00 | 55200.00 | 0.00 | 1200 | 43 | 2400 | 0 | 0 | 0.42238116716475 | 0.42238116716475 | false | false | false | true | ||||||||||||||||
| ec144b37-29dd-46e5-9598-26fa4129760e | 2026-09-21 09:40 | 2026-09-21 09:40 | 2026-09-21 09:40 | IBIT | IBIT261016P00043500 | put | 43.5000 | 2026-10-16 | 0.4500 | 0.4400 | 0.4500 | 48.1900 | 46935.00 | 46935.00 | 0.00 | 1043 | 18 | 1043 | 0 | 0 | 0.418550886528642 | 0.418550886528642 | 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-29T13:54:00.139875Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-28T14:15:56.070001Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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-28T14:09:02.122615Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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-21T16:32:17.927421Z"} |
| 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-21T13:40:40.009181Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T13:40:40.009181Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |