with tornado_address as(
select *
from ethereum.core.dim_labels
where label='tornado cash' and LABEL_SUBTYPE='general_contract'),
main as(
SELECT
*,date_trunc('hour',BLOCK_TIMESTAMP) as hour
FROM(tornado_address tor inner join ethereum.core.ez_token_transfers ez on ez.TO_ADDRESS=tor.address)
),
select_main as (
SELECT
*,
CASE
WHEN AMOUNT_USD is null THEN PRICE*AMOUNT
else AMOUNT_USD
END
from(main inner join ethereum.core.fact_hourly_token_prices pr on pr.hour=main.hour and main.symbol=pr.symbol))
SELECT
sum(amount_usd) as total_amount,
address_name
from select_main
where block_timestamp>=CURRENT_DATE-30
group by address_name