amelia-leeUntitled Query
Updated 2022-07-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select symbol,
count(distinct tx_hash),count (distinct origin_from_address)
from ethereum.core.fact_event_logs t1 join ethereum.core.fact_hourly_token_prices t2 on t1.contract_address = t2.token_address
where origin_to_address in ('0x401f6c983ea34274ec46f84d70b31c151321188b','0xa0c68c638235ee32657e8f720a23cec1bfc77c77','0x40ec5b33f54e0e8a33a975908c5ba1c14e5bbbdf','0x8484ef722627bf18ca5ae6bcf031c23e6e922b30')
and origin_function_signature in ('0xe3dec8fb','0x4faa8a26','0x8b9e4f93') and symbol is not null
group by 1
order by 2 desc
limit 10
--alik110
Run a query to Download Data