Updated 2023-06-09
    select count(distinct TRADER) , sum(FROM_AMOUNT/pow(10,6)) , avg(FROM_AMOUNT/pow(10,6)),trunc(block_timestamp, 'DAY')
    from osmosis.core.fact_swaps inner join osmosis.core.dim_labels
    on FROM_CURRENCY=osmosis.core.dim_labels.address
    where PROJECT_NAME ='ATOM'
    group by 4
    Run a query to Download Data