Drsimonpills 5
Updated 2024-09-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
--https://warpcast.com/~/channel/ogs
--https://warpcast.com/hony
select
PROJECT_NAME,
block_timestamp::date AS day,
'https://basescan.org/tx/' || tx_hash AS tx_hash,
'https://basescan.org/address/' || BUYER_ADDRESS AS BUYER_ADDRESS,
'https://basescan.org/address/' || SELLER_ADDRESS AS SELLER_ADDRESS,
PLATFORM_NAME,
price,
price_usd,
TOTAL_FEES,
TOTAL_FEES_USD
from base.nft.ez_nft_sales
where nft_address = lower('0x6e230533d53e2f8fb90c542f02e5fa306b1fe1d3')
--and price <= '10'
--and price <> '0'
ORDER BY 2 DESC
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived