andurilPayments/Commerce Data - Programs and Transfers
Updated 2024-11-12
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
›
⌄
with programs_agg as (
select
date_trunc('month',block_timestamp) as month,
CASE
when program_id in (
'ENicYBBNZQ91toN7ggmTxnDGZW14uv9UkumN7XBGeYJ4',
'3KPRuKWxV6PtneZXbokMBwdF4T9brCFx7FcmKJ2tPqqt') then 'Helio'
when program_id = 'FD1amxhTsDpwzoVX41dxp2ygAESURV2zdUACzxM1Dfw9' then 'Coinflow'
else 'Unknown' end as label,
count(distinct tx_id) as txs,
count(distinct signers[0]) as wallets
from
solana.core.fact_events
where
month between '2023-01-01' and date_trunc('month', current_date())
and succeeded
and program_id in
(
'ENicYBBNZQ91toN7ggmTxnDGZW14uv9UkumN7XBGeYJ4',
'3KPRuKWxV6PtneZXbokMBwdF4T9brCFx7FcmKJ2tPqqt',
'FD1amxhTsDpwzoVX41dxp2ygAESURV2zdUACzxM1Dfw9'
)
group by
month,label
),
transfers_agg as (
select
date_trunc('month', block_timestamp) as month,
case when tx_from = 'DhEsUaJkT1DzkFUWLCkU21VruJQZk1es4zBRhU9QjK9R' then 'Stripe'
when tx_from = 'Ffreyan5HfFkzZi8ACDYQs4KH7hURmzeJAWHrcpggnUe' then 'Sphere'
else 'Unknown' end as label,
count(distinct tx_id) as txs,
count(distinct tx_to) as wallets
from
QueryRunArchived: QueryRun has been archived