RamaharTOP 10 gained Lil Nouns in Secondary Sales
Updated 2022-06-19Copy Reference Fork
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 mint_metadata as (select
block_number as mint_block,
block_timestamp as mint_time,
tx_hash as mint_hash,
contract_address,
tokenflow_eth.hextoint(topics[1])::integer as tokenID,
tokenflow_eth.hextoint(substr(data,3,64)) as background,
tokenflow_eth.hextoint(substr(data,67,64)) as body,
tokenflow_eth.hextoint(substr(data,131,64)) as accessory,
tokenflow_eth.hextoint(substr(data,195,64)) as head,
tokenflow_eth.hextoint(substr(data,259,64)) as glasses
from ethereum.core.fact_event_logs
where
contract_address = '0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b'
and topics[0]::string = '0x1106ee9d020bfbb5ee34cf5535a5fbf024a011bd130078088cbf124ab3092478'),
combined_details as (select *
from ethereum.core.ez_eth_transfers
inner join mint_metadata ON mint_hash = tx_hash),
final_mint_details as (select
c.mint_block,
c.mint_time,
c.mint_hash,
c.contract_address,
c.tokenid as mint_tokenid,
c.amount as mint_price,
c.amount_usd as mint_usd,
nft_count,
mint_price / nft_count as mint_per_NFT_price,
mint_usd / nft_count as mint_usd_per_nft,
background,
body,
accessory,
Run a query to Download Data