i_dan2024-05-02 11:21 AM
    Updated 2024-05-02
    --select -from -where -group by -order by

    SELECT
    t.block_timestamp,
    t.tx_hash,
    t.origin_from_address,
    l.address_name,
    l.label,
    t.amount,
    t.symbol,
    t.amount_usd

    FROM ethereum.core.ez_token_transfers t
    JOIN ethereum.core.dim_labels l
    ON t.contract_address = l.address

    WHERE amount_usd IS NOT NULL

    ORDER BY 8 DESC

    LIMIT 100
    QueryRunArchived: QueryRun has been archived