binhachonUser Activity - #1
Updated 2022-06-11
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 vault_data as (
select
event_inputs:assetAddress::string as assetAddress,
event_inputs:vaultAddress::string as vaultAddress,
event_inputs:vaultId::int as vaultId
from ethereum.core.fact_event_logs
where event_name = 'NewVault'
and contract_address = '0xbe86f647b167567525ccaafcd6f881f1ee558216'
and tx_status = 'SUCCESS'
),
vault_transactions as (
select
vault_data.*,
tx_hash,
'Provide liquidity' as actions
from ethereum.core.fact_token_transfers
inner join vault_data on (vaultAddress = contract_address)
where from_address = '0x0000000000000000000000000000000000000000'
and block_timestamp::date >= getdate() - interval'60 days'
union all
select
vault_data.*,
tx_hash,
'Remove liquidity' as actions
from ethereum.core.fact_token_transfers
inner join vault_data on (vaultAddress = contract_address)
where to_address = '0x0000000000000000000000000000000000000000'
and block_timestamp::date >= getdate() - interval'60 days'
),
top3_vaults as (
select
vaultID,
count(distinct tx_hash) as number_of_actions
from vault_transactions
group by 1
order by 2 desc
Run a query to Download Data