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.
Simplify Analyticsuw_flow_alerts474,253 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 | price |
|---|
| 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 |
|---|
| 4d5c4ea3-4c5f-41e3-8e5b-b0bb5a96db34 | 2026-09-24 13:21 | 2026-09-24 13:21 | 2026-09-24 13:21 | ANF | ANF261030P00145000 | put | 145.0000 | 2026-10-30 | 13.6000 | 11.8000 | 13.6000 | 136.5000 | 38080.00 | 38080.00 | 0.00 | 28 | 8 | 28 | 0 | 0 | 0.517828004500238 | 0.517828004500238 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 5611946358.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T17:26:09.725902Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| a2da6b50-dad6-4dc5-a086-568d7f143da3 | 2026-09-24 13:38 | 2026-09-24 13:38 | 2026-09-24 13:38 | ANF | ANF261016P00140000 | put | 140.0000 | 2026-10-16 | 8.2000 | 7.5000 | 8.3000 | 136.3400 | 123820.00 | 123820.00 | 0.00 | 151 | 15 | 159 | 584 | 0.272260273972603 | 0.473886346079609 | 0.473886346079609 | false | false | false | true | false | |||||||||||||||
| f2b9cacb-fef8-47cc-81a6-91774b55e09d | 2026-09-24 13:46 | 2026-09-24 13:46 | 2026-09-24 13:46 | ANF | ANF261120P00135000 | put | 135.0000 | 2026-11-20 | 9.3000 | 8.9000 | 9.3000 | 136.0000 | 59520.00 | 59520.00 | 0.00 | 64 | 9 | 152 | 115 | 1.32173913043478 | 0.479911782949062 | 0.479911782949062 | true | false | false | true | false | |||||||||||||||
| 1ac1f1dc-7d27-4df2-89e1-84832ad1d22b | 2026-09-24 15:48 | 2026-09-24 15:48 | 2026-09-24 15:48 | ANF | ANF261009C00135000 | call | 135.0000 | 2026-10-09 | 5.0000 | 5.0000 | 6.2000 | 134.7500 | 55500.00 | 0.00 | 55500.00 | 111 | 8 | 226 | 2 | 113 | 0.460247735013284 | 0.460247735013284 | false | false | false | true | false | |||||||||||||||
| 8a9fe7d1-ccfe-4fcf-b94d-513d5e1a4930 | 2026-09-25 11:03 | 2026-09-25 11:03 | 2026-09-25 11:03 | ANF | ANF261016P00134000 | put | 134.0000 | 2026-10-16 | 5.6000 | 5.5000 | 6.1000 | 134.3000 | 37520.00 | 0.00 | 37520.00 | 67 | 8 | 68 | 1 | 68 | 0.460325842029756 | 0.460325842029756 | false | false | false | true | false | |||||||||||||||
| 06ccd454-0763-4c11-8587-a515b0811d44 | 2026-09-25 13:26 | 2026-09-25 13:26 | 2026-09-25 13:26 | ANF | ANF261120C00130000 | call | 130.0000 | 2026-11-20 | 13.3000 | 12.9000 | 13.3000 | 134.6600 | 106400.00 | 106400.00 | 0.00 | 80 | 18 | 84 | 67 | 1.25373134328358 | 0.501664290922773 | 0.501664290922773 | true | false | false | true | false | |||||||||||||||
| fdf3b7f9-326d-4f94-8bc5-5c41efb9f676 | 2026-09-25 13:37 | 2026-09-25 13:36 | 2026-09-25 13:36 | ANF | ANF261002C00125000 | call | 125.0000 | 2026-10-02 | 10.4000 | 10.4000 | 11.1000 | 134.0000 | 172640.00 | 0.00 | 172640.00 | 166 | 8 | 166 | 243 | 0.683127572016461 | 0.468047760561848 | 0.468047760561848 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 5611946358.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:43:31.900788Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 5611946358.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:47:19.997705Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 5611946358.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:50:03.728318Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 5758769303.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:05:27.463808Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 5758769303.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:33:28.969909Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 5758769303.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |