alirsop-4dec-05
    Updated 2022-12-09
    WITH price
    AS (
    SELECT HOUR::DATE AS Price_date
    ,SYMBOL
    ,TOKEN_ADDRESS
    ,decimals
    ,avg(price) AS price_usd
    FROM ethereum.core.fact_hourly_token_prices
    GROUP BY 1
    ,2
    ,3
    ,4
    )
    , swap_from as (
    SELECT
    BLOCK_TIMESTAMP::date as date,
    SYMBOL as "Token IN",
    tx_hash,
    contract_address,
    FROM_ADDRESS,
    ((RAW_AMOUNT / pow(10, decimals)) * price_usd) as "Volume IN"
    FROM ethereum.core.fact_token_transfers Gigaswap
    join price on (Gigaswap.contract_address = price.TOKEN_ADDRESS and Gigaswap.BLOCK_TIMESTAMP::date = price.Price_date)
    WHERE TO_ADDRESS = '0x83249c6794bca5a77eb8c0af9f1a86e055459cea' --GigaSwap
    AND FROM_ADDRESS != '0x83249c6794bca5a77eb8c0af9f1a86e055459cea'

    )
    , swap_to as (
    SELECT
    date_trunc('day', BLOCK_TIMESTAMP)::date as date,
    contract_address,
    SYMBOL as "Token OUT",
    tx_hash,
    FROM_ADDRESS,
    ((RAW_AMOUNT / pow(10, decimals)) * price_usd) as "Volume OUT"
    FROM ethereum.core.fact_token_transfers Gigaswap
    Run a query to Download Data