elsina2024-07-08: single numbers
Updated 2024-07-08
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
COUNT(DISTINCT tx_hash) AS total_transaction_count,
COUNT(DISTINCT origin_from_address) AS unique_trader_count,
SUM(amount_in_usd) AS total_transaction_volume,
total_transaction_count / unique_trader_count AS average_transactions_per_user,
total_transaction_volume / unique_trader_count AS average_volume_per_user,
total_transaction_volume / total_transaction_count AS average_volume_per_transaction
FROM
arbitrum.defi.ez_dex_swaps
QueryRunArchived: QueryRun has been archived