mariyaDily number of bridges(sol/eth)
Updated 2022-11-24
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
›
⌄
select
BLOCK_TIMESTAMP::date as date,
'Solana -> Ethereum' as type,
substring(INPUT_DATA, 202, 1) as chain_id,
count(DISTINCT tx_hash) as tx_cnt,
count(DISTINCT from_address) as user_cnt,
sum(tx_cnt) over (order by date asc ) as cum_tx_cnt,
sum(user_cnt) over (order by date asc) as cum_user_cnt
from ethereum.core.fact_transactions
where to_address in (lower('0x3ee18b2214aff97000d974cf647e7c347e8fa585'))
and origin_function_signature = '0xc6878519'
and chain_id = '1'
and date >= '2022-10-01'
group by 1,2,3
union all
select BLOCK_TIMESTAMP::date as date,
'Ethereum -> Solana' as type, substring(INPUT_DATA, 202, 1) as chain_id,
count(DISTINCT tx_hash) as tx_cnt,
count(DISTINCT from_address) as user_cnt,
sum(tx_cnt) over (order by date asc ) as cum_tx_cnt,
sum(user_cnt) over (order by date asc) as cum_user_cnt
from ethereum.core.fact_transactions
where to_address in (lower('0x3ee18b2214aff97000d974cf647e7c347e8fa585'))
and origin_function_signature in ( '0x0f5287b0','0x9981509f')
and chain_id = '1'
and date >= '2022-10-01'
group by 1,2,3
Run a query to Download Data