siavashjWeth Staking Volume In Osmosis
    Updated 2022-10-25
    select
    block_timestamp::date as date,
    count(distinct tx_id) as "Number Stake",
    count(distinct delegator_address) as "Staker",
    sum(amount) / pow(10,decimal) as "Amount WETH",
    label
    from osmosis.core.fact_superfluid_staking s inner join osmosis.core.dim_labels l
    on s.validator_address = l.address
    where split_part(currency, 'gamm/pool/', 2) = '704'
    and tx_status = 'SUCCEEDED'
    group by 1,5,decimal
    Run a query to Download Data