0xHaM-dTotal Pool Sizes by Assets copy
    Updated 2024-06-01
    -- forked from Total Pool Sizes by Assets @ https://flipsidecrypto.xyz/edit/queries/114e2ed7-5e67-4585-9346-043be83d309b

    -- forked from Pool Sizes Over Time @ https://flipsidecrypto.xyz/edit/queries/3f6cab74-f736-4832-836c-a995fd24e4af

    -- forked from Playwo / Pool Sizes @ https://flipsidecrypto.xyz/Playwo/q/W68ZGgWTsT-7/pool-sizes

    WITH timeframe AS (
    SELECT date_day AS date
    FROM crosschain.core.dim_dates
    WHERE date_day >= TO_DATE('{{start_date}}')
    AND date_day < CURRENT_DATE()
    ),
    levana_contracts AS (
    SELECT $1 AS contract_address, $2 AS asset, $3 AS asset_decimals
    FROM (VALUES
    ('sei1jvl8avv45sj92q9x9c84fq2ymddya6dkwv9euf7y365tkzma38zq5xldpy', 'ETH', 6),
    ('sei1zjryrejvtufeaaer7w55fxgxurqnajwlshdpuqf5lp4j00uzek8s6sktv3', 'ETH', 6),
    ('sei1rl9z38s9t853jddjfexxkqqpq5d5wpzrqudfg7ruchzymxhms7pq39j645', 'ETH', 6),
    ('sei14j7zhcj50qsk6vhu7dsa48r5e7v37nthnwwx0q8q4nd0h39udy6qhqq6dm','SEI', 6),
    ('sei1tasaxmw8axfmcmzg2m9zp24msuurfkz3m44mga2dl98eh0txcxjspw9rga','BTC', 6),
    ('sei1teg8l8lanhkdxcdffg9anrzt3hhv9d8967ajczlrq3lzdrkzczsskh6733','SOL', 6)
    )
    ),
    pool_size_events AS (
    SELECT a__contract_address.tx_id, a__contract_address.block_timestamp,
    a__contract_address.attribute_value AS contract,
    a_locked_usd.attribute_value AS locked_usd,
    a_unlocked_usd.attribute_value AS unlocked_usd,
    a_lp_collateral.attribute_value AS lp_collateral,
    a_xlp_collateral.attribute_value AS xlp_collateral
    FROM
    sei.core.fact_msg_attributes AS a__contract_address,
    sei.core.fact_msg_attributes AS a_locked_usd,
    sei.core.fact_msg_attributes AS a_unlocked_usd,
    sei.core.fact_msg_attributes AS a_lp_collateral,
    sei.core.fact_msg_attributes AS a_xlp_collateral
    QueryRunArchived: QueryRun has been archived