block_timestamp::date as day,

iff(block_timestamp < '2022-12-20', 'Before', 'After') as timespan,

count(distinct(tx_id)) as txns_count,

count(distinct sender) as senders_count,

count(distinct receiver) as receivers_count,

sum(amount / pow(10, decimal)) as total_volume,

avg(amount/pow(10,decimal)) as average_volume,

median(amount /pow(10, decimal)) as median_volume,

sum(txns_count) over (order by day) as cumulative_txns_count,

sum(senders_count) over (order by day) as cumulative_senders_count,

sum(receivers_count) over (order by day) as cumulative_receivers_count,

sum(total_volume) over (order by day) as cumulative_volume

from osmosis.core.fact_transfers

where tx_succeeded = 1

and transfer_type = 'IBC_TRANSFER_IN'

and currency = 'ibc/AB589511ED0DD5FA56171A39978AFBF1371DB986EC1C3526CE138A16377E39BB'

and block_timestamp >= '2022-11-01'

group by 1, 2

order by 1