0xHaM-dDesired Address Volume
Updated 2023-06-12
999
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 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