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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d312956a-b3fb-40af-a013-2b1830c522a2 | 2026-09-18 14:13 | 2026-09-18 14:13 | 2026-09-18 14:13 | DLO | DLO261218P00012000 | put | 12.0000 | 2026-12-18 | 0.4000 | 0.3500 | 0.5000 | 14.2100 | 36400.00 | 0.00 | 36400.00 | 910 | 28 | 955 | 915 | 1.04371584699454 | 0.476303008490698 | 0.476303008490698 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4190983095.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 53925748-2cef-415d-b945-4125628f2cca | 2026-09-18 13:32 | 2026-09-18 13:32 | 2026-09-18 13:32 | DLO | DLO270219P00015000 | put | 15.0000 | 2027-02-19 | 1.8500 | 1.8000 | 1.9000 | 14.2400 | 15910.00 | 7030.00 | 8880.00 | 86 | 12 | 116 | 6 | 19.3333333333333 | 0.424729420858242 | 0.424729420858242 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4190983095.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 8d0bb71f-f80b-4896-a9bf-cbbab057f619 | 2026-09-18 11:51 | 2026-09-18 11:51 | 2026-09-18 11:51 | DLO | DLO270219P00016000 | put | 16.0000 | 2027-02-19 | 2.5000 | 2.4500 | 2.5500 | 14.2500 | 18500.00 | 6500.00 | 12000.00 | 74 | 18 | 267 | 87 | 3.06896551724138 | 0.430102629714017 | 0.430102629714017 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4190983095.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 8b236225-2da1-484b-b4f7-a696fe301c16 | 2026-09-18 10:32 | 2026-09-18 10:32 | 2026-09-18 10:32 | DLO | DLO270219P00016000 | put | 16.0000 | 2027-02-19 | 2.5000 | 2.3500 | 2.5500 | 14.2650 | 22000.00 | 8750.00 | 13250.00 | 88 | 10 | 88 | 87 | 1.01149425287356 | 0.432519329546805 | 0.432519329546805 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4190983095.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a1ef2fbc-a787-4c34-80af-5813e9fab673 | 2026-09-15 11:36 | 2026-09-15 11:35 | 2026-09-15 11:35 | DLO | DLO270115C00019470 | call | 19.4700 | 2027-01-15 | 0.3500 | 0.3000 | 0.4000 | 14.6500 | 12250.00 | 1750.00 | 10500.00 | 350 | 7 | 350 | 3085 | 0.113452188006483 | 0.458605016650716 | 0.458605016650716 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T15:54:17.138635Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 3d9b6515-4eea-4346-b985-d0bd439ed656 | 2026-09-14 12:03 | 2026-09-14 12:03 | 2026-09-14 12:03 | DLO | DLO261016C00015000 | call | 15.0000 | 2026-10-16 | 0.6500 | 0.6500 | 0.7000 | 14.8214 | 18330.00 | 0.00 | 18330.00 | 282 | 12 | 582 | 281 | 2.0711743772242 | 0.404616609357882 | 0.404616609357882 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6e37130a-8453-4900-8fd1-0214188cc938 | 2026-08-28 10:49 | 2026-08-28 10:49 | 2026-08-28 10:49 | DLO | DLO261016C00016000 | call | 16.0000 | 2026-10-16 | 0.5500 | 0.5000 | 0.6000 | 15.1400 | 33605.00 | 33110.00 | 495.00 | 611 | 20 | 1997 | 151 | 13.2251655629139 | 0.395906857291709 | 0.390417935543134 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:54:23.998586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cc1943a4-2f74-495f-bbf7-2abe7b55c670 | 2026-08-28 09:48 | 2026-08-28 09:48 | 2026-08-28 09:48 | DLO | DLO261016C00016000 | call | 16.0000 | 2026-10-16 | 0.5500 | 0.4500 | 0.6000 | 15.0900 | 17655.00 | 605.00 | 17050.00 | 321 | 5 | 873 | 151 | 5.78145695364238 | 0.39955564077447 | 0.39955564077447 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T13:57:11.446067Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 311422df-de7f-4322-a147-37d6a248fc9f | 2026-08-28 09:48 | 2026-08-28 09:48 | 2026-08-28 09:48 | DLO | DLO261016C00016000 | call | 16.0000 | 2026-10-16 | 0.5500 | 0.3500 | 0.7000 | 15.0900 | 30360.00 | 28600.00 | 1760.00 | 552 | 22 | 552 | 151 | 3.65562913907285 | 0.408642815943577 | 0.39955564077447 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T13:57:11.446067Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2a18e04f-8944-4e0b-9a2a-d9c0bd3df4df | 2026-08-26 10:27 | 2026-08-26 10:27 | 2026-08-26 10:27 | DLO | DLO261218C00017000 | call | 17.0000 | 2026-12-18 | 1.0300 | 1.0000 | 1.1500 | 15.4250 | 10347.00 | 0.00 | 10347.00 | 100 | 5 | 103 | 59677 | 0.00172595807429998 | 0.456535884318601 | 0.456535884318601 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 87b12013-7406-4800-add6-57ba87145db6 | 2026-08-25 15:12 | 2026-08-25 15:12 | 2026-08-25 15:12 | DLO | DLO261016C00017000 | call | 17.0000 | 2026-10-16 | 0.4000 | 0.4000 | 0.4500 | 15.4100 | 40000.00 | 0.00 | 40000.00 | 1000 | 51 | 3087 | 98 | 31.5 | 0.395186057011548 | 0.399596468169687 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | 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 |
| 9ea512be-6ad3-4f35-a6be-0b40a4f3c3a4 | 2026-08-25 13:58 | 2026-08-25 13:58 | 2026-08-25 13:58 | DLO | DLO261016C00017000 | call | 17.0000 | 2026-10-16 | 0.4000 | 0.3500 | 0.4000 | 15.4300 | 40080.00 | 40080.00 | 0.00 | 1002 | 5 | 2054 | 98 | 20.9591836734694 | 0.396656895218366 | 0.396656895218366 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2002d8c5-1466-49c7-ae5f-a4acf369be90 | 2026-08-21 10:56 | 2026-08-21 10:56 | 2026-08-21 10:56 | DLO | DLO260918C00015000 | call | 15.0000 | 2026-09-18 | 0.6000 | 0.5500 | 0.6500 | 14.8350 | 87300.00 | 600.00 | 86700.00 | 1455 | 27 | 1692 | 730 | 2.31780821917808 | 0.400531135773688 | 0.400531135773688 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | 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 |
| 23a698f7-2a1f-4ac3-9869-2169efd1d489 | 2026-08-20 13:54 | 2026-08-20 13:54 | 2026-08-20 13:54 | DLO | DLO261016C00014000 | call | 14.0000 | 2026-10-16 | 1.1500 | 1.1000 | 1.2000 | 14.3750 | 16100.00 | 0.00 | 15985.00 | 140 | 27 | 141 | 225 | 0.626666666666667 | 0.405166380915261 | 0.405166380915261 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a6ab80b1-a186-49a8-adb5-6a13d3c5cbb7 | 2026-08-17 10:43 | 2026-08-17 10:42 | 2026-08-17 10:42 | DLO | DLO261016C00014000 | call | 14.0000 | 2026-10-16 | 1.2500 | 0.8500 | 1.2500 | 13.9600 | 24988.00 | 24988.00 | 0.00 | 200 | 6 | 200 | 45 | 4.44444444444444 | 0.53612813506336 | 0.545055109246964 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ddb30a9f-f7e8-462b-85a4-30829ca8f2c8 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | DLO | DLO280121C00015000 | call | 15.0000 | 2028-01-21 | 3.6000 | 3.6000 | 4.7000 | 14.2500 | 19080.00 | 0.00 | 19080.00 | 53 | 5 | 53 | 1218 | 0.0435139573070608 | 0.531775880719118 | 0.531775880719118 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4376790227.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |