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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d178d876-46b5-45ba-a02c-a8e7d621deaf | 2026-08-17 10:04 | 2026-08-17 10:04 | 2026-08-17 10:04 | TREE | TREE271217C00040000 | call | 40.0000 | 2027-12-17 | 7.5000 | 6.4000 | 9.4000 | 32.0000 | 150000.00 | 0.00 | 150000.00 | 200 | 1 | 200 | 201 | 0.995024875621891 | 0.64714701353236 | 0.64714701353236 | false | true | false | true | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Financial Services | 389738213.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 37158793-c2b5-4b96-a96a-73988882719d | 2026-08-17 12:11 | 2026-08-17 12:11 | 2026-08-17 12:11 | TREE | TREE270115C00035000 | call | 35.0000 | 2027-01-15 | 4.2100 | 3.8000 | 4.7000 | 31.5551 | 210500.00 | 0.00 | 210500.00 | 500 | 3 | 500 | 4 | 125 | 0.658501579325418 | 0.658501579325418 | false | true | true | false | true | FloorTradeSmallCap | f5350e0c-ce0c-4a4d-9480-d500b0bdaf3a | 1 | Common Stock | Financial Services | 389738213.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b83bb62c-e570-4edc-b861-100756196e20 | 2026-08-31 13:12 | 2026-08-31 13:11 | 2026-08-31 13:11 | TREE | TREE270115P00030000 | put | 30.0000 | 2027-01-15 | 5.1000 | 4.7000 | 5.6000 | 27.7100 | 34170.00 | 7140.00 | 23460.00 | 67 | 8 | 125 | 739 | 0.16914749661705 | 0.591373245068277 | 0.591373245068277 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 389738213.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a5594c62-b4c1-4197-ae71-4c43f5981af6 | 2026-08-31 13:12 | 2026-08-31 13:12 | 2026-08-31 13:12 | TREE | TREE270115P00030000 | put | 30.0000 | 2027-01-15 | 5.2000 | 5.1000 | 5.6000 | 27.7300 | 26000.00 | 10400.00 | 10400.00 | 50 | 8 | 175 | 739 | 0.23680649526387 | 0.607598759437099 | 0.607598759437099 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 389738213.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 37f13d46-889a-4113-977f-658a4b353a38 | 2026-09-15 13:25 | 2026-09-15 13:25 | 2026-09-15 13:25 | TREE | TREE271217C00040000 | call | 40.0000 | 2027-12-17 | 4.7000 | 3.9000 | 4.9000 | 26.5150 | 11750.00 | 11750.00 | 0.00 | 25 | 6 | 50 | 178 | 0.280898876404494 | 0.665876586855175 | 0.665876586855175 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 389738213.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T17:45:33.615815Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |