Aephiacore_addresses
Updated 2022-11-27
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
›
⌄
SELECT
*
--date_trunc('day', block_timestamp::date) as date,
--block_timestamp,
--sum(case when mint = '4Rrcj4MArUcMtHPp6amTy3SUXbCGYG3n8sf8KgMKjRnr'
-- THEN zeroifnull(amount)end) as core_ep1_SA,
FROM solana.core.fact_transfers
WHERE tx_from != 'MRKT9mCmNU2R4KnZt9BV5uh9MESj7Phxws4AR7fUhRc'
AND tx_to != 'MRKT9mCmNU2R4KnZt9BV5uh9MESj7Phxws4AR7fUhRc'
AND tx_from != 'M1NTq6mJnYhyhRe1ZRum1v54AqHmvo4mYYGk7tcFcHn'
AND tx_from != '889rGYFb9BwxZj2V6ZcUSaa5xBXdhEcC1NgNeg17wTmH'
--instructions[0]:programId::string = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'
--AND succeeded = 'true'
AND mint = '4Rrcj4MArUcMtHPp6amTy3SUXbCGYG3n8sf8KgMKjRnr'
--AND tx_id = '34sxU6KqTxc9eq9uBKvdPNQfXLYWxAhiywKE2XoAjr9TrPGYQiEmCjvo3nYuczJRsneQmGy5hekCP7RdkobUh3Gk'
AND block_timestamp > '2022-11-07'-- and block_timestamp < '2022-11-19'
--Group BY 1--,2
--ORDER BY 1 DESC
--limit 100
Run a query to Download Data