Updated 2024-07-01
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
›
⌄
with eth as (
SELECT
count(distinct USER_ADDRESS) as eth_count
from
ethereum.core.fact_token_balances
where
CONTRACT_ADDRESS = lower('0xe3c408BD53c31C085a1746AF401A4042954ff740')
),
solana_swaps as (
select
count(distinct SWAPPER) as swapper_count
from
solana.defi.ez_dex_swaps
where
SWAP_TO_SYMBOL like '%GMT%'
),
solana_transaction as (
select
*
from
solana.core.fact_transactions
where
account_keys [0] = '7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
)
select
*
from
solana_transaction