datavortexbridges
Updated 2024-12-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH usdt_bridge_2024 AS (
SELECT
COUNT(DISTINCT sender) AS "USDT Bridgers 2024",
COUNT(DISTINCT tx_hash) AS "Total USDT Bridges 2024",
SUM(amount_unadj) / POWER(10, 6) AS "Total Volume Bridged 2024",
COUNT(DISTINCT DATE(block_timestamp)) AS "Total Days Bridged 2024"
FROM
aptos.defi.fact_bridge_activity
WHERE
token_address = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'
AND block_timestamp >= '2024-01-01' AND block_timestamp <= '2024-12-31'
),
usdt_bridge_2023 AS (
SELECT
COUNT(DISTINCT sender) AS "USDT Bridgers 2023",
COUNT(DISTINCT tx_hash) AS "Total USDT Bridges 2023",
SUM(amount_unadj) / POWER(10, 6) AS "Total Volume Bridged 2023",
COUNT(DISTINCT DATE(block_timestamp)) AS "Total Days Bridged 2023"
FROM
aptos.defi.fact_bridge_activity
WHERE
token_address = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'
AND block_timestamp >= '2023-01-01' AND block_timestamp <= '2023-12-31'
)
SELECT
b2023."USDT Bridgers 2023",
b2023."Total USDT Bridges 2023",
b2023."Total Volume Bridged 2023",
b2023."Total Days Bridged 2023",
b2024."USDT Bridgers 2024",
b2024."Total USDT Bridges 2024",
b2024."Total Volume Bridged 2024",
b2024."Total Days Bridged 2024",
(b2024."Total USDT Bridges 2024" / NULLIF(b2024."Total Days Bridged 2024", 0)) AS "Avg Bridges per Day 2024",
QueryRunArchived: QueryRun has been archived