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 | 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 |
|---|
| e03704f0-fc68-4daf-9994-9688a62b1ea2 | 2026-09-22 09:32 | 2026-09-22 09:32 | 2026-09-22 09:32 | ETHU | ETHU261030C00030000 | call | 30.0000 | 2026-10-30 | 5.2300 | 4.7000 | 5.8000 | 32.0300 | 41864.00 | 0.00 | 41864.00 | 80 | 5 | 80 | 203 | 0.394088669950739 | 1.0163391879005 | 1.02675307236392 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 106418400.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T13:32:27.895939Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| a4f17a9e-bb22-4795-a6ab-a71e1fd92239 | 2026-09-18 12:19 | 2026-09-18 12:19 | 2026-09-18 12:19 | ETHU | ETHU261016C00025000 | call | 25.0000 | 2026-10-16 | 5.2300 | 5.1000 | 5.3000 | 28.0000 | 13080.00 | 13080.00 | 0.00 | 25 | 6 | 57 | 327 | 0.174311926605505 | 0.988715566460993 | 0.988715566460993 | false | false | false | true | ||||||||||||||||
| e1e32d65-5bd0-4498-a2d9-c7119d319850 | 2026-09-14 11:01 | 2026-09-14 11:01 | 2026-09-14 11:01 | ETHU | ETHU260918C00025000 | call | 25.0000 | 2026-09-18 | 2.3200 | 2.0500 | 2.6000 | 26.7950 | 19036.00 | 5126.00 | 13910.00 | 82 | 6 | 93 | 1845 | 0.0504065040650407 | 1.10796798252543 | 1.10796798252543 | false | false | false | true | ||||||||||||||||
| bff0efdd-5679-4ee2-94d4-ea24ca738b8f | 2026-09-11 13:49 | 2026-09-11 13:48 | 2026-09-11 13:48 | ETHU | ETHU260918C00030000 | call | 30.0000 | 2026-09-18 | 1.0000 | 0.9500 | 1.0000 | 28.3950 | 15593.00 | 15593.00 | 0.00 | 156 | 8 | 698 | 784 | 0.89030612244898 | 1.03236153144392 | 1.03904240797823 | false | false | false | true | ||||||||||||||||
| 3eb35a3a-01b4-43b5-b322-85b2d16f0b72 | 2026-09-10 09:50 | 2026-09-10 09:50 | 2026-09-10 09:50 | ETHU | ETHU260925P00025000 | put | 25.0000 | 2026-09-25 | 1.9000 | 1.7000 | 2.0000 | 25.3000 | 22760.00 | 7560.00 | 15200.00 | 120 | 11 | 156 | 1516 | 0.102902374670185 | 1.0129634498056 | 1.01792062218934 | false | false | false | true | ||||||||||||||||
| e0b70b16-5ddc-48cb-95b1-69c98adc1f55 | 2026-09-09 12:43 | 2026-09-09 12:43 | 2026-09-09 12:43 | ETHU | ETHU260925P00025000 | put | 25.0000 | 2026-09-25 | 1.4400 | 1.4000 | 1.5000 | 26.8300 | 21545.00 | 16485.00 | 710.00 | 150 | 9 | 408 | 224 | 1.82142857142857 | 1.03449527074636 | 1.03941463713238 | false | false | false | true | ||||||||||||||||
| ec82afd8-b7ce-4ad9-a7ca-e1cc1a11c713 | 2026-09-04 10:46 | 2026-09-04 10:46 | 2026-09-04 10:46 | ETHU | ETHU260918C00025000 | call | 25.0000 | 2026-09-18 | 2.2200 | 2.2000 | 2.4000 | 25.7557 | 110938.00 | 0.00 | 110938.00 | 500 | 12 | 710 | 2263 | 0.31374281926646 | 0.897437346875061 | 0.897437346875061 | false | false | false | true | ||||||||||||||||
| a8c7795f-a736-492e-b593-a3a8b1b11297 | 2026-08-20 09:31 | 2026-08-20 09:31 | 2026-08-20 09:31 | ETHU | ETHU260821C00020000 | call | 20.0000 | 2026-08-21 | 2.7100 | 2.7000 | 2.9000 | 22.6600 | 32022.00 | 0.00 | 32022.00 | 118 | 9 | 233 | 1205 | 0.193360995850622 | 1.48664262119955 | 1.48664262119955 | false | false | false | true | ||||||||||||||||
| dac6ce3f-a411-43b8-b140-7b5051955038 | 2026-08-19 15:07 | 2026-08-19 15:07 | 2026-08-19 15:07 | ETHU | ETHU260821C00019500 | call | 19.5000 | 2026-08-21 | 0.7000 | 0.5000 | 0.7000 | 19.3700 | 52478.00 | 52478.00 | 0.00 | 750 | 9 | 852 | 2 | 426 | 1.25722921320298 | 1.32717135245562 | false | false | false | true | ||||||||||||||||
| 3da4319b-035f-42bd-93d7-0556356eb16f | 2026-08-19 11:46 | 2026-08-19 11:46 | 2026-08-19 11:46 | ETHU | ETHU260828C00017000 | call | 17.0000 | 2026-08-28 | 2.6400 | 2.5000 | 2.6500 | 19.1900 | 53401.00 | 53401.00 | 0.00 | 202 | 22 | 634 | 1852 | 0.342332613390929 | 1.0710346140386 | 1.10540362375374 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 106418400.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 106418400.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 106418400.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 106418400.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:52:43.061304Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 106418400.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T16:45:40.179334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 106418400.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 106418400.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 106418400.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 106418400.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |