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 | 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 |
|---|
| 8d66fd89-de8f-4e95-bc6b-73eb6c7ab782 | 2026-09-16 12:13 | 2026-09-16 12:13 | 2026-09-16 12:13 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 1.3400 | 1.3400 | 1.5300 | 156.6200 | 18090.00 | 0.00 | 18090.00 | 135 | 16 | 138 | 0 | 0 | 0.547373454055203 | 0.547373454055203 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | Financial Services | 1228364647.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 7e216b95-e9ba-49c0-8e70-97ae8eab9c9c | 2026-09-21 12:39 | 2026-09-21 12:39 | 2026-09-21 12:39 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 2.2600 | 2.0200 | 2.2700 | 146.9400 | 22374.00 | 22148.00 | 226.00 | 99 | 18 | 216 | 239 | 0.903765690376569 | 0.519949747284858 | 0.521218856819532 | true | false | false | true | ||||||||||||||||
| 03a77c0c-16bf-4a61-b019-9e119cb6b537 | 2026-09-21 13:13 | 2026-09-21 13:12 | 2026-09-21 13:12 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 2.1800 | 1.9900 | 2.1800 | 147.2400 | 43818.00 | 43818.00 | 0.00 | 201 | 26 | 448 | 239 | 1.8744769874477 | 0.520621828402276 | 0.520621828402276 | true | false | false | true | ||||||||||||||||
| c3a52d99-81a5-42ef-943e-65758843895f | 2026-09-21 13:23 | 2026-09-21 13:23 | 2026-09-21 13:23 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 2.0500 | 1.8200 | 2.0600 | 147.0000 | 24805.00 | 23575.00 | 0.00 | 121 | 17 | 569 | 239 | 2.38075313807531 | 0.512109738890604 | 0.513413428159114 | true | false | false | true | ||||||||||||||||
| a952a119-7fe0-41e8-82c6-a0207a89e917 | 2026-09-22 09:42 | 2026-09-22 09:42 | 2026-09-22 09:42 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 2.5800 | 2.4500 | 2.6000 | 145.5400 | 10303.00 | 5433.00 | 4870.00 | 40 | 7 | 97 | 423 | 0.229314420803783 | 0.536352287490822 | 0.536352287490822 | true | false | false | true | ||||||||||||||||
| 05df713c-4f33-4e64-abc5-c8107cedcc78 | 2026-09-22 10:19 | 2026-09-22 10:19 | 2026-09-22 10:19 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 2.4300 | 2.2900 | 2.4300 | 145.9300 | 10449.00 | 10449.00 | 0.00 | 43 | 13 | 194 | 423 | 0.458628841607565 | 0.533084538293833 | 0.533084538293833 | true | false | false | true | ||||||||||||||||
| f320f220-fa5b-42ac-8082-a4ab00449837 | 2026-09-22 11:05 | 2026-09-22 11:05 | 2026-09-22 11:05 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 2.1800 | 1.8100 | 2.2200 | 146.0000 | 27700.00 | 13686.00 | 14014.00 | 127 | 73 | 373 | 423 | 0.881796690307329 | 0.53112072409479 | 0.533815593966341 | true | false | false | true | ||||||||||||||||
| 04534fc3-4505-47bb-9450-f9f2fa5b671d | 2026-09-22 12:48 | 2026-09-22 12:48 | 2026-09-22 12:48 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 2.1500 | 2.1300 | 2.4400 | 147.3000 | 20425.00 | 215.00 | 20210.00 | 95 | 24 | 686 | 423 | 1.62174940898345 | 0.549739053264758 | 0.549739053264758 | false | false | false | true | ||||||||||||||||
| 45633eb6-ae17-4dce-b90a-63a96ad8ebd9 | 2026-09-22 13:11 | 2026-09-22 13:11 | 2026-09-22 13:11 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 2.3600 | 2.3500 | 2.7000 | 146.6550 | 11800.00 | 0.00 | 11800.00 | 50 | 9 | 739 | 423 | 1.74704491725768 | 0.553029188821122 | 0.553029188821122 | true | false | false | true | ||||||||||||||||
| 70dbc62d-ddce-4fa4-b9e0-107a055586df | 2026-09-22 13:13 | 2026-09-22 13:13 | 2026-09-22 13:13 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 2.3800 | 2.3800 | 2.6000 | 146.5400 | 13804.00 | 0.00 | 13804.00 | 58 | 20 | 798 | 423 | 1.88652482269504 | 0.551122238708959 | 0.551122238708959 | true | false | false | true | ||||||||||||||||
| 5e2834a4-5894-42e9-8870-dc92e4329e69 | 2026-09-22 13:58 | 2026-09-22 13:58 | 2026-09-22 13:58 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 3.1200 | 2.5200 | 3.1500 | 143.9100 | 34985.00 | 34985.00 | 0.00 | 112 | 6 | 950 | 423 | 2.24586288416076 | 0.529620827396454 | 0.535791986366858 | false | false | false | true | ||||||||||||||||
| 67254f2f-a0df-4edd-a52b-58a69092d391 | 2026-09-22 15:28 | 2026-09-22 15:27 | 2026-09-22 15:27 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 2.9100 | 2.9100 | 3.1000 | 144.0000 | 13677.00 | 0.00 | 13677.00 | 47 | 12 | 1069 | 423 | 2.52718676122931 | 0.542880595002899 | 0.542880595002899 | true | false | false | true | ||||||||||||||||
| d97867ed-6a76-42c5-a230-534214cafe23 | 2026-09-22 15:51 | 2026-09-22 15:51 | 2026-09-22 15:51 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 3.3000 | 3.2500 | 3.8000 | 143.7750 | 14190.00 | 0.00 | 12210.00 | 43 | 11 | 1234 | 423 | 2.91725768321513 | 0.547907540011019 | 0.547907540011019 | false | false | false | true | ||||||||||||||||
| 48e24b31-c409-419f-91fe-4bd9ff256bd7 | 2026-09-25 14:29 | 2026-09-25 14:29 | 2026-09-25 14:29 | USO | USO260930P00141000 | put | 141.0000 | 2026-09-30 | 1.2000 | 1.1700 | 1.2500 | 148.5850 | 21098.00 | 0.00 | 18480.00 | 176 | 19 | 1653 | 2572 | 0.642690513219285 | 0.575439267429506 | 0.575439267429506 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:41:29.676906Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:16:02.178873Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:24:56.111062Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:20:22.518739Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:48:50.097062Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:14:46.677665Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:14:46.677665Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:33:11.786837Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:31:26.314014Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |