LTirrellML Base -- Volume Spike copy
Updated 2023-04-28
999
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 ML Base -- Volume Spike @ https://flipsidecrypto.xyz/edit/queries/565bfd32-7713-4abe-8a99-1e79cc78b11f
-- -- forked from anduril / ML Base -- Volume Spike @ https://flipsidecrypto.xyz/anduril/q/ml-base-sales-total-daily-rE0xWL
-- -- forked from LTirrell / ML Base -- sales Total Daily @ https://flipsidecrypto.xyz/LTirrell/q/ml-base-sales-SQMfsW
-- -- forked from ML Base -- sales @ https://flipsidecrypto.xyz/edit/queries/66990db6-668c-4d46-89fb-86cd8473c33d
-- -- forked from anduril / ML Base @ https://flipsidecrypto.xyz/anduril/q/2023-04-22-09-28-pm-lVxzpW
select
date_trunc('day', block_timestamp),
sum(sales_amount)
from
solana.core.fact_nft_sales
where
date_trunc('day', block_timestamp) > '2023-04-01'
group by
date_trunc('day', block_timestamp)
-- with
-- ml_raw as (
-- select
-- signers[0] as collector,
-- signers[2] as mint,
-- fee / pow(10, 9) as fee,
-- amount -- in sol
-- from
-- solana.core.fact_transactions
-- inner join solana.core.fact_transfers t using (tx_id)
-- where
-- date(block_timestamp) >= '2023-04-19'
-- and signers[1] = '2RtGg6fsFiiF1EQzHqbd66AhW7R5bWeQGpTbv2UMkCdW'
-- and t.tx_to = '2RtGg6fsFiiF1EQzHqbd66AhW7R5bWeQGpTbv2UMkCdW'
-- and mint = 'So11111111111111111111111111111111111111112'
-- ),
-- sol_price as (
-- select
-- recorded_hour,
-- close as price
-- from
Run a query to Download Data