jackguyBase 100
    Updated 2023-09-29
    with tab1 as (
    SELECT
    DISTINCT sender as users
    FROM axelar.core.ez_squid
    WHERE DESTINATION_CHAIN LIKE 'base'
    OR SOURCE_CHAIN LIKE 'base'
    )


    SELECT
    date_trunc('day', block_timestamp) as day,
    count(DISTINCT tx_hash) as Transactions,
    count(DISTINCT from_address) as active_users
    FROM base.core.fact_transactions
    WHERE from_address in (SELECT * FROM tab1)
    GROUP BY 1

    Run a query to Download Data