anderhelETH transfers remaining
Updated 2023-01-05
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 labels2.label_type, count(distinct TX_HASH)
--SELECT origin_function_signature, functions.TEXT_SIGNATURE, eth_from_address, labels2.address_name, labels2.label_type, count(distinct TX_HASH)
--select *
--SELECT count(distinct TX_HASH)
FROM ethereum.core.ez_eth_transfers
left join ethereum.core.dim_function_signatures as functions
on origin_function_signature = functions.bytes_signature
left join ethereum.core.dim_labels as labels2
on eth_to_address = labels2.address
WHERE tx_hash not IN (
SELECT tx_hash
FROM (
SELECT distinct tx_hash FROM ethereum.core.EZ_DEX_SWAPS where year(block_timestamp)=2021
UNION
SELECT distinct tx_hash FROM ethereum.core.EZ_NFT_MINTS where year(block_timestamp)=2021
UNION
SELECT distinct tx_hash FROM ethereum.core.EZ_NFT_SALES where year(block_timestamp)=2021
UNION
SELECT distinct tx_hash FROM ethereum.core.EZ_NFT_TRANSFERS where year(block_timestamp)=2021
UNION
SELECT distinct tx_hash FROM ethereum.AAVE.EZ_BORROWS where year(block_timestamp)=2021
UNION
SELECT distinct tx_hash FROM ethereum.AAVE.EZ_DEPOSITS where year(block_timestamp)=2021
UNION
SELECT distinct tx_hash FROM ethereum.AAVE.EZ_FLASHLOANS where year(block_timestamp)=2021
UNION
SELECT distinct tx_hash FROM ethereum.AAVE.EZ_LIQUIDATIONS where year(block_timestamp)=2021
UNION
SELECT distinct tx_hash FROM ethereum.AAVE.EZ_REPAYMENTS where year(block_timestamp)=2021
UNION
SELECT distinct tx_hash FROM ethereum.AAVE.EZ_WITHDRAWS where year(block_timestamp)=2021
UNION
SELECT distinct tx_hash FROM ethereum.COMPoUND.EZ_BORROWS where year(block_timestamp)=2021
UNION
SELECT distinct tx_hash FROM ethereum.COMPoUND.EZ_DEPOSITS where year(block_timestamp)=2021
UNION
Run a query to Download Data