elsinaAXL trasnfer to Osmosis
Updated 2022-12-02
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
›
⌄
select
date_trunc('day', BLOCK_TIMESTAMP) as "Day",
sum(AMOUNT / power(10, 6)) as volume,
avg(AMOUNT / power(10, 6)) as avg_transfer_size,
sum(volume) over (order by "Day") as total_transfer_size
from axelar.core.fact_transfers
where "Day" > '2022-09-26' and TRANSFER_TYPE = 'IBC_TRANSFER_OUT' and CURRENCY = 'uaxl' and RECEIVER like 'osmo%' and TX_SUCCEEDED = true
group by "Day"
order by "Day"
-- with tab1 as (
-- SELECT
-- tx_id as tx,
-- attribute_value as to_chain
-- FROM axelar.core.fact_msg_attributes
-- WHERE attribute_key = 'destinationChain' and TO_CHAIN = 'osmosis'
-- )
-- , tab2 as (
-- select
-- date_trunc('day', block_timestamp) as week,
-- attribute_value,
-- to_chain,
-- tx_id ,
-- count(DISTINCT tx_id) as events,
-- sum(cast(REPLACE(attribute_value, 'uaxl', '') as INT) / power(10, 6) ) as toke_amt
-- from axelar.core.fact_msg_attributes LEFT outer JOIN tab1 ON tx = tx_id
-- WHERE msg_type LIKE 'coin_spent' and attribute_value LIKE '%uaxl%'
-- AND attribute_index = 1
-- AND to_chain is not NULL
-- GROUP BY 1 ,2,3,4
-- )
-- select * from tab2 limit 10
-- -- , tab3 as (
-- -- SELECT
-- -- date_trunc('day', RECORDED_HOUR) as week2,
-- -- symbol,
-- -- median(open) as price
Run a query to Download Data