Sbhn_NPdepin other chains
    Updated 2023-05-06
    select
    date_trunc('month',block_timestamp) as date,
    'RNDR' as platform,
    count(distinct tx_hash) as txs,
    count(distinct from_address) as users
    from polygon.core.fact_transactions
    where to_address = lower('0x61299774020dA444Af134c82fa83E3810b309991')
    and status = 'SUCCESS'
    and date >= '2023-01-01'
    group by 1,2

    union all

    select
    date_trunc('month',block_timestamp) as date,
    'FLUX' as platform,
    count(distinct tx_hash) as txs,
    count(distinct from_address) as users
    from ethereum.core.fact_transactions
    where to_address = lower('0x720cd16b011b987da3518fbf38c3071d4f0d1495')
    and status = 'SUCCESS'
    and date >= '2023-01-01'
    group by 1,2

    Run a query to Download Data