Query editor
WITH base AS (withraw_data as (selectbitcoin.inputs.address as user,bitcoin.outputs.value as value,bitcoin.inputs.witness_data as witness,bitcoin.inputs.tx_id as txidFROMbitcoin.outputsjoin bitcoin.inputs on bitcoin.inputs.tx_id = bitcoin.outputs.tx_idWHEREbitcoin.outputs.address = 'bc1qtu66zfqxj6pam6e0zunwnggh87f5pjr7vdr5cd'and bitcoin.outputs.block_date <= timestamp '2024-04-15'order bybitcoin.outputs.value desc,bitcoin.inputs.address),txid_data as (selectuser,txid,sum(value) / count(txid) as BTC_Stakedfromraw_datagroup bytxid,userorder byBTC_Staked desc)selectuser,sum(BTC_Staked) as "Total Staked BTC (Outputs)"fromtxid_datagroup byuserorder by"Total Staked BTC (Outputs)" desc),stake_dates AS (SELECTbitcoin.inputs.address AS user,MIN(bitcoin.outputs.block_time) AS stake_dateFROM bitcoin.outputsJOIN bitcoin.inputsON bitcoin.inputs.tx_id = bitcoin.outputs.tx_idWHERE bitcoin.outputs.address = 'bc1qtu66zfqxj6pam6e0zunwnggh87f5pjr7vdr5cd'GROUP BY 1)SELECTb.*,s.stake_dateFROM base bLEFT JOIN stake_dates s