SELECT

block_timestamp,

signer_id,

try_parse_json(CLEAN_LOG) AS log,

log:data[0]:total_booster_amount / 1e18 AS amount_adj,

TRUNC(log:data[0]:duration / (30 * 86400), 2) AS duration_months

FROM

near.core.fact_logs

WHERE

receiver_id = 'contract.main.burrow.near'

AND log:event = 'booster_stake'

AND receipt_succeeded = 1

AND block_timestamp::date >= '2022-04-22'

),

UserVolumeDuration AS (

SELECT

signer_id,

duration_months,

SUM(amount_adj) AS total_staked

FROM

Burrow

GROUP BY signer_id, duration_months

SELECT

duration_months,

SUM(total_staked) AS total_volume

FROM

UserVolumeDuration

GROUP BY duration_months

ORDER BY duration_months;