MOHAMAD23sum eth value last year
    Updated 2022-08-10
    with addresses as (
    select ADDRESS , ADDRESS_NAME
    from ethereum.core.dim_labels
    where label like '%tornado cash%'
    ),
    y as (
    select sum (ETH_VALUE) as sum_ , '0.01<transactions<0.1' as eth
    from ethereum.core.fact_transactions
    join addresses on ethereum.core.fact_transactions.TO_ADDRESS=addresses.ADDRESS
    where BLOCK_TIMESTAMP >= DATEADD(month, - 12, GETDATE())
    AND BLOCK_TIMESTAMP <= getdate() and ETH_VALUE between 0.01 and 0.1
    ),
    yy as (
    select sum (ETH_VALUE) as sum_ , '0.1<transactions<1' as eth
    from ethereum.core.fact_transactions
    join addresses on ethereum.core.fact_transactions.TO_ADDRESS=addresses.ADDRESS
    where BLOCK_TIMESTAMP >= DATEADD(month, - 12, GETDATE())
    AND BLOCK_TIMESTAMP <= getdate() and ETH_VALUE between 0.1 and 1
    ),
    yyy as (
    select sum (ETH_VALUE) as sum_ , '1<transactions<10' as eth
    from ethereum.core.fact_transactions
    join addresses on ethereum.core.fact_transactions.TO_ADDRESS=addresses.ADDRESS
    where BLOCK_TIMESTAMP >= DATEADD(month, - 12, GETDATE())
    AND BLOCK_TIMESTAMP <= getdate() and ETH_VALUE between 1 and 10
    ),
    yyyy as (
    select sum (ETH_VALUE) as sum_ , '10<transactions<100' as eth
    from ethereum.core.fact_transactions
    join addresses on ethereum.core.fact_transactions.TO_ADDRESS=addresses.ADDRESS
    where BLOCK_TIMESTAMP >= DATEADD(month, - 12, GETDATE())
    AND BLOCK_TIMESTAMP <= getdate() and ETH_VALUE between 10 and 100
    ),
    yyyyy as (
    select sum (ETH_VALUE) as sum_ , '100<transactions' as eth
    from ethereum.core.fact_transactions
    Run a query to Download Data