rezarwzpast 7 days fp
    Updated 2024-02-03
    with FP as (
    with trades as (
    SELECT
    TX_HASH,
    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
    PLATFORM_NAME
    USD_VOLUME
    # of transactions
    # of Traders
    1
    Floor Protocol14768233.13234372
    2
    rarible208595.400222571166123
    3
    opensea25650503.19346034800324512
    4
    larva labs2914507.3527134117
    5
    sudoswap184792.73765074218981
    6
    blur135322231.0112444206414800
    7
    x2y23347506.26595177841481
    8
    looksrare274466.880384322211155
    9
    nftx193381.442297451185101
    9
    336B
    31s