0xHaM-dDesired Address Volume
    Updated 2023-06-12
    with priceTb as (
    SELECT
    HOUR,
    TOKEN_ADDRESS,
    SYMBOL,
    DECIMALS,
    avg(price) as usd_price
    FROM ethereum.core.fact_hourly_token_prices
    GROUP by 1,2,3,4
    )
    , mainTb as (
    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    DECODED_LOG:receiver as maker,
    DECODED_LOG:base_quantity as token_sold_amt,
    (DECODED_LOG:base_quantity/pow(10, ps.decimals))*ps.usd_price as token_sold_amt_usd,
    COALESCE(token_sold_amt_usd, 0) as sold_vol_usd,
    DECODED_LOG:base_token as token_sold_address,
    ps.SYMBOL as SYMBOL_Sold,
    DECODED_LOG:quote_quantity as token_bought_amt,
    (DECODED_LOG:quote_quantity/pow(10, pb.decimals))*pb.usd_price as token_bought_amt_usd,
    COALESCE(token_bought_amt_usd, 0) as bought_vol_usd,
    DECODED_LOG:quote_token as token_bought_address,
    pb.SYMBOL as SYMBOL_BOUGHT,

    DECODED_LOG:base_quantities[0] as token1_sold_amt,
    (DECODED_LOG:base_quantities[0]/pow(10, ps1.decimals))*ps1.usd_price as token1_sold_amt_usd,
    COALESCE(token1_sold_amt_usd, 0) as sold1_vol_usd,
    DECODED_LOG:base_tokens[0] as token1_sold_address,
    ps1.SYMBOL as SYMBOL_Sold1,
    DECODED_LOG:quote_quantities[0] as token1_bought_amt,
    (DECODED_LOG:quote_quantities[0]/pow(10, pb1.decimals))*pb1.usd_price as token1_bought_amt_usd,
    COALESCE(token1_bought_amt_usd, 0) as bought1_vol_usd,
    DECODED_LOG:quote_tokens[0] as token1_bought_address,
    pb1.SYMBOL as SYMBOL_BOUGHT1,
    Run a query to Download Data