jackguyToken Reactor Rankings 3
    Updated 2022-06-21
    with tab1 as (
    SELECT
    address,
    name
    FROM ethereum.core.dim_contracts
    WHERE name LIKE '%Tokemak%'
    )

    SELECT
    date_trunc('day', block_timestamp),
    name,
    SUM(amount_usd)
    FROM ethereum.core.ez_token_transfers
    LEFT outer JOIN tab1
    ON from_address = address
    WHERE from_address IN (SELECT address from tab1)
    AND block_timestamp > '2022-01-01'
    GROUP BY 1,2
    Run a query to Download Data