makemoments-eF99leOpenseaPro NFT Rank copy copy copy copy copy copy copy copy copy 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 OpenseaPro NFT Rank copy copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/92eac7fc-ff33-4b87-b177-5756228f1fcb
-- forked from OpenseaPro NFT Rank copy copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/f5328c7a-05c0-4ff1-8cb0-61956807299c
-- forked from OpenseaPro NFT Rank copy copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/592bca27-626f-476e-975a-a7c20b7aa3a8
-- forked from OpenseaPro NFT Rank copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/db8213b8-8840-445d-9833-6b753bfe4338
-- forked from OpenseaPro NFT Rank copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/7f3e2112-f2b7-4938-8ec1-2ab6b092d634
-- forked from OpenseaPro NFT Rank copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/02cc6d8e-2510-456a-b23c-15fbc52abcf2
-- forked from OpenseaPro NFT Rank copy copy copy @ https://flipsidecrypto.xyz/edit/queries/7276bfaf-8929-4a00-a542-821af28c57ae
-- forked from NRT-RNyAf- / OpenseaPro NFT Rank copy copy @ https://flipsidecrypto.xyz/NRT-RNyAf-/q/opensea-pro-nft-rank-copy--Uw_bi
-- forked from OpenseaPro NFT Rank copy @ https://flipsidecrypto.xyz/edit/queries/7b727e04-90eb-4a75-b2dc-af85a8503c60
-- 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
)
Run a query to Download Data