vegardUntitled Query
Updated 2022-09-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT * FROM (
SELECT DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS MONTHLY, 'OPTIMISM TO EHTHEREUM' AS TYPE, SUM(AMOUNT) as AMOUNT, SUM(AMOUNT_USD) as AMOUNT_USD
FROM ethereum.core.ez_eth_transfers
WHERE BLOCK_TIMESTAMP::DATE >= '2022-01-1'
AND ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1' -- OPTIMISM TO EHTHEREUM
GROUP BY MONTHLY
UNION
SELECT DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS MONTHLY, 'EHTHEREUM TO OPTIMISM' AS TYPE, SUM(AMOUNT) as AMOUNT, SUM(AMOUNT_USD) as AMOUNT_USD
FROM ethereum.core.ez_eth_transfers
WHERE BLOCK_TIMESTAMP::DATE >= '2022-01-1'
AND ORIGIN_TO_ADDRESS = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- EHTHEREUM TO OPTIMISM
GROUP BY MONTHLY
)
ORDER BY 1, 2
Run a query to Download Data