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 | 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 |
|---|
| 26ddd3e1-008b-48ea-93ab-77ad8161cb40 | 2026-08-24 13:38 | 2026-08-24 13:38 | 2026-08-24 13:38 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.5600 | 0.5600 | 0.5900 | 44.6100 | 119952.00 | 0.00 | 119952.00 | 2142 | 51 | 2858 | 8092 | 0.353188334157192 | 0.539186469408246 | 0.539186469408246 | 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-24T17:47:44.554262Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8195e3c8-68ec-4d6e-915d-179644976a81 | 2026-08-24 13:49 | 2026-08-24 13:48 | 2026-08-24 13:48 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.5300 | 0.5300 | 0.5700 | 44.6000 | 159106.00 | 0.00 | 159106.00 | 3002 | 66 | 5879 | 8092 | 0.726520019772615 | 0.532450737814146 | 0.532450737814146 | false | false | false | true | ||||||||||||||||
| 3aaec9a5-50c2-4638-a682-579fda2ab9db | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.4000 | 0.3900 | 0.4000 | 48.5150 | 80000.00 | 80000.00 | 0.00 | 2000 | 42 | 2025 | 14053 | 0.144097345762471 | 0.483679876830198 | 0.483679876830198 | false | false | false | true | ||||||||||||||||
| a95a24b9-c8cc-413d-9ffc-8956ae4a23c4 | 2026-09-21 10:33 | 2026-09-21 10:33 | 2026-09-21 10:33 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.4100 | 0.4000 | 0.4100 | 48.6797 | 21238.00 | 21238.00 | 0.00 | 518 | 19 | 2543 | 14053 | 0.180957802604426 | 0.482631777786094 | 0.482631777786094 | false | false | false | true | ||||||||||||||||
| 97c37d6d-9477-42ee-92e0-c04763066997 | 2026-09-21 10:39 | 2026-09-21 10:39 | 2026-09-21 10:39 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.4300 | 0.4100 | 0.4300 | 48.6350 | 279371.00 | 279371.00 | 0.00 | 6497 | 56 | 9040 | 14053 | 0.643279015156906 | 0.488974386043701 | 0.488974386043701 | false | false | false | true | ||||||||||||||||
| e5937a37-7a23-47c9-b837-f5100c586407 | 2026-09-21 10:40 | 2026-09-21 10:40 | 2026-09-21 10:40 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.4300 | 0.4200 | 0.4300 | 48.6150 | 67639.00 | 67639.00 | 0.00 | 1573 | 30 | 10613 | 14053 | 0.755212410161531 | 0.48943555285657 | 0.48943555285657 | false | false | false | true | ||||||||||||||||
| 4eded4d4-2d3d-433f-a6ae-d1f6e6a6397f | 2026-09-21 10:46 | 2026-09-21 10:46 | 2026-09-21 10:46 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.4300 | 0.4200 | 0.4400 | 48.5806 | 168646.00 | 164260.00 | 817.00 | 3922 | 37 | 16088 | 14053 | 1.1448089375934 | 0.490229100168167 | 0.490229100168167 | false | false | false | true | ||||||||||||||||
| 199ba046-163a-413b-995e-1a4a98ba313f | 2026-09-21 10:46 | 2026-09-21 10:46 | 2026-09-21 10:46 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.4300 | 0.4200 | 0.4300 | 48.5806 | 66349.00 | 66349.00 | 0.00 | 1543 | 63 | 12166 | 14053 | 0.865722621504305 | 0.490229100168167 | 0.490229100168167 | false | false | false | true | ||||||||||||||||
| 68a0b6f6-d5c2-45b2-8de6-03a58408942f | 2026-09-21 10:53 | 2026-09-21 10:53 | 2026-09-21 10:53 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.4500 | 0.4400 | 0.4550 | 48.7750 | 194535.00 | 192870.00 | 1665.00 | 4323 | 46 | 20857 | 14053 | 1.4841670817619 | 0.490923507279408 | 0.490923507279408 | false | false | false | true | ||||||||||||||||
| 62a4fcd7-833a-4c6c-a4bb-85a0ff825978 | 2026-09-21 10:59 | 2026-09-21 10:59 | 2026-09-21 10:59 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.4600 | 0.4500 | 0.4700 | 48.6100 | 361054.00 | 352820.00 | 8234.00 | 7849 | 80 | 29084 | 14053 | 2.06959368106454 | 0.497428821042301 | 0.497312157806227 | false | false | false | true | ||||||||||||||||
| f2a1bf73-42bb-49dc-a4be-937776d76264 | 2026-09-21 11:01 | 2026-09-21 11:01 | 2026-09-21 11:01 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.4700 | 0.4600 | 0.4700 | 48.7150 | 21385.00 | 21385.00 | 0.00 | 455 | 8 | 29682 | 14053 | 2.1121468725539 | 0.497386361560141 | 0.497386361560141 | false | false | false | true | ||||||||||||||||
| 7bf7f988-3d8d-48a4-ae0d-71f713a08880 | 2026-09-21 14:05 | 2026-09-21 14:05 | 2026-09-21 14:05 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.4800 | 0.4800 | 0.4900 | 48.0000 | 327120.00 | 0.00 | 327120.00 | 6815 | 29 | 40004 | 14053 | 2.84665196043549 | 0.499999528475078 | 0.499999528475078 | false | false | false | true | ||||||||||||||||
| 3cefc2fa-6541-424f-8f4b-79b9c6d11906 | 2026-09-21 15:44 | 2026-09-21 15:44 | 2026-09-21 15:44 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.5000 | 0.4900 | 0.5000 | 49.0150 | 16950.00 | 16950.00 | 0.00 | 339 | 16 | 40538 | 14053 | 2.88465096420693 | 0.497725353364996 | 0.497725353364996 | false | false | false | true | ||||||||||||||||
| 560adb45-9394-4364-8fe3-9e626cd49aa2 | 2026-09-21 15:44 | 2026-09-21 15:44 | 2026-09-21 15:44 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.5000 | 0.4900 | 0.5000 | 49.0150 | 50000.00 | 50000.00 | 0.00 | 1000 | 18 | 42199 | 14053 | 3.0028463673237 | 0.497725353364996 | 0.497725353364996 | false | false | false | true | ||||||||||||||||
| f397b79c-69d0-4a15-81f7-7538760084d3 | 2026-09-21 15:44 | 2026-09-21 15:44 | 2026-09-21 15:44 | IBIT | IBIT261218C00070000 | call | 70.0000 | 2026-12-18 | 0.5000 | 0.4900 | 0.5100 | 49.0150 | 40650.00 | 39500.00 | 50.00 | 813 | 15 | 43013 | 14053 | 3.06076994236106 | 0.497725353364996 | 0.497725353364996 | true | 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-08-24T18:20:03.734818Z"} |
| 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-21T14:32:01.820117Z"} |
| 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:34:41.643622Z"} |
| 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:42:35.959490Z"} |
| 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:47:49.730853Z"} |
| 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:47:49.730853Z"} |
| 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:55:57.762099Z"} |
| 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-21T15:02:30.535242Z"} |
| 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-21T15:02:30.535242Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T18:09:57.736377Z"} |
| 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-21T19:46:53.809312Z"} |
| 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-21T19:46:53.809312Z"} |
| 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-21T19:46:53.809312Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |