walemathsTransaction Volume
Updated 2024-07-11
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
›
⌄
WITH unique_transfers AS (
SELECT
DISTINCT
BLOCK_TIMESTAMP,
TX_HASH,
SOURCE_CHAIN,
SENDER,
DESTINATION_CHAIN,
RECEIVER,
TOKEN_ADDRESS,
TOKEN_SYMBOL,
AMOUNT
FROM
axelar.defi.ez_bridge_satellite
)
SELECT
COUNT(DISTINCT TX_HASH) AS total_transactions,
COUNT(DISTINCT SENDER) AS unique_senders,
COUNT(DISTINCT RECEIVER) AS unique_receivers,
ROUND(SUM(CASE WHEN TOKEN_SYMBOL ILIKE '%usd%' THEN AMOUNT ELSE 0 END), 2) AS stablecoin_volume
FROM
unique_transfers;