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 |
|---|
| 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 |
|---|
| fc975c9e-6200-4730-95aa-ef20e88fe6d5 | 2026-09-23 12:05 | 2026-09-23 12:05 | 2026-09-23 12:05 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 5.9000 | 5.9000 | 6.0500 | 380.6900 | 180617.00 | 0.00 | 180617.00 | 306 | 20 | 6900 | 390 | 17.6923076923077 | 0.442802007406582 | 0.442802007406582 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 1501301955407.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T16:06:31.927382Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 1bd91e26-097d-49d9-9b3f-768ede99c143 | 2026-09-24 10:00 | 2026-09-24 10:00 | 2026-09-24 10:00 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 5.7600 | 5.7500 | 5.8500 | 379.3100 | 19573.00 | 0.00 | 19573.00 | 34 | 8 | 895 | 831 | 1.07701564380265 | 0.500344314240034 | 0.500344314240034 | true | false | false | |||||||||||||||||
| f3857805-9958-49ec-8e48-126823b7f8bd | 2026-09-24 12:44 | 2026-09-24 12:44 | 2026-09-24 12:44 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 4.0400 | 4.0000 | 4.1000 | 381.4900 | 10107.00 | 6907.00 | 3200.00 | 25 | 6 | 4509 | 831 | 5.42599277978339 | 0.436942283311041 | 0.445702545721367 | false | false | false | |||||||||||||||||
| cbf733e3-06dc-4d21-8eec-79004f3481c0 | 2026-09-24 13:21 | 2026-09-24 13:21 | 2026-09-24 13:21 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 3.9400 | 3.8000 | 3.9500 | 381.7600 | 39844.00 | 39064.00 | 390.00 | 101 | 7 | 12550 | 831 | 15.1022864019254 | 0.447437864882085 | 0.44366620126086 | false | false | false | |||||||||||||||||
| 232a0a50-f39f-488d-b6a0-0d4601d8f572 | 2026-09-24 13:22 | 2026-09-24 13:22 | 2026-09-24 13:22 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 3.9200 | 3.9000 | 3.9500 | 381.6500 | 39246.00 | 32226.00 | 7020.00 | 100 | 6 | 12708 | 831 | 15.2924187725632 | 0.436338119483855 | 0.440114784209089 | false | false | false | |||||||||||||||||
| d4e55a52-1023-4cbc-9d22-fc423ca8054f | 2026-09-24 13:26 | 2026-09-24 13:26 | 2026-09-24 13:26 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 4.4000 | 4.3500 | 4.4500 | 380.6400 | 11872.00 | 8804.00 | 2628.00 | 27 | 10 | 13410 | 831 | 16.1371841155235 | 0.432430289446898 | 0.432376974925633 | false | false | false | |||||||||||||||||
| c7ad82ba-9e87-4e57-a28f-8063149708f5 | 2026-09-24 13:48 | 2026-09-24 13:48 | 2026-09-24 13:48 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 4.3600 | 4.3000 | 4.4000 | 380.0000 | 47940.00 | 43600.00 | 4340.00 | 110 | 5 | 16723 | 831 | 20.1239470517449 | 0.424170601626724 | 0.426736115725829 | false | false | false | |||||||||||||||||
| a265e979-456f-4e66-b88c-dc41cde6e56d | 2026-09-24 13:55 | 2026-09-24 13:55 | 2026-09-24 13:55 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 4.9700 | 4.9500 | 5.0500 | 379.5800 | 27840.00 | 0.00 | 27840.00 | 56 | 6 | 17595 | 831 | 21.173285198556 | 0.416529928135031 | 0.421864713455384 | false | false | false | |||||||||||||||||
| 8575bca2-503d-4538-8ebe-8fd10ffbf40a | 2026-09-24 14:04 | 2026-09-24 14:04 | 2026-09-24 14:04 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 5.9500 | 5.8500 | 5.9500 | 378.0000 | 267825.00 | 267825.00 | 0.00 | 450 | 20 | 18551 | 831 | 22.323706377858 | 0.440451442017291 | 0.437582080435867 | true | false | false | |||||||||||||||||
| d4bde8a1-68be-436d-9ff9-52c0c91b48f8 | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 1.8700 | 1.6500 | 2.1100 | 384.9100 | 118114.00 | 65643.00 | 52471.00 | 630 | 26 | 742 | 1590 | 0.466666666666667 | 0.70855144113371 | 0.71361012145372 | true | false | false | |||||||||||||||||
| 2b57185e-7d8a-44e7-a0da-d09b17a4f505 | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 2.0200 | 1.7300 | 2.0200 | 384.9100 | 30569.00 | 30569.00 | 0.00 | 151 | 13 | 893 | 1590 | 0.561635220125786 | 0.731301912966037 | 0.743901671920725 | true | false | false | |||||||||||||||||
| b7fdeded-7f6f-40bf-a817-3324225aa888 | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 2.3000 | 1.9600 | 2.3100 | 385.0000 | 12649.00 | 12649.00 | 0.00 | 55 | 5 | 1223 | 1590 | 0.769182389937107 | 0.815233071176661 | 0.817737707189174 | false | false | false | |||||||||||||||||
| cb1d7b92-93d0-4024-bedb-c9984d92b150 | 2026-09-25 09:31 | 2026-09-25 09:30 | 2026-09-25 09:30 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 2.3800 | 2.2400 | 2.4300 | 384.6700 | 10937.00 | 5273.00 | 5664.00 | 46 | 7 | 2392 | 1590 | 1.50440251572327 | 0.792935665380727 | 0.80175067995724 | true | false | false | |||||||||||||||||
| a506ae45-25e4-48b5-9825-73d0318a0f01 | 2026-09-25 09:32 | 2026-09-25 09:31 | 2026-09-25 09:31 | TSLA | TSLA260925P00382500 | put | 382.5000 | 2026-09-25 | 4.5900 | 4.3250 | 4.9000 | 380.2750 | 10096.00 | 3256.00 | 5430.00 | 22 | 10 | 3886 | 1590 | 2.4440251572327 | 0.786384268181597 | 0.812202143354267 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:01:19.671622Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:45:03.999525Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:30:31.713908Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:55:11.953323Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:01:57.698805Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:05:05.581438Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:30:25.838480Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:30:25.838480Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:30:25.838480Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:31:26.059584Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:32:31.841243Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |