greyswantrading share of NFTfi
Updated 2023-08-31
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 NFT_fi_users as (
select
distinct date_trunc('month', block_timestamp) as week,
signers [0] as user
from
solana.core.fact_events
where
program_id in (
'SHARKobtfF1bHhxD2eqftjHBdVSCbKo9JtgK71FhELP',
'A66HabVL3DzNzeJgcHYtRRNW1ZRMKwBfrdSR4kLsZ9DJ',
'4tdmkuY6EStxbS6Y8s5ueznL3VPMSugrvQuDeAHGZhSt',
'JCFRaPv7852ESRwJJGRy2mysUMydXZgVVhrMLmExvmVp',
'RainEraPU5yDoJmTrHdYynK9739GkEfDsE4ffqce2BR'
) --sharky, frakt_old, frakt_bonds, citrus, rain
and block_timestamp > CURRENT_DATE - 90
AND succeeded = 'TRUE'
),
weekly_volumes as (
select
date_trunc('month', block_timestamp) as week,
sum(sales_amount) as total_volume
from
solana.nft.fact_nft_sales
where
succeeded = 'TRUE'
and marketplace='tensorswap'
group by
date_trunc('month', block_timestamp)
),
volumes_by_nftfi as (
select
week,
sum (sales_amount) as nftfi_volume
from
NFT_fi_users
left join solana.nft.fact_nft_sales on user = seller
Run a query to Download Data