Query editor
with ps as (select769500 as total_invested,timestamp '2024-07-20 03:58:35' as start_time,17739684 as start_block,0x3b82d771549b3AdCca25dcb88eAc825F736eAd60 as mansa_contract_address,0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913 as usdc_address,1e6 as usdc_decimals),/* ---------------------------------------------------Base Payments (Outgoing from Mansa)(No individual TX-hash filtering; still uses "from" = mansa)---------------------------------------------------- */base_payments as (selectsum(value) / (select usdc_decimals from ps) as "Total Payment Volume"from erc20_base.evt_Transferwherecontract_address = (select usdc_address from ps)and evt_block_number >= (select start_block from ps)and "from" = (select mansa_contract_address from ps)),/* ---------------------------------------------------Base Repayments (Incoming to Mansa)(No individual TX-hash filtering; uses "to" = mansa)---------------------------------------------------- */base_repayments as (selectsum(value) / (select usdc_decimals from ps) as "Total Repayment Volume",sum(case when evt_block_time >= now() - interval '30' day then value else 0 end) / (select usdc_decimals from ps) as "Loans (Last 30 Days)"from erc20_base.evt_Transferwherecontract_address = (select usdc_address from ps)and evt_block_number >= (select start_block from ps)and "to" = (select mansa_contract_address from ps)),/* ---------------------------------------------------Base Payments2 (Specific extra TX hashes for Base)(Updated to include newly discovered Base Payment TXs)---------------------------------------------------- */base_payments2 as (selectsum(value) / 1e6 as "Total Payment Volume"from erc20_base.evt_Transferwhereevt_tx_hash in (-- Old single TX:0xdb788c93f5b48ba7117fac64e48cb004ce5fef3b093dc9156768a45439e78b75,-- Newly appended from snippet:0x89141f1d5438972576d1e48f96b3d9ae0ca66bcaa806b440ea94c722ea118d55,0x0400cc4aa2d25c6b000788f95a3d4d27d3c1945df84c63bbc65f6bb1c714fd36)),/* ---------------------------------------------------Base Repayments2 (Specific extra TX hashes for Base)(Updated to include newly discovered Base Repayment TXs)