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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94c870f7-acc2-4a85-b56b-0ccdee8308d4 | 2026-09-17 11:32 | 2026-09-17 11:32 | 2026-09-17 11:32 | FCX | FCX270617C00095000 | call | 95.0000 | 2027-06-17 | 5.7000 | 5.6500 | 5.8500 | 71.3700 | 114042.00 | 43890.00 | 70152.00 | 200 | 6 | 200 | 994 | 0.201207243460765 | 0.488546998838045 | 0.48767142864603 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 101741841505.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 72834500-a4c5-426d-aa93-16f8af4a67d2 | 2026-09-11 15:06 | 2026-09-11 15:06 | 2026-09-11 15:06 | FCX | FCX261016C00072500 | call | 72.5000 | 2026-10-16 | 3.4500 | 3.4500 | 3.5500 | 71.1650 | 289907.00 | 0.00 | 289907.00 | 840 | 37 | 1167 | 190 | 6.14210526315789 | 0.452711100943021 | 0.447020083520124 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 378e684c-6e51-4574-8e18-3179d1f62b8f | 2026-09-10 12:08 | 2026-09-10 12:08 | 2026-09-10 12:08 | FCX | FCX270917C00085000 | call | 85.0000 | 2027-09-17 | 10.1500 | 9.5000 | 10.3000 | 70.8400 | 699064.00 | 616849.00 | 56840.00 | 689 | 30 | 689 | 1955 | 0.352429667519182 | 0.488556094433028 | 0.49330311068309 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fc57d06a-830d-44ee-b35f-21c93812d55f | 2026-09-08 13:12 | 2026-09-08 13:12 | 2026-09-08 13:12 | FCX | FCX261016C00090000 | call | 90.0000 | 2026-10-16 | 1.2800 | 1.2200 | 1.2900 | 76.8700 | 104816.00 | 104816.00 | 0.00 | 817 | 24 | 2304 | 3078 | 0.748538011695906 | 0.510488695826241 | 0.509036088286181 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 763846fc-eca0-4558-939b-52f6f86f6975 | 2026-09-03 13:44 | 2026-09-03 13:44 | 2026-09-03 13:44 | FCX | FCX261016C00070000 | call | 70.0000 | 2026-10-16 | 6.1700 | 6.0000 | 6.2000 | 72.7000 | 61700.00 | 61700.00 | 0.00 | 100 | 8 | 330 | 3072 | 0.107421875 | 0.466023306599477 | 0.458945538610328 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 97a0e406-ada9-4258-8c60-49ad9f2e5ef3 | 2026-08-31 15:22 | 2026-08-31 15:22 | 2026-08-31 15:22 | FCX | FCX261120C00090000 | call | 90.0000 | 2026-11-20 | 2.4500 | 2.4400 | 2.5600 | 75.0900 | 61777.00 | 3222.00 | 57817.00 | 252 | 37 | 10982 | 1835 | 5.98474114441417 | 0.491651119464419 | 0.489056775907781 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | 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 |
| c015967d-12cc-49fa-a900-331755e7893c | 2026-08-31 13:21 | 2026-08-31 13:21 | 2026-08-31 13:21 | FCX | FCX260911C00077000 | call | 77.0000 | 2026-09-11 | 1.9200 | 1.8500 | 1.9700 | 75.6500 | 95908.00 | 78336.00 | 0.00 | 500 | 8 | 1124 | 147 | 7.64625850340136 | 0.473373787928508 | 0.471440353632038 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 37a262fc-0ba5-4ee2-bc42-eee94ccb8b80 | 2026-08-31 10:13 | 2026-08-31 10:13 | 2026-08-31 10:13 | FCX | FCX261016C00075000 | call | 75.0000 | 2026-10-16 | 5.3700 | 5.3500 | 5.7500 | 75.5300 | 107360.00 | 0.00 | 107360.00 | 200 | 5 | 230 | 14333 | 0.0160468848112747 | 0.462270124484936 | 0.462270124484936 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 027c55c5-e954-4be6-8dfd-5edcf1e98b20 | 2026-08-25 13:05 | 2026-08-25 13:05 | 2026-08-25 13:05 | FCX | FCX261218C00085000 | call | 85.0000 | 2026-12-18 | 7.1300 | 7.0500 | 7.3000 | 78.6700 | 71250.00 | 25025.00 | 10725.00 | 100 | 6 | 120 | 2077 | 0.0577756379393356 | 0.527330410314881 | 0.524484615380035 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T17:31:01.749779Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 19f5af3f-33f0-47f6-9563-9b0f6d48473a | 2026-08-25 10:59 | 2026-08-25 10:58 | 2026-08-25 10:58 | FCX | FCX270319P00065000 | put | 65.0000 | 2027-03-19 | 5.1300 | 4.8500 | 5.1500 | 78.6900 | 102550.00 | 102550.00 | 0.00 | 200 | 8 | 323 | 8474 | 0.0381165919282511 | 0.527346181032588 | 0.522329155698555 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5ee9a1a7-858d-4fd9-b969-0698c3c6900e | 2026-08-25 10:57 | 2026-08-25 10:57 | 2026-08-25 10:57 | FCX | FCX270319P00065000 | put | 65.0000 | 2027-03-19 | 5.1600 | 5.0000 | 5.2000 | 78.6600 | 50535.00 | 6760.00 | 32445.00 | 98 | 6 | 123 | 8474 | 0.0145149870191173 | 0.529743079522839 | 0.529743079522839 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e1c7a52a-1138-45e8-b91f-8b8df40ee580 | 2026-08-21 14:39 | 2026-08-21 14:39 | 2026-08-21 14:39 | FCX | FCX261120C00085000 | call | 85.0000 | 2026-11-20 | 5.2900 | 5.2500 | 5.3500 | 76.6495 | 106383.00 | 52420.00 | 15273.00 | 201 | 16 | 681 | 9015 | 0.075540765391015 | 0.535297893586407 | 0.535297893586407 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7de36920-74eb-4ae3-a0e8-ca0877360b37 | 2026-08-21 09:46 | 2026-08-21 09:46 | 2026-08-21 09:46 | FCX | FCX261016C00080000 | call | 80.0000 | 2026-10-16 | 5.1500 | 5.0000 | 5.1500 | 76.3200 | 128725.00 | 128725.00 | 0.00 | 250 | 7 | 3124 | 9044 | 0.345422379478107 | 0.545931809719646 | 0.545931809719646 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c76d92e7-c9e0-40e2-829d-c1d07c98a986 | 2026-08-21 09:33 | 2026-08-21 09:33 | 2026-08-21 09:33 | FCX | FCX260821C00070000 | call | 70.0000 | 2026-08-21 | 5.7500 | 5.6500 | 6.8000 | 75.8000 | 74760.00 | 0.00 | 74760.00 | 130 | 7 | 432 | 17736 | 0.0243572395128552 | 3.88997009188688 | 3.88997009188688 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c1dd2a70-b698-4de4-95b2-85239582c660 | 2026-08-19 13:41 | 2026-08-19 13:41 | 2026-08-19 13:41 | FCX | FCX260925C00073000 | call | 73.0000 | 2026-09-25 | 2.6000 | 2.5700 | 2.7000 | 68.8803 | 72930.00 | 25557.00 | 44773.00 | 281 | 16 | 402 | 15 | 26.8 | 0.472687491035812 | 0.469114719484035 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e1e28f1e-97dc-4a87-9a54-4d922228335b | 2026-08-19 12:35 | 2026-08-19 12:35 | 2026-08-19 12:35 | FCX | FCX261016C00075000 | call | 75.0000 | 2026-10-16 | 3.3000 | 3.2500 | 3.4500 | 69.3800 | 297011.00 | 330.00 | 296681.00 | 900 | 36 | 8335 | 9523 | 0.875249396198677 | 0.484525631634219 | 0.481664171595988 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2fda6629-f105-43fc-a8bb-734b9b5c69bf | 2026-08-19 12:34 | 2026-08-19 12:34 | 2026-08-19 12:34 | FCX | FCX280121P00075000 | put | 75.0000 | 2028-01-21 | 17.5000 | 17.0500 | 17.5000 | 69.4800 | 55992.00 | 55992.00 | 0.00 | 32 | 8 | 33 | 1089 | 0.0303030303030303 | 0.514721569673802 | 0.514721569673802 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 64496266-ad9f-49c3-8172-26035bedd682 | 2026-08-19 10:41 | 2026-08-19 10:40 | 2026-08-19 10:40 | FCX | FCX261016C00075000 | call | 75.0000 | 2026-10-16 | 3.4500 | 3.4000 | 3.5000 | 69.7500 | 192851.00 | 125576.00 | 32775.00 | 559 | 25 | 3309 | 9523 | 0.347474535335504 | 0.482367221722004 | 0.481993999650147 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| df462c2b-3b79-42c5-b326-57e3bf50c9f6 | 2026-08-19 10:40 | 2026-08-19 10:40 | 2026-08-19 10:40 | FCX | FCX261016C00075000 | call | 75.0000 | 2026-10-16 | 3.4000 | 3.2500 | 3.4000 | 69.6800 | 190167.00 | 190167.00 | 0.00 | 560 | 15 | 2281 | 9523 | 0.239525359655571 | 0.481802131117904 | 0.479944143428306 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7189b9f1-398a-4def-88ec-426866fcf315 | 2026-08-19 10:30 | 2026-08-19 10:30 | 2026-08-19 10:30 | FCX | FCX260918P00065000 | put | 65.0000 | 2026-09-18 | 1.9700 | 1.8200 | 1.9700 | 68.5250 | 343361.00 | 341401.00 | 392.00 | 1743 | 59 | 1901 | 6608 | 0.287681598062954 | 0.462705058395699 | 0.462705058395699 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 919669fd-5859-4d67-a65f-0e826feeb976 | 2026-08-17 13:05 | 2026-08-17 13:04 | 2026-08-17 13:04 | FCX | FCX261016C00075000 | call | 75.0000 | 2026-10-16 | 3.1400 | 3.0000 | 3.1500 | 68.7500 | 94300.00 | 94300.00 | 0.00 | 300 | 34 | 4803 | 7105 | 0.676002814919071 | 0.48241482092716 | 0.477920534520329 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| faf98e15-e3cd-4af8-89d3-b41be0ad556d | 2026-08-17 09:33 | 2026-08-17 09:33 | 2026-08-17 09:33 | FCX | FCX281215C00065000 | call | 65.0000 | 2028-12-15 | 22.5000 | 21.6500 | 22.5000 | 67.2600 | 76485.00 | 74240.00 | 2245.00 | 34 | 9 | 34 | 273 | 0.124542124542125 | 0.480909161138452 | 0.479492785339438 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 99573455045.00 | 2026-10-22 | 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 |