KaskoazulGraph visualization
Updated 2022-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select case marketplace
when 'magic eden v1' then 'magic eden'
when 'magic eden v2' then 'magic eden'
else marketplace
end as source,
purchaser as target,
project_name
--block_timestamp
from solana.core.fact_nft_sales s
left join solana.core.dim_nft_metadata m
on s.mint = m.mint
where block_timestamp >= '2022-10-01' and block_timestamp < CURRENT_DATE - 1--project_name = 'ABC'
and source in ('coral cube', 'hyperspace', 'hadeswap')
and project_name != ''
and succeeded = True
order by 1 desc
Run a query to Download Data