datasovrun2023-12-25 10:52 PM
Updated 2024-01-02
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 filtered as (
select *
from ethereum.nft.ez_nft_transfers
where nft_address = '0xd1258db6ac08eb0e625b75b371c023da478e94a9'
and block_timestamp <=
( dateadd('day', 10, (select min(block_timestamp) from ethereum.nft.ez_nft_transfers where nft_address = '0xd1258db6ac08eb0e625b75b371c023da478e94a9') ) )
)
, base as (
select nft_from_address AS addr
, 'from' as type
, count(*) as tokens_transferred
from filtered
group by 1
union
select nft_to_address AS addr
, 'to' as type
, count(*) AS tokens_transferred
from filtered
group by 1
)
, base_agg as (
select addr
, sum(tokens_transferred) as tokens_transferred
from base
group by 1
order by 2 desc
)
, outflow as (
select
QueryRunArchived: QueryRun has been archived