flipside

    base new projects
    Penta Limited Teambase new projects
    Updated 2024-10-01
    select distinct project_name, label_type, min(block_timestamp) as debut, count(*) from
    base.core.fact_event_logs l1 join
    base.core.dim_labels l2 on l1.contract_address=l2.address
    where label_type ilike '%defi%'
    group by 1,2 order by 3 desc
    limit 10




    QueryRunArchived: QueryRun has been archived