LTirrellUntitled Query
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date_trunc(hour,block_timestamp) as hour,
count(distinct tx_from) as affected_wallets
from
solana.core.fact_transfers
where
date(block_timestamp) > '2022-08-01' and
tx_to in
('CEzN7mqP9xoxn2HdyW6fjEJ73t7qaX9Rp2zyS6hb3iEu',
'Htp9MGP8Tig923ZFY7Qf2zzbMUmYneFRAhSp7vSg4wxV',
'5WwBYgQG6BdErM2nNNyUmQXfcUnB68b6kesxBywh1J3n',
'GeEccGJ9BEzVbVor1njkBCCiqXJbXVeDHaXDCrBDbmuy')
group by 1
Run a query to Download Data