nsa2000Daily variation of Kamino transactions
Updated 2022-10-10Copy Reference Fork
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
›
⌄
with kamino_program as (
SELECT
-- tr.signers
tx_id
, block_timestamp
, instruction:accounts[0] as user
from
solana.core.fact_events ev -- inner join solana.core.fact_transactions tr using(tx_id)
WHERE
-- address_name ilike '%Hubble %'
program_id = '6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc' -- Kamino
-- and instruction:accounts[0] != 'H5s8388JNiFMigoy5fhEEED5nB5i2UGPxh1Gh3cBvqQd'
-- and tx_id = '4VEyMHCskeLsYuTwnoxmfooAuvCvMXV2NrdQThXg8HLVKb9XHP6VNEkfrJR4ceWUs2wAR11r5tBhL4kitgYrRz7y'
and block_timestamp >= CURRENT_DATE - INTERVAL'3 months'
-- 1=1
-- limit 10
)
SELECT
distinct block_timestamp::date as DAY
, count(distinct tx_id) over (partition by DAY) as daily_kamino_usage
, count(distinct tx_id) over () as kamino_total_usage
from
kamino_program
Run a query to Download Data