flipside

    Number of transactions
    campNumber of transactions
    Updated 2022-03-08
    select tx_from[0] as wallet_address,
    min(block_timestamp)::date as min_date ,
    count(DISTINCT tx_id) as Count_transactions
    from terra.transactions
    group by 1
    having min_date>=CURRENT_DATE-90
    order by 2 DESC
    Run a query to Download Data