proxOpenseaPro NFT Rank copy
Updated 2023-04-04
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
›
⌄
-- 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 (ORDER BY first_gem_txn_ts) as gem_user_rank
FROM base
)
SELECT *
FROM ranked
WHERE from_address = LOWER('0x1bBf83b54Cfb3625d84bd251501Ac28DbA8a3373')
Run a query to Download Data