ValiMohammadiIncentived/pre Incentived wMatic
Updated 2023-02-15
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
›
⌄
-- wMatic
SELECT
* FROM (
SELECT
CASE
when block_timestamp >= '2022-12-19' then 'Incentived'
when block_timestamp < '2022-12-19' then 'pre Incentived'
end AS period,
date_trunc('day', block_timestamp) as datee,
sum(amount) / pow(10, 18) AS volume,
COUNT(DISTINCT TX_ID) AS transactions,
count(DISTINCT receiver) AS bridgers
FROM
osmosis.core.fact_transfers
WHERE
sender LIKE 'axelar%'
AND receiver LIKE 'osmo%'
AND currency = 'ibc/AB589511ED0DD5FA56171A39978AFBF1371DB986EC1C3526CE138A16377E39BB'
-- currency info FROM https://docs.osmosis.zone/osmosis-core/asset-info/
GROUP BY datee,period
)
Run a query to Download Data