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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19896702-a68d-45a9-a1ba-0205b7fb9b76 | 2026-09-21 14:47 | 2026-09-21 14:47 | 2026-09-21 14:47 | FIGR | FIGR261023C00038000 | call | 38.0000 | 2026-10-23 | 2.2900 | 2.2000 | 2.4000 | 35.0000 | 11456.00 | 464.00 | 10992.00 | 50 | 6 | 50 | 3 | 16.6666666666667 | 0.764132856060011 | 0.756922850566894 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6552370279.00 | 2026-11-12 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:50:33.734980Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 3ff9d53a-ba7a-4a34-bb06-f88773a68109 | 2026-09-16 10:07 | 2026-09-16 10:07 | 2026-09-16 10:07 | FIGR | FIGR270115C00055000 | call | 55.0000 | 2027-01-15 | 1.5400 | 1.2000 | 1.5500 | 33.1250 | 77150.00 | 63975.00 | 0.00 | 500 | 11 | 1400 | 1760 | 0.795454545454545 | 0.8288803291683 | 0.821250050040327 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6181025973.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 9b996a70-1362-4d42-9d2a-382faae1b640 | 2026-09-04 11:57 | 2026-09-04 11:57 | 2026-09-04 11:57 | FIGR | FIGR280121C00095000 | call | 95.0000 | 2028-01-21 | 4.2100 | 3.8000 | 4.6000 | 35.7650 | 18504.00 | 5076.00 | 3348.00 | 44 | 11 | 44 | 161 | 0.273291925465839 | 0.793798975065364 | 0.793798975065364 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:13:56.145626Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 40578757-d859-40bc-a2bb-7eed8e51cee5 | 2026-09-03 09:45 | 2026-09-03 09:45 | 2026-09-03 09:45 | FIGR | FIGR260904C00035000 | call | 35.0000 | 2026-09-04 | 1.0200 | 0.7000 | 1.3500 | 35.4000 | 124770.00 | 49400.00 | 73370.00 | 1220 | 19 | 1225 | 248 | 4.93951612903226 | 1.16136358891789 | 1.0636032922262 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 526da02e-55c8-4202-a472-4b406aa793da | 2026-09-01 13:50 | 2026-09-01 13:50 | 2026-09-01 13:50 | FIGR | FIGR280121C00100000 | call | 100.0000 | 2028-01-21 | 3.9400 | 3.6000 | 4.8000 | 35.1750 | 37030.00 | 0.00 | 37030.00 | 94 | 6 | 94 | 358 | 0.262569832402235 | 0.806594839930585 | 0.806594839930585 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:15:43.135015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8257d3c3-3fef-463a-b56d-6350cd0a724f | 2026-09-01 13:50 | 2026-09-01 13:50 | 2026-09-01 13:50 | FIGR | FIGR280121C00095000 | call | 95.0000 | 2028-01-21 | 4.2600 | 4.0000 | 5.2000 | 35.1800 | 42169.00 | 0.00 | 42169.00 | 99 | 6 | 99 | 134 | 0.738805970149254 | 0.806192312360044 | 0.806192312360044 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:15:43.135015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a5242a78-a76c-4e54-ac06-59d26e6bbd7a | 2026-08-26 15:16 | 2026-08-26 15:16 | 2026-08-26 15:16 | FIGR | FIGR260918C00035000 | call | 35.0000 | 2026-09-18 | 4.3800 | 4.0000 | 4.9000 | 37.6450 | 41612.00 | 0.00 | 41612.00 | 95 | 10 | 98 | 1652 | 0.0593220338983051 | 0.780206072305097 | 0.780206072305097 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f9eb7995-6c62-4d69-acaa-320c6d3a2cad | 2026-08-26 11:42 | 2026-08-26 11:42 | 2026-08-26 11:42 | FIGR | FIGR270219C00040000 | call | 40.0000 | 2027-02-19 | 7.5400 | 7.4000 | 7.7000 | 37.1800 | 15088.00 | 0.00 | 6028.00 | 20 | 6 | 21 | 165 | 0.127272727272727 | 0.815617540388915 | 0.815617540388915 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bc604568-90e3-42cc-adf7-d9755bab4744 | 2026-08-26 09:36 | 2026-08-26 09:36 | 2026-08-26 09:36 | FIGR | FIGR261120P00035000 | put | 35.0000 | 2026-11-20 | 4.0100 | 3.4000 | 4.5000 | 38.9750 | 20042.00 | 20042.00 | 0.00 | 50 | 7 | 151 | 60 | 2.51666666666667 | 0.836739364340824 | 0.836739364340824 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e0c9f922-a30d-40f4-92e9-84236cf3050f | 2026-08-26 09:30 | 2026-08-26 09:30 | 2026-08-26 09:30 | FIGR | FIGR261120P00035000 | put | 35.0000 | 2026-11-20 | 3.9000 | 3.6000 | 4.0000 | 40.2500 | 19496.00 | 19496.00 | 0.00 | 50 | 8 | 50 | 60 | 0.833333333333333 | 0.877396627175242 | 0.877396627175242 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2dc7faab-0438-4714-9021-748d7e4d864a | 2026-08-24 10:46 | 2026-08-24 10:46 | 2026-08-24 10:46 | FIGR | FIGR261120C00055000 | call | 55.0000 | 2026-11-20 | 2.2700 | 2.1000 | 2.4000 | 39.2489 | 39905.00 | 8510.00 | 31395.00 | 176 | 24 | 276 | 575 | 0.48 | 0.842655598992821 | 0.834913064617389 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 26a6e8ab-f22b-40a1-9481-504ef17f3e93 | 2026-08-19 13:09 | 2026-08-19 13:09 | 2026-08-19 13:09 | FIGR | FIGR260918C00032500 | call | 32.5000 | 2026-09-18 | 6.3600 | 5.8000 | 6.4000 | 37.0250 | 63560.00 | 56960.00 | 6600.00 | 100 | 8 | 303 | 287 | 1.05574912891986 | 0.917704948654658 | 0.799780416056367 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a3b3e842-5a43-4659-bf25-b519af9d42eb | 2026-08-17 12:49 | 2026-08-17 12:49 | 2026-08-17 12:49 | FIGR | FIGR260918P00035000 | put | 35.0000 | 2026-09-18 | 3.2000 | 2.8000 | 3.2000 | 35.0800 | 828460.00 | 828460.00 | 0.00 | 2589 | 58 | 2640 | 52 | 50.7692307692308 | 0.799854629059354 | 0.799854629059354 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 12055dae-4ff8-46b5-ba0b-6323adaf8176 | 2026-08-17 11:13 | 2026-08-17 11:13 | 2026-08-17 11:13 | FIGR | FIGR260828C00034000 | call | 34.0000 | 2026-08-28 | 1.9000 | 1.7000 | 2.1000 | 33.9005 | 38024.00 | 19482.00 | 14742.00 | 200 | 7 | 1016 | 23 | 44.1739130434783 | 0.826347320446885 | 0.826347320446885 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |