intellidegent2023-05-25 11:55 AM
    Updated 2023-05-29
    select
    block_timestamp::date as date,
    sum(amount) as amount
    from ethereum.core.ez_token_transfers
    where block_timestamp::date between '2023-01-01' and '2023-04-30'
    and origin_from_address = lower('0x5efda50f22d34f262c29268506c5fa42cb56a1ce')
    group by date


    select *
    from ethereum.core.ez_current_balances
    where user_address = lower('0xBE8E3e3618f7474F8cB1d074A26afFef007E98FB')
    or user_address = lower('0x8EE7D9235e01e6B42345120b5d270bdB763624C7')
    and (contract_address is null
    or contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    )



    select
    *
    from ethereum.core.ez_token_transfers
    where origin_from_address = lower('0x8EE7D9235e01e6B42345120b5d270bdB763624C7')
    limit 10

    select * from ethereum.fact_token_transfers
    where from_address = lower('0xDcd382bE6cC4f1971C667ffDa85C7a287605afe4')
    limit 10

    select * from ethereum.core.dim_labels
    where --label_subtype = 'treasury'
    address_name like '%maker%'
    limit 100;



    Run a query to Download Data