yasminTOTAL 1
Updated 2025-03-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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
standard_chains AS (
SELECT
BLOCKCHAIN,
SUM(TRANSACTION_COUNT_SUCCESS) AS transactions
FROM
crosschain.stats.ez_core_metrics_hourly
WHERE
BLOCK_TIMESTAMP_HOUR::date >= '2024-09-14'
AND BLOCKCHAIN IN ('arbitrum', 'base', 'polygon', 'solana','ethereum')
GROUP BY BLOCKCHAIN
),
ronin_transactions AS (
SELECT
'Ronin' AS blockchain,
COUNT(DISTINCT TX_HASH) AS transactions
FROM ronin.core.fact_transactions
WHERE block_timestamp::date >= '2024-09-14'
AND TX_SUCCEEDED = true
GROUP BY blockchain
),
------------------------------ GUN blockchain data (using API call)------------------------------------------------------
gun_transactions AS (
WITH base_data AS (
SELECT live.udf_api('https://metrics.avax.network/v2/chains/49321/metrics/cumulativeTxCount?startTimestamp=1726272000&timeInterval=day&pageSize=2160') AS response ),
flattened_data AS (
SELECT
TO_TIMESTAMP(t.value:timestamp)::date AS date,
t.value:value::integer AS cumulativeTxCount
FROM base_data,
LATERAL FLATTEN(input => PARSE_JSON(response:data:results)) t ),
stats AS (
SELECT MAX(cumulativeTxCount) AS total_cumulativeTxCount
FROM flattened_data )
QueryRunArchived: QueryRun has been archived