Updated 2022-04-25
    select
    date_trunc(day,BLOCK_TIMESTAMP) as dt,
    COUNT(distinct EVENT_INPUTS:solver) as total_users,
    COUNT(TX_HASH) as total_transactions

    from ethereum_core.fact_event_logs
    where contract_address = lower('0x9008D19f58AAbD9eD0D60971565AA8510560ab41') and EVENT_NAME = 'Settlement'
    and BLOCK_TIMESTAMP>='2022-01-01'
    group by 1

    Run a query to Download Data