date_trunc('day', block_timestamp) as date,

case when date < '2023-01-01' then 'Before 2023'

else '2023'

END as "Time",

count(distinct TX_ID) as "Number of TXs",

count(distinct TX_SENDER) as "Number of Users",

sum("Number of TXs") over (order by date) as "Cumulative Number of TXs",

"Number of TXs"/(24*60) as "TX Per Min",

"Number of TXs"/(24) as "TX Per Hour",

avg(fee) as "Average Daily TX Fee",

max(fee) as "Maximum Daily TX Fee",

min(fee) as "Minimum Daily TX Fee",

median(fee) as "Median Daily TX Fee"

from terra.core.fact_transactions

where block_timestamp > current_date - interval '60 days'

group by 1

order by 1