Copy of new contract mints

Nige7777Copy of new contract mints

Updated 2021-11-10

-- select * from ethereum.nft_events e

-- where token_id < 100

-- and e.block_timestamp > dateadd('day', -1, getdate())

-- limit 500

--select event_platform , count(*) from ethereum.nft_events group by event_platform

--select * from ethereum.transactions t where tx_id = '0x65f650a3c2d55ef2db0b5bb0ad3df4f833eed08a0b7a45b3cf4635f238145f05'

--select * from ethereum.events_emitted where tx_id = '0x65f650a3c2d55ef2db0b5bb0ad3df4f833eed08a0b7a45b3cf4635f238145f05'

--select * from ethereum.nft_events where tx_id= '0x5c7fec9d7aa91ad38c46d6956435dd203cb4e4238c98520a13f74726b9e5e72d'

-- select *

-- ,

-- avg(price_usd) over (partition by date_trunc('Hour',block_timestamp ) order by date_trunc('Hour',block_timestamp )) as AVG_PRICE,

-- date_trunc('Hour',block_timestamp ) Hour

-- from ethereum.nft_events

-- where contract_address = '0xf78296dfcf01a2612c2c847f68ad925801eeed80'

-- and event_type = 'sale'

-- and date_trunc('day',block_timestamp ) > '2021-06-15T09:55:55Z'

-- order by block_timestamp--price_usd desc

-- select *

-- --avg(price_usd) AVG_PRICE --

-- -- over (partition by date_trunc('Hour',block_timestamp ) order by date_trunc('Hour',block_timestamp )) as AVG_PRICE,

-- ,date_trunc('Hour',block_timestamp ) Hour

-- from ethereum.nft_events

-- where

-- 1=1

-- --and contract_address = '0x85f740958906b317de6ed79663012859067e745b' -- craniums

Run a query to Download Data

flipside