amelia-leeUntitled Query
    Updated 2022-07-30
    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