Simplify AnalyticsOptions flow alerts (market-wide)
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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bb274bf5-8eab-45de-9b42-969150f0c55f | 2026-08-17 09:45 | 2026-08-17 09:45 | 2026-08-17 09:45 | PDD | PDD260828P00086000 | put | 86.0000 | 2026-08-28 | 2.9100 | 2.8700 | 2.9800 | 86.3400 | 216003.00 | 4320.00 | 211683.00 | 742 | 12 | 743 | 274 | 2.71167883211679 | 0.518943995341685 | 0.52734888738197 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e5db23c1-6229-481b-b232-318782b36eca | 2026-08-17 10:34 | 2026-08-17 10:34 | 2026-08-17 10:34 | PDD | PDD260821C00086000 | call | 86.0000 | 2026-08-21 | 1.4000 | 1.3900 | 1.4000 | 86.2300 | 51476.00 | 45360.00 | 6116.00 | 368 | 20 | 514 | 1110 | 0.463063063063063 | 0.348398090425078 | 0.348398090425078 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d7480f26-cb3c-4fcf-ae70-6773201555ce | 2026-08-17 11:11 | 2026-08-17 11:11 | 2026-08-17 11:11 | PDD | PDD261016P00090000 | put | 90.0000 | 2026-10-16 | 7.3000 | 7.3000 | 7.5500 | 85.6900 | 82496.00 | 0.00 | 82496.00 | 113 | 23 | 121 | 3838 | 0.0315268368942157 | 0.368459376890062 | 0.368459376890062 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4b229773-aa43-4692-94f2-7c9abff2df2f | 2026-08-20 15:01 | 2026-08-20 15:00 | 2026-08-20 15:00 | PDD | PDD270319P00080000 | put | 80.0000 | 2027-03-19 | 5.1900 | 5.0500 | 5.2000 | 89.5400 | 53436.00 | 53436.00 | 0.00 | 103 | 9 | 124 | 8817 | 0.0140637405013043 | 0.38874565089951 | 0.389630906609068 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fbbd2cf9-9a2e-436a-ada5-ad97041a996e | 2026-08-20 15:27 | 2026-08-20 15:27 | 2026-08-20 15:27 | PDD | PDD270319P00085000 | put | 85.0000 | 2027-03-19 | 7.1500 | 7.0000 | 7.1500 | 89.5600 | 113615.00 | 113615.00 | 0.00 | 159 | 9 | 208 | 3134 | 0.0663688576898532 | 0.384986624287709 | 0.386184724793327 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 82a63a61-86ab-4324-8170-734ebaccff47 | 2026-08-21 10:08 | 2026-08-21 10:07 | 2026-08-21 10:07 | PDD | PDD261218C00110000 | call | 110.0000 | 2026-12-18 | 2.0100 | 1.9300 | 2.3300 | 88.3800 | 143739.00 | 4848.00 | 138489.00 | 715 | 29 | 1539 | 2180 | 0.705963302752294 | 0.384764118042063 | 0.385049418546425 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d974d3ff-27f0-4398-bdf2-913aed0f494e | 2026-08-24 09:30 | 2026-08-24 09:30 | 2026-08-24 09:30 | PDD | PDD260828P00092000 | put | 92.0000 | 2026-08-28 | 2.8700 | 1.8000 | 3.4000 | 90.6300 | 96283.00 | 57225.00 | 39058.00 | 335 | 11 | 335 | 42 | 7.97619047619048 | 0.566373696891918 | 0.577186006105408 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 409bf83e-c8bb-4ff0-99f7-c25f7de998a5 | 2026-08-24 13:07 | 2026-08-24 13:07 | 2026-08-24 13:07 | PDD | PDD260918C00090000 | call | 90.0000 | 2026-09-18 | 2.5300 | 2.5000 | 2.6700 | 88.4500 | 59259.00 | 29892.00 | 29367.00 | 234 | 6 | 3157 | 22195 | 0.142239243072764 | 0.33590009759265 | 0.341355027979897 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 561402f3-9ac1-46ab-a6b2-c99f8d91b90c | 2026-08-25 15:10 | 2026-08-25 15:10 | 2026-08-25 15:10 | PDD | PDD261218P00085000 | put | 85.0000 | 2026-12-18 | 5.2500 | 5.2500 | 5.4500 | 87.5600 | 167499.00 | 0.00 | 167499.00 | 319 | 40 | 595 | 2082 | 0.285782901056676 | 0.35996939777305 | 0.35996939777305 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T19:21:53.483381Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 675af09b-d94e-4b2b-8017-9bc78957f323 | 2026-08-26 15:02 | 2026-08-26 15:02 | 2026-08-26 15:02 | PDD | PDD270115P00080000 | put | 80.0000 | 2027-01-15 | 4.1000 | 4.1000 | 4.2000 | 86.4300 | 67691.00 | 0.00 | 67691.00 | 165 | 11 | 459 | 8546 | 0.0537093377018488 | 0.35381029737502 | 0.35381029737502 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T19:11:05.103195Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 43c56a91-a756-4095-95f9-51163b738043 | 2026-08-26 15:02 | 2026-08-26 15:02 | 2026-08-26 15:02 | PDD | PDD270115P00090000 | put | 90.0000 | 2027-01-15 | 8.8000 | 8.6500 | 8.8500 | 86.4300 | 435798.00 | 28160.00 | 397958.00 | 495 | 34 | 510 | 6663 | 0.0765420981539847 | 0.348794519727266 | 0.348794519727266 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T19:11:05.103195Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e953e7d1-ec11-4b7a-be69-80236564ad5a | 2026-08-26 15:52 | 2026-08-26 15:52 | 2026-08-26 15:52 | PDD | PDD261002C00087000 | call | 87.0000 | 2026-10-02 | 3.3300 | 1.8700 | 3.8500 | 86.8400 | 399853.00 | 32010.00 | 367843.00 | 1200 | 29 | 1204 | 11 | 109.454545454545 | 0.290639002496826 | 0.29159787049248 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5871eca2-666b-4a84-aafb-c2650a69fb15 | 2026-08-31 12:03 | 2026-08-31 12:03 | 2026-08-31 12:03 | PDD | PDD270115C00090000 | call | 90.0000 | 2027-01-15 | 5.4500 | 5.4000 | 5.6000 | 84.2650 | 122627.00 | 24525.00 | 98102.00 | 225 | 14 | 1238 | 2959 | 0.418384589388307 | 0.351124978177746 | 0.352776136044824 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 27118ffb-2c8d-49d2-82b0-d807fb73b1e8 | 2026-09-01 14:04 | 2026-09-01 14:04 | 2026-09-01 14:04 | PDD | PDD270115P00085000 | put | 85.0000 | 2027-01-15 | 7.2500 | 7.0500 | 7.3000 | 83.1913 | 73932.00 | 73932.00 | 0.00 | 102 | 15 | 185 | 13335 | 0.0138732658417698 | 0.339924984210707 | 0.340241676007623 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:15:43.135015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2308ab67-b4fb-4f75-ad52-e7b472f97ed3 | 2026-09-03 11:46 | 2026-09-03 11:46 | 2026-09-03 11:46 | PDD | PDD261218P00080000 | put | 80.0000 | 2026-12-18 | 4.5500 | 4.5500 | 4.7000 | 81.9700 | 289030.00 | 0.00 | 289030.00 | 635 | 42 | 783 | 12859 | 0.0608912046037795 | 0.340529827086569 | 0.340529827086569 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7ec2e184-6b9d-401e-84a4-9f0b1101114f | 2026-09-08 12:05 | 2026-09-08 12:04 | 2026-09-08 12:04 | PDD | PDD270319P00070000 | put | 70.0000 | 2027-03-19 | 3.5000 | 3.3500 | 3.5500 | 79.4700 | 87499.00 | 35699.00 | 51800.00 | 250 | 5 | 258 | 2201 | 0.117219445706497 | 0.364997500476543 | 0.365550584405776 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |