h4wkbase
    Updated 2023-11-15
    s-- select label, label_type, address
    -- from solana.core.dim_labels
    -- where label = 'jupiter' and label_type = 'dex'


    select block_timestamp::date as date,
    label,
    count(distinct signers[0]) as users,
    count(distinct tx_id) as txs
    from solana.core.fact_events
    join solana.core.dim_labels on program_id = address
    where
    block_timestamp >= CURRENT_DATE - 14 and block_timestamp < CURRENT_DATE
    -- block_timestamp::date = '2023-11-11'
    and succeeded = TRUE and label != 'solana'
    group by 1,2
    -- order by users desc
    -- limit 20
    Run a query to Download Data