piperBase - Based Rekt Chicken - Opensea sales
Updated 2023-09-15
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 all_transactions AS (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
ETH_VALUE,
TX_FEE--,
--FROM_ADDRESS
FROM
base.core.fact_transactions
WHERE
--TX_HASH = '0x3e44e94b11f9ed401665aab68c0346270c3d67b0b6768cbc049ac783a0ca21e5'
TO_ADDRESS = lower('0x00000000000000adc04c56bf30ac9d3c0aaf14dc')
AND
ETH_VALUE > 0
AND
STATUS = 'SUCCESS'
),
all_nft_transfers AS (
SELECT
TX_HASH,
NFT_ADDRESS,
PROJECT_NAME,
NFT_FROM_ADDRESS,
TOKENID
FROM
base.core.ez_nft_transfers
WHERE
--TX_HASH = '0x3e44e94b11f9ed401665aab68c0346270c3d67b0b6768cbc049ac783a0ca21e5'
--EVENT_TYPE = 'other'
NFT_ADDRESS = lower('0xc16706ae5eed1805990d92241add1662724e50f2')
)
SELECT
all_transactions.*,
all_nft_transfers.PROJECT_NAME,
Run a query to Download Data