barbodbtc
Updated 2022-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
Select
block_timestamp:: date as date,
count(distinct inner_instruction:instructions[0]:parsed:info:source) as unique_wallets_number,
sum(inner_instruction:instructions[1]:parsed:info:amount/1e6) as btc_amount
From Solana.events
Where
block_timestamp:: date >= '2022-01-28'
and index=1
And INSTRUCTION:programId = 'VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp'
and POSTTOKENBALANCES[1]:mint = '3BjcHXvyzMsjmeqE2qFLx45K4XFx3JPiyRnjJiF5MAHt'
and INNER_INSTRUCTION:instructions[1]:parsed:type = 'transfer'
and SUCCEEDED = 'TRUE'
GROUP BY 1
Run a query to Download Data