PROGRAM_ID | ADDRESS_NAME | TOTAL_ROYALTIES_SOL | ROYALTIES_USD | SALES | DISTINCT_SELLERS | DISTINCT_PURCHASERS | |
|---|---|---|---|---|---|---|---|
1 | M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K | magiceden v2 program | 887.191180613 | 139875.502638251 | 11569 | 5005 | 4710 |
2 | TSWAPaqyCSx2KABk68Shruf4rp7CxcNi8hAsbdwmHbN | tensorswap program | 432.298209865 | 71168.674163706 | 6469 | 1877 | 2738 |
3 | mmm3XBJg5gk8XJxEKBvdgptZz6SgK4tXvn36sodowMc | mmm | 334.100158596 | 55037.684698241 | 5432 | 2238 | 1029 |
4 | SNPRohhBurQwrpwAptw1QYtpFdfEKitr4WSJ125cN1g | sniper market | 1.25955 | 180.635202102 | 16 | 12 | 14 |
LittlerDataGIgabuds sales by platform
Updated 2025-02-24
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
›
⌄
-- forked from GIgabuds sales copy copy @ https://flipsidecrypto.xyz/studio/queries/89c5dd22-c730-444c-9ed5-cd909da2ec0a
-- forked from GIgabuds sales copy @ https://flipsidecrypto.xyz/studio/queries/82553174-7137-4afe-b8f2-a4b4aef146cd
with gigabuds_addresses as (
select
address as mint
from solana.core.dim_labels
where 1=1
and address_name = 'gigabuds token'
and label = 'gigabuds'
),
avg_sol_price as (
SELECT
hour::date AS date
,symbol
,ROUND(AVG(price), 6) AS avg_sol_price
FROM solana.price.ez_prices_hourly
where hour > '2024-06-26'
and token_address = 'So11111111111111111111111111111111111111112'
group by 1, 2
),
sales as (
select
tx_id
,block_timestamp
,program_id
,address_name
,purchaser
,seller
from solana.nft.fact_nft_sales as sales
join gigabuds_addresses using (mint)
left join solana.core.dim_labels on sales.program_id = solana.core.dim_labels.address
where block_timestamp > '2024-06-26'
Last run: 18 days ago
4
427B
44s