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 |
|---|
| 475c1a7e-da2e-484a-8f43-423a38ae6500 | 2026-09-02 15:33 | 2026-09-02 15:33 | 2026-09-02 15:33 | ETHA | ETHA260925P00017000 | put | 17.0000 | 2026-09-25 | 0.4300 | 0.4300 | 0.4400 | 17.9989 | 10750.00 | 0.00 | 10750.00 | 250 | 9 | 261 | 1104 | 0.236413043478261 | 0.486516792893751 | 0.486516792893751 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 6944643005.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5b7e6816-319e-421a-8dc1-e6ab1d65b1e0 | 2026-09-03 12:19 | 2026-09-03 12:19 | 2026-09-03 12:19 | ETHA | ETHA260925P00017000 | put | 17.0000 | 2026-09-25 | 0.2700 | 0.2600 | 0.2700 | 18.8400 | 20250.00 | 20250.00 | 0.00 | 750 | 26 | 751 | 1004 | 0.74800796812749 | 0.525492068993599 | 0.525492068993599 | false | false | false | true | ||||||||||||||||
| ffeb7aa1-8aaf-4724-a99a-cab24b3c98f5 | 2026-09-03 12:20 | 2026-09-03 12:19 | 2026-09-03 12:19 | ETHA | ETHA260925P00017000 | put | 17.0000 | 2026-09-25 | 0.2700 | 0.2600 | 0.2700 | 18.8250 | 20250.00 | 20250.00 | 0.00 | 750 | 18 | 1501 | 1004 | 1.49501992031873 | 0.52321976984591 | 0.52321976984591 | false | false | false | true | ||||||||||||||||
| 76e4124c-70e8-4e32-85b5-d0181d922208 | 2026-09-03 12:20 | 2026-09-03 12:20 | 2026-09-03 12:20 | ETHA | ETHA260925P00017000 | put | 17.0000 | 2026-09-25 | 0.2700 | 0.2600 | 0.2700 | 18.8250 | 12528.00 | 3159.00 | 0.00 | 464 | 17 | 1965 | 1004 | 1.95717131474104 | 0.52321976984591 | 0.52321976984591 | true | false | false | true | ||||||||||||||||
| 1ec9ed9d-adb9-4e6f-a52f-76cdba390b27 | 2026-09-03 12:20 | 2026-09-03 12:20 | 2026-09-03 12:20 | ETHA | ETHA260925P00017000 | put | 17.0000 | 2026-09-25 | 0.2800 | 0.2700 | 0.2800 | 18.8301 | 19544.00 | 19544.00 | 0.00 | 698 | 9 | 2663 | 1004 | 2.65239043824701 | 0.531917797178875 | 0.531917797178875 | false | false | false | true | ||||||||||||||||
| 34e92f7e-2191-4b5d-8649-22fea35d5b84 | 2026-09-03 12:22 | 2026-09-03 12:22 | 2026-09-03 12:22 | ETHA | ETHA260925P00017000 | put | 17.0000 | 2026-09-25 | 0.2800 | 0.2600 | 0.2800 | 18.8500 | 14224.00 | 14224.00 | 0.00 | 508 | 14 | 4009 | 1004 | 3.99302788844621 | 0.534947268017738 | 0.534947268017738 | false | false | false | true | ||||||||||||||||
| 61310981-e6d5-41b0-bbd3-ecf91a43edf2 | 2026-09-03 15:27 | 2026-09-03 15:27 | 2026-09-03 15:27 | ETHA | ETHA260925P00017000 | put | 17.0000 | 2026-09-25 | 0.2400 | 0.2400 | 0.2600 | 18.9801 | 96168.00 | 0.00 | 96168.00 | 4007 | 5 | 8021 | 1004 | 7.9890438247012 | 0.521740730653682 | 0.521740730653682 | false | false | false | true | ||||||||||||||||
| 750810ac-a407-4b8f-b095-68cc74a426dd | 2026-09-15 14:42 | 2026-09-15 14:42 | 2026-09-15 14:42 | ETHA | ETHA260925P00017000 | put | 17.0000 | 2026-09-25 | 0.3000 | 0.3000 | 0.3200 | 17.9750 | 24960.00 | 0.00 | 24960.00 | 832 | 22 | 2185 | 4416 | 0.494791666666667 | 0.594045066751423 | 0.594045066751423 | false | false | false | true | ||||||||||||||||
| 52e3286e-5c03-45bf-b8a4-e1e7ba1c8969 | 2026-09-15 15:23 | 2026-09-15 15:22 | 2026-09-15 15:22 | ETHA | ETHA260925P00017000 | put | 17.0000 | 2026-09-25 | 0.2400 | 0.2300 | 0.2500 | 18.1573 | 23544.00 | 0.00 | 22272.00 | 981 | 24 | 3207 | 4416 | 0.726222826086957 | 0.577991748106503 | 0.577991748106503 | false | false | false | true | ||||||||||||||||
| e18f6a5f-b077-4237-9b1c-418ae2a7f08c | 2026-09-16 09:46 | 2026-09-16 09:46 | 2026-09-16 09:46 | ETHA | ETHA260925P00017000 | put | 17.0000 | 2026-09-25 | 0.2400 | 0.2300 | 0.2400 | 18.0200 | 14664.00 | 14664.00 | 0.00 | 611 | 16 | 611 | 6326 | 0.0965855200758773 | 0.57180789431829 | 0.57180789431829 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |