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.
Simplify Analyticsuw_flow_alerts326,449 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 | price |
|---|
| 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 |
|---|
| a078324b-bd9b-46a6-b2d4-b1a334b3e427 | 2026-08-21 12:14 | 2026-08-21 12:14 | 2026-08-21 12:14 | PDD | PDD260828C00091000 | call | 91.0000 | 2026-08-28 | 2.6900 | 2.6900 | 2.8000 | 89.2600 | 68057.00 | 0.00 | 68057.00 | 253 | 5 | 557 | 832 | 0.669471153846154 | 0.696843467348258 | 0.695936912272685 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Consumer Cyclical | 112989211154.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dc77b2a4-da22-45a2-b8e2-71543323e195 | 2026-08-21 11:09 | 2026-08-21 11:09 | 2026-08-21 11:09 | PDD | PDD261120P00065000 | put | 65.0000 | 2026-11-20 | 0.5700 | 0.4400 | 0.5700 | 88.5200 | 55683.00 | 55630.00 | 53.00 | 977 | 42 | 982 | 1331 | 0.737791134485349 | 0.44584324605732 | 0.437669034124232 | true | false | false | true | false | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| fc4ede22-b84f-4ef1-9243-c0c242be4def | 2026-08-20 14:25 | 2026-08-20 14:25 | 2026-08-20 14:25 | PDD | PDD260918C00100000 | call | 100.0000 | 2026-09-18 | 1.2000 | 1.1300 | 1.2400 | 89.3650 | 60600.00 | 60600.00 | 0.00 | 505 | 6 | 674 | 10227 | 0.0659039796616799 | 0.438243186205991 | 0.438243186205991 | false | false | false | true | false | |||||||||||||||
| 6cec9ed0-ab97-441d-a132-5949a0678d03 | 2026-08-20 10:46 | 2026-08-20 10:46 | 2026-08-20 10:46 | PDD | PDD261218C00110000 | call | 110.0000 | 2026-12-18 | 2.0600 | 1.9800 | 2.0600 | 87.7350 | 61594.00 | 61594.00 | 0.00 | 299 | 27 | 309 | 2234 | 0.138316920322292 | 0.396018456346008 | 0.396018456346008 | false | false | false | true | false | |||||||||||||||
| 2106550b-aa82-4358-8675-39a9c95e2f37 | 2026-08-20 09:30 | 2026-08-20 09:30 | 2026-08-20 09:30 | PDD | PDD280121C00090000 | call | 90.0000 | 2028-01-21 | 19.5500 | 18.9000 | 19.9000 | 89.2500 | 78200.00 | 9775.00 | 68425.00 | 40 | 5 | 40 | 1874 | 0.0213447171824973 | 0.420682048921105 | 0.420682048921105 | false | false | false | true | false | |||||||||||||||
| 9759f802-2971-4844-961a-f81e4b23b784 | 2026-08-19 10:44 | 2026-08-19 10:44 | 2026-08-19 10:44 | PDD | PDD261016C00105000 | call | 105.0000 | 2026-10-16 | 1.2100 | 1.0700 | 1.2100 | 89.0500 | 52876.00 | 52756.00 | 120.00 | 437 | 43 | 440 | 4987 | 0.0882293964307199 | 0.391343728759773 | 0.391343728759773 | false | false | false | true | false | |||||||||||||||
| a65db375-6317-4cc8-ad4e-4788d4ed0f43 | 2026-08-19 09:40 | 2026-08-19 09:39 | 2026-08-19 09:39 | PDD | PDD260918C00095000 | call | 95.0000 | 2026-09-18 | 2.0000 | 1.8400 | 2.0000 | 88.6000 | 100600.00 | 100600.00 | 0.00 | 503 | 6 | 515 | 19010 | 0.0270910047343503 | 0.422387698506744 | 0.419618349341893 | false | false | false | true | false | |||||||||||||||
| 70569ffb-0e3e-4e01-9322-300c0a4e9cec | 2026-08-18 13:55 | 2026-08-18 13:55 | 2026-08-18 13:55 | PDD | PDD260918P00085000 | put | 85.0000 | 2026-09-18 | 3.3000 | 3.2000 | 3.3000 | 86.4250 | 54120.00 | 54120.00 | 0.00 | 164 | 15 | 307 | 7524 | 0.040802764486975 | 0.411758224051929 | 0.411758224051929 | false | false | false | true | false | |||||||||||||||
| 817c5c46-14db-4efb-ace3-f28118703234 | 2026-08-17 13:12 | 2026-08-17 13:12 | 2026-08-17 13:12 | PDD | PDD261218P00085000 | put | 85.0000 | 2026-12-18 | 6.4000 | 6.4000 | 6.6000 | 86.3000 | 64000.00 | 0.00 | 64000.00 | 100 | 21 | 359 | 1902 | 0.188748685594111 | 0.383969865314805 | 0.383969865314805 | false | false | false | true | false | |||||||||||||||
| d5c35837-221d-46ef-b0fb-5830b8ddd0cd | 2026-08-17 13:12 | 2026-08-17 13:12 | 2026-08-17 13:12 | PDD | PDD261120P00085000 | put | 85.0000 | 2026-11-20 | 5.5500 | 5.5000 | 5.7000 | 86.3200 | 76035.00 | 31080.00 | 37740.00 | 137 | 28 | 269 | 3959 | 0.0679464511240212 | 0.379920392657678 | 0.379920392657678 | true | false | false | true | false | |||||||||||||||
| c9863640-53fb-4340-b48f-1293103511c3 | 2026-08-17 11:33 | 2026-08-17 11:33 | 2026-08-17 11:33 | PDD | PDD261016P00085000 | put | 85.0000 | 2026-10-16 | 4.6200 | 4.5500 | 4.8000 | 85.3100 | 184678.00 | 0.00 | 184678.00 | 400 | 5 | 518 | 3172 | 0.163303909205549 | 0.368074677899953 | 0.365878859607308 | false | false | false | true | false | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 93e94930-a972-4674-a699-9f5a7ad0b5fd | 2026-08-17 09:51 | 2026-08-17 09:51 | 2026-08-17 09:51 | PDD | PDD260828C00087000 | call | 87.0000 | 2026-08-28 | 3.0700 | 3.0500 | 3.1500 | 86.5700 | 76855.00 | 39640.00 | 37215.00 | 250 | 24 | 250 | 321 | 0.778816199376947 | 0.544187813646016 | 0.543349669265387 | false | false | false | true | false | |||||||||||||||
| 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 | |||||||||||||||
| 8e41fa5f-cbfb-4be9-a8e0-77a24cf6d00e | 2026-08-17 09:45 | 2026-08-17 09:45 | 2026-08-17 09:45 | PDD | PDD260828C00090000 | call | 90.0000 | 2026-08-28 | 1.8000 | 1.7700 | 1.8500 | 86.3400 | 54714.00 | 52560.00 | 2154.00 | 304 | 6 | 338 | 398 | 0.849246231155779 | 0.537066023437656 | 0.537066023437656 | true | false | false | true | false |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Consumer Cyclical |
| 112989211154.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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 |
| 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 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 112989211154.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 112989211154.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 112989211154.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 112989211154.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 112989211154.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 112989211154.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 112989211154.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 112989211154.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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 |
| 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 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| 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 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |