jackguywAssets impact transfer volumes on Axelar
Updated 2023-04-29
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
›
⌄
--SELECT
-- date_trunc('day', block_timestamp) as day,
-- sum(amount / power(10, decimal)) as matic_volume,
-- COUNT(DISTINCT tx_id) as transfers
--FROM axelar.core.fact_transfers
--WHERE CURRENCY LIKE 'wmatic-wei'
--AND receiver LIKE 'osmo%'
--GROUP by 1
SELECT
*,
sum(volume_matic) over (ORDER by day) as cume_bridge_volume
FROM (
SELECT
date_trunc('day', block_timestamp) as day,
sum(amount / power(10, decimal)) as volume_matic,
COUNT(DISTINCT RECEIVER) as bridgers
FROM osmosis.core.fact_transfers
LEFT outer JOIN osmosis.core.dim_labels
ON address = currency
WHERE project_name LIKE '%MATIC%'
AND sender LIKE 'axelar%'
AND receiver LIKE 'osmo%'
GROUP BY 1
)
--LIMIT 100
Run a query to Download Data