ValiMohammadiIncentived/pre Incentived wBNB
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
›
⌄
11-- wBNB
SELECT
* FROM (
SELECT
CASE
when block_timestamp >= '2022-11-14' then 'Incentived'
when block_timestamp < '2022-11-14' 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/F4A070A6D78496D53127EA85C094A9EC87DFC1F36071B8CCDDBD020F933D213D'
-- currency info FROM https://docs.osmosis.zone/osmosis-core/asset-info/
GROUP BY datee,period
)
Run a query to Download Data