BUYER_ADDRESS | PLATFORM_NAME | TOTAL_SPENT | |
|---|---|---|---|
1 | 0x43cd76f68916165e67ecc9df67b67721fe4e92e8aaa12a01ad895ad47187b7cc | Wapal | 822.01324 |
2 | 0x81de60794883d362fc4f2b5af64179993dd2c43bc671401731ab28fa48447ac | Wapal | 607.283999952 |
3 | 0x1a7bb2976717336e53de6cacd08d604ca6e475c199af8dd6593ed52233a0d6c1 | Wapal | 584.136127503 |
4 | 0xcc24e05d0dd6cf147a6548d5db9ae684b20dfe33f39f1c80ec08998a776d747a | Wapal | 481.643 |
5 | 0x92580700887374bae44391d7386cd9423d3604cabbde5f3216e1135ef1916095 | Wapal | 408.1539 |
6 | 0xacd29823918e0128c00b906a2ae8d4efc23f26f0d636715f3b8b096ea4477a32 | Wapal | 268.4913 |
7 | 0x2ca8a79c2bf6365f0c8ddfb10bc552f7c4f6677546982777af347561db1b8f6 | Wapal | 216.288 |
8 | 0x165b80c964269cbcb3aabfdedbcb966e0c4a91af0f98d0a99cf296075f6fff2d | Wapal | 214.798 |
9 | 0x2b66f8482997b0d4e125a29be5ef696765c3a29c9229a5bde2c5c14e2c7c262a | Wapal | 213.4678 |
10 | 0xf84b3dc7143f6f49bfc2bf110f7bd7e3c2dd7c9c7653b2966815eaacce834395 | Wapal | 186.5297 |
aureasarsanedesbattle 5
Updated 6 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
BUYER_ADDRESS,
PLATFORM_NAME,
SUM(TOTAL_PRICE_USD) AS total_spent
FROM
aptos.nft.ez_nft_sales
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
GROUP BY
BUYER_ADDRESS, PLATFORM_NAME
HAVING total_spent is not null
ORDER BY
total_spent DESC
LIMIT 10
Last run: 6 days ago
10
887B
8s