headitmanagerTotal users who have used TERRASWAP
    Updated 2022-03-07
    with tbl1 as
    (
    select distinct tx_from[0] as all_address from terra.transactions where
    date(block_timestamp) <= DATEADD(DAY, -90, CURRENT_DATE) and tx_from[0] is not null
    )
    ,tbl2 as
    (
    select distinct tx_from[0] as new_address from terra.transactions where
    date(block_timestamp) > DATEADD(DAY, -90, CURRENT_DATE) and tx_from[0] is not null
    )
    ,tbl3 as
    (select new_address from tbl2 left join tbl1 on tbl2.new_address=tbl1.all_address where all_address is null
    )

    select count(distinct msg_value:sender) as users ,
    (
    case
    WHEN msg_value:contract='terra1pn20mcwnmeyxf68vpt3cyel3n57qm9mp289jta' then 'LOTA-UST Pair'
    WHEN msg_value:contract='terra1vayuttjw6z4hk5r734z9qatgs8vp6r5a2t043p' then 'LUNI-UST Pair'
    WHEN msg_value:contract='terra1xj2w7w8mx6m2nueczgsxy2gnmujwejjeu2xf78' then 'APOLLO-UST Pair'
    WHEN msg_value:contract='terra1llhpkqd5enjfflt27u3jx0jcp5pdn6s9lfadx3' then 'LUNAX-UST PAIR'
    WHEN msg_value:contract='terra1zrzy688j8g6446jzd88vzjzqtywh6xavww92hy' then 'LUNAX-Luna Pair'
    WHEN msg_value:contract='terra1zz39wfyyqt4tjz7dz6p7s9c8pwmcw2xzde3xl8' then 'DPH-UST PAIR'
    WHEN msg_value:contract='terra1e59utusv5rspqsu8t37h5w887d9rdykljedxw0' then 'VKR-UST Pair'
    WHEN msg_value:contract='terra1z6tp0ruxvynsx5r9mmcc2wcezz9ey9pmrw5r8g' then 'ORION-UST PAIR'
    WHEN msg_value:contract='terra1fmv3g96s4xc9nrnlkdn87vxyaydd22xsxzel5r' then 'SDOLLAR-UST PAIR'
    WHEN msg_value:contract='terra1stdzf28wlq7llzfecse366r657rtdh6wtrdfk2' then 'tSHIBA-UST Pair'
    WHEN msg_value:contract='terra1ykfz4hrq8en2f098j8a4ppaq8u8hangpw9tnqu' then 'BTL-UST Pair'
    WHEN msg_value:contract='terra1v4kpj65uq63m4x0mqzntzm27ecpactt42nyp5c' then 'WHALE-UST Pair'
    WHEN msg_value:contract='terra1x8h5gan6vey5cz2xfyst74mtqsj7746fqj2hze' then 'LUNAX-bLUNA Pair'
    WHEN msg_value:contract='terra1de8xa55xm83s3ke0s20fc5pxy7p3cpndmmm7zk' then 'stLUNA-LUNA Pair'
    WHEN msg_value:contract='terra1jzqlw8mfau9ewr7lufqkrpgfzk4legz9zx306p' then 'TLAND-UST Pair'
    WHEN msg_value:contract='terra1z50zu7j39s2dls8k9xqyxc89305up0w7f7ec3n' then 'aUST-UST Pair'
    WHEN msg_value:contract='terra1pufczag48fwqhsmekfullmyu02f93flvfc9a25' then 'ASTRO-UST Pair'
    WHEN msg_value:contract='terra1ycp5lnn0qu4sq4wq7k63zax9f05852xt9nu3yc' then 'ATLO-UST Pair'
    WHEN msg_value:contract='terra1p44kn7l233p7gcj0v3mzury8k7cwf4zt6gsxs5' then 'GLOW-UST Pair'
    Run a query to Download Data