jackguydexalot 2
Updated 2023-09-27
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
count(DISTINCT tx_hash) as bridge_events,
count(DISTINCT origin_from_address) as users,
SUM(CASE WHEN to_address LIKE lower('0x1fd108cf42a59c635bd4703b8dbc8a741ff834be') THEN AMOUNT_USD END) AS deposit_volume_usd,
SUM(CASE WHEN from_address LIKE lower('0x1fd108cf42a59c635bd4703b8dbc8a741ff834be') THEN AMOUNT_USD END) AS withdraw_volume_usd,
deposit_volume_usd - withdraw_volume_usd as net_deposit_usd,
deposit_volume_usd + withdraw_volume_usd as total_bridge_volume
FROM avalanche.core.ez_token_transfers
WHERE from_address LIKE lower('0x1fd108cf42a59c635bd4703b8dbc8a741ff834be')
OR to_address LIKE lower('0x1fd108cf42a59c635bd4703b8dbc8a741ff834be')
Run a query to Download Data