nitsP-Polygon Top DEFI Calls made
    Updated 2022-08-02
    select project_name, count(DISTINCT tx_hash) as total_txs
    from
    (SELECT * from polygon.core.dim_labels
    inner join polygon.core.fact_event_logs
    on contract_address = address)
    where label_type = 'defi' and date(block_timestamp) >= CURRENT_DATE -90
    GROUP by 1
    order by 2 desc
    limit 10
    Run a query to Download Data