mehrancrypto-dxoepqQ81-1
Updated 2022-12-06
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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