shadiltmp
Updated 2022-03-19
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
›
⌄
-- select * from ethereum.udm_events
-- where tx_id='0x0da59251949251154ab0e3e8c078cf2ef1a2a28f29e08014142697235ea268ae'
-- select * from ethereum.contracts
-- where address='0x53de5a7b03dc24ff5d25ccf7ad337a0425dfd8d1'
select *
-- symbol,
-- sum(amount)
from ethereum.udm_events
where from_address='0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569'
and from_label='rari capital'
and lower(symbol)!='usdc'
-- group by symbol
limit 10
-- select *
-- -- symbol,
-- -- sum(amount)
-- from ethereum.erc20_balances
-- where user_address='0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569'
-- and balance_date = '2022-03-17'
-- limit 10
Run a query to Download Data