aaronr3genVenus New past 90 days
    Updated 2025-02-20
    WITH contract_addresses AS (
    SELECT LOWER(address) as address, name, chain
    FROM (
    VALUES
    -- BSC
    ('0xdF31a28D68A2AB381D42b380649Ead7ae2A76E42', 'RiskFund', 'BSC'),
    ('0x269ff7818DB317f60E386D2be0B259e1a324a40a', 'XVSVaultTreasury', 'BSC'),
    ('0xf322942f644a996a617bd29c16bd7d231d9f35e9', 'Venus Treasury', 'BSC'),
    ('0xBbCD063efE506c3D42a0Fa2dB5C08430288C71FC', 'Prime', 'BSC'),
    ('0x23c4F844ffDdC6161174eB32c770D4D8C07833F2', 'Prime Liquidity Provider', 'BSC'),
    -- Ethereum
    ('0xaE39C38AF957338b3cEE2b3E5d825ea88df02EfE', 'XVSVaultTreasury', 'ETH'),
    ('0xFD9B071168bC27DBE16406eC3Aba050Ce8Eb22FA', 'Venus Treasury', 'ETH'),
    ('0x14C4525f47A7f7C984474979c57a2Dccb8EACB39', 'Prime', 'ETH'),
    ('0x8ba6aFfd0e7Bcd0028D1639225C84DdCf53D8872', 'Prime Liquidity Provider', 'ETH'),
    -- Arbitrum
    ('0xb076D4f15c08D7A7B89466327Ba71bc7e1311b58', 'XVSVaultTreasury', 'ARB'),
    ('0x8a662ceAC418daeF956Bc0e6B2dd417c80CDA631', 'Venus Treasury', 'ARB'),
    ('0xFE69720424C954A2da05648a0FAC84f9bf11Ef49', 'Prime', 'ARB'),
    ('0x86bf21dB200f29F21253080942Be8af61046Ec29', 'Prime Liquidity Provider', 'ARB'),
    -- Optimism
    ('0x104c01EB7b4664551BE6A9bdB26a8C5c6Be7d3da', 'Venus Treasury', 'OP'),
    ('0xE76d2173546Be97Fa6E18358027BdE9742a649f7', 'Prime', 'OP'),
    ('0x6412f6cd58D0182aE150b90B5A99e285b91C1a12', 'Prime Liquidity Provider', 'OP'),
    -- Base
    ('0xbefD8d06f403222dd5E8e37D2ba93320A97939D1', 'Venus Treasury', 'BASE'),
    ('0xD2e84244f1e9Fca03Ff024af35b8f9612D5d7a30', 'Prime', 'BASE'),
    ('0xcB293EB385dEFF2CdeDa4E7060974BB90ee0B208', 'Prime Liquidity Provider', 'BASE')
    ) as addresses(address, name, chain)
    ),

    -- BSC Transactions
    QueryRunArchived: QueryRun has been archived