CONTRACT_ADDRESS | PRICE_UPDATES | NUMBER_OF_USERS | PROJECT_NAME | |
---|---|---|---|---|
1 | 0xf8a319bcd9fff599c191f30eb7b2c876067cb2ad | 7743 | 1 | Unknown |
2 | 0x0c9a3dd6b8f28529d72d7f9ce918d493519ee383 | 864 | 5203 | Unknown |
3 | 0xc1459fcfe23d5db9ddb04935ab7a426bd398eab0 | 459 | 1 | Unknown |
4 | 0x2f020e07e680c8826642f6be1b28eca9086bc850 | 188 | 2 | Unknown |
5 | 0x271aca3e9b8ed9f4f618875093bd75a7e1b3116c | 143 | 1 | Unknown |
6 | 0xdaf4da41aacc0439b412a138fe8274e06341024e | 88 | 0 | Unknown |
7 | 0xc23e8ba7dfc6bc544c8912847cc72a4c1dd4e712 | 44 | 0 | Unknown |
8 | 0xa9bbbdde822789f123667044443dc7001fb43c01 | 43 | 0 | Unknown |
9 | 0x63506717f6f2324ea15edc6cd0bdcc57379cb271 | 30 | 1 | Unknown |
10 | 0xda3cb1b836678255dda230c3853dc491296b2374 | 30 | 1 | Unknown |
11 | 0x29ee42d8849bc1ad341c49f0a8522ac57ae10b7b | 11 | 1 | Unknown |
12 | 0x46aaa4b384d7103d3e99552011795a9b270b25fe | 8 | 1 | Unknown |
13 | 0xd04a2e318e4557bb81344ea485b63d0d55732a37 | 8 | 1 | Unknown |
14 | 0x5e93bcc3ce5115ed665676256c1959e8217428e8 | 7 | 0 | Unknown |
15 | 0x3b8dfe237895f737271371f339eecbd66face43e | 7 | 1 | Unknown |
16 | 0xc6f3405c861fa0dca04ec4ba59bc189d1d56ee05 | 6 | 1 | Unknown |
17 | 0x57d86c0418120aa3d0d53f3922f165d9e4ca465f | 5 | 0 | Unknown |
18 | 0x20d12300b4805708d4293d29cb83c1e01d6f8913 | 5 | 1 | Unknown |
19 | 0x8842fe65a7db9bb5de6d50e49af19496da09f9b5 | 4 | 0 | Unknown |
20 | 0x78357316239040e19fc823372cc179ca75e64b81 | 3 | 2 | Unknown |
mrwildcatPyth Oracle on Ethereum, Top Contracts
Updated 4 days ago
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 Pyth Oracle on Polygon, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/5fdb390b-61ae-456e-9159-192473e9720f
-- forked from Pyth Oracle on Blast, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/70aa138d-2ce9-4ce5-89c0-a9d130f1148f
-- forked from Pyth Oracle on Avalanche, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/9ba1950e-7aa8-43d0-8a4c-c005f08e09af
-- forked from Pyth Oracle on Optimism, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/cbd225e2-ebea-499c-9143-b297643ecccb
-- forked from Pyth Oracle on Gnosis, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/3f87d077-c73f-4683-b616-dd51e661e6a9
-- forked from Pyth Oracle on Base, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/94c89a33-82dc-4e44-a0b9-77239dd3e404
-- forked from Pyth Oracle on BSC, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/c5bddb69-cd5a-48ad-84cd-0ddae8ee1ae2
WITH price_updates AS (
SELECT
from_address AS contract_address,
COUNT(*) AS update_count
FROM ethereum.core.fact_traces
WHERE to_address = LOWER('0x4305FB66699C3B2702D4d05CF36551390A4c69C6')
AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '6 months'
AND SUBSTRING(input, 1, 10) IN (
'0xef9e5e28', '0xb9256d28', '0x785bdda0', '0xf4347f83',
'0x4716e9c5', '0xaccca7f9', '0x0d4702e1', '0x631a316c'
)
AND type = 'CALL'
GROUP BY 1
),
user_counts AS (
SELECT
to_address AS contract_address,
COUNT(DISTINCT from_address) AS unique_users
FROM ethereum.core.fact_transactions
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '6 months'
AND status = 'SUCCESS'
AND to_address IN (
Last run: 4 days ago
36
2KB
99s