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 |
|---|
| 088e1578-7f0e-448b-bd30-618500c0a2f5 | 2026-09-15 09:45 | 2026-09-15 09:45 | 2026-09-15 09:45 | IBRX | IBRX260918C00007500 | call | 7.5000 | 2026-09-18 | 0.7000 | 0.5500 | 1.1500 | 8.2100 | 148470.00 | 30800.00 | 117670.00 | 2121 | 46 | 2121 | 5973 | 0.3550979407333 | 0 | 2.61249790412802 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 8870829605.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| fa8a8baa-37a2-46ce-bb15-1c897ad7c4d1 | 2026-09-11 15:59 | 2026-09-11 15:58 | 2026-09-11 15:58 | IBRX | IBRX260918C00007500 | call | 7.5000 | 2026-09-18 | 0.4500 | 0.4500 | 0.6500 | 7.8850 | 40500.00 | 0.00 | 40500.00 | 900 | 12 | 6999 | 8260 | 0.847336561743341 | 0.461376354076739 | 0.461376354076739 | false | false | false | true | ||||||||||||||||
| 6302e84b-872c-4a8e-aa95-a7b97ff9e319 | 2026-09-11 15:57 | 2026-09-11 15:57 | 2026-09-11 15:57 | IBRX | IBRX260918C00007500 | call | 7.5000 | 2026-09-18 | 0.5000 | 0.4500 | 0.6500 | 7.9000 | 50000.00 | 8000.00 | 42000.00 | 1000 | 10 | 6049 | 8260 | 0.732324455205811 | 0.578602387254741 | 0.578602387254741 | false | false | false | true | ||||||||||||||||
| dc53912a-bc6a-4e70-bedd-683635701bfd | 2026-09-11 15:57 | 2026-09-11 15:57 | 2026-09-11 15:57 | IBRX | IBRX260918C00007500 | call | 7.5000 | 2026-09-18 | 0.5000 | 0.5000 | 0.6500 | 7.9213 | 50050.00 | 0.00 | 50050.00 | 1000 | 19 | 5049 | 8260 | 0.611259079903148 | 0.493864154648094 | 0.559821849262082 | false | false | false | true | ||||||||||||||||
| 4deb51de-97e9-4be1-a663-a66625c1db90 | 2026-09-11 15:56 | 2026-09-11 15:55 | 2026-09-11 15:55 | IBRX | IBRX260918C00007500 | call | 7.5000 | 2026-09-18 | 0.6000 | 0.6000 | 0.8000 | 8.0300 | 60000.00 | 0.00 | 60000.00 | 1000 | 12 | 3049 | 8260 | 0.369128329297821 | 0.525935825500161 | 0.570454764588392 | false | false | false | true | ||||||||||||||||
| 96345fcd-4361-4440-86f7-14a8616d1367 | 2026-09-11 15:55 | 2026-09-11 15:55 | 2026-09-11 15:55 | IBRX | IBRX260918C00007500 | call | 7.5000 | 2026-09-18 | 0.6000 | 0.6000 | 0.8000 | 8.0600 | 15618.00 | 0.00 | 15618.00 | 259 | 10 | 2018 | 8260 | 0.244309927360775 | 0.526838775741755 | 0.474531855087023 | false | false | false | true | ||||||||||||||||
| 62eaa4e4-c80b-4481-acb5-9aa876d0ac2f | 2026-09-10 15:17 | 2026-09-10 15:16 | 2026-09-10 15:16 | IBRX | IBRX260918C00007500 | call | 7.5000 | 2026-09-18 | 0.4500 | 0.4000 | 0.4500 | 7.7150 | 20250.00 | 20250.00 | 0.00 | 450 | 22 | 3081 | 3694 | 0.834055224688684 | 0.729699530054492 | 0.729699530054492 | false | false | false | true | ||||||||||||||||
| 84c3ceb7-2f31-4561-9731-1801ee2d6244 | 2026-09-03 13:15 | 2026-09-03 13:15 | 2026-09-03 13:15 | IBRX | IBRX260918C00007500 | call | 7.5000 | 2026-09-18 | 0.7000 | 0.6500 | 0.7000 | 7.9750 | 11760.00 | 11760.00 | 0.00 | 168 | 6 | 564 | 1948 | 0.28952772073922 | 0.659180442580213 | 0.659180442580213 | false | false | false | true | ||||||||||||||||
| f51fec75-c1f3-422d-81ea-e9719b708034 | 2026-09-02 13:22 | 2026-09-02 13:22 | 2026-09-02 13:22 | IBRX | IBRX260918C00007500 | call | 7.5000 | 2026-09-18 | 0.6500 | 0.5500 | 0.7000 | 7.8500 | 13000.00 | 10530.00 | 2470.00 | 200 | 8 | 530 | 1136 | 0.466549295774648 | 0.706817607476816 | 0.696073543620937 | false | false | false | true | ||||||||||||||||
| b29285a5-51d1-43dd-b099-c648ba844b7d | 2026-08-27 14:23 | 2026-08-27 14:23 | 2026-08-27 14:23 | IBRX | IBRX260918C00007500 | call | 7.5000 | 2026-09-18 | 1.2000 | 1.1000 | 1.5000 | 8.4901 | 21240.00 | 12000.00 | 3240.00 | 177 | 5 | 179 | 8 | 22.375 | 0.687824279864877 | 0.714592197502189 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:25:57.950009Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T17:30:37.600118Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |