Updated 2022-12-06
    SELECT C.symbol ,
    RAW_AMOUNT*power(10 , -C.DECIMALS) as volume ,
    volume*PRICE as USD_value , BLOCK_TIMESTAMP , tx_hash ,FROM_ADDRESS ,TO_ADDRESS
    FROM ethereum.core.fact_token_transfers A
    LEFT OUTER JOIN ethereum.core.fact_hourly_token_prices C on A.CONTRACT_ADDRESS = TOKEN_ADDRESS
    and date_trunc('hour' , A.BLOCK_TIMESTAMP) = HOUR
    where ORIGIN_FROM_ADDRESS = '0x0000098a312e1244f313f83cac319603a97f4582'
    and VOLUME is NOT NULL
    ORDER by BLOCK_TIMESTAMP DESC
    LIMIT 100
    Run a query to Download Data