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.
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
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37740f63-5f6c-42d0-9bf9-8ef32f71492e | 2026-09-01 12:08 | 2026-09-01 12:08 | 2026-09-01 12:08 | RUTW | RUTW260909P02950000 | put | 2950.0000 | 2026-09-09 | 32.8700 | 32.4000 | 33.0000 | 2934.0281 | 295785.00 | 269625.00 | 0.00 | 90 | 6 | 200 | 6 | 33.3333333333333 | 0.146187639050802 | 0.146187639050802 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T16:27:11.873526Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 97c8a146-1292-4879-857c-72555486b32a | 2026-09-11 16:14 | 2026-09-11 16:13 | 2026-09-11 16:13 | RUTW | RUTW260918C02905000 | call | 2905.0000 | 2026-09-18 | 30.3700 | 30.3000 | 30.5000 | 2903.9444 | 100235.00 | 3040.00 | 60715.00 | 33 | 8 | 500 | 6 | 83.3333333333333 | 0.184947634484441 | 0.186007661283786 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f7803eb5-4f0f-4f58-affb-f7732a8927cc | 2026-09-16 12:59 | 2026-09-16 12:58 | 2026-09-16 12:58 | RUTW | RUTW260916P02865000 | put | 2865.0000 | 2026-09-16 | 6.7800 | 6.5000 | 6.8000 | 2885.1406 | 135564.00 | 131574.00 | 0.00 | 200 | 12 | 327 | 159 | 2.05660377358491 | 0.683718362788958 | 0.691902997883306 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| d7f5d30a-3424-4a7d-8929-01dd34fff30d | 2026-09-17 13:45 | 2026-09-17 13:45 | 2026-09-17 13:45 | RUTW | RUTW260917P02995000 | put | 2995.0000 | 2026-09-17 | 109.0300 | 108.4000 | 109.1000 | 2885.3944 | 130840.00 | 130840.00 | 0.00 | 12 | 8 | 13 | 4 | 3.25 | 0.29865831713412 | 0.29865831713412 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |