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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21a1cf08-a954-4ff8-b498-efa593c3ca67 | 2026-09-18 14:35 | 2026-09-18 14:35 | 2026-09-18 14:35 | ADI | ADI261120P00380000 | put | 380.0000 | 2026-11-20 | 27.4500 | 27.4000 | 28.5000 | 369.6450 | 63130.00 | 0.00 | 63130.00 | 23 | 5 | 31 | 50 | 0.62 | 0.379561686526839 | 0.377927272822312 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 182060936510.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| de84fb73-4cc5-4d5e-81a2-a8a4c07ea858 | 2026-09-18 13:50 | 2026-09-18 13:50 | 2026-09-18 13:50 | ADI | ADI261120C00380000 | call | 380.0000 | 2026-11-20 | 19.5700 | 18.5000 | 19.6000 | 369.1100 | 72420.00 | 52920.00 | 19500.00 | 37 | 8 | 126 | 55 | 2.29090909090909 | 0.379854844549745 | 0.379854844549745 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 182060936510.00 | 2026-11-24 | 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 |
| dba4eec3-cff4-43e4-a1ab-43749c253910 | 2026-09-18 13:50 | 2026-09-18 13:50 | 2026-09-18 13:50 | ADI | ADI270617C00410000 | call | 410.0000 | 2027-06-17 | 37.9100 | 37.0000 | 38.0000 | 369.1100 | 79620.00 | 79620.00 | 0.00 | 21 | 10 | 23 | 111 | 0.207207207207207 | 0.387839780774998 | 0.387051947925533 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 182060936510.00 | 2026-11-24 | 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 |
| e89d5022-92ee-43b4-a59b-ae52f42bd064 | 2026-09-16 12:22 | 2026-09-16 12:22 | 2026-09-16 12:22 | ADI | ADI261120P00370000 | put | 370.0000 | 2026-11-20 | 23.5900 | 22.4000 | 23.6000 | 367.3100 | 141530.00 | 129780.00 | 9400.00 | 60 | 33 | 60 | 121 | 0.495867768595041 | 0.382128713573208 | 0.380506315276855 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 175432080949.00 | 2026-11-24 | unknown | — | 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 |
| f32ec6fd-df89-4d43-9810-de3936202ec0 | 2026-09-14 09:32 | 2026-09-14 09:32 | 2026-09-14 09:32 | ADI | ADI261120C00360000 | call | 360.0000 | 2026-11-20 | 25.9500 | 25.4000 | 27.3000 | 361.8300 | 199850.00 | 129530.00 | 34060.00 | 77 | 9 | 653 | 1332 | 0.49024024024024 | 0.390931184191803 | 0.386022123290274 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d735092e-196f-4e57-a56c-1fda6bf0f9d4 | 2026-09-14 09:32 | 2026-09-14 09:32 | 2026-09-14 09:32 | ADI | ADI261120C00360000 | call | 360.0000 | 2026-11-20 | 26.2400 | 26.0000 | 26.3000 | 361.6600 | 91840.00 | 91840.00 | 0.00 | 35 | 7 | 482 | 1332 | 0.361861861861862 | 0.394127954818727 | 0.392491491427585 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2eed1fec-d762-41b8-aa69-0ea6c11a0ba9 | 2026-09-11 10:54 | 2026-09-11 10:54 | 2026-09-11 10:54 | ADI | ADI270115C00430000 | call | 430.0000 | 2027-01-15 | 15.6300 | 15.6000 | 16.5000 | 374.0500 | 57820.00 | 4760.00 | 53060.00 | 37 | 5 | 37 | 656 | 0.0564024390243902 | 0.382023973553521 | 0.380759350417446 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ff4800c2-8fa5-4243-a0e9-631f026ab1a4 | 2026-09-02 11:42 | 2026-09-02 11:42 | 2026-09-02 11:42 | ADI | ADI280121C00420000 | call | 420.0000 | 2028-01-21 | 50.6000 | 49.2000 | 50.8000 | 357.8750 | 126490.00 | 91140.00 | 35350.00 | 25 | 6 | 88 | 45 | 1.95555555555556 | 0.387178822800415 | 0.385394104197518 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 06f5b6e0-b886-425b-8e81-d3222e429df1 | 2026-09-01 15:31 | 2026-09-01 15:30 | 2026-09-01 15:30 | ADI | ADI280121P00400000 | put | 400.0000 | 2028-01-21 | 83.1900 | 81.5000 | 83.2000 | 354.7300 | 83189.00 | 74879.00 | 8310.00 | 10 | 7 | 23 | 51 | 0.450980392156863 | 0.406475898590928 | 0.406475898590928 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e1884b8a-29fc-466b-a34a-442487fefecd | 2026-08-31 13:44 | 2026-08-31 13:43 | 2026-08-31 13:43 | ADI | ADI270617P00330000 | put | 330.0000 | 2027-06-17 | 29.5000 | 29.3000 | 29.6000 | 363.1550 | 120970.00 | 82880.00 | 38090.00 | 41 | 8 | 81 | 196 | 0.413265306122449 | 0.39552381015873 | 0.392853271852452 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 48732ebe-dbcf-46c2-9026-614a38f18409 | 2026-08-28 09:39 | 2026-08-28 09:39 | 2026-08-28 09:39 | ADI | ADI261120C00370000 | call | 370.0000 | 2026-11-20 | 26.5000 | 26.4000 | 27.2000 | 368.3201 | 58310.00 | 2650.00 | 55660.00 | 22 | 8 | 545 | 1105 | 0.493212669683258 | 0.368133530980194 | 0.366706187135315 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | 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 |
| 8637cff3-60b0-47f2-b0a8-67e3ce7ea50d | 2026-08-27 11:29 | 2026-08-27 11:29 | 2026-08-27 11:29 | ADI | ADI261218P00320000 | put | 320.0000 | 2026-12-18 | 10.5000 | 9.8000 | 10.5000 | 375.1150 | 203698.00 | 203698.00 | 0.00 | 194 | 48 | 197 | 1127 | 0.174800354924579 | 0.413575351277849 | 0.413829866069317 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0a6230c5-e9f9-4fb1-b771-375e31f6c3ea | 2026-08-25 11:39 | 2026-08-25 11:39 | 2026-08-25 11:39 | ADI | ADI270617C00540000 | call | 540.0000 | 2027-06-17 | 14.7500 | 14.7000 | 14.8000 | 371.1750 | 178480.00 | 90280.00 | 0.00 | 121 | 5 | 127 | 38 | 3.34210526315789 | 0.404176051688629 | 0.404176051688629 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 83b38a4a-a26b-4dfe-a840-1868a2a8d923 | 2026-08-25 10:04 | 2026-08-25 10:04 | 2026-08-25 10:04 | ADI | ADI270617P00350000 | put | 350.0000 | 2027-06-17 | 39.8600 | 37.4000 | 39.9000 | 368.8800 | 75740.00 | 67800.00 | 7940.00 | 19 | 6 | 19 | 218 | 0.0871559633027523 | 0.424814279936737 | 0.423992084894776 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ea4ff440-d38a-4c91-ad96-9bb4ec4987f4 | 2026-08-21 12:52 | 2026-08-21 12:52 | 2026-08-21 12:52 | ADI | ADI260918C00390000 | call | 390.0000 | 2026-09-18 | 8.1400 | 7.8000 | 8.3000 | 372.9537 | 64334.00 | 61928.00 | 2406.00 | 79 | 5 | 219 | 495 | 0.442424242424242 | 0.353534970965619 | 0.347516203686406 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2ef2d91a-bf7a-4cbd-9599-25eae79d3791 | 2026-08-21 10:51 | 2026-08-21 10:51 | 2026-08-21 10:51 | ADI | ADI280121P00330000 | put | 330.0000 | 2028-01-21 | 44.3600 | 43.9000 | 44.4000 | 373.5150 | 70980.00 | 26630.00 | 22150.00 | 16 | 5 | 23 | 114 | 0.201754385964912 | 0.445137149497134 | 0.444458245633863 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c06a59ee-2c94-4355-810f-b03dffae2891 | 2026-08-19 12:02 | 2026-08-19 12:01 | 2026-08-19 12:01 | ADI | ADI260918C00450000 | call | 450.0000 | 2026-09-18 | 1.2700 | 1.1000 | 2.0500 | 380.6400 | 352784.00 | 161.00 | 352623.00 | 2773 | 7 | 2775 | 741 | 3.74493927125506 | 0.399725716359268 | 0.399725716359268 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a81b9307-f060-4f22-a903-38f9a52194d5 | 2026-08-17 09:38 | 2026-08-17 09:37 | 2026-08-17 09:37 | ADI | ADI260821P00385000 | put | 385.0000 | 2026-08-21 | 9.0800 | 7.9000 | 10.4000 | 390.4700 | 272471.00 | 31669.00 | 240802.00 | 300 | 21 | 300 | 148 | 2.02702702702703 | 0.73986056652035 | 0.718459766353753 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 174937824174.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |