Flipside Community[FFF] Inflows sources (7D)
Updated 2024-05-10
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
›
⌄
-- Famous Fox Federation 7-Day Revenue Streams
-- Original author: alkine
-- Original query: https://flipsidecrypto.xyz/Alkine/q/Dr6ILY4TLPCJ/fff-inflows-sources-7d
-- Original dashboard: https://flipsidecrypto.xyz/Alkine/fff-dashboard-fff-dashboard-lndNg1
-- get all the copper burnt by day
with
ffflip as (
SELECT
sum(amount) as sol,
'ffflip' as label
FROM
solana.core.fact_transfers
WHERE
BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '7 days')
AND BLOCK_TIMESTAMP <= CURRENT_DATE
-- SOL sent here is revenue from ffflip
AND TX_TO = 'Fz2tay9wmAhaz1GuEETorL55LBMECaT85DX9Tj5zqQKb'
AND AMOUNT >= 0
AND AMOUNT <= 0.3
AND mint = 'So11111111111111111111111111111111111111112'
),
raffles as (
SELECT
sum(amount) as sol,
'raffles' as label
FROM
solana.core.fact_transfers
WHERE
BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '7 days')
AND BLOCK_TIMESTAMP < CURRENT_DATE
-- SOL sent here is revenue from ff raffles
AND tx_to = 'GFDko6sYw96a3nUmPqNLZwq7YstQ1u1SNUaVhnoCPW7o'
AND MINT = 'So11111111111111111111111111111111111111112'
),
royalties as (
QueryRunArchived: QueryRun has been archived