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
active:ticker = MELI×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0b42a604-abbc-454a-b747-0974e739bf79 | 2026-08-24 10:29 | 2026-08-24 10:29 | 2026-08-24 10:29 | MELI | MELI270115C02100000 | call | 2100.0000 | 2027-01-15 | 151.0000 | 141.3000 | 160.0000 | 1970.0100 | 241600.00 | 45300.00 | 196300.00 | 16 | 5 | 66 | 67 | 0.985074626865672 | 0.388313506147493 | 0.388313506147493 | 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-08-24T14:35:34.147296Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8bf0efd2-6856-4be1-a568-084fbbe4c64f | 2026-08-24 10:17 | 2026-08-24 10:16 | 2026-08-24 10:16 | MELI | MELI260918C02100000 | call | 2100.0000 | 2026-09-18 | 21.0000 | 16.7000 | 21.0000 | 1953.0300 | 256200.00 | 256200.00 | 0.00 | 122 | 28 | 123 | 218 | 0.564220183486238 | 0.332495492954342 | 0.332495492954342 | 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-08-24T14:21:20.397116Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a6470b47-f18d-4463-bb68-a18af74b8f2c | 2026-08-21 15:02 | 2026-08-21 15:02 | 2026-08-21 15:02 | MELI | MELI261218P01460000 | put | 1460.0000 | 2026-12-18 | 19.8000 | 19.8000 | 23.0000 | 1933.0000 | 99000.00 | 0.00 | 99000.00 | 50 | 15 | 50 | 21 | 2.38095238095238 | 0.411375398687593 | 0.411375398687593 | 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-08-21T19:11:44.414359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a1c6abf0-2529-48ac-bc58-6382921175ad | 2026-08-21 14:10 | 2026-08-21 14:10 | 2026-08-21 14:10 | MELI | MELI260911C01950000 | call | 1950.0000 | 2026-09-11 | 53.7000 | 53.7000 | 60.0000 | 1930.0000 | 134250.00 | 0.00 | 134250.00 | 25 | 8 | 48 | 15 | 3.2 | 0.31074633585106 | 0.314426030148923 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 96336091032.00 | 2026-11-04 | 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 |
| b5c2d4a9-52e2-4e27-ac13-96cbda1760d5 | 2026-08-21 10:25 | 2026-08-21 10:25 | 2026-08-21 10:25 | MELI | MELI260828C01945000 | call | 1945.0000 | 2026-08-28 | 37.0000 | 32.3000 | 42.5000 | 1945.3000 | 118400.00 | 0.00 | 118400.00 | 32 | 7 | 34 | 5 | 6.8 | 0.336403343415179 | 0.336403343415179 | true | 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-08-21T14:36:46.143381Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ab2121e7-7a12-41d1-89a7-ebc49513b3a4 | 2026-08-21 09:49 | 2026-08-21 09:49 | 2026-08-21 09:49 | MELI | MELI261002P02090000 | put | 2090.0000 | 2026-10-02 | 170.9000 | 161.0000 | 186.2000 | 1946.7000 | 239260.00 | 120200.00 | 119060.00 | 14 | 7 | 22 | 0 | 0 | 0.321649056794965 | 0.325815082969784 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 96336091032.00 | 2026-11-04 | 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 |
| 652d573b-03dd-4489-9343-43564fc664bc | 2026-08-21 09:45 | 2026-08-21 09:45 | 2026-08-21 09:45 | MELI | MELI260828P01825000 | put | 1825.0000 | 2026-08-28 | 5.5700 | 4.1000 | 5.6000 | 1936.2150 | 67990.00 | 66400.00 | 1590.00 | 122 | 12 | 132 | 6 | 22 | 0.361145505779618 | 0.359164407380517 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 96336091032.00 | 2026-11-04 | 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 |
| fed27c4e-4f15-4a92-a728-1277abc43495 | 2026-08-20 15:35 | 2026-08-20 15:35 | 2026-08-20 15:35 | MELI | MELI261016C01720000 | call | 1720.0000 | 2026-10-16 | 244.5000 | 224.0000 | 249.5000 | 1922.7300 | 244500.00 | 244500.00 | 0.00 | 10 | 6 | 10 | 29 | 0.344827586206897 | 0.374774385656438 | 0.36952428526955 | 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-08-20T19:42:29.270849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d1e53b08-f0ee-4b16-971c-24881d20c08b | 2026-08-20 09:59 | 2026-08-20 09:59 | 2026-08-20 09:59 | MELI | MELI261218P01770000 | put | 1770.0000 | 2026-12-18 | 100.2000 | 98.2000 | 107.7000 | 1904.0401 | 90180.00 | 60270.00 | 29910.00 | 9 | 5 | 24 | 4 | 6 | 0.402032536411342 | 0.400739578391861 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 96336091032.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 02e0a504-1138-445d-99c8-0d45893fa9f8 | 2026-08-20 09:56 | 2026-08-20 09:56 | 2026-08-20 09:56 | MELI | MELI270115C02460000 | call | 2460.0000 | 2027-01-15 | 39.4600 | 36.1000 | 47.6000 | 1897.9300 | 63130.00 | 23910.00 | 39220.00 | 16 | 7 | 17 | 34 | 0.5 | 0.367751897782852 | 0.371853614377826 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 96336091032.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 39c118a5-cae6-4f39-a297-78f590c04aff | 2026-08-20 09:52 | 2026-08-20 09:52 | 2026-08-20 09:52 | MELI | MELI260911C01900000 | call | 1900.0000 | 2026-09-11 | 71.0400 | 65.2000 | 81.8000 | 1905.9700 | 78140.00 | 7120.00 | 71020.00 | 11 | 7 | 12 | 17 | 0.705882352941177 | 0.354250691268206 | 0.354250691268206 | true | 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-08-20T13:54:26.267880Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1f565f8e-55ee-4f58-a0f9-367fadcd9bb9 | 2026-08-19 12:22 | 2026-08-19 12:22 | 2026-08-19 12:22 | MELI | MELI260828C02020000 | call | 2020.0000 | 2026-08-28 | 4.6000 | 0.0500 | 4.6000 | 1889.4250 | 93838.00 | 93838.00 | 0.00 | 204 | 31 | 204 | 12 | 17 | 0.324586358218877 | 0.324586358218877 | 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-08-19T16:28:32.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dc0db1f6-20f6-4bca-9d6b-64d6210c0de2 | 2026-08-18 10:33 | 2026-08-18 10:33 | 2026-08-18 10:33 | MELI | MELI280121P01180000 | put | 1180.0000 | 2028-01-21 | 66.8500 | 52.3000 | 83.9000 | 1798.8363 | 73530.00 | 6770.00 | 66760.00 | 11 | 5 | 11 | 6 | 1.83333333333333 | 0.432269865790026 | 0.432743438410864 | 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-08-18T14:49:07.673043Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 157bd081-f06e-45ee-b56d-28a2173a2330 | 2026-08-18 10:32 | 2026-08-18 10:31 | 2026-08-18 10:31 | MELI | MELI260821P01775000 | put | 1775.0000 | 2026-08-21 | 16.3000 | 16.3000 | 19.9000 | 1797.7450 | 114100.00 | 0.00 | 114100.00 | 70 | 5 | 70 | 142 | 0.492957746478873 | 0.407539326221698 | 0.407539326221698 | 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-08-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3a44c255-4ea4-4db8-ae96-8ab9de8f8458 | 2026-08-18 10:27 | 2026-08-18 10:27 | 2026-08-18 10:27 | MELI | MELI260821P01975000 | put | 1975.0000 | 2026-08-21 | 181.9000 | 179.1000 | 183.8000 | 1793.5050 | 436560.00 | 436560.00 | 0.00 | 24 | 24 | 25 | 0 | 0 | 0.554964377493579 | 0.554964377493579 | 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-08-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b022e0b1-b8bb-4e68-915f-ad12844497ba | 2026-08-17 15:17 | 2026-08-17 15:17 | 2026-08-17 15:17 | MELI | MELI261016C01900000 | call | 1900.0000 | 2026-10-16 | 58.3000 | 58.3000 | 61.7000 | 1785.7700 | 291500.00 | 0.00 | 291500.00 | 50 | 9 | 58 | 121 | 0.479338842975207 | 0.341520581967541 | 0.341520581967541 | 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-08-17T19:39:36.389012Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 97ababb4-98e1-4870-bfd6-dcd7d98985ce | 2026-08-17 10:49 | 2026-08-17 10:48 | 2026-08-17 10:48 | MELI | MELI261016P01880000 | put | 1880.0000 | 2026-10-16 | 146.4800 | 144.4000 | 155.2000 | 1786.7600 | 87890.00 | 14650.00 | 73240.00 | 6 | 6 | 7 | 44 | 0.159090909090909 | 0.339222967588925 | 0.340439911623856 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 96336091032.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bbaa1166-31e5-410c-af6a-5c302df99eca | 2026-08-17 09:38 | 2026-08-17 09:38 | 2026-08-17 09:38 | MELI | MELI260821P01700000 | put | 1700.0000 | 2026-08-21 | 3.3000 | 1.9500 | 3.3000 | 1795.7625 | 56427.00 | 56427.00 | 0.00 | 171 | 33 | 171 | 249 | 0.686746987951807 | 0.403249874519386 | 0.403249874519386 | 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-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |