theericstoneERC20 Non-exchange Volume
    Updated 2022-01-24
    WITH condeets AS (
    SELECT contract_address, symbol, name FROM(
    SELECT
    cmc.token_address AS contract_address,
    cmc.name,
    cmc.symbol,
    AVG(price.market_cap) AS mean_mcap,
    AVG(price.volume) AS mean_vol
    FROM
    public.daily_candles price JOIN
    public.cmc_assets cmc
    ON cmc.asset_id = price.asset_id
    WHERE
    cmc.token_address IS NOT NULL
    AND price.recorded_at > getdate() - INTERVAL '7 days'
    GROUP BY 1,2,3
    ) contracts
    WHERE mean_mcap > 1000000 OR mean_vol > 10000000
    )

    SELECT
    ee.contract_address,
    condeets.symbol,
    condeets.name,
    date_trunc('day',block_timestamp) AS date,
    sum(amount_usd) AS usd_sent,
    sum(amount) AS amount_sent,
    count( DISTINCT from_address) AS n_senders
    FROM gold.ethereum_events ee JOIN
    condeets on condeets.contract_address = ee.contract_address
    WHERE
    ((from_label_type <> 'distributor' OR from_label_type IS NULL)
    OR (to_label_type <> 'distributor' OR to_label_type IS NULL))
    AND ee.contract_address IS NOT NULL
    AND block_timestamp > getdate() - INTERVAL '7 days'
    AND amount > 0
    Run a query to Download Data