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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35a32dc3-5dd8-435d-814f-34b594052b1b | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | FSLR | FSLR261120P00180000 | put | 180.0000 | 2026-11-20 | 7.4100 | 6.4500 | 8.7500 | 225.0900 | 741000.00 | 0.00 | 741000.00 | 1000 | 14 | 2000 | 23 | 86.9565217391304 | 0.586800686387139 | 0.586800686387139 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Technology | 22250544908.00 | 2026-10-29 | unknown | — | 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 |
| f445dbdc-c950-4b61-8a79-5cc9784a4483 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | FSLR | FSLR261120P00195000 | put | 195.0000 | 2026-11-20 | 11.6400 | 10.7000 | 13.4500 | 225.0900 | 582000.00 | 0.00 | 582000.00 | 500 | 16 | 500 | 12 | 41.6666666666667 | 0.576339851921887 | 0.576339851921887 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Technology | 22250544908.00 | 2026-10-29 | unknown | — | 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 |
| 94b4d498-69d3-493c-9464-ead3be6882b2 | 2026-08-26 14:15 | 2026-08-26 14:15 | 2026-08-26 14:15 | FSLR | FSLR270319P00185000 | put | 185.0000 | 2027-03-19 | 21.6000 | 20.2500 | 21.6000 | 204.5500 | 2160000.00 | 2160000.00 | 0.00 | 1000 | 2 | 1000 | 1064 | 0.93984962406015 | 0.561130442325609 | 0.561130442325609 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Technology | 22250544908.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 24b98422-bb37-4830-b905-897f5a22358e | 2026-08-31 09:30 | 2026-08-31 09:30 | 2026-08-31 09:30 | FSLR | FSLR280616C00280000 | call | 280.0000 | 2028-06-16 | 41.2500 | 39.5000 | 43.5500 | 203.4750 | 6187500.00 | 0.00 | 6187500.00 | 1500 | 1 | 1500 | 1021 | 1.46914789422135 | 0.542645347790239 | 0.542645347790239 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 22250544908.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 70dfdfea-f7fa-4894-87f1-4d016e42c66d | 2026-08-31 14:25 | 2026-08-31 14:25 | 2026-08-31 14:25 | FSLR | FSLR270617P00150000 | put | 150.0000 | 2027-06-17 | 11.4500 | 10.2000 | 13.1500 | 202.3500 | 343500.00 | 0.00 | 343500.00 | 300 | 1 | 300 | 86 | 3.48837209302326 | 0.532815625328726 | 0.532815625328726 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 22250544908.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 753de44f-a9a4-419e-a994-7f1bfbc0f6c5 | 2026-09-02 10:29 | 2026-09-02 10:28 | 2026-09-02 10:28 | FSLR | FSLR261016C00220000 | call | 220.0000 | 2026-10-16 | 6.6000 | 6.3500 | 6.8000 | 199.6201 | 532620.00 | 532620.00 | 0.00 | 807 | 1 | 1042 | 2568 | 0.405763239875389 | 0.491852883193823 | 0.491852883193823 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 22250544908.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| df7c04a4-ba86-49fe-9c26-7b0725fc944c | 2026-09-08 09:30 | 2026-09-08 09:30 | 2026-09-08 09:30 | FSLR | FSLR260911C00215000 | call | 215.0000 | 2026-09-11 | 1.6000 | 1.6000 | 2.8000 | 209.8300 | 240000.00 | 0.00 | 240000.00 | 1500 | 1 | 1547 | 227 | 6.81497797356828 | 0.467307601618183 | 0.467307601618183 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 22250544908.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:33:29.575205Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e4961f38-858d-4fea-a644-70b7ab4ee6f3 | 2026-09-14 13:33 | 2026-09-14 13:33 | 2026-09-14 13:33 | FSLR | FSLR290119P00130000 | put | 130.0000 | 2029-01-19 | 16.5000 | 15.9000 | 18.2000 | 208.3500 | 297000.00 | 0.00 | 297000.00 | 180 | 1 | 180 | 0 | 0 | 0.50922007898986 | 0.50922007898986 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 22250544908.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| deac2340-fd68-4e93-b6b4-7c260aa4a9f0 | 2026-09-17 13:28 | 2026-09-17 13:27 | 2026-09-17 13:27 | FSLR | FSLR270617P00200000 | put | 200.0000 | 2027-06-17 | 32.0000 | 31.5000 | 32.7500 | 202.0000 | 960000.00 | 0.00 | 960000.00 | 300 | 1 | 300 | 826 | 0.36319612590799 | 0.522947371808686 | 0.522947371808686 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 21618622554.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 4eda5e91-8376-4fc3-9d2d-202325c1a93e | 2026-09-17 14:51 | 2026-09-17 14:51 | 2026-09-17 14:51 | FSLR | FSLR261023C00175000 | call | 175.0000 | 2026-10-23 | 30.0000 | 29.2500 | 31.7500 | 201.3600 | 150000.00 | 0.00 | 150000.00 | 50 | 1 | 160 | 170 | 0.941176470588235 | 0.509037301297538 | 0.509037301297538 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 21618622554.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |