UNIQUE_CONTRACTS | TOTAL_TRANSACTIONS | TOTAL_GAS_USED | TOTAL_VALUE_TRANSFERRED | |
---|---|---|---|---|
1 | 206 | 1289182 | 251166122046 | 0.0009000000025 |
mrwildcatpyth base totals
Updated 2024-09-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- 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 base.core.fact_traces
WHERE to_address = LOWER('0x8250f4aF4B972684F7b336503E2D6dFeDeB1487a')
AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '6 months'
Last run: 4 days ago
1
44B
526s