eferTransactions copy
Updated 2023-12-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Transactions @ https://flipsidecrypto.xyz/edit/queries/61cf6833-043e-4642-9cbc-5c27d8012987
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
Run a query to Download Data