Afonso_Diaz2023-08-16 03:53 PM
Updated 2023-08-16
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
t1 as (
select
block_timestamp::date as day,
avg(sales_amount) as price_usd
from solana.core.fact_nft_sales
where tx_id = '3nLPHbSt6dLRqBtFtifc42eMLsbveSS6A6NZE4gZTAbKZo5ngnasNbbDufhWid3UD743X8386iZtgNgRjd7cAvhi'
group by 1
),
t2 as (
select * from (values
(date('2023-08-08'), 1.46),
(date('2023-08-09'), 1.73),
(date('2023-08-10'), 1.73),
(date('2023-08-11'), 1.89),
(date('2023-08-12'), 2.58),
(date('2023-08-13'), 2.6),
(date('2023-08-14'), 2.35),
(date('2023-08-15'), 1.98)
) as t(date, price_sol)
),
t3 as (
select
tx_id,
block_timestamp,
1.69 as amount_sol,
signers[0] as minter,
10 as burned_shards,
burned_shards * price_sol as burned_amount_sol
from solana.core.fact_events a
join t2 on date = a.block_timestamp::date
where instruction:accounts[8] = '5PA96eCFHJSFPY9SWFeRJUHrpoNF5XZL6RrE1JADXhxf'
and instruction:accounts[13] = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
Run a query to Download Data