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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bbd474e1-8f62-452d-95e0-3bbb3dd727a1 | 2026-08-17 09:35 | 2026-08-17 09:35 | 2026-08-17 09:35 | ONON | ONON260821C00032000 | call | 32.0000 | 2026-08-21 | 0.9200 | 0.8600 | 1.0600 | 32.3550 | 14853.00 | 188.00 | 14665.00 | 162 | 24 | 333 | 1220 | 0.272950819672131 | 0.50380754903216 | 0.521450306199551 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | 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 |
| 7ffadcb1-1f0a-4b09-a9a8-0c10d6061453 | 2026-08-18 10:53 | 2026-08-18 10:53 | 2026-08-18 10:53 | ONON | ONON260904C00032000 | call | 32.0000 | 2026-09-04 | 0.8000 | 0.7900 | 0.8200 | 31.3200 | 27283.00 | 5084.00 | 22199.00 | 343 | 10 | 354 | 655 | 0.540458015267176 | 0.405469684609727 | 0.405469684609727 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 615d1c02-8799-4b86-88f0-4eb7ab709f9b | 2026-08-18 12:12 | 2026-08-18 12:11 | 2026-08-18 12:11 | ONON | ONON270319P00030000 | put | 30.0000 | 2027-03-19 | 3.2500 | 3.2000 | 3.3000 | 31.4650 | 89239.00 | 67139.00 | 1950.00 | 275 | 26 | 275 | 2303 | 0.119409465914025 | 0.460587787940045 | 0.460587787940045 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e3319998-5ea7-47d3-bbef-910c00d99bdf | 2026-08-20 11:56 | 2026-08-20 11:56 | 2026-08-20 11:56 | ONON | ONON280121P00022500 | put | 22.5000 | 2028-01-21 | 2.5000 | 2.4900 | 2.6200 | 29.8300 | 12763.00 | 253.00 | 12510.00 | 51 | 11 | 51 | 1199 | 0.042535446205171 | 0.492802453608566 | 0.491670129197951 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 78252e20-59b9-446d-9d93-35b8d78b59ee | 2026-08-20 12:58 | 2026-08-20 12:58 | 2026-08-20 12:58 | ONON | ONON270917C00030000 | call | 30.0000 | 2027-09-17 | 6.3500 | 6.3500 | 6.5500 | 29.9950 | 158800.00 | 0.00 | 158800.00 | 250 | 6 | 279 | 0 | 0 | 0.472194074892292 | 0.471341777131477 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cfbd8adb-c23f-49ad-9e48-f7ab49e58c5b | 2026-08-20 13:25 | 2026-08-20 13:25 | 2026-08-20 13:25 | ONON | ONON260918C00032500 | call | 32.5000 | 2026-09-18 | 0.4100 | 0.4000 | 0.4400 | 29.8150 | 24096.00 | 1845.00 | 22251.00 | 587 | 42 | 778 | 2842 | 0.27375087966221 | 0.381440797348692 | 0.377562698927471 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4b0f48a3-e81a-43df-96e3-54550bc531a9 | 2026-08-24 11:03 | 2026-08-24 11:03 | 2026-08-24 11:03 | ONON | ONON270617C00037500 | call | 37.5000 | 2027-06-17 | 2.7600 | 2.6000 | 3.0500 | 29.4900 | 12410.00 | 6062.00 | 6348.00 | 45 | 6 | 45 | 453 | 0.0993377483443709 | 0.470258875281137 | 0.469279521960106 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7bc78561-f0a5-420a-a282-74d2d4c1caf4 | 2026-08-24 13:03 | 2026-08-24 13:03 | 2026-08-24 13:03 | ONON | ONON260904P00030000 | put | 30.0000 | 2026-09-04 | 1.0900 | 1.0900 | 1.1100 | 29.4450 | 21898.00 | 5439.00 | 14279.00 | 200 | 12 | 235 | 299 | 0.785953177257525 | 0.400430922890955 | 0.400430922890955 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f0fe6136-703e-4a2f-b28b-dcc99da3208d | 2026-09-08 09:50 | 2026-09-08 09:50 | 2026-09-08 09:50 | ONON | ONON280121P00020000 | put | 20.0000 | 2028-01-21 | 2.1000 | 1.9000 | 2.1100 | 27.6100 | 118624.00 | 118624.00 | 0.00 | 565 | 44 | 565 | 264 | 2.14015151515152 | 0.510582707233156 | 0.510373150382408 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 162b94a9-2a29-4fc2-9299-165634faa617 | 2026-09-09 09:31 | 2026-09-09 09:31 | 2026-09-09 09:31 | ONON | ONON270319C00040000 | call | 40.0000 | 2027-03-19 | 0.8000 | 0.8000 | 0.9000 | 27.0000 | 20040.00 | 0.00 | 20040.00 | 250 | 5 | 250 | 3101 | 0.0806191551112544 | 0.481721455767453 | 0.481721455767453 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c0f65458-e07f-40dd-8132-3adbac9c9953 | 2026-09-11 09:55 | 2026-09-11 09:55 | 2026-09-11 09:55 | ONON | ONON260925C00029000 | call | 29.0000 | 2026-09-25 | 0.5500 | 0.2500 | 0.6900 | 27.0000 | 246981.00 | 226600.00 | 1186.00 | 4491 | 37 | 4514 | 351 | 12.8603988603989 | 0.532110194387557 | 0.498249061546578 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5461563a-d242-4c8f-8bdb-a1338ab20c35 | 2026-09-11 11:54 | 2026-09-11 11:54 | 2026-09-11 11:54 | ONON | ONON280121P00030000 | put | 30.0000 | 2028-01-21 | 6.8300 | 6.8000 | 7.0000 | 27.5200 | 102408.00 | 25567.00 | 76841.00 | 150 | 44 | 153 | 744 | 0.205645161290323 | 0.509583625517143 | 0.500889100463291 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T16:20:29.379987Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ab6adb84-01e2-4afa-8118-e561e7ed5a63 | 2026-09-18 14:47 | 2026-09-18 14:47 | 2026-09-18 14:47 | ONON | ONON260925C00028500 | call | 28.5000 | 2026-09-25 | 0.6000 | 0.4800 | 0.6000 | 27.6050 | 30110.00 | 29998.00 | 112.00 | 502 | 28 | 671 | 270 | 2.48518518518519 | 0.636115512529686 | 0.60200751477898 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8092767603.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 9d946582-ca4f-459b-b50c-5a26a8470820 | 2026-09-21 11:01 | 2026-09-21 11:01 | 2026-09-21 11:01 | ONON | ONON280121C00045000 | call | 45.0000 | 2028-01-21 | 2.0800 | 1.9200 | 2.1400 | 27.0100 | 164909.00 | 108338.00 | 8107.00 | 793 | 78 | 1033 | 2437 | 0.423881821912187 | 0.470999549647034 | 0.470999549647034 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8110580004.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:02:30.535242Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |