Holonymactivity on Eth and L2s
Updated 2024-11-30
999
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 optimism_fees_transactions as (
select
block_timestamp,
tx_hash,
from_address as userAddress,
value as fee,
'ETH' as currency
from optimism.core.fact_transactions
where to_address = '0xdca2e9ae8423d7b0f94d7f9fc09e698a45f3c851'
),
avalanche_fees_transactions as (
select
block_timestamp,
tx_hash,
from_address as userAddress,
value as fee,
'AVAX' as currency
from avalanche.core.fact_transactions
where to_address = '0xdca2e9ae8423d7b0f94d7f9fc09e698a45f3c851'
),
ethereum_fees_transactions as (
select
block_timestamp,
tx_hash,
from_address as userAddress,
value as fee,
'ETH' as currency
from ethereum.core.fact_transactions
where to_address = '0xdca2e9ae8423d7b0f94d7f9fc09e698a45f3c851'
),
fantom_fees_transactions_from_dune as (
select
livequery.live.udf_api(
'https://api.flipsidecrypto.com/api/v2/queries/38a8ae12-3a05-4dc2-bd02-af696e63518c/data/latest'
):"data" as response