HosseinUntitled Query
    Updated 2022-12-21
    select
    tx:body:messages[0]:contract as contract_address,
    label_type as type,
    count(distinct tx_id) as tx_count,
    count(distinct tx_sender) as users_count
    from terra.core.dim_address_labels
    join terra.core.fact_transactions
    on address = tx:body:messages[0]:contract
    where block_timestamp >= '2022-01-01'
    group by 1, 2
    order by tx_count desc
    Run a query to Download Data