Options 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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 rowsrestricted — hover for the licence
active:alert_rule = RepeatedHitsDescendingFill×option_symbol = SOXL260918P00100000×sorted by created_at ↑×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71c4b662-c640-4c6c-8cb8-2c5881694a1a | 2026-08-14 16:00 | 2026-08-14 15:59 | 2026-08-14 15:59 | SOXL | SOXL260918P00100000 | put | 100.0000 | 2026-09-18 | 4.5000 | 4.5000 | 4.9000 | 144.9700 | 45010.00 | 0.00 | 45010.00 | 100 | 6 | 2435 | 3952 | 0.616143724696356 | 1.30874005465275 | 1.29712404768079 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 17090976068.00 | — | — | — | 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 |
| afecf2e0-1bf5-41c0-84d7-f10748000b95 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | SOXL | SOXL260918P00100000 | put | 100.0000 | 2026-09-18 | 4.1500 | 3.4000 | 4.1500 | 151.1300 | 29041.00 | 28631.00 | 0.00 | 70 | 7 | 76 | 4260 | 0.0178403755868545 | 1.40032796307812 | 1.39448267409953 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 17090976068.00 | — | — | — | 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 |
| ac55895c-b9fd-44db-824a-99112ddb5be2 | 2026-08-26 12:04 | 2026-08-26 12:04 | 2026-08-26 12:04 | SOXL | SOXL260918P00100000 | put | 100.0000 | 2026-09-18 | 7.2000 | 6.9000 | 7.2000 | 115.0600 | 89994.00 | 89994.00 | 0.00 | 125 | 31 | 414 | 6994 | 0.0591935945095796 | 1.26166882500222 | 1.26166882500222 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 17090976068.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 20d98bbc-3733-495f-bcbe-363625b3504c | 2026-08-31 11:37 | 2026-08-31 11:37 | 2026-08-31 11:37 | SOXL | SOXL260918P00100000 | put | 100.0000 | 2026-09-18 | 5.5700 | 5.2500 | 5.7500 | 111.3700 | 25055.00 | 9515.00 | 15540.00 | 45 | 5 | 389 | 7421 | 0.0524188114809325 | 1.13040672612224 | 1.10662328509781 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 17090976068.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6030b5ad-67cd-49b4-9fad-4c41c24c4028 | 2026-09-08 10:55 | 2026-09-08 10:54 | 2026-09-08 10:54 | SOXL | SOXL260918P00100000 | put | 100.0000 | 2026-09-18 | 1.9900 | 1.9800 | 2.0200 | 125.0701 | 20721.00 | 11963.00 | 8360.00 | 104 | 14 | 1080 | 7435 | 0.145258910558171 | 1.33863610930831 | 1.33635402282752 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 17090976068.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 165d9377-119e-48e2-93b1-364cd8b423ba | 2026-09-10 12:11 | 2026-09-10 12:11 | 2026-09-10 12:11 | SOXL | SOXL260918P00100000 | put | 100.0000 | 2026-09-18 | 2.0500 | 2.0500 | 2.0800 | 117.3300 | 26661.00 | 0.00 | 26661.00 | 130 | 8 | 1427 | 8231 | 0.173368970963431 | 1.23687475117493 | 1.23226320449393 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 20605860309.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a23b35c1-8524-413a-a671-56d97ed316e0 | 2026-09-14 15:35 | 2026-09-14 15:35 | 2026-09-14 15:35 | SOXL | SOXL260918P00100000 | put | 100.0000 | 2026-09-18 | 3.7800 | 3.5500 | 3.8000 | 102.7200 | 37768.00 | 37768.00 | 0.00 | 100 | 5 | 6891 | 9475 | 0.727282321899736 | 1.19691582657059 | 1.18721641464235 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 20605860309.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |