forgashBeer is NEAR, Aggregations by Customer
    Updated 2022-09-14
    WITH txs AS (
    SELECT
    *
    FROM
    near.core.fact_transactions
    WHERE
    block_timestamp :: DATE >= '2022-09-11'
    ),
    usn AS (
    SELECT
    *
    FROM
    near.core.ez_usn_supply
    WHERE
    block_timestamp :: DATE >= '2022-09-11'
    ),
    prices AS (
    SELECT
    DATE_TRUNC(
    'm',
    TIMESTAMP
    ) AS block_timestamp,
    symbol,
    AVG(price_usd) AS price_usd
    FROM
    near.core.fact_prices
    WHERE
    symbol = 'NEAR'
    AND TIMESTAMP :: DATE >= '2022-09-11'
    GROUP BY
    1,
    2
    ),
    transfers AS (
    SELECT
    *
    Run a query to Download Data