WEEK | ETH_ROYALTIES | USD_ROYALTIES | CUM_ETH_ROYALTIES | CUM_USD_ROYALTIES | |
|---|---|---|---|---|---|
1 | 2025-02-17 00:00:00.000 | 12.061944665 | 32919.979162437 | 85.873917795 | 264557.052236847 |
2 | 2025-02-10 00:00:00.000 | 19.96754 | 53613.2131418 | 73.81197313 | 231637.07307441 |
3 | 2025-02-03 00:00:00.000 | 2.589144965 | 7103.069230011 | 53.84443313 | 178023.85993261 |
4 | 2025-01-27 00:00:00.000 | 4.138029995 | 13169.333670811 | 51.255288165 | 170920.790702599 |
5 | 2025-01-20 00:00:00.000 | 7.115379985 | 23405.662094462 | 47.11725817 | 157751.457031788 |
6 | 2025-01-13 00:00:00.000 | 4.93405977 | 16223.201458961 | 40.001878185 | 134345.794937326 |
7 | 2025-01-06 00:00:00.000 | 3.69671859 | 12178.887836274 | 35.067818415 | 118122.593478365 |
8 | 2024-12-30 00:00:00.000 | 1.80729096 | 6240.015228692 | 31.371099825 | 105943.705642091 |
9 | 2024-12-23 00:00:00.000 | 6.276646285 | 21278.547684092 | 29.563808865 | 99703.690413398 |
10 | 2024-12-16 00:00:00.000 | 23.28716258 | 78425.142729306 | 23.28716258 | 78425.142729306 |
Sandeshkaito nft royalties
Updated 2025-02-21
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('week',block_timestamp) as week
, sum(CREATOR_FEE) as eth_royalties
, sum(CREATOR_FEE_USD) as usd_royalties
, sum(eth_royalties) over(order by week asc) as cum_eth_royalties
, sum(usd_royalties) over(order by week asc) as cum_usd_royalties
from ethereum.nft.ez_nft_sales
where nft_address='0x9830b32f7210f0857a859c2a86387e4d1bb760b8'
and block_timestamp>='2024-12-01'
group by week
order by week desc
Last run: 2 months ago
10
844B
2s