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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5cca0c19-707c-47aa-af4c-4f09dfc204ee | 2026-08-18 10:38 | 2026-08-18 10:38 | 2026-08-18 10:38 | MNST | MNST270617C00050000 | call | 50.0000 | 2027-06-17 | 4.6000 | 4.4000 | 4.7000 | 47.2350 | 230920.00 | 37720.00 | 114540.00 | 502 | 12 | 1003 | 943 | 1.06362672322375 | 0.297104199901674 | 0.297104199901674 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 86590087969.00 | 2026-11-05 | 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 |
| a6e7b62d-3127-4d5a-b86a-e057df724442 | 2026-08-21 11:19 | 2026-08-21 11:19 | 2026-08-21 11:19 | MNST | MNST270319C00048750 | call | 48.7500 | 2027-03-19 | 4.1000 | 3.6000 | 4.1000 | 47.7000 | 107420.00 | 107420.00 | 0.00 | 262 | 24 | 262 | 127 | 2.06299212598425 | 0.282799553633818 | 0.282799553633818 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 86590087969.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d1bf61df-0c1c-48f7-bbe0-5be47653b58e | 2026-09-01 13:55 | 2026-09-01 13:55 | 2026-09-01 13:55 | MNST | MNST270115P00045000 | put | 45.0000 | 2027-01-15 | 2.6400 | 2.6000 | 2.6500 | 45.1150 | 72887.00 | 60927.00 | 11960.00 | 276 | 33 | 284 | 495 | 0.573737373737374 | 0.277948059338357 | 0.277948059338357 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 86590087969.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:15:43.135015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a959ca7e-e167-4845-9fe5-b55af881c0ab | 2026-09-02 15:10 | 2026-09-02 15:10 | 2026-09-02 15:10 | MNST | MNST260918P00043750 | put | 43.7500 | 2026-09-18 | 0.6500 | 0.6000 | 0.8500 | 44.0800 | 96626.00 | 96561.00 | 65.00 | 1487 | 48 | 1723 | 1665 | 1.03483483483483 | 0.233960700678316 | 0.228243816161076 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 86590087969.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9633e897-2594-4c07-8589-11c06c47ccfa | 2026-09-09 10:24 | 2026-09-09 10:24 | 2026-09-09 10:24 | MNST | MNST261218C00045000 | call | 45.0000 | 2026-12-18 | 1.7500 | 1.6500 | 1.8500 | 42.0000 | 56350.00 | 56175.00 | 175.00 | 322 | 13 | 322 | 596 | 0.540268456375839 | 0.293926835561038 | 0.294162996242361 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 86590087969.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2ba4ffcb-13a6-4d1e-b8d8-b9131caa6b82 | 2026-09-15 12:17 | 2026-09-15 12:16 | 2026-09-15 12:16 | MNST | MNST261218C00042500 | call | 42.5000 | 2026-12-18 | 3.9000 | 3.9000 | 4.3000 | 44.3250 | 62400.00 | 0.00 | 62400.00 | 160 | 17 | 171 | 427 | 0.400468384074941 | 0.298033238421765 | 0.298033238421765 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 86590087969.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 8f0efbea-5cab-4529-8a37-4c52f619f0b9 | 2026-09-18 11:12 | 2026-09-18 11:12 | 2026-09-18 11:12 | MNST | MNST261120C00050000 | call | 50.0000 | 2026-11-20 | 0.7000 | 0.7000 | 0.7500 | 44.8500 | 53340.00 | 0.00 | 53340.00 | 762 | 29 | 766 | 0 | 0 | 0.30221260092842 | 0.30221260092842 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 87589204368.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |