flipside

    Used or not used? The question is!
    eferUsed or not used? The question is!
    Updated 2024-01-30
    WITH dictionary AS (
    SELECT
    ARRAY_CONSTRUCT(
    'ImmutableX',
    '0x5fdcca53617f4d2b9134b29090c87d01058e27e9',
    'https://immutable.com/',
    'https://etherscan.io/address/0x5fdcca53617f4d2b9134b29090c87d01058e27e9'
    ) AS imx,
    ARRAY_CONSTRUCT(
    'Sorare',
    '0xf5c9f957705bea56a7e806943f98f7777b995826',
    'https://sorare.com/',
    'https://etherscan.io/address/0xf5c9f957705bea56a7e806943f98f7777b995826'
    ) AS sorare,
    ARRAY_CONSTRUCT(
    'dYdX', -- Perpetual Exchange
    '0xd54f502e184b6b739d7d27a6410a67dc462d69c8',
    'https://dydx.exchange/',
    'https://etherscan.io/address/0xd54f502e184b6b739d7d27a6410a67dc462d69c8'
    ) AS dydx,
    ARRAY_CONSTRUCT(
    'RhinoFi/DeversiFi',
    '0x5d22045daceab03b158031ecb7d9d06fad24609b',
    'https://rhino.fi/',
    'https://etherscan.io/address/0x5d22045daceab03b158031ecb7d9d06fad24609b'
    ) AS rhino,
    ARRAY_CONSTRUCT(
    'Myria',
    '0x3071be11f9e92a9eb28f305e1fa033cd102714e7',
    'https://myria.com/',
    'https://etherscan.io/address/0x3071be11f9e92a9eb28f305e1fa033cd102714e7'
    ) AS myria,
    ARRAY_CONSTRUCT(
    'Apex', -- Perpetual Exchange
    '0xa1d5443f2fb80a5a55ac804c948b45ce4c52dcbb',
    'https://apex.exchange/',
    Last run: about 1 year ago
    NAME
    USED_BEFORE_JUNE_2022
    FIRST_TXN_HASH
    WEBSITE
    FIRST_INTERACTION_DATE
    1
    Sorare
    		✅ YES0xfb58***af34https://sorare.com/2021-12-12 @ 13:44
    2
    ImmutableX
    		✅ YES0xb1a3***5d82https://immutable.com/2022-02-05 @ 10:00
    3
    RhinoFi/DeversiFi
    		❌ NO0x797c***091fhttps://rhino.fi/2022-09-03 @ 13:57
    4
    Myria
    		❌ NO0x32bb***94f0https://myria.com/2022-10-23 @ 06:20
    5
    Apex
    		❌ NO0x5f85***b438https://apex.exchange/2022-11-10 @ 07:40
    6
    dYdX
    		❌ NONever Used!https://dydx.exchange/Never Used!
    7
    Reddio
    		❌ NONever Used!https://reddio.com/Never Used!
    7
    554B
    2s