CONTRACT_ADDRESS | WALLET_ADDRESS | MINT_QUANTITY | TRANSFER_QUANTITY | TX_HASH_LIST | FIRST_TRANSFER_DATE | LAST_TRANSFER_DATE | |
|---|---|---|---|---|---|---|---|
1 | 0xa038c593115f6fcd673f6833e15462b475994879 | 0xff894ca49005ac4846d2b553d717dd7b77c1b349 | 2 | 0x4f73395d0cd09c556ead8ff30b02e914943dc1784aee30dea9b4a18e04a12cc7 | 2025-03-01 09:36:23.000 | 2025-03-01 09:36:23.000 | |
2 | 0xd78efaec85c1a4f42e6edb7209067702a2be8c90 | 0xff894ca49005ac4846d2b553d717dd7b77c1b349 | 1 | 0x46118faeaf040e08c817e36ef5a76fee3ecad1aec6f6cd9cb33741955302001d | 2025-02-10 07:18:09.000 | 2025-02-10 07:18:09.000 | |
3 | 0x67c409dab0ee741a1b1be874bd1333234cfdbf44 | 0xff894ca49005ac4846d2b553d717dd7b77c1b349 | 4 | 0x8ef11b4a77aaa872b00b7287806f293d99a33f8f3379e210cb8c2bcbeed2b46a, 0xec... | 2025-02-21 03:25:47.000 | 2025-03-01 08:17:05.000 | |
4 | 0xd7097f65217b28885fdd5b9511b08dcd65220b67 | 0xff894ca49005ac4846d2b553d717dd7b77c1b349 | 2 | 0x991d4bebdb66c718c11fe6cf55b0ef4d13e9326cd974867e2252772fa8748de8, 0xd0... | 2025-03-10 06:21:17.000 | 2025-03-15 14:18:03.000 | |
5 | 0xa899849929e113315200609be208e6a0858f645c | 0xff894ca49005ac4846d2b553d717dd7b77c1b349 | 2 | 0xab4379fc7bffa3e592c1d45494f305a7dae577e00494e00f18a2f6046db93510, 0x68... | 2025-03-01 09:50:47.000 | 2025-03-01 09:51:35.000 |
D3 AnalyticsNFT transaction by wallet
Updated 5 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 nft_mint as (
SELECT
CONTRACT_ADDRESS,
TO_ADDRESS as wallet_address,
sum(quantity) as quantity
FROM
ronin.nft.ez_nft_transfers
WHERE
IS_MINT = TRUE
and TO_ADDRESS = '0xff894ca49005ac4846d2b553d717dd7b77c1b349'
group by
1,
2
),
nft_transfer as (
SELECT
CONTRACT_ADDRESS,
TO_ADDRESS as wallet_address,
sum(quantity) as transfer_quantity,
LISTAGG(distinct tx_hash, ', ') tx_hash_list,
min(block_timestamp) as first_transfer_date,
max(block_timestamp) as last_transfer_date
FROM
ronin.nft.ez_nft_transfers
WHERE
IS_MINT = FALSE
and TO_ADDRESS = '0xff894ca49005ac4846d2b553d717dd7b77c1b349'
group by
1,
2
)
select
coalesce(m.contract_address, t.contract_address) contract_address,
coalesce(m.wallet_address, t.wallet_address) wallet_address,
m.quantity as mint_quantity,
transfer_quantity,
Last run: 5 days ago
5
1KB
3s