IacomusCryptopunk
Updated 2022-08-29
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
›
⌄
-- SELECT distinct platform_address
-- FROM ethereum.core.ez_nft_sales
-- WHERE project_name in ('cryptopunks', 'wrapped cryptopunks')
-- -- order by block_timestamp desc
-- limit 10
-- SELECT Distinct nft_address
-- FROM ethereum.core.ez_nft_transfers
-- WHERE project_name in ('cryptopunks',' wrapped cryptopunks')
-- -- order by block_timestamp
-- limit 100
SELECT TOPIC, EVENT_NAME, COUNT(*),
'https://etherscan.io/tx/' || LOWER(MAX(TX_HASH)) AS link1,
'https://etherscan.io/tx/' || LOWER(MIN(TX_HASH)) AS link2
FROM
(
SELECT EVENT_NAME, TOPICS[0] TOPIC, CONTRACT_NAME,
ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS
EVENT_INPUTS, TOPICS
DATA,
BLOCK_TIMESTAMP, TX_HASH
FROM ethereum.core.fact_event_logs
WHERE 1=1
AND CONTRACT_ADDRESS = LOWER('0xA858DDc0445d8131daC4d1DE01f834ffcbA52Ef1')
-- AND ORIGIN_TO_ADDRESS = LOWER('0x7b18913D945242A9c313573E6c99064cd940c6aF')
)
GROUP BY 1, 2
-- select BALANCE_DATE, USER_ADDRESS, CONTRACT_ADDRESS, BALANCE
-- from flipside_prod_db.ethereum.erc20_balances
-- where contract_address = lower('0xb47e3cd837dDF8e4c57F05d70Ab865de6e193BBB')
-- and BALANCE_DATE = current_date()
Run a query to Download Data