commanderjoseph-761gwXsUSD Total Deposit
Updated 2024-11-13
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
total
AS
(
SELECT
block_timestamp,
signers[0] AS depositor,
value:parsed:info:authority:: string AS user,
value:parsed:info:tokenAmount:uiAmount :: int AS amount,
tx_id
FROM
solana.core.fact_events,
LATERAL FLATTEN (input => inner_instruction:instructions )
WHERE
program_id = 's1aysqpEyZyijPybUV89oBGeooXrR22wMNLjnG2SWJA' --sUSD PROGRAM
--tx_id = '2QWVd2dmi3RY46cqywnwaymckVhDdp5rMt34CZQckQBvcoxWaT26ZaejqGhmHpKZQKXQpj3GgRktkdL9cuU7CKY4'
AND
value:parsed:type:: string = 'transferChecked'
AND
value:parsed:info:mint::string = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC
AND
succeeded = 'TRUE'
AND
depositor != 'AxnDY6nekRa4hEY1rm1g11A51EPPU29iAXXxh8vAqpM8'
AND
user != 'FhVcYNEe58SMtxpZGnTu2kpYJrTu2vwCZDGpPLqbd2yG'
--AND
--block_timestamp > CAST('2024-10-29'AS TIMESTAMP)
)
SELECT
COUNT(DISTINCT depositor) AS total_depositor,
SUM(amount) AS total_amount_deposited,
COUNT(DISTINCT tx_id) AS tottal_deposits
FROM
total
QueryRunArchived: QueryRun has been archived