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_alerts658,639 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 |
|---|
| 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 |
|---|
| ad664ad8-1a3b-4d44-93dd-c520a2ec1282 | 2026-09-25 13:31 | 2026-09-25 13:31 | 2026-09-25 13:31 | IEF | IEF261218P00084000 | put | 84.0000 | 2026-12-18 | 0.1800 | 0.1700 | 0.1900 | 89.7350 | 11520.00 | 11052.00 | 0.00 | 640 | 9 | 7788 | 59 | 132 | 0.1142213360544 | 0.1142213360544 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 41422981390.00 | — | — | — | 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 |
| 111da390-107f-4c89-8fb7-e5bab50663f9 | 2026-09-25 13:31 | 2026-09-25 13:31 | 2026-09-25 13:31 | IEF | IEF261218P00084000 | put | 84.0000 | 2026-12-18 | 0.1800 | 0.1600 | 0.1800 | 89.7350 | 11610.00 | 11610.00 | 0.00 | 645 | 21 | 7148 | 59 | 121.152542372881 | 0.1142213360544 | 0.1142213360544 | false | false | false | true | false | |||||||||||||||
| 80708c01-80fe-4787-b76f-2b6f5f1df00b | 2026-09-25 13:31 | 2026-09-25 13:31 | 2026-09-25 13:31 | IEF | IEF261218P00084000 | put | 84.0000 | 2026-12-18 | 0.1800 | 0.1600 | 0.1800 | 89.7350 | 11358.00 | 11358.00 | 0.00 | 631 | 11 | 5865 | 59 | 99.406779661017 | 0.1142213360544 | 0.1142213360544 | false | false | false | true | false | |||||||||||||||
| 8273b547-5884-4cc2-a456-5a0e9a8f1f12 | 2026-09-25 13:20 | 2026-09-25 13:20 | 2026-09-25 13:20 | IEF | IEF261218P00084000 | put | 84.0000 | 2026-12-18 | 0.1700 | 0.1600 | 0.1700 | 89.0000 | 14773.00 | 14773.00 | 0.00 | 869 | 11 | 4960 | 59 | 84.0677966101695 | 0.112748330194766 | 0.112748330194766 | false | false | false | true | false | |||||||||||||||
| eb9f89a7-86ac-4659-889c-0be1bc412791 | 2026-09-25 10:07 | 2026-09-25 10:07 | 2026-09-25 10:07 | IEF | IEF261218P00084000 | put | 84.0000 | 2026-12-18 | 0.1700 | 0.1700 | 0.1800 | 89.6400 | 14909.00 | 0.00 | 14909.00 | 877 | 18 | 3877 | 59 | 65.7118644067797 | 0.11144848135925 | 0.11144848135925 | false | false | false | true | false | |||||||||||||||
| efe4172b-0b3e-49be-8fcb-da7daa753a27 | 2026-09-25 10:07 | 2026-09-25 10:07 | 2026-09-25 10:07 | IEF | IEF261218P00084000 | put | 84.0000 | 2026-12-18 | 0.1800 | 0.1700 | 0.1800 | 89.6358 | 11556.00 | 11556.00 | 0.00 | 642 | 19 | 2297 | 59 | 38.9322033898305 | 0.112982264903594 | 0.112982264903594 | false | false | false | true | false | |||||||||||||||
| 859fdab5-63a1-476b-9493-a9f2959f457d | 2026-09-25 10:07 | 2026-09-25 10:07 | 2026-09-25 10:07 | IEF | IEF261218P00084000 | put | 84.0000 | 2026-12-18 | 0.1800 | 0.1700 | 0.1800 | 89.6400 | 11376.00 | 11376.00 | 0.00 | 632 | 15 | 2929 | 59 | 49.6440677966102 | 0.113034816514552 | 0.113034816514552 | false | false | false | true | false | |||||||||||||||
| bf91ac5b-eac4-44db-a2a3-de59b45f727d | 2026-09-25 10:07 | 2026-09-25 10:07 | 2026-09-25 10:07 | IEF | IEF261218P00084000 | put | 84.0000 | 2026-12-18 | 0.1800 | 0.1700 | 0.1800 | 89.6358 | 11556.00 | 11556.00 | 0.00 | 642 | 22 | 1655 | 59 | 28.0508474576271 | 0.112982264903594 | 0.112982264903594 | false | false | false | true | false | |||||||||||||||
| 2e9be3f5-577c-4589-b625-87b827bafcdb | 2026-09-25 10:07 | 2026-09-25 10:07 | 2026-09-25 10:07 | IEF | IEF261218P00084000 | put | 84.0000 | 2026-12-18 | 0.1800 | 0.1700 | 0.1800 | 89.6358 | 11592.00 | 11592.00 | 0.00 | 644 | 24 | 1013 | 59 | 17.1694915254237 | 0.112982264903594 | 0.112982264903594 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41422981390.00 |
| — |
| — |
| — |
| 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 |
| ETF |
| — |
| 41422981390.00 |
| — |
| — |
| — |
| 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 |
| ETF |
| — |
| 41422981390.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:23:42.010099Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41422981390.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:07:37.625722Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41422981390.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:07:37.625722Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41422981390.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:07:37.625722Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41422981390.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:07:37.625722Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41422981390.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:07:37.625722Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |