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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0374273c-e3c8-4cfe-ac30-ca2914a86a48 | 2026-08-17 09:42 | 2026-08-17 09:42 | 2026-08-17 09:42 | FIGR | FIGR260828C00034000 | call | 34.0000 | 2026-08-28 | 1.4000 | 0.8500 | 1.6000 | 32.9100 | 27982.00 | 27982.00 | 0.00 | 200 | 10 | 200 | 23 | 8.69565217391304 | 0.807737623989442 | 0.807737623989442 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 46251e93-e0b8-4ecc-8af1-5dec1f4f18f6 | 2026-08-20 10:54 | 2026-08-20 10:54 | 2026-08-20 10:54 | FIGR | FIGR261120P00030000 | put | 30.0000 | 2026-11-20 | 2.6400 | 2.1500 | 3.1000 | 36.8900 | 25855.00 | 1855.00 | 260.00 | 98 | 40 | 98 | 298 | 0.328859060402685 | 0.82706625720459 | 0.844678943396586 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-20T15:02:58.462752Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 18842c1b-7f12-4610-a6ad-fab851fcf840 | 2026-08-21 10:52 | 2026-08-21 10:52 | 2026-08-21 10:52 | FIGR | FIGR260918P00032500 | put | 32.5000 | 2026-09-18 | 0.9100 | 0.8500 | 1.0500 | 38.7800 | 10100.00 | 2810.00 | 360.00 | 111 | 22 | 116 | 52 | 2.23076923076923 | 0.791570193811495 | 0.809400487693814 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-21T15:04:10.571442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3ecb1589-67d1-4151-88ff-3f560a98c0db | 2026-08-21 10:52 | 2026-08-21 10:52 | 2026-08-21 10:52 | FIGR | FIGR260918P00032500 | put | 32.5000 | 2026-09-18 | 0.9200 | 0.8500 | 1.0000 | 38.7250 | 14300.00 | 6650.00 | 3690.00 | 155 | 18 | 367 | 52 | 7.05769230769231 | 0.788077223128234 | 0.805877938328277 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-21T15:04:10.571442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 852ef86b-603e-4ad8-a4eb-cef072f4ce33 | 2026-08-21 14:24 | 2026-08-21 14:24 | 2026-08-21 14:24 | FIGR | FIGR260828C00036000 | call | 36.0000 | 2026-08-28 | 3.9900 | 3.1000 | 4.0000 | 39.0000 | 39911.00 | 39911.00 | 0.00 | 100 | 5 | 113 | 72 | 1.56944444444444 | 1.02774443170376 | 1.0391169725112 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 407934e3-90b3-40db-870a-f65604d50369 | 2026-08-26 15:17 | 2026-08-26 15:17 | 2026-08-26 15:17 | FIGR | FIGR261016C00040000 | call | 40.0000 | 2026-10-16 | 3.5800 | 3.2000 | 4.0000 | 37.6650 | 33990.00 | 0.00 | 33990.00 | 95 | 5 | 123 | 122 | 1.00819672131148 | 0.791466660314868 | 0.791466660314868 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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 |
| 9851d9df-2ad2-49f1-8dbd-496846f8f649 | 2026-08-31 14:30 | 2026-08-31 14:29 | 2026-08-31 14:29 | FIGR | FIGR280121C00095000 | call | 95.0000 | 2028-01-21 | 4.7400 | 4.5000 | 5.0000 | 36.0600 | 14220.00 | 3812.00 | 8508.00 | 30 | 12 | 50 | 34 | 1.47058823529412 | 0.816314175666888 | 0.816314175666888 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-31T19:01:22.528333Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aba2811e-b86d-4a77-8734-7b23dfbf1cb5 | 2026-08-31 14:30 | 2026-08-31 14:30 | 2026-08-31 14:30 | FIGR | FIGR280121C00095000 | call | 95.0000 | 2028-01-21 | 4.8000 | 4.5000 | 4.9000 | 36.0600 | 23998.00 | 23998.00 | 0.00 | 50 | 16 | 100 | 34 | 2.94117647058824 | 0.820240832612352 | 0.820240832612352 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-31T19:01:22.528333Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 97157366-9a94-48b5-85c6-200c3cabea70 | 2026-08-31 14:30 | 2026-08-31 14:30 | 2026-08-31 14:30 | FIGR | FIGR280121C00100000 | call | 100.0000 | 2028-01-21 | 4.4800 | 4.2000 | 4.6000 | 36.0800 | 20142.00 | 20142.00 | 0.00 | 45 | 20 | 46 | 304 | 0.151315789473684 | 0.819612090195799 | 0.819612090195799 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-31T19:01:22.528333Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2bced8e7-9102-4785-ba13-4b014e21c7f7 | 2026-09-03 11:29 | 2026-09-03 11:29 | 2026-09-03 11:29 | FIGR | FIGR280121C00100000 | call | 100.0000 | 2028-01-21 | 4.2700 | 3.8000 | 4.5000 | 36.3200 | 20909.00 | 20909.00 | 0.00 | 49 | 17 | 55 | 362 | 0.151933701657459 | 0.802855998386517 | 0.802855998386517 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-03T15:43:05.796155Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ba450b13-5c1f-4318-a688-dfd5283487af | 2026-09-04 13:49 | 2026-09-04 13:49 | 2026-09-04 13:49 | FIGR | FIGR270115P00030000 | put | 30.0000 | 2027-01-15 | 3.4100 | 3.2000 | 3.6000 | 35.6900 | 17074.00 | 3400.00 | 13674.00 | 50 | 13 | 100 | 2399 | 0.0416840350145894 | 0.768403385045337 | 0.779798579207813 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-04T18:01:17.201510Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ce13e665-d0de-4f4c-aeef-5644f1e90f59 | 2026-09-08 12:41 | 2026-09-08 12:41 | 2026-09-08 12:41 | FIGR | FIGR280121C00095000 | call | 95.0000 | 2028-01-21 | 5.0000 | 4.5000 | 5.2000 | 37.7850 | 11992.00 | 11992.00 | 0.00 | 24 | 5 | 25 | 148 | 0.168918918918919 | 0.80436524748904 | 0.80436524748904 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-08T16:42:24.738421Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 79192a10-3b7b-49da-af07-603d30c78d4f | 2026-09-09 12:07 | 2026-09-09 12:07 | 2026-09-09 12:07 | FIGR | FIGR261120P00027500 | put | 27.5000 | 2026-11-20 | 0.8400 | 0.8000 | 1.4500 | 39.5800 | 25348.00 | 0.00 | 21508.00 | 300 | 11 | 307 | 2265 | 0.135540838852097 | 0.775338732356489 | 0.855279528659149 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-09T16:21:26.040266Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f8fac613-337e-460f-8f64-8160151ead90 | 2026-09-11 09:30 | 2026-09-11 09:30 | 2026-09-11 09:30 | FIGR | FIGR280121C00095000 | call | 95.0000 | 2028-01-21 | 4.7600 | 4.1000 | 5.3000 | 37.0000 | 23301.00 | 23301.00 | 0.00 | 49 | 10 | 49 | 184 | 0.266304347826087 | 0.802328453811493 | 0.802328453811493 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 6619212254.00 | 2026-11-12 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:37:33.609039Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c4596380-b41d-4854-a649-05073a818b1e | 2026-09-16 15:47 | 2026-09-16 15:47 | 2026-09-16 15:47 | FIGR | FIGR280121C00095000 | call | 95.0000 | 2028-01-21 | 3.6000 | 3.0000 | 5.0000 | 33.0000 | 17618.00 | 0.00 | 17618.00 | 49 | 8 | 148 | 283 | 0.522968197879859 | 0.81069526149621 | 0.81069526149621 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 6181025973.00 | 2026-11-12 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 1153e0f5-20a2-49d1-8923-31cade5d63f4 | 2026-09-18 09:31 | 2026-09-18 09:31 | 2026-09-18 09:31 | FIGR | FIGR280121C00100000 | call | 100.0000 | 2028-01-21 | 3.6600 | 3.0000 | 3.8000 | 34.9200 | 25247.00 | 25247.00 | 0.00 | 69 | 9 | 69 | 477 | 0.144654088050314 | 0.801251463587904 | 0.8034758811386 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 6589504710.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:31:27.885359Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 49fa3818-5183-4d3c-96d1-90dad514f355 | 2026-09-18 10:41 | 2026-09-18 10:41 | 2026-09-18 10:41 | FIGR | FIGR261016P00030000 | put | 30.0000 | 2026-10-16 | 0.7700 | 0.7500 | 0.8500 | 35.9700 | 14800.00 | 5680.00 | 7200.00 | 191 | 20 | 258 | 93 | 2.7741935483871 | 0.771691806828095 | 0.791648124590146 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 6589504710.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 321520b1-75d2-4f06-97c7-3158480495d9 | 2026-09-18 10:42 | 2026-09-18 10:41 | 2026-09-18 10:41 | FIGR | FIGR261016P00030000 | put | 30.0000 | 2026-10-16 | 0.7200 | 0.7000 | 0.8000 | 36.2000 | 10560.00 | 900.00 | 5460.00 | 146 | 19 | 442 | 93 | 4.75268817204301 | 0.766452685023014 | 0.786960424632271 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 6589504710.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 8a60bcab-b956-45b5-a06d-2cb823f41c96 | 2026-09-18 10:48 | 2026-09-18 10:48 | 2026-09-18 10:48 | FIGR | FIGR261016C00042500 | call | 42.5000 | 2026-10-16 | 1.0700 | 1.0500 | 1.2000 | 36.0100 | 10045.00 | 3190.00 | 6195.00 | 94 | 22 | 121 | 319 | 0.379310344827586 | 0.762027257998802 | 0.780756782407825 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 6589504710.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| b0face3a-08bf-44ed-99bd-b4eec0fd29c0 | 2026-09-18 10:49 | 2026-09-18 10:48 | 2026-09-18 10:48 | FIGR | FIGR261016C00042500 | call | 42.5000 | 2026-10-16 | 1.0800 | 1.0500 | 1.2500 | 36.0050 | 11795.00 | 660.00 | 4205.00 | 109 | 21 | 230 | 319 | 0.721003134796238 | 0.765604238705213 | 0.781158446975928 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 6589504710.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 82d31d7c-1801-46f6-b371-d52b2b2232a9 | 2026-09-21 10:57 | 2026-09-21 10:57 | 2026-09-21 10:57 | FIGR | FIGR261016P00031000 | put | 31.0000 | 2026-10-16 | 0.8300 | 0.8000 | 0.9000 | 36.0700 | 14935.00 | 2550.00 | 8560.00 | 181 | 25 | 384 | 0 | 0 | 0.746951457603232 | 0.786413206668823 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 6552370279.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 9aac05b9-43a0-4f4d-ba1d-7b179b9db58f | 2026-09-21 10:57 | 2026-09-21 10:57 | 2026-09-21 10:57 | FIGR | FIGR261016P00031000 | put | 31.0000 | 2026-10-16 | 0.8200 | 0.8000 | 0.9500 | 36.0700 | 14650.00 | 2380.00 | 7680.00 | 178 | 24 | 562 | 0 | 0 | 0.747690184999085 | 0.767193445466768 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 6552370279.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |