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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5a078824-8272-41b0-bb54-c4019671a72b | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | MU | MU270617C01200000 | call | 1200.0000 | 2027-06-17 | 206.1000 | 198.3500 | 206.1000 | 996.9100 | 144270.00 | 144270.00 | 0.00 | 7 | 7 | 7 | 1398 | 0.0050071530758226 | 0.728646679081673 | 0.728646679081673 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | 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 |
| 486cc589-6d8f-4391-92d6-a130f0f399fe | 2026-08-17 10:49 | 2026-08-17 10:49 | 2026-08-17 10:49 | MU | MU270617C01200000 | call | 1200.0000 | 2027-06-17 | 218.6500 | 216.4000 | 220.6000 | 1025.5600 | 109326.00 | 65626.00 | 0.00 | 5 | 5 | 35 | 1398 | 0.025035765379113 | 0.719585726463433 | 0.720667548870379 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | 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 |
| a5f09aad-8dfa-4393-8ba0-559bf45de3ad | 2026-08-19 09:30 | 2026-08-19 09:30 | 2026-08-19 09:30 | MU | MU270617C01200000 | call | 1200.0000 | 2027-06-17 | 175.5800 | 172.2500 | 180.3500 | 950.2700 | 245815.00 | 228255.00 | 17560.00 | 14 | 14 | 29 | 1328 | 0.0218373493975904 | 0.713552189566286 | 0.714146982855262 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 288fcc1d-4380-4261-96bc-d78189225cd3 | 2026-08-19 09:30 | 2026-08-19 09:30 | 2026-08-19 09:30 | MU | MU270617C01200000 | call | 1200.0000 | 2027-06-17 | 175.4300 | 172.2500 | 180.3500 | 949.5150 | 192975.00 | 175435.00 | 17540.00 | 11 | 11 | 11 | 1328 | 0.00828313253012048 | 0.71453088670009 | 0.714676015624654 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 34d36c80-613b-4465-aaef-0aed100edafc | 2026-08-19 09:30 | 2026-08-19 09:30 | 2026-08-19 09:30 | MU | MU270617C01200000 | call | 1200.0000 | 2027-06-17 | 175.6500 | 172.3500 | 179.0000 | 952.3100 | 193215.00 | 175650.00 | 17565.00 | 11 | 11 | 40 | 1328 | 0.0301204819277108 | 0.713928090747071 | 0.711152320466505 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 082d07ad-34ad-47b2-a147-016a7dc4996c | 2026-08-20 09:30 | 2026-08-20 09:30 | 2026-08-20 09:30 | MU | MU270617C01200000 | call | 1200.0000 | 2027-06-17 | 169.7500 | 165.2000 | 173.5000 | 941.3300 | 882695.00 | 67940.00 | 271425.00 | 52 | 51 | 52 | 1353 | 0.0384331116038433 | 0.711698386226356 | 0.71111192153475 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6421bb64-e4aa-4193-a089-33309bca6ef0 | 2026-09-04 12:30 | 2026-09-04 12:30 | 2026-09-04 12:30 | MU | MU270617C01200000 | call | 1200.0000 | 2027-06-17 | 172.9300 | 168.2000 | 173.2000 | 1006.8261 | 570665.00 | 518805.00 | 34565.00 | 33 | 8 | 51 | 1625 | 0.0313846153846154 | 0.647920765069405 | 0.647757500434898 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b15f0eb5-dd6c-4e35-bf89-53ceabda8b75 | 2026-09-11 12:04 | 2026-09-11 12:04 | 2026-09-11 12:04 | MU | MU270617C01200000 | call | 1200.0000 | 2027-06-17 | 152.8000 | 152.2000 | 155.0000 | 977.4900 | 3575530.00 | 15285.00 | 3560245.00 | 234 | 7 | 422 | 1794 | 0.235228539576366 | 0.63516475594209 | 0.635220751331032 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | 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 |
| 3e83cdd0-ff56-4b5b-ad7c-517249a5bf59 | 2026-09-11 12:04 | 2026-09-11 12:04 | 2026-09-11 12:04 | MU | MU270617C01200000 | call | 1200.0000 | 2027-06-17 | 152.7500 | 151.9000 | 155.0000 | 977.1100 | 473530.00 | 15280.00 | 458250.00 | 31 | 9 | 482 | 1794 | 0.268673355629877 | 0.635213052812894 | 0.635617063246916 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | 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 |