dannyamahDaily Deposit Volume
Updated 2024-11-25
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
›
⌄
-- forked from chispas / Interval 24hr Deposits Parcl v3 @ https://flipsidecrypto.xyz/chispas/q/qQfBCDPm_dz0/interval-24hr-deposits-parcl-v3
SELECT
DATE_TRUNC('day', block_timestamp) AS DATE,
SUM(
CASE
WHEN tx_to = '82dGS7Jt4Km8ZgwZVRsJ2V6vPXEhVdgDaMP7cqPGG1TW' THEN amount
ELSE - amount
END
) AS usd_deposit_vol
FROM
solana.core.fact_transfers
WHERE
(
tx_to = '82dGS7Jt4Km8ZgwZVRsJ2V6vPXEhVdgDaMP7cqPGG1TW' -- LP address
OR tx_from = '82dGS7Jt4Km8ZgwZVRsJ2V6vPXEhVdgDaMP7cqPGG1TW'
)
AND mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC only
AND date(block_timestamp) >= '2023-11-01'
GROUP BY
date
ORDER BY
date DESC
QueryRunArchived: QueryRun has been archived