mrwildcatpyth avalanche totals
Updated 2025-02-11
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
›
⌄
-- forked from pyth optimism totals @ https://flipsidecrypto.xyz/edit/queries/dc8f9e4d-311d-45b8-bb67-0079baffcbcc
-- forked from pyth gnosis totals @ https://flipsidecrypto.xyz/edit/queries/33008ecc-8c23-41ed-b9f8-884b6fbae925
-- forked from pyth base totals @ https://flipsidecrypto.xyz/edit/queries/b428f6f1-bcda-4a65-8e3c-e683f0547f07
-- forked from pyth bsc totals @ https://flipsidecrypto.xyz/edit/queries/980eb3e6-0d16-47b5-b895-80e13ff926f8
-- forked from 2024-06-29 12:47 AM arb totals @ https://flipsidecrypto.xyz/edit/queries/2e295d89-fa87-4e82-9864-d7a52681b561
SELECT
COUNT(DISTINCT from_address) as unique_contracts,
COUNT(DISTINCT tx_hash) as total_transactions,
SUM(gas_used) as total_gas_used,
SUM(value) as total_value_transferred
FROM avalanche.core.fact_traces
WHERE to_address = LOWER('0x4305FB66699C3B2702D4d05CF36551390A4c69C6')
AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '6 months'
QueryRunArchived: QueryRun has been archived