zyroqbridge compare
Updated 2024-12-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
'solana' AS chain,
SUM(CASE WHEN destination_chain = 'solana' THEN amount_usd ELSE 0 END) AS inflow,
SUM(CASE WHEN SOURCE_CHAIN = 'solana' THEN amount_usd ELSE 0 END) AS outflow,
COUNT(DISTINCT tx_hash) AS transactions,
COUNT(DISTINCT source_address) AS users
FROM
crosschain.defi.ez_bridge_activity
WHERE
blockchain = 'solana'
AND block_timestamp > CURRENT_DATE - INTERVAL '{{trading_period}} days'
GROUP BY
date
QueryRunArchived: QueryRun has been archived