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 |
|---|
| expirydate |
|---|
| 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 |
|---|
| 76eab3aa-cc5c-453f-ac3e-631e48d050e8 | 2026-09-24 10:35 | 2026-09-24 10:35 | 2026-09-24 10:35 | ETSY | ETSY261016P00070000 | put | 70.0000 | 2026-10-16 | 3.3800 | 3.0000 | 3.4000 | 69.6400 | 163822.00 | 163822.00 | 0.00 | 484 | 56 | 491 | 1911 | 0.256933542647828 | 0.473632254108678 | 0.483901437634858 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 6764314828.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T14:35:45.310206Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| df71cd38-7e56-44be-859f-fe7bc4204f8e | 2026-09-22 10:56 | 2026-09-22 10:55 | 2026-09-22 10:55 | ETSY | ETSY261218C00090000 | call | 90.0000 | 2026-12-18 | 2.5900 | 2.5700 | 2.8000 | 73.9900 | 30046.00 | 15027.00 | 15019.00 | 116 | 7 | 117 | 919 | 0.127312295973885 | 0.502829759971612 | 0.504525646241899 | true | false | false | |||||||||||||||||
| 249eb904-61df-4773-ae37-1af427b13832 | 2026-09-18 13:57 | 2026-09-18 13:57 | 2026-09-18 13:57 | ETSY | ETSY280121C00085000 | call | 85.0000 | 2028-01-21 | 14.4000 | 14.0500 | 14.4000 | 72.8000 | 1340405.00 | 302390.00 | 64575.00 | 931 | 36 | 933 | 177 | 5.27118644067797 | 0.507764280380279 | 0.507764280380279 | false | false | false | |||||||||||||||||
| 8386e6f0-9607-4f34-bc40-595ea664a0cc | 2026-09-17 12:20 | 2026-09-17 12:20 | 2026-09-17 12:20 | ETSY | ETSY260925C00080000 | call | 80.0000 | 2026-09-25 | 0.3400 | 0.2500 | 0.3800 | 72.8500 | 33038.00 | 32863.00 | 175.00 | 974 | 53 | 1981 | 50 | 39.62 | 0.52624651678933 | 0.530790997057067 | false | false | false | |||||||||||||||||
| f83772f8-5ebf-499d-8c2e-d382c114bcc6 | 2026-09-17 12:10 | 2026-09-17 12:10 | 2026-09-17 12:10 | ETSY | ETSY260925C00080000 | call | 80.0000 | 2026-09-25 | 0.3300 | 0.1600 | 0.5100 | 73.0100 | 32674.00 | 21828.00 | 10846.00 | 1001 | 60 | 1001 | 50 | 20.02 | 0.517174745950503 | 0.52173473749368 | false | false | false | |||||||||||||||||
| afd1267c-91d4-4f98-b867-f2783f76a797 | 2026-09-14 09:51 | 2026-09-14 09:51 | 2026-09-14 09:51 | ETSY | ETSY290119P00060000 | put | 60.0000 | 2029-01-19 | 11.6400 | 10.0500 | 14.5000 | 72.9700 | 245580.00 | 229340.00 | 16240.00 | 211 | 10 | 211 | 0 | 0 | 0.506117810199173 | 0.50908452278754 | true | false | false | |||||||||||||||||
| 4176f027-fbb9-43ea-b91a-bd4788c53b29 | 2026-09-09 12:25 | 2026-09-09 12:25 | 2026-09-09 12:25 | ETSY | ETSY261016P00067500 | put | 67.5000 | 2026-10-16 | 2.6500 | 2.5400 | 2.6600 | 70.5300 | 60110.00 | 56180.00 | 3930.00 | 227 | 18 | 233 | 72 | 3.23611111111111 | 0.464227906583969 | 0.467850995688674 | false | false | false | |||||||||||||||||
| d6cfb08f-e10f-4e00-8ddf-c4a5fc2b8550 | 2026-08-28 10:19 | 2026-08-28 10:19 | 2026-08-28 10:19 | ETSY | ETSY260904C00093000 | call | 93.0000 | 2026-09-04 | 0.2900 | 0.0100 | 0.4500 | 83.7300 | 26984.00 | 25274.00 | 1710.00 | 941 | 58 | 943 | 12 | 78.5833333333333 | 0.573285289074652 | 0.56852963107473 | true | false | false | |||||||||||||||||
| a0fcabf3-e8b3-4243-81dc-08a0cb9b8960 | 2026-08-28 09:42 | 2026-08-28 09:42 | 2026-08-28 09:42 | ETSY | ETSY260904C00090000 | call | 90.0000 | 2026-09-04 | 0.5200 | 0.5200 | 0.8500 | 83.1401 | 18248.00 | 0.00 | 18248.00 | 351 | 8 | 351 | 756 | 0.464285714285714 | 0.536801023530673 | 0.551231567181068 | false | false | false | |||||||||||||||||
| a125fb77-eb3a-40ee-868e-ac7f295d2465 | 2026-08-24 15:18 | 2026-08-24 15:17 | 2026-08-24 15:17 | ETSY | ETSY270617P00070000 | put | 70.0000 | 2027-06-17 | 6.9500 | 6.9500 | 7.3000 | 85.6000 | 71596.00 | 700.00 | 70196.00 | 103 | 12 | 116 | 262 | 0.442748091603053 | 0.518649468560842 | 0.51873604566106 | true | false | false | |||||||||||||||||
| 57d490cf-15a2-45ac-a407-f633b23bf025 | 2026-08-24 14:58 | 2026-08-24 14:58 | 2026-08-24 14:58 | ETSY | ETSY260918C00085000 | call | 85.0000 | 2026-09-18 | 4.3500 | 4.2500 | 4.3500 | 85.5350 | 11733.00 | 11733.00 | 0.00 | 27 | 6 | 47 | 4146 | 0.0113362276893391 | 0.441188342824354 | 0.44570806603766 | false | false | false | |||||||||||||||||
| 7a1e52b3-b33a-4078-9ea3-d2dca92eb82b | 2026-08-21 10:41 | 2026-08-21 10:41 | 2026-08-21 10:41 | ETSY | ETSY261016C00090000 | call | 90.0000 | 2026-10-16 | 2.8500 | 2.8000 | 3.1000 | 81.8900 | 74563.00 | 68578.00 | 5985.00 | 262 | 14 | 350 | 266 | 1.31578947368421 | 0.438830629937563 | 0.440123965261724 | true | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 6896480545.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 6663354905.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 6639491650.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 6639491650.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 6834068956.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 6834068956.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T16:45:40.179334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 6834068956.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 6834068956.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 6834068956.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 6834068956.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 6834068956.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:50:41.871179Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |