flipside

    home: daily information
    elsinahome: daily information
    Updated 2022-08-27
    select date_trunc('day', block_timestamp) as "Day",
    count(tx_hash) as "Number of transactions",
    count(distinct from_address) as "Number of unique addresses"
    from avalanche.core.fact_transactions
    where "Day" <= current_date - 1
    group by 1
    Run a query to Download Data