arabianhorses-jZtVNaFibrous new users analysis
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
›
⌄
WITH
firsttxns AS (
SELECT * FROM (
SELECT
PARAMETERS[0]:"value" AS swapper
, TX_HASH AS hash
, TIMESTAMP AS date
, ROW_NUMBER() OVER (PARTITION BY PARAMETERS[0]:"value" ORDER BY TIMESTAMP) AS rn
FROM external.tokenflow_starknet.decoded_events
WHERE CHAIN_ID = 'mainnet'
AND NAME = 'Transfer'
--AND TX_HASH = '0x033f7f9fbe5b77e3369747b1cfd90ba40db1d6f3f1ebafa58ed1a018f7dafcec'
AND PARAMETERS[1]:"value" = '0x1b23ed400b210766111ba5b1e63e33922c6ba0c45e6ad56ce112e5f4c578e62' --fibrous router
AND PARAMETERS[0]:"value" != '0x437bd0dab99c6a011ba3a9b17e103832c18af282a12c251555a1e05b8ea2f5b' --zetsu.stark
)
WHERE rn = 1
AND date BETWEEN '2023-08-08 15:29:00' AND '2023-08-10 16:31:00'
) --ilkfibrous işlemini event ile yapanlar
, edited_list AS (
SELECT
tr.contract AS addresswith0s
, ft.*
FROM firsttxns ft
LEFT JOIN external.tokenflow_starknet.decoded_transactions tr ON ft.hash = tr.tx_hash
--WHERE FirstTransactionTime BETWEEN '2023-08-08 15:29:00' AND '2023-08-10 16:31:00'
)
SELECT
ageOfAddress
, COUNT(CONTRACT)
FROM (
SELECT
CONTRACT
, DATEDIFF(WEEK, MIN(TIMESTAMP), '2023-08-10 16:31:00'::TIMESTAMP ) AS ageOfAddress
FROM external.tokenflow_starknet.decoded_transactions
Run a query to Download Data