freeman_7Transaction Per seconds
Updated 2025-02-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- pool address 0x09cabEC1eAd1c0Ba254B09efb3EE13841712bE14
-- user 0xf369af914dBed0aD7afdDdEbc631Ee0FDA1b4891
--start date 2018-11-02 10:27
-- end date 2019-01-11 10:38
--with poolbalance as (
select
*
from ethereum.core.ez_current_balances
--where last_activity_block_timestamp BETWEEN date(timestamp '2018-11-02') and date(timestamp '2019-01-11')
where contract_address is null and symbol ilike 'eth'
and user_address = lower('0x09cabEC1eAd1c0Ba254B09efb3EE13841712bE14')
and extract(year from last_activity_block_timestamp ) = '2018'
limit 1
--)
QueryRunArchived: QueryRun has been archived