freemartianUntitled Query
Updated 2023-04-13
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 deposit_count,
count(distinct origin_from_address) as depositors_count,
sum(event_inputs:value)/pow(10,18) as deposit_amount,
block_timestamp::date as TIME
from polygon.core.fact_event_logs
where origin_to_address = '0x794a61358d6845594f94dc1db02a252b5b4814ad'
and contract_address = '0xd6df932a45c0f255f85145f286ea0b292b21c90b'
and event_name = 'Transfer'
and event_inputs:to = '0xf329e36c7bf6e5e86ce2150875a84ce77f477375'
group by TIME),
opi as (
select
count(distinct tx_hash) as deposit_count,
count(distinct origin_from_address) as depositors_count,
sum(event_inputs:value)/pow(10,18) as deposit_amount,
block_timestamp::date as TIME
from optimism.core.fact_event_logs
where origin_to_address = '0x794a61358d6845594f94dc1db02a252b5b4814ad'
and contract_address = '0x76fb31fb4af56892a25e32cfc43de717950c9278'
and event_name = 'Transfer'
and event_inputs:to = '0xf329e36c7bf6e5e86ce2150875a84ce77f477375'
and block_timestamp::date < '2022-08-04'
group by TIME),
arbi as (
select
count(distinct tx_hash) as deposit_count,
count(distinct origin_from_address) as depositors_count,
sum(event_inputs:value)/pow(10,18) as deposit_amount,
block_timestamp::date as TIME
from arbitrum.core.fact_event_logs
where origin_to_address = '0x794a61358d6845594f94dc1db02a252b5b4814ad'
and contract_address = '0xba5ddd1f9d7f570dc94a51479a000e3bce967196'
and event_name = 'Transfer'
Run a query to Download Data