intellidegent2023-05-25 11:55 AM
Updated 2023-05-29
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::date as date,
sum(amount) as amount
from ethereum.core.ez_token_transfers
where block_timestamp::date between '2023-01-01' and '2023-04-30'
and origin_from_address = lower('0x5efda50f22d34f262c29268506c5fa42cb56a1ce')
group by date
select *
from ethereum.core.ez_current_balances
where user_address = lower('0xBE8E3e3618f7474F8cB1d074A26afFef007E98FB')
or user_address = lower('0x8EE7D9235e01e6B42345120b5d270bdB763624C7')
and (contract_address is null
or contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
)
select
*
from ethereum.core.ez_token_transfers
where origin_from_address = lower('0x8EE7D9235e01e6B42345120b5d270bdB763624C7')
limit 10
select * from ethereum.fact_token_transfers
where from_address = lower('0xDcd382bE6cC4f1971C667ffDa85C7a287605afe4')
limit 10
select * from ethereum.core.dim_labels
where --label_subtype = 'treasury'
address_name like '%maker%'
limit 100;
Run a query to Download Data