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.
uw_flow_alerts566,287 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 |
|---|
| 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 |
| c6087500-6830-4aa6-9427-fc04f5c9d61c | 2026-09-10 11:23 | 2026-09-10 11:23 | 2026-09-10 11:23 | MELI | MELI260918C01760000 | call | 1760.0000 | 2026-09-18 | 174.1200 | 161.6000 | 184.1000 | 1927.5700 | 330820.00 | 157020.00 | 173800.00 | 19 | 7 | 34 | 88 | 0.386363636363636 | 0.450931791555234 | 0.450931791555234 | false | false | false | |||||||||||||||||
| 11eefd60-5994-42f8-b801-21621950a637 | 2026-09-08 11:34 | 2026-09-08 11:34 | 2026-09-08 11:34 | MELI | MELI261016P02140000 | put | 2140.0000 | 2026-10-16 | 229.1900 | 217.1000 | 236.3000 | 1928.2950 | 275029.00 | 160439.00 | 114590.00 | 12 | 5 | 17 | 4 | 4.25 | 0.364113377678675 | 0.364664961039922 | false | false | false | |||||||||||||||||
| cf86e285-858e-4250-a0ff-382f05da23e9 | 2026-09-03 09:51 | 2026-09-03 09:51 | 2026-09-03 09:51 | MELI | MELI270115C02000000 | call | 2000.0000 | 2027-01-15 | 234.6900 | 234.6000 | 234.7000 | 2048.5200 | 445910.00 | 23470.00 | 0.00 | 19 | 19 | 19 | 217 | 0.0875576036866359 | 0.398897866464005 | 0.399107935506786 | false | false | false | |||||||||||||||||
| 85182c01-efa3-4c09-b4a8-ece092338257 | 2026-08-31 09:44 | 2026-08-31 09:44 | 2026-08-31 09:44 | MELI | MELI261009P02070000 | put | 2070.0000 | 2026-10-09 | 171.7700 | 162.2000 | 184.6000 | 1930.1250 | 171770.00 | 51720.00 | 120050.00 | 10 | 5 | 11 | 0 | 0 | 0.345909240686364 | 0.35364122045214 | false | false | false | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 |
| 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-09-10T15:47:40.219521Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-09-08T15:43:32.720264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-31T13:47:44.562652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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 |
| 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 |
| 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 |
| 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 |