date_Trunc ('{{Time_Interval}}',block_timestamp) as date,

count (distinct fact_transfers_id) as Transfers,

count (distinct to_address) as Users,

sum (rune_amount_usd) as Volume,

avg (rune_amount_usd) as Average_Volume,

transfers / users as Transfer_Per_User,

volume / users as Volume_Per_User,

sum (transfers) over (order by date) as Cumulative_Transfers,

sum (volume) over (order by date) as Cumulative_Volume

from thorchain.core.fact_transfers

where block_timestamp >= '{{From_Date}}' and block_timestamp <= '{{To_Date}}'

and from_address in (select distinct address from thorchain.core.dim_labels where label_type = 'cex' group by 1)

group by 1,2

union all

select 'Outflow' as type,

date_Trunc ('{{Time_Interval}}',block_timestamp) as date,

count (distinct fact_transfers_id) as Transfers,

count (distinct from_address) as Users,

sum (rune_amount_usd) as Volume,

avg (rune_amount_usd) as Average_Volume,

transfers / users as Transfer_Per_User,

volume / users as Volume_Per_User,

sum (transfers) over (order by date) as Cumulative_Transfers,

sum (volume) over (order by date) as Cumulative_Volume

from thorchain.core.fact_transfers

where block_timestamp >= '{{From_Date}}' and block_timestamp <= '{{To_Date}}'

and to_address in (select distinct address from thorchain.core.dim_labels where label_type = 'cex' group by 1)

group by 1,2

order by date desc