select

TX_HASH,

date_trunc('month', block_timestamp) as day,

case

when ETH_VALUE<0.01 then 'Under 0.01 ETH'

when ETH_VALUE>=0.01 and ETH_VALUE<0.1 then '0.01-0.1 ETH'

when ETH_VALUE>=0.1 and ETH_VALUE<1 then '0.1-1 ETH'

when ETH_VALUE>=1 and ETH_VALUE<10 then '1-10 ETH'

when ETH_VALUE>=10 and ETH_VALUE<100 then '10-100 ETH'

when ETH_VALUE>=100 then 'Above 100 ETH'

end as range

ethereum.core.fact_transactions t

join ethereum.core.dim_labels l on t.to_address = l.address

where

label like '%tornado cash%' and

status = 'SUCCESS' and

block_timestamp > '2021-08-01' and block_timestamp < '2022-08-01'

select

day,

range,

count(distinct TX_HASH) AS cnt

from

ranges

group by

day, range

order by

day asc