headitmanagernumber of transactions
    Updated 2022-04-16
    select count(1) as sum , date(block_timestamp) as date
    , (case
    when date='2022-02-24' then 'Start War'
    when date <'2022-02-24' then 'Befor Start War'
    when date >'2022-02-24' then 'After Start War'
    end ) as war_datefrom from ethereum.dex_swaps inner join ethereum.labels
    on labels.address=token_address
    where
    date(block_timestamp)>'2022-01-01' and platform!='curve'
    group by date,war_datefrom
    Run a query to Download Data