freemartianAAVE V3 Withdrawals
Updated 2023-02-18
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 poly as (
select
count(distinct tx_hash) as Withdraw_count,
count(distinct origin_from_address) as Withdrawers_count,
sum(event_inputs:value)/pow(10,18) as Withdraw_amount
from polygon.core.fact_event_logs
where origin_to_address = '0x794a61358d6845594f94dc1db02a252b5b4814ad'
and contract_address = '0xd6df932a45c0f255f85145f286ea0b292b21c90b'
and event_inputs:from = '0xf329e36c7bf6e5e86ce2150875a84ce77f477375'
and event_name = 'Transfer'),
opi as (
select
count(distinct tx_hash) as Withdraw_count,
count(distinct origin_from_address) as Withdrawers_count,
sum(event_inputs:value)/pow(10,18) as Withdraw_amount
from optimism.core.fact_event_logs
where origin_to_address = '0x794a61358d6845594f94dc1db02a252b5b4814ad'
and contract_address = '0x76fb31fb4af56892a25e32cfc43de717950c9278'
and event_name = 'Transfer'
and event_inputs:from = '0xf329e36c7bf6e5e86ce2150875a84ce77f477375'
),
arbi as (
select
count(distinct tx_hash) as Withdraw_count,
count(distinct origin_from_address) as Withdrawers_count,
sum(event_inputs:value)/pow(10,18) as Withdraw_amount
from arbitrum.core.fact_event_logs
where origin_to_address = '0x794a61358d6845594f94dc1db02a252b5b4814ad'
and contract_address = '0xba5ddd1f9d7f570dc94a51479a000e3bce967196'
and event_name = 'Transfer'
and event_inputs:from = '0xf329e36c7bf6e5e86ce2150875a84ce77f477375'
),
avalanche as (
select
Run a query to Download Data