Top Addresses by Number of Days of Activity

Eman-RazTop Addresses by Number of Days of Activity

Updated 2023-04-13

select tx_sender, count(distinct block_timestamp::date) as "Active Days",

rank () over (order by "Active Days" desc) as "Rank"

from terra.core.fact_transactions

group by 1

order by 2 desc

limit 20

Run a query to Download Data

flipside