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
active:ticker = DGXX×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c4d96df0-39e0-4a9c-b76d-62e1b8c10965 | 2026-09-18 15:54 | 2026-09-18 15:54 | 2026-09-18 15:54 | DGXX | DGXX261120C00007000 | call | 7.0000 | 2026-11-20 | 0.1000 | 0.1000 | 0.1500 | 4.0000 | 10000.00 | 0.00 | 10000.00 | 1000 | 7 | 3501 | 0 | 0 | 0.993754625995055 | 0.993754625995055 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 414698822.00 | 2026-11-12 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 814cc2ff-6c24-48da-9a5d-df7a845a9c7b | 2026-09-18 13:41 | 2026-09-18 13:41 | 2026-09-18 13:41 | DGXX | DGXX261120C00006000 | call | 6.0000 | 2026-11-20 | 0.1500 | 0.1500 | 0.2000 | 3.8350 | 15000.00 | 0.00 | 15000.00 | 1000 | 7 | 6834 | 0 | 0 | 1.01060745980952 | 1.01060745980952 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 414698822.00 | 2026-11-12 | 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 |
| 0b68dd26-be69-4755-a144-d52f182f4f2a | 2026-09-18 10:37 | 2026-09-18 10:37 | 2026-09-18 10:37 | DGXX | DGXX261120C00006000 | call | 6.0000 | 2026-11-20 | 0.1500 | 0.1000 | 0.1500 | 3.7900 | 10515.00 | 420.00 | 0.00 | 701 | 9 | 2706 | 0 | 0 | 1.02638486912608 | 1.03091604201647 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 414698822.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 91d2b8c1-6941-420f-ad28-70335d6ec1ec | 2026-09-18 09:57 | 2026-09-18 09:56 | 2026-09-18 09:56 | DGXX | DGXX261120C00006000 | call | 6.0000 | 2026-11-20 | 0.1500 | 0.1000 | 0.2500 | 3.8750 | 15000.00 | 1500.00 | 13500.00 | 1000 | 6 | 1000 | 0 | 0 | 0.992728344439601 | 0.992728344439601 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 414698822.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 07764eb9-893d-4656-bf22-7195a1a2afa9 | 2026-09-08 11:06 | 2026-09-08 11:06 | 2026-09-08 11:06 | DGXX | DGXX261218C00004000 | call | 4.0000 | 2026-12-18 | 0.8500 | 0.7500 | 0.9000 | 3.9800 | 145265.00 | 125885.00 | 12495.00 | 1709 | 77 | 1709 | 458 | 3.73144104803493 | 1.03350148979139 | 1.01831570665587 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 378197214.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c3122446-b8ea-4601-a5bb-a11b6a85ba4a | 2026-09-08 11:04 | 2026-09-08 11:04 | 2026-09-08 11:04 | DGXX | DGXX270115P00004000 | put | 4.0000 | 2027-01-15 | 0.9500 | 0.9000 | 1.0000 | 3.9600 | 142500.00 | 106875.00 | 1900.00 | 1500 | 28 | 1500 | 1607 | 0.933416303671437 | 1.03466135075303 | 1.03466135075303 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 378197214.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3a084cc9-429e-412d-9795-e02a8e2b1cbb | 2026-09-03 14:11 | 2026-09-03 14:11 | 2026-09-03 14:11 | DGXX | DGXX261016C00006000 | call | 6.0000 | 2026-10-16 | 0.0500 | 0.0000 | 0.0500 | 3.7000 | 10000.00 | 10000.00 | 0.00 | 2000 | 10 | 3003 | 10332 | 0.290650406504065 | 0.960415269275506 | 0.960415269275506 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 378197214.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T18:16:35.526734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ce1eac71-a368-4bce-b108-18366caa8d10 | 2026-08-27 11:53 | 2026-08-27 11:53 | 2026-08-27 11:53 | DGXX | DGXX270115P00004000 | put | 4.0000 | 2027-01-15 | 0.9500 | 0.9000 | 0.9500 | 4.1100 | 23750.00 | 23750.00 | 0.00 | 250 | 7 | 1001 | 2588 | 0.386785162287481 | 1.05376678150694 | 1.05376678150694 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 378197214.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 774e29f4-36e7-44af-8298-2ed023335a62 | 2026-08-27 11:53 | 2026-08-27 11:53 | 2026-08-27 11:53 | DGXX | DGXX270115P00004000 | put | 4.0000 | 2027-01-15 | 0.9500 | 0.9000 | 0.9500 | 4.1170 | 23750.00 | 23750.00 | 0.00 | 250 | 7 | 251 | 2588 | 0.0969860896445131 | 1.05633932031557 | 1.05633932031557 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 378197214.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6b4f12fa-2dae-4245-9ba2-95651e6b2d5d | 2026-08-27 11:53 | 2026-08-27 11:53 | 2026-08-27 11:53 | DGXX | DGXX270115P00004000 | put | 4.0000 | 2027-01-15 | 0.9500 | 0.9000 | 0.9500 | 4.1100 | 23750.00 | 23750.00 | 0.00 | 250 | 6 | 751 | 2588 | 0.290185471406491 | 1.05376678150694 | 1.05376678150694 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 378197214.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9aa16141-822f-4793-9eff-96cc577a968a | 2026-08-18 15:52 | 2026-08-18 15:52 | 2026-08-18 15:52 | DGXX | DGXX270115C00007000 | call | 7.0000 | 2027-01-15 | 0.3000 | 0.3000 | 0.4000 | 3.0000 | 15013.00 | 0.00 | 15013.00 | 500 | 5 | 1569 | 4244 | 0.369698397737983 | 1.08544566954559 | 1.08544566954559 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 378197214.00 | 2026-11-12 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:30:09.852702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |