eferTransactions
    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
    APPLICATION
    INTERACTED_ON
    HASH
    EARLY_BIRD_SCORE
    1
    Sorare
    2021-12-12 13:44:49.0000xfb58cfc36d00c472358343e9cd03037e5cd1bbd53688b303e32c169ade41af3410
    2
    ImmutableX
    2022-02-05 10:00:06.0000xb1a372124bdec475d645f258e4f78603d0b4fd1059ed541a3f90b52ad5725d829
    3
    RhinoFi/DeversiFi
    2022-09-03 13:57:07.0000x797cc3bf81bbc8f977c44fc33f11446de89d6e2aec6cac0a8401fa3222c4091f8
    4
    Myria
    2022-10-23 06:20:35.0000x32bb922eec71b9b3483a96dec8ec91baa63600caa94191e7221a9255c94f94f07
    5
    Myria
    2022-10-26 06:44:23.0000xb368ef5cb1341a7bef0dfad3526a58b2caafb13369c635f40539f29876b38f8c6
    6
    Apex
    2022-11-10 07:40:11.0000x5f85e89325437846994fd26202cffb52b194a711e0b5c6f810d31490d67cb4385
    7
    Apex
    2022-11-10 07:40:23.0000xbf6c798efebc9b0204358f596597ea9b9255691a43c0e2cce5f89a7afdeed7714
    8
    Apex
    2022-11-11 08:58:59.0000x0ab01998f9f75ad6c2286e439c54bd5a4d42d3b636ac04f402f72a7c90f1ff763
    9
    Sorare
    2022-11-29 07:33:23.0000x4750d7faf45e1df5f38b974387a4264f3d3ec6166886f54f6734eef83e0e29422
    10
    Sorare
    2022-11-29 08:55:59.0000x9b088f0dd67315ac00bc15978da4f655af458dc565339e61d9284a40ca9410481
    10
    1KB
    2s