CHAIN | # of payments | Volume amount (USD) | |
|---|---|---|---|
1 | Ethereum | 26472 | 13032509.75 |
2 | Polygon | 7372 | 1092303.3079779 |
3 | Arbitrum | 924 | 102846.32 |
4 | Avalanche | 892 | 45981.12 |
5 | Optimism | 84 | 2246.01 |
adriaparcerisasSunloan payments 3: all
Updated 2024-01-30
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
eth_data as (
select
'ETH' as symbol,
amount,
amount_usd,
block_timestamp,
tx_hash
from ethereum.core.ez_eth_transfers
where origin_to_address = lower('0xEF0B56692F78A44CF4034b07F80204757c31Bcc9')
and eth_from_address='0xef0b56692f78a44cf4034b07f80204757c31bcc9'
UNION
select
symbol,
amount,
amount_usd,
block_timestamp,
tx_hash
from ethereum.core.ez_token_transfers
where origin_to_address = lower('0xEF0B56692F78A44CF4034b07F80204757c31Bcc9')
and from_address = lower('0xEF0B56692F78A44CF4034b07F80204757c31Bcc9')
),
eth as (
SELECT
count(distinct tx_hash) as "# of payments",
sum(amount_usd) as "Volume amount (USD)"
from eth_data where amount_usd is not NULL
and amount<1e9
and block_timestamp >=current_date-INTERVAL '{{number_of_months}} MONTHS'
),
poly_data as (
select
'MATIC' as symbol,
amount,
Last run: about 1 year agoAuto-refreshes every 3 hours
5
143B
181s