namanasync2024-04-22 09:43 PM
Updated 2024-04-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
a.block_number,
a.block_timestamp,
a.tx_hash,
a.from_address,
a.to_address,
a.value,
a.value * b.price as value_usd,
a.tx_fee,
a.tx_fee * b.price as tx_fee_usd,
b.price
from
arbitrum.core.fact_transactions a
JOIN (
SELECT
*
FROM
ethereum.price.fact_hourly_token_prices
where
token_address = lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2')
) b on date_trunc ('hour', a.block_timestamp) = b.hour
limit 10
QueryRunArchived: QueryRun has been archived