Daily activity

elsinaDaily activity

Updated 4 days ago

with price as (

select

date_trunc('day', hour) as date,

avg(price) as price_usd

from crosschain.price.ez_prices_hourly

where

blockchain = 'ethereum' and

token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

group by 1

base as (

SELECT

e.block_timestamp,

e.origin_from_address,

e.tx_hash,

value as amount,

amount * price_usd as amount_usd,

tx_fee,

utils.udf_hex_to_string(substring(data, 129)) AS domain_name

from ink.core.fact_event_logs e left join ink.core.fact_transactions t on e.tx_hash = t.tx_hash left join price on e.block_timestamp::date = date

where

e.tx_succeeded = TRUE and

topics[0] = '0x53946bf984072f5888fcb2d7d2b0587c8efeb9187d958f21809711cf00b4b4a5' and

origin_to_address = '0xfb2cd41a8aec89efbb19575c6c48d872ce97a0a5'

)

SELECT

date_trunc('day', block_timestamp) as date,

count(DISTINCT origin_from_address) as user_count,

count(DISTINCT tx_hash) as tx_count,

sum(amount) as total_volume_eth,

sum(amount_usd) as total_volume_usd,

avg(amount) as avg_tx_volume_eth,

Last run: 4 days ago

	DATE	USER_COUNT	TX_COUNT	TOTAL_VOLUME_ETH	TOTAL_VOLUME_USD	AVG_TX_VOLUME_ETH	AVG_TX_VOLUME_USD	TOTAL_FEE	AVG_FEE
1	2025-04-16 00:00:00.000	14	14	0.04725019365	74.731359089	0.003375013832	5.337954221	0.0007185280677	0.00005132343341
2	2025-04-12 00:00:00.000	20	20	0.0699070488	111.948885796	0.00349535244	5.59744429	0.0007370147455	0.00003685073728
3	2025-01-24 00:00:00.000	424	424	0.5844956247	1965.462005554	0.001378527417	4.635523598	0.02393825741	0.00005645815428
4	2025-02-26 00:00:00.000	119	120	0.2219031758	540.902397742	0.001849193132	4.507519981	0.001603252152	0.0000133604346
5	2025-03-12 00:00:00.000	59	59	0.1123336174	212.698930275	0.001903959616	3.605066615	0.002993611146	0.00005073917196
6	2025-03-07 00:00:00.000	138	139	0.2471445081	539.079324406	0.001778018044	3.878268521	0.01235499639	0.00008888486614
7	2025-02-05 00:00:00.000	176	177	0.3369481022	929.430765879	0.001903661595	5.251021276	0.007268125218	0.00004106285434
8	2025-01-28 00:00:00.000	1287	1291	1.723518472	5470.139550725	0.001319692551	4.188468262	0.0785165147	0.00006011984281
9	2025-01-18 00:00:00.000	2149	2149	2.920643432	9732.750954647	0.001359070931	4.528967406	0.1224802026	0.00005699404495
10	2025-04-04 00:00:00.000	75	76	0.2076878389	374.715937258	0.002732734722	4.930472859	0.006973947165	0.0000917624627
11	2025-01-08 00:00:00.000	160	224	0.2247989276	751.97095878	0.001003566641	3.357013209	0.003744067672	0.00001671458782
12	2025-01-07 00:00:00.000	191	204	0.2636984745	947.939980012	0.001286334022	4.624097463	0.005737148808	0.00002798609175
13	2025-03-02 00:00:00.000	142	142	0.2673261348	611.936812053	0.001882578414	4.309414169	0.00317070677	0.00002232892092
14	2025-02-16 00:00:00.000	378	378	0.744348567	2006.540432068	0.001969176103	5.308308021	0.03603637603	0.00009533432813
15	2025-03-22 00:00:00.000	54	54	0.1231603408	244.645187839	0.002280747052	4.530466441	0.001552741702	0.00002875447596
16	2025-01-10 00:00:00.000	76	76	0.1029490617	336.328621984	0.001354592917	4.425376605	0.009970369903	0.0001311890777
17	2025-03-04 00:00:00.000	200	201	0.3663826491	772.56300284	0.001822799249	3.843597029	0.01453528458	0.00007231484863
18	2025-04-18 00:00:00.000	14	14	0.04783113865	75.868157759	0.003416509904	5.419154126	0.0007706720527	0.00005504800376
19	2025-03-17 00:00:00.000	43	43	0.100116189	191.343103295	0.002328283465	4.449839612	0.008642866321	0.0002009968912
20	2024-12-18 00:00:00.000	38	39	0.06045576408	232.495059372	0.001550147797	5.961411779	0.0007464899336	0.00001914076753

...

126

15KB

11s

flipside

flipside