ejirogabrielGetting Started
Updated 2024-11-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- Comparing DeFi User Behavior on Solana vs. Ethereum
-- Objective:
-- Enable participants to understand and compare how users interact with DeFi on Solana and Ethereum by
-- analyzing essential user behavior metrics.ethereum.defi.dim_dex_liquidity_pools
SELECT
COUNT(DISTINCT tx_id) AS txs,
COUNT(DISTINCT signers[0]) AS usrs,
txs/COUNT(DISTINCT block_timestamp::date) as daily_avg_tx,
usrs/COUNT(DISTINCT block_timestamp::date) as daily_avg_usr
FROM solana.core.fact_events
WHERE
block_timestamp > CURRENT_TIMESTAMP - INTERVAL '1 Month'
AND SUCCEEDED
select *
from ethereum.events_emitted
WHERE contract_address = lower('0xb47e3cd837dDF8e4c57F05d70Ab865de6e193BBB')
AND event_name = 'PunkBought'
AND TX_SUCCEEDED = 'TRUE'
LIMIT 100000
QueryRunArchived: QueryRun has been archived