Eman-RazVolume of Interchain Transfers By Route Over Time
Updated 2024-09-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with tab1 as (select date_trunc('day',created_at) as "Date", sum(amount) as "Volume ($RMRK)",
call:chain || '➡' || call:returnValues:destinationChain as "Route"
from axelar.axelscan.fact_gmp
where call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%'
and (data:executed:receipt:logs[1]:address='0x524d524b4c9366be706d3a90dcf70076ca037ae3'
or data:executed:receipt:logs[1]:address=lower('0xECf2ADafF1De8A512f6e8bfe67a2C836EDb25Da3'))
group by 1,3),
tab2 as (select hour::date as "Date", avg(price) as avg_price
from base.price.ez_prices_hourly
where token_address='0x524d524b4c9366be706d3a90dcf70076ca037ae3'
group by 1
order by 1)
select DATE_TRUNC('{{Time_Frame}}',tab1."Date") as "Date", SUM("Volume ($RMRK)") AS "Volume ($RMRK)",
SUM("Volume ($RMRK)"*avg_price) as "Volume ($USD)", "Route"
FROM TAB1 LEFT JOIN TAB2 ON TAB1."Date"=tab2."Date"
where tab1."Date" between '{{Start_Date}}' and '{{End_Date}}'
GROUP BY 1,4
order by 1
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived