headitmanagerCopy of Copy of Copy of Copy of Copy of Copy of Copy of Total deposits
    Updated 2022-06-22
    with total_deposite as (select sum(mint_price_usd) as total ,
    case
    when nft_address=lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523') then 'Judge'
    when nft_address=lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9') then 'Lawyer'
    when nft_address=lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed') then 'Supporter'
    end as nft_name
    from ethereum.core.ez_nft_mints
    where
    nft_address in (lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')
    ,lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'),
    lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'))
    group by nft_name)
    , deposite_overtime as (select sum(mint_price_usd) as total , block_timestamp::date,
    case
    when nft_address=lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523') then 'Judge'
    when nft_address=lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9') then 'Lawyer'
    when nft_address=lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed') then 'Supporter'
    end as nft_name
    from ethereum.core.ez_nft_mints
    where
    nft_address in (lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')
    ,lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'),
    lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'))
    group by block_timestamp::date,nft_name)
    , avg_deposite as (select avg(mint_price_usd) as avg ,
    case
    when nft_address=lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523') then 'Judge'
    when nft_address=lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9') then 'Lawyer'
    when nft_address=lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed') then 'Supporter'
    end as nft_name
    from ethereum.core.ez_nft_mints
    where
    nft_address in (lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')
    ,lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'),
    lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'))
    group by nft_name)
    Run a query to Download Data