flipside

    resident-bronze
    namanasyncresident-bronze
    Updated 2024-09-13
    -- SELECT * FROM ethereum.core.ez_current_balances WHERE user_address = '0x40b38765696e3d5d8d9d834d8aad4bb6e418e489' limit 50

    -- SELECT user_address, sum(current_bal) as bal FROM ethereum.core.ez_current_balances where contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'
    -- group by user_address
    -- order by bal desc
    -- limit 10

    -- SELECT * FROM ethereum.core.ez_current_balances LIMIT 5

    -- SELECT * FROM ethereum.core.dim_contracts WHERE symbol = 'USDT'

    SELECT user_address, count(*) as cnt
    FROM ethereum.core.ez_current_balances
    WHERE contract_address in ('0xdac17f958d2ee523a2206206994597c13d831ec7')
    AND LAST_ACTIVITY_BLOCK_TIMESTAMP > '2024-09-01'
    GROUP BY user_address
    -- ORDER BY cnt desc
    LIMIT 5
    QueryRunArchived: QueryRun has been archived