0x137d9174D3bd00F2153DcC0Fe7AF712d3876a71EKoinly - Sent and received
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,
Amount as "Sent Amount",
Token_Contract as "Sent Currency",
0 as "Recieved Amount",
'' as "Recieved Currency",
'' as "Fee Amount",
'' as "Fee Currency",
'' as "Net Worth Amount",
'' as "Net Worth Currency",
'withdraw' as Label,
recipient as Description,
tx_id as TxHash
FROM flow.core.ez_token_transfers
where sender = '0xdf868d4de6d2e0ab'
and tx_succeeded = TRUE
UNION
select
Block_timestamp as Date,
0 as "Sent Amount",
'' as "Sent Currency",
Amount as "Recieved Amount",
Token_Contract as "Recieved Currency",
'' as "Fee Amount",
'' as "Fee Currency",
'' as "Net Worth Amount",
'' as "Net Worth Currency",
'deposit' as Label,
sender as Description,
tx_id as TxHash
FROM flow.core.ez_token_transfers
where recipient = '0xdf868d4de6d2e0ab'
and tx_succeeded = TRUE
Run a query to Download Data