jackguy2023-09-01 07:55 PM
Updated 2023-09-02
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 tab1 as (
SELECT
tx_hash,
'in' as tx_type,
block_timestamp,
(raw_amount / power(10, decimals)) as amt,
token_address,
price
FROM base.core.fact_token_transfers
INNER join (
SELECT
date(hour) as date1,
token_address,
symbol,
decimals,
median(price) as price
FROM base.price.ez_hourly_token_prices
GROUP BY 1,2,3,4
) on date(block_timestamp) = date1
AND token_address = CONTRACT_ADDRESS
WHERE --tx_hash LIKE '0xc8dddfe5c9ccfe2ac6d0b17d58ab07702a6b128e27c556f33f256cccfefcc85e'
TO_ADDRESS in (
--lower('0x7f670f78B17dEC44d5Ef68a48740b6f8849cc2e6'), -- WETH/AERO
lower('0x2223F9FE624F69Da4D8256A7bCc9104FBA7F8f75') -- AERO/USDbC
)
), tab2 as (
SELECT
tx_hash,
'out' as tx_type,
block_timestamp,
(raw_amount / power(10, decimals)) as amt,
contract_address as token_address,
price
FROM base.core.fact_token_transfers
Run a query to Download Data