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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3e7e3709-6536-4362-8104-9fcc3454a0f6 | 2026-08-17 09:50 | 2026-08-17 09:50 | 2026-08-17 09:50 | DINO | DINO261218C00135000 | call | 135.0000 | 2026-12-18 | 1.8800 | 1.7500 | 2.8000 | 94.7175 | 14075.00 | 0.00 | 14075.00 | 75 | 7 | 75 | 175 | 0.428571428571429 | 0.487288276599216 | 0.502225896547328 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | 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 |
| 081a1057-5ecb-4633-b0e1-3b3678df7e2e | 2026-08-17 11:39 | 2026-08-17 11:39 | 2026-08-17 11:39 | DINO | DINO260821C00095000 | call | 95.0000 | 2026-08-21 | 1.8300 | 1.8000 | 2.0000 | 94.6600 | 41205.00 | 26085.00 | 15120.00 | 225 | 26 | 631 | 7358 | 0.085756999184561 | 0.494123959345563 | 0.504323751327378 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | 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 |
| f3928805-45a7-4bb9-a694-b42a0bde80dd | 2026-08-17 11:39 | 2026-08-17 11:39 | 2026-08-17 11:39 | DINO | DINO260821C00095000 | call | 95.0000 | 2026-08-21 | 1.7000 | 1.7000 | 1.9000 | 94.5700 | 29923.00 | 0.00 | 29923.00 | 176 | 44 | 1526 | 7358 | 0.207393313400381 | 0.477310587060071 | 0.477310587060071 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | 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 |
| c33f6a69-03ec-497f-b43f-ba67c37ea387 | 2026-08-18 10:46 | 2026-08-18 10:46 | 2026-08-18 10:46 | DINO | DINO270115C00110000 | call | 110.0000 | 2027-01-15 | 6.4600 | 6.2000 | 6.6000 | 94.8600 | 12916.00 | 12916.00 | 0.00 | 20 | 9 | 62 | 2544 | 0.0243710691823899 | 0.46266334993326 | 0.46266334993326 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e86cffd2-940c-4922-87a0-1fda2278e419 | 2026-08-18 14:02 | 2026-08-18 14:02 | 2026-08-18 14:02 | DINO | DINO260918C00100000 | call | 100.0000 | 2026-09-18 | 3.3000 | 3.3000 | 3.5000 | 95.3600 | 217160.00 | 0.00 | 217160.00 | 658 | 41 | 735 | 3625 | 0.202758620689655 | 0.456774019881281 | 0.456774019881281 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | 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 |
| a071ae41-873a-4087-ada2-d3794c55c808 | 2026-08-21 13:00 | 2026-08-21 13:00 | 2026-08-21 13:00 | DINO | DINO270115C00100000 | call | 100.0000 | 2027-01-15 | 10.8500 | 10.5000 | 11.2000 | 96.7200 | 21690.00 | 0.00 | 6500.00 | 20 | 6 | 91 | 2675 | 0.034018691588785 | 0.47391999794239 | 0.47391999794239 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | 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 |
| a9707346-fbc0-4169-a361-9fe6834599b8 | 2026-08-27 11:22 | 2026-08-27 11:21 | 2026-08-27 11:21 | DINO | DINO260918P00095000 | put | 95.0000 | 2026-09-18 | 4.4000 | 4.4000 | 4.5000 | 94.9900 | 92416.00 | 0.00 | 92416.00 | 210 | 38 | 214 | 228 | 0.93859649122807 | 0.484809523540487 | 0.484809523540487 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 10a7f8bd-fff9-46a7-a56f-7d60dd11351e | 2026-08-28 11:54 | 2026-08-28 11:54 | 2026-08-28 11:54 | DINO | DINO260918C00105000 | call | 105.0000 | 2026-09-18 | 2.8300 | 2.5500 | 3.1000 | 100.0000 | 80415.00 | 39330.00 | 9450.00 | 284 | 10 | 1296 | 2151 | 0.602510460251046 | 0.480219172808368 | 0.496816017070572 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4826d7bb-7ecc-4fed-81a8-e6d0fe9b5b6c | 2026-08-28 11:54 | 2026-08-28 11:54 | 2026-08-28 11:54 | DINO | DINO260918C00100000 | call | 100.0000 | 2026-09-18 | 4.6000 | 4.6000 | 4.8000 | 100.0000 | 58431.00 | 470.00 | 57961.00 | 127 | 37 | 1179 | 7359 | 0.160211985324093 | 0.46938878132421 | 0.479869056017622 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 36e61592-ac70-44c8-89d9-b64b6e7908c4 | 2026-08-28 11:54 | 2026-08-28 11:54 | 2026-08-28 11:54 | DINO | DINO260918C00105000 | call | 105.0000 | 2026-09-18 | 2.7700 | 2.4500 | 2.8500 | 99.0000 | 97850.00 | 93745.00 | 3825.00 | 353 | 35 | 3017 | 2151 | 1.40260344026034 | 0.486276957860139 | 0.496988611019129 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9a3f8ae1-f13a-4ddf-a623-04a7606b7ee3 | 2026-08-31 13:17 | 2026-08-31 13:16 | 2026-08-31 13:16 | DINO | DINO260918C00100000 | call | 100.0000 | 2026-09-18 | 4.4000 | 4.4000 | 4.6000 | 100.0000 | 55003.00 | 0.00 | 55003.00 | 125 | 46 | 1834 | 5186 | 0.353644427304281 | 0.486597356464466 | 0.486597356464466 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | 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 |
| 73026dc1-a70d-4b36-804c-b756387d4cf3 | 2026-09-02 13:56 | 2026-09-02 13:56 | 2026-09-02 13:56 | DINO | DINO270521C00140000 | call | 140.0000 | 2027-05-21 | 8.5000 | 8.0000 | 8.5000 | 106.1192 | 10198.00 | 10198.00 | 0.00 | 12 | 8 | 12 | 2 | 6 | 0.494434522297604 | 0.494734989079956 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6cf7616e-03e4-40c2-99fa-9be1242afaf8 | 2026-09-03 13:50 | 2026-09-03 13:50 | 2026-09-03 13:50 | DINO | DINO261016P00110000 | put | 110.0000 | 2026-10-16 | 9.1000 | 9.1000 | 9.5000 | 106.4000 | 364008.00 | 0.00 | 364008.00 | 400 | 44 | 400 | 2 | 200 | 0.498935045214413 | 0.503720575029212 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 132941d8-9843-42de-bdc1-d24f9577260f | 2026-09-14 12:49 | 2026-09-14 12:49 | 2026-09-14 12:49 | DINO | DINO271119C00160000 | call | 160.0000 | 2027-11-19 | 9.3500 | 8.4000 | 10.3000 | 106.5350 | 13090.00 | 6580.00 | 6510.00 | 14 | 5 | 20 | 0 | 0 | 0.470742886267628 | 0.47311788275701 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 19006871297.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ec8d0aad-5b22-4ef8-bc2b-567a2c343d76 | 2026-09-16 14:47 | 2026-09-16 14:47 | 2026-09-16 14:47 | DINO | DINO261016C00120000 | call | 120.0000 | 2026-10-16 | 5.2000 | 4.9000 | 5.2000 | 113.7800 | 220460.00 | 220460.00 | 0.00 | 424 | 26 | 792 | 300 | 2.64 | 0.575134047168774 | 0.583003487464924 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 20262025271.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| ee2b4e02-9e6f-4d04-b821-8dcaea6a0821 | 2026-09-17 12:36 | 2026-09-17 12:36 | 2026-09-17 12:36 | DINO | DINO261016C00115000 | call | 115.0000 | 2026-10-16 | 7.4000 | 7.4000 | 7.8000 | 115.0950 | 142087.00 | 0.00 | 142087.00 | 192 | 36 | 1263 | 1155 | 1.09350649350649 | 0.555621971056684 | 0.555621971056684 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 20733152470.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |