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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d8850836-0dcd-41e5-aec0-5ad61264ab2b | 2026-09-14 15:14 | 2026-09-14 15:14 | 2026-09-14 15:14 | FAS | FAS260918P00181000 | put | 181.0000 | 2026-09-18 | 10.6000 | 10.2000 | 12.1000 | 170.9100 | 10600.00 | 0.00 | 10600.00 | 10 | 6 | 10 | 3 | 3.33333333333333 | 0.484527533559729 | 0.484527533559729 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2225924350.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3ec6f3f6-b53d-4b87-8505-32b45677708a | 2026-09-15 10:44 | 2026-09-15 10:44 | 2026-09-15 10:44 | FAS | FAS261002P00160000 | put | 160.0000 | 2026-10-02 | 2.3600 | 2.3500 | 3.9000 | 168.2000 | 23605.00 | 1960.00 | 21645.00 | 100 | 6 | 201 | 31 | 6.48387096774194 | 0.397075295292049 | 0.405558745712379 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 2202629644.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 470d7e04-0cc5-4a6e-8c04-a27e1dbb2024 | 2026-09-15 14:56 | 2026-09-15 14:56 | 2026-09-15 14:56 | FAS | FAS261002C00161000 | call | 161.0000 | 2026-10-02 | 12.0000 | 9.9000 | 12.0000 | 169.3400 | 12000.00 | 12000.00 | 0.00 | 10 | 5 | 10 | 0 | 0 | 0.481170075879519 | 0.481170075879519 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2202629644.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| c29d6f9d-9c66-4138-9d33-df20ed196fc8 | 2026-09-15 15:05 | 2026-09-15 15:05 | 2026-09-15 15:05 | FAS | FAS261030C00170000 | call | 170.0000 | 2026-10-30 | 11.7000 | 10.7000 | 12.6000 | 170.4400 | 10530.00 | 10530.00 | 0.00 | 9 | 8 | 9 | 0 | 0 | 0.46483570131552 | 0.46483570131552 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2202629644.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| f6989b2f-f098-465c-b2cb-923b49733e74 | 2026-09-16 10:38 | 2026-09-16 10:37 | 2026-09-16 10:37 | FAS | FAS260918P00177000 | put | 177.0000 | 2026-09-18 | 9.5000 | 9.5000 | 11.9000 | 167.5017 | 11400.00 | 0.00 | 11400.00 | 12 | 9 | 12 | 2 | 6 | 0.37060644203395 | 0.37060644203395 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2178183002.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 4e787d45-f773-425d-91ac-6fd12280ecaa | 2026-09-16 15:37 | 2026-09-16 15:37 | 2026-09-16 15:37 | FAS | FAS261009C00179000 | call | 179.0000 | 2026-10-09 | 1.9000 | 1.9000 | 3.7000 | 159.1200 | 12720.00 | 0.00 | 12720.00 | 67 | 17 | 67 | 0 | 0 | 0.48606626455492 | 0.48606626455492 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2178183002.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 238788ae-8b01-41bf-b7d9-83331d89a2ab | 2026-09-16 15:37 | 2026-09-16 15:37 | 2026-09-16 15:37 | FAS | FAS261009C00177500 | call | 177.5000 | 2026-10-09 | 2.1000 | 2.1000 | 3.8000 | 159.1200 | 12180.00 | 0.00 | 12180.00 | 58 | 13 | 58 | 12 | 4.83333333333333 | 0.481848906232248 | 0.481848906232248 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2178183002.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 3a25374e-5213-4b96-92f8-ad19408de38b | 2026-09-16 15:49 | 2026-09-16 15:48 | 2026-09-16 15:48 | FAS | FAS260918P00169000 | put | 169.0000 | 2026-09-18 | 9.1000 | 9.1000 | 11.3000 | 160.0000 | 27300.00 | 0.00 | 27300.00 | 30 | 8 | 30 | 17 | 1.76470588235294 | 0.685133809106119 | 0.685133809106119 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2178183002.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 8af096f4-9313-4d6a-8af0-e384344ec764 | 2026-09-17 09:38 | 2026-09-17 09:38 | 2026-09-17 09:38 | FAS | FAS260918C00162000 | call | 162.0000 | 2026-09-18 | 2.7500 | 2.7500 | 5.4000 | 162.8200 | 20350.00 | 0.00 | 20350.00 | 74 | 10 | 74 | 5 | 14.8 | 0.680345141979779 | 0.680345141979779 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2071564925.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 30f81ea7-c098-4849-837e-f664087957d7 | 2026-09-17 10:14 | 2026-09-17 10:14 | 2026-09-17 10:14 | FAS | FAS261023P00182500 | put | 182.5000 | 2026-10-23 | 24.9000 | 24.9000 | 27.1000 | 159.7900 | 47310.00 | 0.00 | 34860.00 | 19 | 5 | 20 | 5 | 4 | 0.488443210472006 | 0.488443210472006 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2071564925.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 12ac6222-c827-4b4c-a086-6ba2b6895c9f | 2026-09-17 10:14 | 2026-09-17 10:14 | 2026-09-17 10:14 | FAS | FAS261023P00182000 | put | 182.0000 | 2026-10-23 | 24.5000 | 24.0000 | 26.6000 | 159.7900 | 117610.00 | 4910.00 | 112700.00 | 48 | 16 | 49 | 5 | 9.8 | 0.48892958951483 | 0.48892958951483 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2071564925.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 6b6454d3-13e5-4a63-af91-35bdb39d9416 | 2026-09-17 10:22 | 2026-09-17 10:22 | 2026-09-17 10:22 | FAS | FAS261016C00150000 | call | 150.0000 | 2026-10-16 | 15.1000 | 13.2000 | 15.1000 | 160.6800 | 21140.00 | 21140.00 | 0.00 | 14 | 8 | 15 | 33 | 0.454545454545455 | 0.480408571169774 | 0.480408571169774 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2071564925.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| e07a0619-99ec-444b-935b-e295f87e6c4f | 2026-09-18 14:42 | 2026-09-18 14:42 | 2026-09-18 14:42 | FAS | FAS261120P00156000 | put | 156.0000 | 2026-11-20 | 9.5000 | 9.0000 | 10.3000 | 161.6000 | 150100.00 | 4750.00 | 145350.00 | 158 | 20 | 158 | 0 | 0 | 0.478080618591993 | 0.478080618591993 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2058372709.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 265118a5-d40f-4abf-881c-5c0e93afb556 | 2026-09-21 10:17 | 2026-09-21 10:17 | 2026-09-21 10:17 | FAS | FAS260925C00163000 | call | 163.0000 | 2026-09-25 | 2.8500 | 2.0500 | 2.8500 | 162.5000 | 11394.00 | 11394.00 | 0.00 | 40 | 16 | 40 | 2 | 20 | 0.450306396485417 | 0.450306396485417 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 2057862737.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:18:27.541285Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |