nsa2000oet6
Updated 2022-12-10
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
liquid_staking_platform_cte as (
select
value:platform platform
, value:contract_address contract_address
from table(flatten(input => parse_json(
'
[
{
"platform": "Lido",
"contract_address": "0xae7ab96520de3a18e5e111b5eaab095312d7fe84"
},
{
"platform": "Ankr",
"contract_address": "0x84db6ee82b7cf3b47e8f19270abde5718b936670"
},
{
"platform": "Rocket Pool",
"contract_address": "0x4d05e3d48a938db4b7a9a59a802d5b45011bde58"
},
{
"platform": "Rocket Pool",
"contract_address": "0x2cac916b2a963bf162f076c0a8a4a8200bcfbfb4"
}
]
'
)))
)
, liquidity_token_minted_cte as ( -- liquidity tokens minted transaction
select
distinct tx_hash
from ethereum.core.ez_token_transfers
where 1=1
and from_address = '0x0000000000000000000000000000000000000000'
)
, liquid_staking_eth_cte as (
Run a query to Download Data