tornado as

(select

dayofweek(block_timestamp) as day_of_week

, HOUR(block_timestamp) as hour_of_day

,address_name,

count (distinct tx_hash) as trxs,

sum (amount) as amount

select

address,address_name

from flipside_prod_db.crosschain.address_labels

where project_name ilike '%tornado%'

and label_type = 'dapp')

as tornad

join ethereum.core.ez_eth_transfers on eth_to_address = address

where block_timestamp >= CURRENT_DATE - 365

group by 1,2,3 )

CASE

WHEN day_of_week = 0 THEN '7_Sunday'

WHEN day_of_week = 1 THEN '6_Monday'

WHEN day_of_week = 2 THEN '5_Tuesday'

WHEN day_of_week = 3 THEN '4_Wednesday'

WHEN day_of_week = 4 THEN '3_Thursday'

WHEN day_of_week = 5 THEN '2_Friday'

WHEN day_of_week = 6 THEN '1_Saturday'

END as day_of_week

, hour_of_day

, trxs

,amount

,address_name

FROM tornado

ORDER by 1, 2