sinahosseinzadehUntitled Query
    Updated 2022-08-12
    select
    'stake' as action, sum(AMOUNT_USD) as usd,date_trunc('day',block_timestamp) date
    from ethereum.core.ez_token_transfers
    where TO_ADDRESS = '0x4da27a545c0c5b758a6ba100e3a049001de870f5'
    and ORIGIN_TO_ADDRESS = TO_ADDRESS and from_ADDRESS=lower('{{user}}')
    group by 1,3
    union
    select
    'unstaked' as action,
    sum(AMOUNT_USD) as usd,
    date_trunc('day',block_timestamp) date
    from ethereum.core.ez_token_transfers
    where FROM_ADDRESS = '0x4da27a545c0c5b758a6ba100e3a049001de870f5'
    and ORIGIN_TO_ADDRESS = FROM_ADDRESS and to_address=lower('{{user}}')
    group by 1,3
    Run a query to Download Data