nitsUntitled Query
    Updated 2022-02-26
    SELECT * from
    (SELECT * from
    (SELECT * from ethereum.erc20_balances
    where
    user_address in
    (SELECT to_address
    from ethereum.udm_events
    where from_address_name is not NULL and lower(symbol) = lower('xSushi') and amount is not NULL and block_timestamp > CURRENT_DATE -60 and to_label is NULL
    ))
    where
    balance_date = CURRENT_DATE -1 and
    amount_usd is not NULL )
    -- GROUP by 1
    -- order by 2 desc
    limit 100
    Run a query to Download Data