Eman-RazTop Sources By Volume
Updated 2024-07-09
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 final_table as (
-----------------------------------------------------------gmp--------------------------------------------------------------
with gmp as (with tab1 as (select date_trunc('hour',created_at) as date, id, call:transaction:from as user,
call:chain as source_chain, lower(call:returnValues:destinationChain) as destination_chain, amount,
call:returnValues:symbol as symbol, case
when call:returnValues:symbol='ARB' then '0xb50721bcf8d664c30412cfbc6cf7a15145234ad1'
when call:returnValues:symbol='axlARB' then '0xb50721bcf8d664c30412cfbc6cf7a15145234ad1'
when call:returnValues:symbol='APE' then '0x4d224452801aced8b2f0aebe155379bb5d594381' --
when call:returnValues:symbol='ARX' then '0x7d8daff6d70cead12c6f077048552cf89130a2b1'
when call:returnValues:symbol='AXL' then '0x467719ad09025fcc6cf6f8311755809d45a5e5f3'
when call:returnValues:symbol='BAL' then '0xba100000625a3754423978a60c9317c58a424e3d'
when call:returnValues:symbol='axlBAL' then '0xba100000625a3754423978a60c9317c58a424e3d'
-----------------------------------------------------------------
when call:returnValues:symbol='BUSD' then '0xdac17f958d2ee523a2206206994597c13d831ec7'
when call:returnValues:symbol='axlBUSD' then '0xdac17f958d2ee523a2206206994597c13d831ec7'
when call:returnValues:symbol='AvalancheUSDC' then '0xdac17f958d2ee523a2206206994597c13d831ec7' --
when call:returnValues:symbol='PolygonUSDC' then '0xdac17f958d2ee523a2206206994597c13d831ec7' --
when call:returnValues:symbol='DAI' then '0xdac17f958d2ee523a2206206994597c13d831ec7'
when call:returnValues:symbol='USDC' then '0xdac17f958d2ee523a2206206994597c13d831ec7'
when call:returnValues:symbol='USDT' then '0xdac17f958d2ee523a2206206994597c13d831ec7'
when call:returnValues:symbol='axlUSDC' then '0xdac17f958d2ee523a2206206994597c13d831ec7'
when call:returnValues:symbol='axlUSDT' then '0xdac17f958d2ee523a2206206994597c13d831ec7'
when call:returnValues:symbol='FRAX' then '0xdac17f958d2ee523a2206206994597c13d831ec7' --
when call:returnValues:symbol='sFRAX' then '0xdac17f958d2ee523a2206206994597c13d831ec7'
when call:returnValues:symbol='axlFRAX' then '0xdac17f958d2ee523a2206206994597c13d831ec7'
when call:returnValues:symbol='axlDAI' then '0xdac17f958d2ee523a2206206994597c13d831ec7'
when call:returnValues:symbol='cUSD' then '0xdac17f958d2ee523a2206206994597c13d831ec7'
-----------------------------------------------------------------
when call:returnValues:symbol='wstETH' then '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
when call:returnValues:symbol='sfrxETH' then '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
when call:returnValues:symbol='rETH' then '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
when call:returnValues:symbol='frxETH' then '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
when call:returnValues:symbol='YieldETH' then '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
when call:returnValues:symbol='axlYieldETH' then '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' --
when call:returnValues:symbol='axl-wstETH' then '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
when call:returnValues:symbol='WETH' then '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived