MufasaTransfers count on daily basis before and after the announcement
    Updated 2023-01-25
    with final_data as (
    select
    to_date(block_timestamp) as date,
    count(*) as total_count, sum(AMOUNT/1e6) as volume, 'Before Week Situation'
    from terra.core.ez_transfers
    where CURRENCY='uluna' and year(block_timestamp)=2023 and
    date >='2023-01-07' and
    date <='2023-01-13'
    group by date
    UNION
    select
    to_date(block_timestamp) as date,
    count(*) as total_count, sum(AMOUNT/1e6) as volume, 'after Week Situation'
    from terra.core.ez_transfers
    where CURRENCY='uluna' and year(block_timestamp)=2023 and
    date >='2023-01-15' and
    date <='2023-01-21'
    group by date
    )
    select * from final_data
    Run a query to Download Data