datavortexTop bridged token to aptos
Updated 2024-12-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH top_tokens_to_aptos AS (
SELECT
token_address,
ANY_VALUE(symbol) AS symbol,
COUNT(DISTINCT tx_hash) AS "Bridges To Aptos Count"
FROM
aptos.defi.ez_bridge_activity
WHERE
DATE_TRUNC('month', block_timestamp) = DATE_TRUNC('month', CURRENT_DATE)
AND destination_chain = 'Aptos'
GROUP BY
token_address
)
SELECT
token_address,
symbol,
"Bridges To Aptos Count"
FROM
top_tokens_to_aptos
ORDER BY
"Bridges To Aptos Count" DESC
LIMIT 5;
QueryRunArchived: QueryRun has been archived