strawbettyUntitled Query
Updated 2022-07-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with tab1 as (
SELECT
SUM(amount_usd) as polygon_fee,
date_trunc('day', block_timestamp) as day
FROM polygon.udm_events
WHERE to_label like 'opensea'
and day>= '2022-07-01'
GROUP by 2
), tab2 as (
SELECT
SUM(amount_usd) as ethereum_fee,
date_trunc('day', block_timestamp) as day
FROM ethereum.udm_events
WHERE to_address LIKE '0x7be8076f4ea4a4ad08075c2508e481d6c946d12b'
and day>= '2022-07-01'
GROUP by 2
)
SELECT *
FROM tab2 join tab1 on tab2.td = tab1.td
Run a query to Download Data