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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 04b75028-2b46-4d28-9163-d11a764a3a25 | 2026-08-17 09:39 | 2026-08-17 09:39 | 2026-08-17 09:39 | MMM | MMM261016P00200000 | put | 200.0000 | 2026-10-16 | 18.9500 | 18.9500 | 20.1000 | 182.2750 | 225507.00 | 0.00 | 225507.00 | 119 | 29 | 169 | 224 | 0.754464285714286 | 0.26684001638856 | 0.26684001638856 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 83557346002.00 | 2026-10-20 | 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 |
| d17b6c85-d2d4-4f1c-ae14-9f4cbcd8857c | 2026-08-20 10:01 | 2026-08-20 10:01 | 2026-08-20 10:01 | MMM | MMM260821C00175000 | call | 175.0000 | 2026-08-21 | 6.3100 | 4.7500 | 6.6000 | 180.9100 | 425735.00 | 0.00 | 0.00 | 675 | 16 | 686 | 1816 | 0.377753303964758 | 0.676517355262028 | 0.584616472409524 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 83557346002.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2a004cfb-188b-4d04-af3f-4202c73e10b3 | 2026-08-20 10:43 | 2026-08-20 10:43 | 2026-08-20 10:43 | MMM | MMM270115C00185000 | call | 185.0000 | 2027-01-15 | 10.2000 | 10.1000 | 11.0000 | 180.6000 | 83610.00 | 80560.00 | 3050.00 | 82 | 11 | 747 | 3918 | 0.190658499234303 | 0.23615398524184 | 0.23615398524184 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 83557346002.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 21163cc3-f5a9-4471-824f-a364afe6f395 | 2026-08-20 10:43 | 2026-08-20 10:43 | 2026-08-20 10:43 | MMM | MMM270115C00185000 | call | 185.0000 | 2027-01-15 | 10.0700 | 9.9500 | 10.7500 | 180.5600 | 412970.00 | 70580.00 | 24120.00 | 410 | 29 | 1646 | 3918 | 0.420112302194997 | 0.234416720503956 | 0.235506990852733 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 83557346002.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| add3865b-8ab4-4c90-8702-109ff1dfe95d | 2026-09-03 12:42 | 2026-09-03 12:42 | 2026-09-03 12:42 | MMM | MMM261120C00175000 | call | 175.0000 | 2026-11-20 | 5.7400 | 5.7000 | 5.8000 | 167.5500 | 127525.00 | 112700.00 | 14825.00 | 222 | 33 | 949 | 129 | 7.35658914728682 | 0.266539202923848 | 0.267516065426074 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 83557346002.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 746acdb3-bdce-4836-9e3e-9c582133a1f1 | 2026-09-03 12:46 | 2026-09-03 12:46 | 2026-09-03 12:46 | MMM | MMM261120C00175000 | call | 175.0000 | 2026-11-20 | 5.9600 | 5.8500 | 6.0500 | 167.6800 | 96495.00 | 76020.00 | 20475.00 | 162 | 25 | 1264 | 129 | 9.7984496124031 | 0.269871354049382 | 0.274007113986828 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 83557346002.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |