flipside

    Last 50 LP Action
    Abbas_ra21Last 50 LP Action
    Updated 2025-02-09
    -- forked from Top 20 Lp Users [by Deposited Amount] @ https://flipsidecrypto.xyz/edit/queries/1be91174-0afc-40ac-8ac0-c66664b772c3

    -- forked from LP users osmo @ https://flipsidecrypto.xyz/edit/queries/9c508a37-5594-4e14-8192-950126a0eb60

    -- forked from LP users @ https://flipsidecrypto.xyz/edit/queries/8c8f2937-c6d3-4420-bd7f-4c5f58ac9b98

    -- forked from Pools Daily flow:SEI/USD @ https://flipsidecrypto.xyz/edit/queries/dc209cf2-ddbb-406f-834d-62afbb860b35

    with main AS (
    select
    m.BLOCK_TIMESTAMP,
    m.TX_ID,
    case
    when MSG_TYPE = 'wasm-liquidity-deposit' then 'Deposit'
    else 'Withdraw'
    end AS Action,
    CASE
    when ATTRIBUTE_VALUE='osmo1nzddhaf086r0rv0gmrepn3ryxsu9qqrh7zmvcexqtfmxqgj0hhps4hruzu' THEN 'BTC'
    when ATTRIBUTE_VALUE='osmo1hd7r733w49wrqnxx3daz4gy7kvdhgwsjwn28wj7msjfk4tde89aqjqhu8x' THEN 'ATOM'
    when ATTRIBUTE_VALUE='osmo127aqy4697zqn27z0vqr3x2n8lraf27t7udvl6ef5hcwmwhjadegq9vytdj' THEN 'OSMO'
    when ATTRIBUTE_VALUE='osmo19c7hdlfvu7cddr0smfz9luaj8375qhfr3s0gtsk087laqfzxlu3qsnk47e' THEN 'axlETH'
    when ATTRIBUTE_VALUE='osmo186nlf2fwfglq8u4nj3f7mwg8uc79j22qhaau4scdyur47e0fatas34vcn9' THEN 'SEI'
    when ATTRIBUTE_VALUE='osmo1d5zsvupzvq5ru6635a0agrcdrj0t8ycj8vpewm8z4y8xf85gvh3qk0ka33' THEN 'DOT'
    when ATTRIBUTE_VALUE='osmo16v36jtfjc933htukqfrk8lk8e2uj8xpp3zjdh0ll04qe9jevlnrsuwhhx8' THEN 'EURO'
    when ATTRIBUTE_VALUE='osmo1rhgn3mp5q7vfr43xgzwtcrnklll6w7e0gv5jvmk9sz26qvcnf3tsw8axyn' THEN 'GBP'
    when ATTRIBUTE_VALUE='osmo164357hnc5jc0pw9lv958h6chrpjucr4sy47hwpm9k4av6zh74gnq7uvcpj' THEN 'BNB'
    when ATTRIBUTE_VALUE='osmo1ufpu3nudumzh53sek246zrwvv2cc7leplaqruuggeny7wlcvfrzq4cqmwd' THEN 'stATOM'
    when ATTRIBUTE_VALUE='osmo1jprh8f4ytxar0q3z5n5p6swqnmunnsvuuhnhteskwxjzyc8jayms4r7e3e' THEN 'SOL'
    end AS Pool,
    User,
    avg(Amount) AS AMount,
    avg(Amount_USD) AS Amount_USD
    from
    osmosis.core.fact_msg_attributes m
    inner join (
    select
    Last run: 3 months ago
    BLOCK_TIMESTAMP
    TX_ID
    ACTION
    POOL
    USER
    AMOUNT
    AMOUNT_USD
    1
    		2025-03-11 10:08:02.8226457F1AAB5BC64F49D1B522407EEBE263CB6055836A86F41972B935C195DFDA7Depositosmo1h3a8uv87p6vc90vuhq2tzymkqylfn35r0cpafe4.0574164.057416
    2
    		2025-03-11 10:07:56.254DD0FB5088D32C16D0CDD75C7CDCF4A30C8DD42D9D20BA98ECBA0ABCF7486A33BDepositosmo1sgsyc69pg0ttnxqhknufduaxvcxrsfw6260sqm0.2525480.252548
    3
    		2025-03-11 10:07:50.5950B2D6CB74643F2102C4BA07B556423B1FF7566C7DBD5D6D91521FAC88261F2FEDepositSOLosmo1h3a8uv87p6vc90vuhq2tzymkqylfn35r0cpafe3.8126223.812622
    4
    		2025-03-11 10:07:00.417A537CB892F1945E8A17308A0D891A0EDD9E37E03160D881C30796E2CCF2D6D2ADepositATOMosmo1sgsyc69pg0ttnxqhknufduaxvcxrsfw6260sqm0.0142580.05193389883
    5
    		2025-03-11 10:06:26.9325CE22A4A7A881E174AB6677296A11181527945A47A3F557ED024D99FB314C050DepositSOLosmo1sgsyc69pg0ttnxqhknufduaxvcxrsfw6260sqm0.2715020.271502
    6
    		2025-03-11 10:02:43.59606FC3E541EE6970CA2200204B60D562DE7416649D9020F31BF59B541DD8CF6D8DepositSOLosmo1nfh9vmfaxxnqcrkw3gepey6k6ptsnsh4u0h3mw0.0770840.077084
    7
    		2025-03-11 10:02:03.2826ADCE5ACC13B90D2E8CB8F4196876AC86759327E66252CD8EF366758601A7A38DepositATOMosmo1nfh9vmfaxxnqcrkw3gepey6k6ptsnsh4u0h3mw0.0179490.0653781421
    8
    		2025-03-11 10:01:28.701AECBF0E38AD46EEA1B5F9AC83991539493564AA6626AEE871DE769B470C646E4Depositosmo1nfh9vmfaxxnqcrkw3gepey6k6ptsnsh4u0h3mw0.0991230.099123
    9
    		2025-03-10 17:43:53.066D7A2CFD7FFD3B665262D7B8E058A740DC4A387447EE1D990274CC6035DDD4670WithdrawBTCosmo1pd2wkd45zt67v3esjlphk48pdlqqxqtce650ux0.00221076173.693915528
    10
    		2025-03-10 17:42:15.365FF99EC1BD5A437ECC61EF1501E9C010E55FC10F6348CAEB0DEEAC717293C7E12Depositosmo1uknjslwqry5rs806d5uaa78fgfhxey03mts73l8.58658825.366331947
    11
    		2025-03-10 17:40:19.0626C42FAD201E6DD153055DF00BE07378455F37C7C13D836D7210633346984A0E9WithdrawATOMosmo17a03uapdatpvlv8vyn42syf6ak78dz9ggtv6y30.657822.482090391
    12
    		2025-03-10 16:41:21.377FD3A08308410EC0D79404A4176206E21C405F142B85362028C9FEAE3810AAB76WithdrawSOLosmo1z0smdyt0agj8tj848s5y29m4grktr44tjwqfhl0.7886660.788666
    13
    		2025-03-10 16:40:57.15647AC2E59C4303E7876A205B0F034A5195431FE56B2F0891ABABFFB75107D6415Withdrawosmo1z0smdyt0agj8tj848s5y29m4grktr44tjwqfhl0.195750.5956471445
    14
    		2025-03-10 16:40:42.324415F3FF8A122E7F1E348E2389BCC5B96CB0D70616585ABB4109462885FCDD7C9Withdrawosmo1z0smdyt0agj8tj848s5y29m4grktr44tjwqfhl0.4900660.490066
    15
    		2025-03-10 16:40:24.0938E270291B12C3134C7CE32D4DE0E3900BE3563370E6A02A89F53C2878A2644E5Withdrawosmo1z0smdyt0agj8tj848s5y29m4grktr44tjwqfhl1.0962361.096236
    16
    		2025-03-10 13:57:59.21677D338BF1FB65971244E476A8FB10E975847C0D2E5C2C1A667CA91639C8F9D1EWithdrawosmo17a03uapdatpvlv8vyn42syf6ak78dz9ggtv6y32.0606662.060666
    17
    		2025-03-10 13:57:09.306C597CFFE3F1764FDA4AEF59EC95783987465599F2FA759C6B995FD0B4B85B3FBWithdrawstATOMosmo17a03uapdatpvlv8vyn42syf6ak78dz9ggtv6y30.1602930.9895177196
    18
    		2025-03-10 13:56:05.724A9EB063AA18757F6A62422E3EA62C1D92163D5942214BAD2CAAAC20E3B636ECBWithdrawATOMosmo17a03uapdatpvlv8vyn42syf6ak78dz9ggtv6y30.8900543.504152869
    19
    		2025-03-10 13:28:38.52251B4D9FD86B0A461B765C26CCE5905E6F7795F4FC1840CEC85193ECD765D4055WithdrawaxlETHosmo1lpl2kze5qp9swhv3cljutwpagknds960amrpyz28.00262412459173.835427348
    20
    		2025-03-10 11:52:18.824EE333F6CE5D02589C50280B328530532A53B8AE18018395F956EB928EBC9C4B5Depositosmo17kllm9htd4l4au2wh03jp5ulrc9u0vy4k0vqnk0.095060.2910790291
    50
    9KB
    413s