PLATFORM_NAME | TRANSACTIONS | USERS | VOLUME_USD | AVERAGE_AMOUNT_USD | MAX_AMOUNT_USD | |
|---|---|---|---|---|---|---|
1 | Paras | 1694 | 328 | 55154.295777998 | 32.558616162 | 1785.6 |
2 | Mitte | 7448 | 263 | 110020.033191364 | 9.496765921 | 1118.951131198 |
3 | Apollo42 | 1 | 1 | 0.09756 | 0.09756 | 0.09756 |
4 | FewAndFar | 26 | 7 | 2628.92265261 | 11.234712191 | 31.972640195 |
5 | TradePort | 1025 | 308 | 39825.650331465 | 38.854293006 | 721.358999245 |
6 | Mintbase | 668 | 136 | 9908.952043211 | 14.833760544 | 602.186294322 |
Afonso_Diazby platform
Updated 6 days ago
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
›
⌄
with
main as (
select
distinct iff(direction = 'inbound', destination_address, source_address) as user
from near.defi.ez_bridge_activity
where platform = 'rainbow'
and receipt_succeeded = 1
and block_timestamp between '{{ start_date }}' and '{{ end_date }}'
),
txns as (
select
tx_hash,
block_timestamp,
nft_address,
platform_name,
seller_address,
buyer_address,
price_usd
from near.nft.ez_nft_sales
where buyer_address in (select user from main)
and block_timestamp >= '2024-01-01'
)
select
platform_name,
count(distinct tx_hash) as transactions,
count(distinct buyer_address) as users,
sum(price_usd) as volume_usd,
avg(price_usd) as average_amount_usd,
max(price_usd) as max_amount_usd
from txns
group by 1
Last run: 6 days ago
6
348B
106s