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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4cfa7803-d500-4e59-bb62-400254690b32 | 2026-08-17 10:45 | 2026-08-17 10:45 | 2026-08-17 10:45 | IREN | IREN280915C00080000 | call | 80.0000 | 2028-09-15 | 16.6000 | 16.5500 | 17.8500 | 44.5700 | 1245000.00 | 0.00 | 1245000.00 | 750 | 1 | 751 | 1982 | 0.37891019172553 | 0.92866610926236 | 0.92866610926236 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Financial Services | 17011511834.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 47d53aca-1779-4ed0-9c06-d80051dfa3e9 | 2026-08-20 12:46 | 2026-08-20 12:46 | 2026-08-20 12:46 | IREN | IREN260828C00040000 | call | 40.0000 | 2026-08-28 | 3.9000 | 3.8500 | 4.0000 | 41.7800 | 382200.00 | 0.00 | 382200.00 | 980 | 1 | 2388 | 2568 | 0.929906542056075 | 1.20468217880045 | 1.20468217880045 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Financial Services | 17011511834.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e071022f-12b5-486a-8ce1-cfe6e2a78e72 | 2026-08-26 12:05 | 2026-08-26 12:05 | 2026-08-26 12:05 | IREN | IREN270219C00060000 | call | 60.0000 | 2027-02-19 | 5.3800 | 5.2500 | 5.5000 | 39.9250 | 1612500.00 | 807000.00 | 805500.00 | 3000 | 4 | 4286 | 859 | 4.9895227008149 | 0.951142359915296 | 0.951142359915296 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Financial Services | 17011511834.00 | 2026-11-05 | unknown | — | 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 |
| 6b96ca78-a430-4361-b646-463ceeea3e28 | 2026-08-28 13:24 | 2026-08-28 13:23 | 2026-08-28 13:23 | IREN | IREN270617P00015000 | put | 15.0000 | 2027-06-17 | 1.3800 | 1.1100 | 1.3900 | 35.0101 | 1380000.00 | 1380000.00 | 0.00 | 10000 | 16 | 10009 | 299 | 33.4749163879599 | 0.942075671544541 | 0.942075671544541 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Financial Services | 17011511834.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T17:47:47.104019Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 85ae2f11-29d1-48e8-9778-c1aac11454a7 | 2026-08-31 10:35 | 2026-08-31 10:35 | 2026-08-31 10:35 | IREN | IREN261009P00020000 | put | 20.0000 | 2026-10-09 | 0.1600 | 0.0000 | 0.3000 | 35.7200 | 20800.00 | 20800.00 | 0.00 | 1300 | 2 | 1300 | 0 | 0 | 1.04370092893956 | 1.04370092893956 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Financial Services | 17011511834.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4565c25d-aa0b-498b-a81c-a485f4f9b46a | 2026-08-31 15:31 | 2026-08-31 15:31 | 2026-08-31 15:31 | IREN | IREN270617P00025000 | put | 25.0000 | 2027-06-17 | 4.4500 | 4.3500 | 4.7500 | 36.4450 | 222500.00 | 0.00 | 222500.00 | 500 | 1 | 610 | 2871 | 0.21246952281435 | 0.894223754047216 | 0.894223754047216 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Financial Services | 17011511834.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| be835ccf-1b1f-46b5-8768-d5f2d8b1e50b | 2026-09-02 09:31 | 2026-09-02 09:31 | 2026-09-02 09:31 | IREN | IREN270115P00040000 | put | 40.0000 | 2027-01-15 | 9.9500 | 9.3500 | 9.9500 | 36.1200 | 199000.00 | 199000.00 | 0.00 | 200 | 1 | 200 | 18167 | 0.0110089723124346 | 0.906692815546011 | 0.906692815546011 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Financial Services | 17011511834.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T13:42:51.501101Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e4071fd1-bea1-4923-b309-014be0b9bd28 | 2026-09-03 15:16 | 2026-09-03 15:16 | 2026-09-03 15:16 | IREN | IREN270319C00050000 | call | 50.0000 | 2027-03-19 | 8.0700 | 7.7000 | 8.1500 | 41.3150 | 443850.00 | 443850.00 | 0.00 | 550 | 2 | 10674 | 610 | 17.4983606557377 | 0.888235912101567 | 0.888235912101567 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Financial Services | 17011511834.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 731b618a-0022-4ee6-97e7-c70400c98975 | 2026-09-04 11:41 | 2026-09-04 11:40 | 2026-09-04 11:40 | IREN | IREN260904C00040000 | call | 40.0000 | 2026-09-04 | 3.4500 | 3.4000 | 3.5000 | 43.4501 | 345000.00 | 0.00 | 0.00 | 1000 | 2 | 4877 | 13339 | 0.365619611665042 | 2.32009409729203 | 2.32009409729203 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Financial Services | 17011511834.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:46:11.944585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cc5fbd5f-aeb4-4a07-a492-f3ac4a6d1d1e | 2026-09-16 12:33 | 2026-09-16 12:33 | 2026-09-16 12:33 | IREN | IREN261218P00045000 | put | 45.0000 | 2026-12-18 | 8.5500 | 8.3500 | 8.6500 | 43.0600 | 1710000.00 | 1710000.00 | 0.00 | 2000 | 2 | 2140 | 3834 | 0.558163797600417 | 0.891739415338624 | 0.891739415338624 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Financial Services | 16794779578.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |