davidwallUntitled Query
Updated 2023-01-14
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
›
⌄
--credit : https://app.flipsidecrypto.com/velocity/queries/857d656d-1531-48ea-afe5-88fd4a18f732
with mints as (
select tx_hash
from ethereum.core.ez_nft_mints
where
block_timestamp > '2022-06-07' -- true freeze launched on 2022-06-08
and nft_address ='0x6c4e530a6f5cec117bbd1ed2937584a71c75ca22'
),
weth as (
select
block_timestamp::date as block_date,
tx_hash as freeze_tx_id,
to_number(event_inputs:value)/1e18 as weth_freeze_amount
from ethereum.core.fact_event_logs
where
-- tx_hash = lower('0x867ac6a4758d39ddce149ee7c621ba2a3163a4c0f197ba8cb68e46120260fade')
origin_to_address = lower('0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0') -- True Freeze Governor Contract
and contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' --WETH
and tx_hash in (select tx_hash from mints)
),
freth as (
select
block_timestamp::date as block_date,
tx_hash as freeze_tx_id,
event_inputs:value as freth_prelim_amount,
to_number(freth_prelim_amount)/1e18 as freth_minted_amount
from ethereum.core.fact_event_logs
where
origin_to_address = lower('0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0') -- True Freeze Governor Contract
and contract_address = '0xb4bd4628e6efb0cb521d9ec35050c75840320374' --frETH
and tx_hash in (select tx_hash from mints)
),
nft as (
Run a query to Download Data