Query editor
WITH vaults AS (SELECT * FROM (VALUES('StakeKit Morpho ETH Moonwell Flagship Vault Crypto On Ramp Standard', 0xb78bbe5ab780bec54891c9ff51fe3c06418ee7b8, 0x4200000000000000000000000000000000000006, 'WETH', 18, 'base'),('StakeKit Morpho ETH Moonwell Flagship Vault Crypto On Ramp Premium', 0xabcf1256a97fc6677ada02df6639c001841c664f, 0x4200000000000000000000000000000000000006, 'WETH', 18, 'base'),('StakeKit Morpho USDC Seamless Fiat On Ramp Standard', 0x848ab873e471be52efdfc6be4447b63696c7c304, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base'),('StakeKit Morpho USDC Seamless Fiat On Ramp Premium', 0xad179a5fe86cf0d873390ccbb07d37e8523a6be0, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base'),('StakeKit Morpho USDC Seamless Crypto On Ramp Standard', 0xef68cb110356984c34642540263aac1ef25d06f3, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base'),('StakeKit Morpho USDC Seamless Crypto On Ramp Premium', 0xe2a392ca29a7020d7b6c2df1a3a5ad35f1d80c49, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base'),('StakeKit Moonwell Flagship EURC Vault Crypto On Ramp Standard', 0xede48327b591231e435948e7428b8eed4055ee80, 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EURC', 6, 'base'),('StakeKit Moonwell Flagship EURC Vault Crypto On Ramp Premium', 0x95ee8fb873c56541fad96f55033c8a8290183e9c, 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EURC', 6, 'base'),('StakeKit Moonwell Flagship EURC Vault Fiat On Ramp Standard', 0x054ea1f836f764fa49873aff0db68e5119ac0c9c, 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EURC', 6, 'base'),('StakeKit Moonwell Flagship EURC Vault Fiat On Ramp Premium', 0x3361fef282f8f0962a7a4306a966d068760de23e, 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EURC', 6, 'base'),('StakeKit Steakhouse EURCV Fiat On Ramp Premium', 0xa3381399f20493fddd3b47e978c1407e66884bbb, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit Steakhouse EURCV Fiat On Ramp Standard', 0xe31631cce2270b83092a4540e2a89bf41d6d6581, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit Steakhouse EURCV Crypto On Ramp Premium', 0x2f9011063506e3ab5e8b5b3231e5a22fcf1ca56f, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit Steakhouse EURCV Crypto On Ramp Standard', 0x4e433bf8e9fd338a8fe7755d6a837ca9e5a2d67b, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit EURCV Prime Fiat On Ramp Premium', 0x284d29890faea6b3de51e9eef04842e0282c258c, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit EURCV Prime Fiat On Ramp Standard', 0x20b9967531faf83ba92367eb9cfab142d44f8e6c, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit EURCV Prime Crypto On Ramp Premium', 0x2840f5299d2ab1ac6a2129fdbfa1a610a829a19e, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit EURCV Prime Crypto On Ramp Standard', 0xb1c7c1e8380e5da8c7904a3c6d1ffd42d141ab75, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit EURCV Steakhouse Prime Instant CS', 0xcdbbe7c7ae6c756bd14b5787fc0bcf66ad5acfc3, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit EURCV Steakhouse Prime Instant CP', 0xad64b7e01dc7304796e9b840043d7834ec3a2929, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit EURC Steakhouse Prime Instant FS', 0x33024d4791413438aa1de6a8b6cb7cceb25459b1, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit EURCV Steakhouse Prime Instant FP', 0x50461744cb3dea4d678be82b8f1b9cead383065d, 0x5f7827fdeb7c20b443265fc2f40845b715385ff2, 'EURCV', 18, 'ethereum'),('StakeKit Steakhouse Prime EURC Morpho V2 Crypto On Ramp Standard', 0x38e1cfd8d30743aa2f4dd6a97e6aa66d46b821ff, 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EURC', 6, 'base'),('StakeKit Steakhouse Prime EURC Morpho V2 Crypto On Ramp Premium', 0x4e4ceb6baa80d1a74d19e4e1461329087ea75f77, 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EURC', 6, 'base'),('StakeKit Steakhouse Prime EURC Morpho V2 Fiat On Ramp Standard', 0x1a5d005e42e4b48141f9ec260cb8dd46b5747e21, 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EURC', 6, 'base'),('StakeKit Steakhouse Prime EURC Morpho V2 Fiat On Ramp Premium', 0x2a14e34c13ce625d48d8aba289974e3d6fff6b27, 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EURC', 6, 'base'),('StakeKit Steakhouse Prime Instant Morpho V2 Crypto On Ramp Standard', 0xea6acb881ee1ff0ea972f87ae112f923f579928f, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base'),('StakeKit Steakhouse Prime Instant Morpho V2 Crypto On Ramp Premium', 0xe1d3edd70824449102e2636093d5fe48980a96fc, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base'),('StakeKit Steakhouse Prime Instant Morpho V2 Fiat On Ramp Standard', 0xa30cd7e632643f304648d240a105149e2bab6d55, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base'),('StakeKit Steakhouse Prime Instant Morpho V2 Fiat On Ramp Premium', 0x9baea149f51b0023e4de6897d50998aa7144f408, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base')) AS t(vault_name, proxy_address, asset_address, asset_symbol, asset_decimals, blockchain)),-- 1) Fee share mints: Transfer(from = 0x0, to = fee recipient) on the proxy vault token.fee_mints AS (SELECT'base' AS blockchain,ev.contract_address AS proxy_address,ev.evt_tx_hash AS tx_hash,ev.evt_block_time AS block_time,DATE_TRUNC('day', ev.evt_block_time) AS day,DATE_TRUNC('month',ev.evt_block_time) AS month,CAST(ev.value AS DOUBLE) AS fee_shares_rawFROM erc20_base.evt_transfer evWHERE ev."from" = 0x0000000000000000000000000000000000000000AND ev."to" = 0x0ce4d79a01e7a507bb715d4f63d6cfce1de2d80bAND ev.evt_block_time >= TIMESTAMP '2025-01-01'AND ev.contract_address IN (SELECT proxy_address FROM vaults WHERE blockchain = 'base')UNION ALLSELECT'ethereum' AS blockchain,ev.contract_address AS proxy_address,ev.evt_tx_hash AS tx_hash,ev.evt_block_time AS block_time,DATE_TRUNC('day', ev.evt_block_time) AS day,DATE_TRUNC('month',ev.evt_block_time) AS month,