commanderjoseph-761gwXBase Bridges Market Share
Updated 2024-10-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
⌄
SELECT
DATE_TRUNC('month', block_timestamp) AS transaction_date,
SUM(amount_usd) AS Bridge_Volume,
platform AS bridges,
COUNT(DISTINCT tx_hash) AS bridge_transactions,
COUNT(DISTINCT origin_from_address) AS bridger
/*COUNT(DISTINCT origin_from_address) AS bridger,
COUNT(DISTINCT tx_hash) AS bridge_transactions,
COUNT(DISTINCT destination_chain) AS destination_chain,
COUNT(DISTINCT token_address) AS token_bridged,
COUNT(DISTINCT platform) AS bridges*/
FROM
base.defi.ez_bridge_activity
GROUP
BY
platform,transaction_date
ORDER
BY
transaction_date
DESC
QueryRunArchived: QueryRun has been archived