hessTop Routes Based on Volume
Updated 2024-10-10
999
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
›
⌄
with from_address as (sELECT VALUE as source_chain,
created_at,
id,
amount as amount_column,
FROM axelar.axelscan.fact_gmp,
LATERAL FLATTEN(PARSE_JSON(call)) flattened_data
where path = 'chain'
)
,
sender as (SELECT a.created_at,
a.id,
b.source_chain,
max(amount_column) as amt_column,
max(value:"amount") as amount,
max(value:"destinationChain") as destination_chain,
max(value:"symbol") as symbol,
max(value:"from") as sender
FROM axelar.axelscan.fact_gmp a join from_address b on a.id = b.id,
LATERAL FLATTEN(PARSE_JSON(call)) flattened_data
group by all
)
,
fee as (SELECT a.id,
a.created_at as date_ii,
max(value:"decimals") as decimal,
max(value:"name") as name,
max(value:"symbol") as symbol_II,
max(value:"value") as amount_II,
max(value:"token_price") as token_price
FROM axelar.axelscan.fact_gmp a join from_address b on a.id = b.id,
LATERAL FLATTEN(PARSE_JSON(FEES)) flattened_data
where path = 'source_token' --source_token
group by all)
,
final as (select a.created_at,
case when symbol ilike '%usdc%' then 'USDC'
QueryRunArchived: QueryRun has been archived