fkcryptoworkspaceUntitled Query
    Updated 2022-07-11
    select --block_timestamp::date as date,
    symbol,
    count(distinct tx_hash) as num_txs,
    count(distinct DEPOSITOR) as num_DEPOSITORs,
    sum(amount) as deposit_amount,
    sum(AMOUNT_USD) as deposit_amount_ucd
    from flipside_prod_db.crosschain.ez_lending
    where symbol in ('USDC','USDT','DAI','UST','FEI','FRAX','BUSD','TUSD','sUSD') and block_timestamp::date<='2022-07-10' and block_timestamp::date>='2022-06-06'
    and PLATFORM='sushi' and action = 'Deposit' and BLOCKCHAIN='polygon'
    group by 1--,2
    order by 1,2 asc
    Run a query to Download Data