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_alerts566,287 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 |
|---|
| 0c53f27a-9b2e-415f-aec7-b2bc0c14938a | 2026-09-21 10:36 | 2026-09-21 10:36 | 2026-09-21 10:36 | IWM | IWM261002C00288000 | call | 288.0000 | 2026-10-02 | 2.2200 | 2.2200 | 2.2500 | 285.6900 | 10434.00 | 0.00 | 10434.00 | 47 | 9 | 305 | 527 | 0.578747628083491 | 0.15636208648056 | 0.15636208648056 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 78247032269.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:37:14.719915Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 8aa7b68c-bc75-4615-af54-0bd26fe51a13 | 2026-09-21 11:50 | 2026-09-21 11:50 | 2026-09-21 11:50 | IWM | IWM261002C00288000 | call | 288.0000 | 2026-10-02 | 2.4500 | 2.4000 | 2.4500 | 286.1250 | 15680.00 | 15680.00 | 0.00 | 64 | 10 | 453 | 527 | 0.859582542694497 | 0.158867701653621 | 0.158867701653621 | true | false | false | |||||||||||||||||
| d6cd1151-be73-44e3-b50c-c0efad1dd4e3 | 2026-09-21 13:53 | 2026-09-21 13:53 | 2026-09-21 13:53 | IWM | IWM261002C00288000 | call | 288.0000 | 2026-10-02 | 2.2100 | 2.1800 | 2.2100 | 285.6300 | 28951.00 | 28951.00 | 0.00 | 131 | 7 | 794 | 527 | 1.50664136622391 | 0.157106311870189 | 0.157104212093264 | true | false | false | |||||||||||||||||
| ee12bb93-47af-4537-9844-6362c582efed | 2026-09-22 09:40 | 2026-09-22 09:40 | 2026-09-22 09:40 | IWM | IWM261002C00288000 | call | 288.0000 | 2026-10-02 | 2.9100 | 2.9100 | 2.9400 | 287.2100 | 24444.00 | 0.00 | 24444.00 | 84 | 13 | 211 | 611 | 0.345335515548282 | 0.165594044780752 | 0.165594044780752 | false | false | false | |||||||||||||||||
| 5cf95056-2be1-4bac-a41f-4358f720cd13 | 2026-09-22 09:41 | 2026-09-22 09:41 | 2026-09-22 09:41 | IWM | IWM261002C00288000 | call | 288.0000 | 2026-10-02 | 2.9400 | 2.9400 | 2.9700 | 287.2600 | 47628.00 | 0.00 | 47628.00 | 162 | 8 | 410 | 611 | 0.671031096563011 | 0.165903884425582 | 0.165903884425582 | false | false | false | |||||||||||||||||
| 678d515a-09e5-439d-942a-544a73accaed | 2026-09-22 11:56 | 2026-09-22 11:56 | 2026-09-22 11:56 | IWM | IWM261002C00288000 | call | 288.0000 | 2026-10-02 | 2.4200 | 2.4000 | 2.4300 | 286.4002 | 17666.00 | 5082.00 | 12584.00 | 73 | 6 | 767 | 611 | 1.25531914893617 | 0.159343518149304 | 0.159343518149304 | false | false | false | |||||||||||||||||
| 68d3e4a4-54ce-4b6c-b010-daef8d7b7e1f | 2026-09-22 12:00 | 2026-09-22 12:00 | 2026-09-22 12:00 | IWM | IWM261002C00288000 | call | 288.0000 | 2026-10-02 | 2.5100 | 2.4800 | 2.5200 | 286.6000 | 19829.00 | 19829.00 | 0.00 | 79 | 7 | 952 | 611 | 1.55810147299509 | 0.159424039723826 | 0.159424039723826 | true | false | false | |||||||||||||||||
| 3d208838-fd3f-4f9f-ad98-c51bd3a9a29d | 2026-09-22 13:31 | 2026-09-22 13:30 | 2026-09-22 13:30 | IWM | IWM261002C00288000 | call | 288.0000 | 2026-10-02 | 2.6800 | 2.6400 | 2.6800 | 286.0000 | 19564.00 | 19564.00 | 0.00 | 73 | 12 | 1057 | 611 | 1.72995090016367 | 0.160200082967448 | 0.160200082967448 | true | false | false | |||||||||||||||||
| 11d9753e-46a5-47a2-8ae4-ebb9892da1da | 2026-09-25 09:45 | 2026-09-25 09:45 | 2026-09-25 09:45 | IWM | IWM261002C00288000 | call | 288.0000 | 2026-10-02 | 0.7700 | 0.7300 | 0.7700 | 281.7400 | 38500.00 | 38500.00 | 0.00 | 500 | 19 | 536 | 3740 | 0.14331550802139 | 0.1791326445712 | 0.1791326445712 | false | false | false | |||||||||||||||||
| 21d941e0-f3e2-4142-8652-3a1231b1ec80 | 2026-09-25 10:50 | 2026-09-25 10:50 | 2026-09-25 10:50 | IWM | IWM261002C00288000 | call | 288.0000 | 2026-10-02 | 0.5500 | 0.5400 | 0.5500 | 280.9500 | 11605.00 | 11605.00 | 0.00 | 211 | 10 | 1157 | 3740 | 0.309358288770054 | 0.171416257083796 | 0.171416257083796 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:52:20.515056Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:55:32.885478Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:41:44.035284Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:41:44.035284Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:56:22.412787Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:00:55.569269Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:47:32.064714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:52:00.220874Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |