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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6ad2d7e1-a505-49b4-af50-6b52c01af3a6 | 2026-09-14 10:51 | 2026-09-14 10:51 | 2026-09-14 10:51 | MELI | MELI270115P01920000 | put | 1920.0000 | 2027-01-15 | 176.9000 | 166.6000 | 176.9000 | 1893.9900 | 1096780.00 | 1096780.00 | 0.00 | 62 | 13 | 64 | 36 | 1.77777777777778 | 0.404811498301041 | 0.404811498301041 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 96336091032.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d4bbe3ca-3909-401c-8a89-f01fb6fa58e0 | 2026-09-14 15:42 | 2026-09-14 15:42 | 2026-09-14 15:42 | MELI | MELI270115C01980000 | call | 1980.0000 | 2027-01-15 | 156.0000 | 145.0000 | 156.0000 | 1898.0200 | 733200.00 | 733200.00 | 0.00 | 47 | 12 | 47 | 79 | 0.594936708860759 | 0.40923713329021 | 0.40923713329021 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 96336091032.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 21baa761-199c-4ac3-bcf0-499520f57c9d | 2026-09-15 14:24 | 2026-09-15 14:24 | 2026-09-15 14:24 | MELI | MELI261002P01910000 | put | 1910.0000 | 2026-10-02 | 90.0000 | 83.6000 | 95.3000 | 1853.7800 | 134993.00 | 134993.00 | 0.00 | 15 | 13 | 15 | 32 | 0.46875 | 0.370119832997334 | 0.370119832997334 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 96336091032.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| a65d05ff-a49b-474e-ab7e-54cf90f64083 | 2026-09-16 12:38 | 2026-09-16 12:38 | 2026-09-16 12:38 | MELI | MELI280121P01000000 | put | 1000.0000 | 2028-01-21 | 30.6500 | 16.0000 | 50.0000 | 1830.5000 | 91950.00 | 0.00 | 91950.00 | 30 | 2 | 30 | 38 | 0.789473684210526 | 0.445196118028171 | 0.445196118028171 | false | true | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 93267413607.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| b69f8f9e-488d-4ac4-b4d2-726cc9414247 | 2026-09-16 12:55 | 2026-09-16 12:55 | 2026-09-16 12:55 | MELI | MELI261120C01840000 | call | 1840.0000 | 2026-11-20 | 135.9000 | 135.9000 | 143.2000 | 1828.5200 | 1032840.00 | 0.00 | 1032840.00 | 76 | 17 | 79 | 8 | 9.875 | 0.439173197434525 | 0.439173197434525 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 93267413607.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 9275c3c3-aea6-46f0-8509-761f4fcd2bf0 | 2026-09-16 14:50 | 2026-09-16 14:50 | 2026-09-16 14:50 | MELI | MELI261002P01870000 | put | 1870.0000 | 2026-10-02 | 69.5000 | 63.2000 | 69.5000 | 1843.0800 | 354449.00 | 354449.00 | 0.00 | 51 | 16 | 51 | 9 | 5.66666666666667 | 0.367119155663127 | 0.367119155663127 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 93267413607.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 4295604b-331e-414d-9724-188489ca0eda | 2026-09-16 14:50 | 2026-09-16 14:50 | 2026-09-16 14:50 | MELI | MELI261002P01800000 | put | 1800.0000 | 2026-10-02 | 36.7000 | 30.5000 | 36.7000 | 1843.0800 | 135790.00 | 135790.00 | 0.00 | 37 | 11 | 39 | 20 | 1.95 | 0.373947950695554 | 0.373947950695554 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 93267413607.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| cd44ff7c-a173-4807-87da-42270ae903a6 | 2026-09-17 10:00 | 2026-09-17 10:00 | 2026-09-17 10:00 | MELI | MELI261023P01820000 | put | 1820.0000 | 2026-10-23 | 76.7900 | 71.8000 | 87.2000 | 1827.3000 | 153580.00 | 7720.00 | 145860.00 | 20 | 10 | 38 | 1 | 38 | 0.365035175481167 | 0.369878905458705 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 92532309978.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| a81bbf02-e06a-41d2-b507-22370843caef | 2026-09-17 14:48 | 2026-09-17 14:48 | 2026-09-17 14:48 | MELI | MELI260918C01760000 | call | 1760.0000 | 2026-09-18 | 61.4000 | 61.4000 | 70.3000 | 1821.3700 | 98241.00 | 0.00 | 98241.00 | 16 | 10 | 16 | 84 | 0.19047619047619 | 0.802216060417284 | 0.802216060417284 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 92532309978.00 | 2026-11-04 | 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 |
| 08b6b24d-316c-452e-88a2-5f8e2ea731d8 | 2026-09-18 13:17 | 2026-09-18 13:17 | 2026-09-18 13:17 | MELI | MELI260918C01820000 | call | 1820.0000 | 2026-09-18 | 2.2500 | 0.0500 | 2.2500 | 1803.7900 | 57145.00 | 57145.00 | 0.00 | 254 | 35 | 920 | 391 | 2.35294117647059 | 0.615082508695022 | 0.615082508695022 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 90614956927.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| cbd55ac7-3d3c-4838-8d95-4e4d26432dde | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | MELI | MELI261016P01750000 | put | 1750.0000 | 2026-10-16 | 53.0000 | 51.0000 | 53.0000 | 1780.0000 | 121900.00 | 121900.00 | 0.00 | 23 | 6 | 45 | 55 | 0.818181818181818 | 0.370478218676987 | 0.370478218676987 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 90614956927.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 713097b7-8770-415c-a7a7-370b4d46e844 | 2026-09-18 15:59 | 2026-09-18 15:59 | 2026-09-18 15:59 | MELI | MELI261016P01640000 | put | 1640.0000 | 2026-10-16 | 20.2800 | 13.9000 | 20.3000 | 1780.0000 | 54760.00 | 54760.00 | 0.00 | 27 | 14 | 56 | 57 | 0.982456140350877 | 0.382046225272079 | 0.382046225272079 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 90614956927.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| d7fcf4c8-9ef0-42d7-a74c-f8f991dba8f5 | 2026-09-21 10:17 | 2026-09-21 10:17 | 2026-09-21 10:17 | MELI | MELI260925C01850000 | call | 1850.0000 | 2026-09-25 | 21.9000 | 17.9000 | 22.0000 | 1827.9450 | 32850.00 | 32850.00 | 0.00 | 15 | 5 | 31 | 38 | 0.815789473684211 | 0.40880493159052 | 0.40880493159052 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 92292007137.00 | 2026-11-04 | unknown | — | 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 |
| d4204667-a821-4066-8d18-7667dac7d137 | 2026-09-21 10:20 | 2026-09-21 10:20 | 2026-09-21 10:20 | MELI | MELI261218C02360000 | call | 2360.0000 | 2026-12-18 | 18.0000 | 12.7000 | 20.0000 | 1828.9100 | 18000.00 | 7200.00 | 1800.00 | 10 | 10 | 10 | 32 | 0.3125 | 0.385598057721823 | 0.385598057721823 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 92292007137.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:20:57.602674Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| be19d372-4411-42ae-972e-d9b9925c74e4 | 2026-09-21 13:24 | 2026-09-21 13:24 | 2026-09-21 13:24 | MELI | MELI260925P01800000 | put | 1800.0000 | 2026-09-25 | 18.0000 | 18.0000 | 21.9000 | 1820.0000 | 36000.00 | 0.00 | 36000.00 | 20 | 6 | 90 | 109 | 0.825688073394495 | 0.40591418059354 | 0.40591418059354 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 92292007137.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:24:56.111062Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| f5793cbd-a4d3-44de-afde-0a72f61d9d6b | 2026-09-21 13:41 | 2026-09-21 13:41 | 2026-09-21 13:41 | MELI | MELI261016C02060000 | call | 2060.0000 | 2026-10-16 | 10.1000 | 8.5000 | 10.1000 | 1826.2775 | 89883.00 | 89883.00 | 0.00 | 89 | 30 | 89 | 67 | 1.32835820895522 | 0.369135445149185 | 0.369135445149185 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 92292007137.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:43:51.748700Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 163b958b-f939-460b-a4ea-ba1112111984 | 2026-09-21 13:55 | 2026-09-21 13:55 | 2026-09-21 13:55 | MELI | MELI261030P01610000 | put | 1610.0000 | 2026-10-30 | 18.6000 | 17.8000 | 21.3000 | 1826.5200 | 16740.00 | 0.00 | 16740.00 | 9 | 6 | 22 | 6 | 3.66666666666667 | 0.399505340511159 | 0.399505340511159 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 92292007137.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:00:14.697100Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| e8522a37-9115-4ea4-93ea-b5b24ca05e82 | 2026-09-21 14:16 | 2026-09-21 14:16 | 2026-09-21 14:16 | MELI | MELI260925C01880000 | call | 1880.0000 | 2026-09-25 | 11.7000 | 8.5000 | 13.5000 | 1828.5075 | 17550.00 | 17550.00 | 0.00 | 15 | 5 | 41 | 335 | 0.122388059701493 | 0.395158167501165 | 0.395158167501165 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 92292007137.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:20:26.028708Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |