CryptoIcicleSolana-Foundation-1.The Bridge from Ethereum to Solana - Top 3
Updated 2022-06-16
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
›
⌄
-- Q1. Create a visualization of the volume of assets being bridged from Ethereum to Solana over time via Wormhole.
-- What does the average profile / size of wallets bridging to Solana from Ethereum look like (what is the average value of assets being bridged over)?
-- What have been the most popular bridged assets from Ethereum to Solana and has that changed over time?
with
erc20_txns as (
select
t.block_timestamp,
tx_hash,
symbol,
t.to_address,
t.from_address,
amount_usd,
contract_address
from ethereum.core.ez_token_transfers t
where to_address = '0xf92cd566ea4864356c5491c177a430c222d7e678' -- Eth-Solana Bridge
),
eth_txns as (
select
t.block_timestamp,
tx_hash,
'ETH' as symbol,
t.ETH_TO_ADDRESS as to_address,
t.ETH_FROM_ADDRESS as from_address,
amount_usd,
'ETH' as contract_address
from ethereum.core.ez_eth_transfers t
where to_address = '0xf92cd566ea4864356c5491c177a430c222d7e678' -- Eth-Solana Bridge
)
select
date_trunc('month',block_timestamp) as date,
symbol,
count(distinct from_address) as n_wallets,
count(distinct tx_hash) as n_transfers,
Run a query to Download Data