alirsop-4dec-05
Updated 2022-12-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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