rezarwzTotal µ-Tokens Volume (USD)
    Updated 2024-02-03
    with FP as (
    with trades as (
    SELECT
    TX_HASH,
    date_trunc('day', BLOCK_TIMESTAMP) as date,
    ORIGIN_FROM_ADDRESS as ua,
    CASE
    when TOKEN_IN in (
    SELECT
    DECODED_LOG:floorToken
    from
    ethereum.core.ez_decoded_event_logs
    where
    contract_address = '0x3eb879cc9a0ef4c6f1d870a40ae187768c278da2'
    and event_name = 'NewCollectionSupported'
    ) then SYMBOL_IN
    else SYMBOL_OUT
    end as Floor_token,
    CASE
    when TOKEN_IN in (
    SELECT
    DECODED_LOG:floorToken
    from
    ethereum.core.ez_decoded_event_logs
    where
    contract_address = '0x3eb879cc9a0ef4c6f1d870a40ae187768c278da2'
    and event_name = 'NewCollectionSupported'
    ) then AMOUNT_IN
    else AMOUNT_OUT
    end as Floor_token_amount,
    CASE
    when TOKEN_IN in (
    SELECT
    DECODED_LOG:floorToken
    from
    ethereum.core.ez_decoded_event_logs
    Last run: about 1 year ago
    Total µ-Tokens Volume (USD)
    # of tradable µ-Tokens
    1
    376232871.14904131
    1
    23B
    27s