0x137d9174D3bd00F2153DcC0Fe7AF712d3876a71EKoinly - NFT trading
Updated 2022-12-16
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
›
⌄
select
Block_timestamp as Date,
Price as "Sent Amount",
Currency as "Sent Currency",
1 as "Recieved Amount",
NFT_collection as "Recieved Currency",
'' as "Fee Amount",
'' as "Fee Currency",
'' as "Net Worth Amount",
'' as "Net Worth Currency",
'NFT buy' as Label,
substring(NFT_collection,15,4) as Description,
tx_id as TxHash
from flow.core.ez_nft_sales
where buyer = '0xdf868d4de6d2e0ab'
and TX_SUCCEEDED = true
union
SELECT
Block_timestamp as Date,
1 as "Sent Amount",
NFT_collection as "Sent Currency",
substring( TOKENFLOW[3],31,8) as "Recieved Amount",
Currency as "Recieved Currency",
'' as "Fee Amount",
'' as "Fee Currency",
'' as "Net Worth Amount",
'' as "Net Worth Currency",
'NFT buy' as Label,
substring(NFT_collection,15,4) as Description,
tx_id as TxHash
from flow.core.ez_nft_sales
where seller = '0xdf868d4de6d2e0ab'
and TX_SUCCEEDED = true
order by date
Run a query to Download Data