0xHaM-dTotal Users
    Updated 2024-01-29
    WITH create_daos as (
    select
    distinct tx_id
    from
    terra.core.fact_msg_attributes_standard
    where
    attribute_value = 'terra19hz374h6ruwtzrnm8ytkae782uv79h9yt9tuytgvt94t26c4793qnfg7vn'
    ),
    qmain as (
    select
    block_timestamp,
    tx_id,
    TX_SENDER
    from
    terra.core.fact_transactions
    where
    tx_id in (
    SELECT
    *
    FROM
    create_daos
    )
    )
    select
    count(DISTINCT TX_SENDER) as address
    from
    qmain
    Last run: over 1 year agoAuto-refreshes every 24 hours
    ADDRESS
    1
    10323
    1
    9B
    8s