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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a01d68b4-3406-4ccf-aab6-ade215c8c8b2 | 2026-09-18 15:10 | 2026-09-18 15:10 | 2026-09-18 15:10 | CORZ | CORZ261002C00018500 | call | 18.5000 | 2026-10-02 | 0.5900 | 0.5500 | 0.6100 | 17.6300 | 112100.00 | 112100.00 | 0.00 | 1900 | 2 | 2002 | 35 | 57.2 | 0.676061676268838 | 0.676061676268838 | false | true | true | false | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 2 | Common Stock | Technology | 5780914534.00 | 2026-10-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| d0b77d65-f2ae-470d-9eb3-acf497f10032 | 2026-09-09 09:56 | 2026-09-09 09:56 | 2026-09-09 09:56 | CORZ | CORZ270115C00027000 | call | 27.0000 | 2027-01-15 | 1.4000 | 1.3300 | 1.5800 | 18.6900 | 175000.00 | 0.00 | 175000.00 | 1250 | 2 | 3750 | 3229 | 1.16135026323939 | 0.807368265728681 | 0.807368265728681 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Technology | 5449933879.00 | 2026-10-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 529201a0-5656-4569-aa59-be9638950fe2 | 2026-09-08 15:10 | 2026-09-08 15:10 | 2026-09-08 15:10 | CORZ | CORZ270115C00020000 | call | 20.0000 | 2027-01-15 | 3.2200 | 3.1500 | 3.3000 | 18.8600 | 322000.00 | 0.00 | 322000.00 | 1000 | 3 | 1100 | 14558 | 0.0755598296469295 | 0.801992927935608 | 0.801992927935608 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 2 | Common Stock | Technology | 5449933879.00 | 2026-10-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 74a73122-effb-4706-a8b4-ef5da2518c96 | 2026-09-02 14:50 | 2026-09-02 14:50 | 2026-09-02 14:50 | CORZ | CORZ261218C00021000 | call | 21.0000 | 2026-12-18 | 1.4200 | 1.3800 | 1.4200 | 16.6600 | 497000.00 | 497000.00 | 0.00 | 3500 | 1 | 3583 | 3186 | 1.12460765850596 | 0.760471594773881 | 0.760471594773881 | false | true | false | true | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Technology | 5449933879.00 | 2026-10-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:08:56.003529Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 450f5dfd-939a-4f07-85e3-7eaf1c7676bd | 2026-09-01 12:25 | 2026-09-01 12:25 | 2026-09-01 12:25 | CORZ | CORZ261218C00020000 | call | 20.0000 | 2026-12-18 | 1.4700 | 1.4100 | 1.5400 | 16.1650 | 441000.00 | 0.00 | 441000.00 | 3000 | 1 | 3004 | 2633 | 1.14090391188758 | 0.758088798410041 | 0.758088798410041 | false | true | false | true | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Technology | 5449933879.00 | 2026-10-23 | unknown | — | 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 |
| 74f257bd-e704-4080-aa62-613ddcac361f | 2026-08-28 14:45 | 2026-08-28 14:44 | 2026-08-28 14:44 | CORZ | CORZ260918C00027000 | call | 27.0000 | 2026-09-18 | 0.0300 | 0.0100 | 0.0400 | 16.2850 | 30000.00 | 30000.00 | 0.00 | 10000 | 1 | 10006 | 56171 | 0.178134624628367 | 0.988681851513009 | 0.988681851513009 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Technology | 5449933879.00 | 2026-10-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |