fog-jMJCmTOpenseaPro NFT Rank copy
Updated 2023-04-05
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 0x33569c101562e1fAF5b24581057E5cEE4c8288D7 / OpenseaPro NFT Rank @ https://flipsidecrypto.xyz/0x33569c101562e1fAF5b24581057E5cEE4c8288D7/q/2023-04-04-11-14-am-ePOuzF
WITH
base AS (
SELECT
from_address,
min(block_timestamp) as first_gem_txn_ts
FROM
ethereum.core.fact_transactions ft
WHERE
ft.to_address IN (
'0x0000000035634b55f3d99b071b5a354f48e10bef',
'0x4326275317acc0fae4aa5c68fce4c54c74dc08d3',
'0x539ea5d6ec0093ff6401dbcd14d049c37a77151b',
'0xeda0edeee797f579bdb0d055ae135ecb71709d28',
'0xf2458bd228d8a39b64bd3b9f84890e957cac3bbc',
'0x1cb16367b3a775e3d6d93906cd3e671e5ec3d07d',
'0x9c049c5a973e9637cdf5f7c31b93ec074161d2fe',
'0x094e654351cf152112e136923ad21508401d64d3',
'0xf24629fbb477e10f2cf331c2b7452d8596b5c7a5',
'0x83c8f28c26bf6aaca652df1dbbe0e1b56f8baba2',
'0xae9c73fd0fd237c1c6f66fe009d24ce969e98704',
'0xf22007700b8c443bcb36a39580f7804bffdb1169',
'0x29ab6d8f7e3d815168d6b40ebb12625b4fe13998',
'0x35ca26a7a7f3ca98f3e60bd94c139c892e45b6c3',
'0x9e97195f937c9372fe5fda5e3b86e9b88cbefed7',
'0x00000000a50bb64b4bbeceb18715748dface08af',
'0x241b8e59e81455e66b9cd0e2ffb2506be1838144',
'0x0000000031f7382a812c64b604da4fc520afef4b'
)
GROUP BY
1
),
ranked as (
SELECT
*,
RANK() OVER (
Run a query to Download Data