mo115Free gas - USD
Updated 2024-06-09
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
›
⌄
-- forked from Free gas - Most Number of Transactions @ https://flipsidecrypto.xyz/edit/queries/9858078b-cb7c-4fbd-b7ff-53bf4b417687
-- forked from Free gas - Total* @ https://flipsidecrypto.xyz/edit/queries/9b014d76-e682-4017-96ab-f2036d2a9f0f
-- forked from Free gas - Total @ https://flipsidecrypto.xyz/edit/queries/2e6ec936-df7e-44be-9be6-d9817bac7625
-- forked from Free gas @ https://flipsidecrypto.xyz/edit/queries/5697eb9f-7b7b-4328-9657-267570ce80ca
with total as (
--Arbitrum
select
date_trunc('day',BLOCK_TIMESTAMP) as "Date"
, 'Arbitrum' as Network
, TX_HASH
, TO_ADDRESS
, AMOUNT
, 'ETH' as Token
, AMOUNT_USD
from arbitrum.core.ez_native_transfers
where ORIGIN_FROM_ADDRESS='0x76dd65529dc6c073c1e0af2a5ecc78434bdbf7d9'
and TO_ADDRESS != '0x740f5da39d28c22e5bdaee8f221209e336432ea8'
and BLOCK_TIMESTAMP> '2024-04-15'
union
--Avalanche
select
date_trunc('day',BLOCK_TIMESTAMP) as "Date"
, 'Avalanche' as Network
, TX_HASH
, TO_ADDRESS
, AMOUNT
, 'ETH' as Token
, AMOUNT_USD
from avalanche.core.ez_native_transfers
where ORIGIN_FROM_ADDRESS='0x76dd65529dc6c073c1e0af2a5ecc78434bdbf7d9'
and TO_ADDRESS != '0x75e67808f3e1948aefc6065eb4b12be4d3ac8929'
QueryRunArchived: QueryRun has been archived