(SELECT date(block_timestamp) as day, sum(total_amt) as daily_amt, count(*) as total_txs,

sum(daily_amt) over (order by day) as cumulative_amt, sum(total_txs) over (order by day) as cumulative_txs, 'dai' as token

from

(SELECT block_timestamp,tx_id, max(amount) as total_amt from ethereum.udm_events

where contract_address ilike '0x6b175474e89094c44da98b954eedeac495271d0f' and amount is not NULL and event_name = 'transfer' and block_timestamp >= CURRENT_DATE -365

GROUP by 1,2 )

GROUP by 1 ),

usdc as

(SELECT date(block_timestamp) as day, sum(total_amt) as daily_amt, count(*) as total_txs,

sum(daily_amt) over (order by day) as cumulative_amt, sum(total_txs) over (order by day) as cumulative_txs, 'usdc' as token

from

(SELECT block_timestamp,tx_id, max(amount) as total_amt from ethereum.udm_events

where contract_address ilike '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' and amount is not NULL and event_name = 'transfer' and block_timestamp >= CURRENT_DATE -365

GROUP by 1,2 )

GROUP by 1 ),

usdt as

(SELECT date(block_timestamp) as day, sum(total_amt) as daily_amt, count(*) as total_txs,

sum(daily_amt) over (order by day) as cumulative_amt, sum(total_txs) over (order by day) as cumulative_txs, 'usdt' as token

from

(SELECT block_timestamp,tx_id, max(amount) as total_amt from ethereum.udm_events

where contract_address ilike '0xdac17f958d2ee523a2206206994597c13d831ec7' and amount is not NULL and event_name = 'transfer' and block_timestamp >= CURRENT_DATE -365

GROUP by 1,2 )

GROUP by 1 )

SELECT * from dai

UNION ALL

SELECT * from usdc

UNION ALL

SELECT * from usdt