Query editor
withfluid_blockchains as (select *from "query_5044493"), tokens_native as (select *from "query_5825281"), fluid_dexes as (select *from "query_6157381"), fluid_vault_deployed as (-- select-- tx_hash-- , block_time-- , blockchain-- , contract_address as factory-- , bytearray_substring(topic1, 13, 20) as vault-- , cast(varbinary_to_uint256(bytearray_substring(data, 1, 32)) as integer) as vault_id-- , case-- when topic0 = 0x4960ed60da9bf499a0841c5bb40e134da1b7a55ec0436c1ca8e19848e78031a3 then 1-- when topic0 = 0xae0ffb892f3445fe1b3837202e0eb69f147ec603a6da0216f312f5ec9098aa11 then 2-- when topic0 = 0x6e6ef0e482822af7114029dca9524b6e8ffee44d30247c4f9e454c1987fc72c1 then 3-- when topic0 = 0x4b2bfb33ad24dcef9319f290b974e50081def081b7a43561ade90d78d068514e then 4-- else null-- end as vault_type-- , bytearray_substring(topic2, 13, 20) as supply_token-- , bytearray_substring(topic3, 13, 20) as borrow_token-- from evms.logs-- where block_time >= timestamp '2024-01-01'-- and contract_address in (-- 0x324c5Dc1fC42c7a4D43d92df1eBA58a54d13Bf2d -- Fluid Vault Factory-- , 0x9c6a8398C7d29FAE02A0Ba4a63b89210b4D2Fc41 -- old factory-- )-- and blockchain in (select blockchain from fluid_blockchains)-- and topic0 in (-- 0x4960ed60da9bf499a0841c5bb40e134da1b7a55ec0436c1ca8e19848e78031a3 -- VaultT1Deployed-- , 0xae0ffb892f3445fe1b3837202e0eb69f147ec603a6da0216f312f5ec9098aa11 -- VaultT2Deployed-- , 0x6e6ef0e482822af7114029dca9524b6e8ffee44d30247c4f9e454c1987fc72c1 -- VaultT3Deployed-- , 0x4b2bfb33ad24dcef9319f290b974e50081def081b7a43561ade90d78d068514e -- VaultT4Deployed-- )selectevt_tx_hash as tx_hash, evt_block_time as block_time, chain as blockchain, contract_address as factory, vault, cast(vaultId as integer) as vault_id, 1 as vault_type, supplyToken as supply_token, borrowToken as borrow_tokenfrom fluid_multichain.fluidvaultfactory_evt_vaultt1deployedwhere not (chain = 'ethereum'