yasmin ava1 copy
Updated 2024-07-18
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 inflow AS (
SELECT
date_trunc('day', block_timestamp) AS day,
count(TX_HASH) AS tx,
count(DISTINCT sender) AS users,
sum(
CASE
WHEN TOKEN_ADDRESS IN (
'0xeb466342c4d449bc9f53a865d5cb90586f405215',
'0x4268b8f0b87b6eae5d897996e6b845ddbd99adf3',
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',
'0x750e4c4984a9e0f12978ea6742bc1c5d248f40ed',
'0xfab550568c688d5d8a52c7d794cb93edc26ec0ec'
) THEN amount
ELSE 0
END
) AS volume -- axlUSDC USDC
FROM axelar.defi.ez_bridge_squid
WHERE DESTINATION_CHAIN LIKE 'avalanche'
AND block_timestamp::date >= '{{Start_Date}}' AND block_timestamp::date <= '{{End_Date}}'
GROUP BY 1
),
outflow AS (
SELECT
date_trunc('day', block_timestamp) AS day,
count(TX_HASH) AS tx,
count(DISTINCT sender) AS users,
sum(
CASE
WHEN TOKEN_ADDRESS IN ('0xfab550568c688d5d8a52c7d794cb93edc26ec0ec') THEN amount
ELSE 0
END
) AS volume -- axlUSDC
FROM axelar.defi.ez_bridge_squid
QueryRunArchived: QueryRun has been archived