ValiMohammadiout of osmo weekly
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS days,
SUM(amount / 1e18) AS transfer_amount,
COUNT(*) AS number_of_tranfers,
currency AS currency_transfer
FROM
axelar.core.fact_transfers
WHERE
currency IN ('wbnb-wei', 'wmatic-wei', 'wavax-wei', 'weth-wei')
AND sender LIKE 'osmo%'
GROUP BY
currency_transfer,
days
Run a query to Download Data