rackhaelClone X metrics by day
Updated 2023-06-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT block_timestamp::date as day,
count(distinct tx_hash) as daily_txns,
sum(platform_fee) as fees_eth,
sum(platform_fee_usd) as fees_usd,
sum(price) as price_ETH,
sum(price_usd) as price_USD,
sum(creator_fee) as royalties_ETH,
sum(creator_fee_usd) as royalties_USD,
count(buyer_address) as daily_buyers,
count(seller_address) as daily_sellers
FROM ethereum.core.ez_nft_sales
WHERE NFT_ADDRESS = '0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b'
AND currency_symbol like 'ETH'
group by 1
order by 1
Run a query to Download Data