yasmindaily VOLUME copy copy copy
Updated 2024-10-29
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
›
⌄
-- forked from daily VOLUME copy copy @ https://flipsidecrypto.xyz/studio/queries/cc2873ea-64f3-43a4-b3a2-fca3472df453
-- forked from daily VOLUME copy @ https://flipsidecrypto.xyz/studio/queries/cd63aee9-cf76-46f1-beff-e817d75e650e
WITH net_flows AS (
SELECT
DATE_TRUNC('week', block_timestamp) as week,
COALESCE(SUM(CASE WHEN TO_ADDRESS = '0x22e229d14dc80a1ea7ca7637173e8c6c36d60fe8' THEN AMOUNT ELSE 0 END), 0) AS total_deposit,
COALESCE(SUM(CASE WHEN FROM_ADDRESS = '0x22e229d14dc80a1ea7ca7637173e8c6c36d60fe8' THEN AMOUNT ELSE 0 END), 0)*-1 AS total_withdrawal,
LOWER(contract_address) AS token_address,
CASE
WHEN LOWER(contract_address) = '0x420fca0121dc28039145009570975747295f2329' THEN 'Coq'
WHEN LOWER(contract_address) = '0xf99516bc189af00ff8effd5a1f2295b67d70a90e' THEN 'Art'
WHEN LOWER(contract_address) = '0x5ac04b69bde6f67c0bd5d6ba6fd5d816548b066a' THEN 'Tech'
WHEN LOWER(contract_address) = '0x184ff13b3ebcb25be44e860163a5d8391dd568c1' THEN 'Kimbo'
WHEN LOWER(contract_address) = '0x8ad25b0083c9879942a64f00f20a70d3278f6187' THEN 'MeowCat'
WHEN LOWER(contract_address) = '0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5' THEN 'Nochill'
WHEN LOWER(contract_address) = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e' THEN 'USDC Token'
WHEN LOWER(contract_address) = '0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7' THEN 'USDt Token'
WHEN LOWER(contract_address) = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b' THEN 'PHARAOH'
WHEN LOWER(contract_address) = '0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd' THEN 'JOE Token'
WHEN LOWER(contract_address) = '0x60781c2586d68229fde47564546784ab3faca982' THEN 'PNG'
WHEN LOWER(contract_address) = '0x18e3605b13f10016901eac609b9e188cf7c18973' THEN 'HEFE'
ELSE 'Unknown Token'
END AS token_name
FROM avalanche.core.ez_token_transfers
WHERE
LOWER(contract_address) IN (
'0x420fca0121dc28039145009570975747295f2329', -- coq
'0xf99516bc189af00ff8effd5a1f2295b67d70a90e', -- art
'0x5ac04b69bde6f67c0bd5d6ba6fd5d816548b066a', -- tech
'0x184ff13b3ebcb25be44e860163a5d8391dd568c1', -- kimbo
'0x8ad25b0083c9879942a64f00f20a70d3278f6187', -- MeowCat
'0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5', -- nochill
'0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e', -- USDC Token
'0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7', -- USDt Token
QueryRunArchived: QueryRun has been archived