yasmin-n-d-r-hUntitled Query
Updated 2022-08-01Copy Reference Fork
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 Quixotic as (
SELECT
x.block_timestamp,
x.tx_hash,
x.origin_from_address as buyer,
regexp_substr_all(
SUBSTR(
x.DATA,
3,
len(x.DATA)
),
'.{64}'
) AS segmented_data,
ethereum.public.udf_hex_to_int(segmented_data [1] :: STRING) as raw_volume,
raw_volume / pow(10, 18) as volume,
b.contract_address
FROM
optimism.core.fact_event_logs x
INNER JOIN optimism.core.fact_event_logs b ON x.tx_hash = b.tx_hash
WHERE
x.DATA != '0x'
AND x.tx_status = 'SUCCESS'
AND x.origin_to_address in (
'0x3f9da045b0f77d707ea4061110339c4ea8ecfa70'
)
AND b.event_name = 'Transfer'
)
SELECT
sum(volume) as eth_volume,
contract_address,
project_name
FROM
Quixotic x
INNER JOIN optimism.core.dim_labels b ON x.contract_address = b.address
GROUP BY
2,
Run a query to Download Data