Mikey_2023-02-25 04:48 PM
Updated 2023-02-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
⌄
/*
select *
from ethereum.maker.ez_liquidations
where block_timestamp::date >= '2023-01-01'
limit 20
*/
select distinct origin_function_signature, count(distinct tx_hash), sum(RAW_AMOUNT/pow(10, 18))
from ethereum.core.fact_token_transfers s
where to_address = '0x0000000000000000000000000000000000000000' and s.contract_address = lower('0x6B175474E89094C44Da98b954EedeAC495271d0F')
group by 1
order by 2 desc
limit 50
select *
from ethereum.core.fact_token_transfers
where origin_function_signature = '0x1cff79cd' and to_address = '0x0000000000000000000000000000000000000000' and contract_address = lower('0x6B175474E89094C44Da98b954EedeAC495271d0F')
order by block_timestamp desc
limit 20
Run a query to Download Data