WEEK | TX_TYPE | EVENTS | USERS | VOLUME_USD | |
|---|---|---|---|---|---|
1 | 2024-07-08 00:00:00.000 | Buy | 16 | 6 | 319.45 |
2 | 2024-10-14 00:00:00.000 | Sell | 187 | 40 | 9856.4 |
3 | 2025-02-10 00:00:00.000 | Sell | 55 | 4 | 4885.05 |
4 | 2024-12-30 00:00:00.000 | Sell | 4 | 2 | 11.01 |
5 | 2024-06-24 00:00:00.000 | Buy | 98 | 47 | 3345.57 |
6 | 2025-01-20 00:00:00.000 | Buy | 3 | 3 | 49.75 |
7 | 2024-09-23 00:00:00.000 | Buy | 62 | 14 | 1769.36 |
8 | 2024-10-07 00:00:00.000 | Sell | 40 | 15 | 4790.5 |
9 | 2024-11-18 00:00:00.000 | Buy | 27 | 12 | 193.29 |
10 | 2025-01-20 00:00:00.000 | Sell | 10 | 5 | 449.94 |
11 | 2024-10-28 00:00:00.000 | Buy | 1069 | 221 | 25364.74 |
12 | 2024-10-21 00:00:00.000 | Buy | 695 | 103 | 9551.01 |
13 | 2024-11-04 00:00:00.000 | Sell | 197 | 44 | 3145.57 |
14 | 2025-01-06 00:00:00.000 | Sell | 478 | 24 | 7424.91 |
15 | 2024-09-09 00:00:00.000 | Buy | 120 | 23 | 4742.74 |
16 | 2024-12-23 00:00:00.000 | Sell | 12 | 6 | 108.88 |
17 | 2024-06-17 00:00:00.000 | Sell | 4399 | 705 | 802841.26 |
18 | 2024-10-07 00:00:00.000 | Buy | 97 | 26 | 5572.43 |
19 | 2024-07-15 00:00:00.000 | Sell | 38 | 14 | 7352.46 |
20 | 2025-01-27 00:00:00.000 | Buy | 8 | 3 | 76.7 |
Pine Analyticstime.fun
Updated 2025-02-14
99
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 tab1 as (
SELECT
tx_hash as tx,
case when ORIGIN_FUNCTION_SIGNATURE like '0x6945b123' then 'Buy'
when ORIGIN_FUNCTION_SIGNATURE like '0xb51d0534' then 'Sell'
end AS tx_type
from base.core.fact_event_logs
WHERE ORIGIN_TO_ADDRESS like lower('0x428aeF7fB31E4E86162D62d4530a4dd7232D953D')
and ORIGIN_FUNCTION_SIGNATURE in ('0x6945b123', '0xb51d0534')
)
SELECT
date_trunc('week', block_timestamp) as week,
tx_type,
count(DISTINCT tx_hash) as events,
count(DISTINCT user) as users,
sum(amount_usd) as volume_usd
FROM (
select
tx_hash,
'Buy' as tx_type,
block_timestamp,
ORIGIN_FROM_ADDRESS as user,
amount_usd
from base.core.ez_native_transfers as a
left outer join tab1
on tx = tx_hash
where a.tx_hash in (SELECT tx from tab1)
--and tx_hash like '0x2abc25318056095fb0843cb4b7945c7f2bfb5f5b364bd597d504e88d78423688'
AND tx_type like 'Buy'
and ORIGIN_FROM_ADDRESS = from_address
UNION all
Last run: about 2 months ago
69
3KB
113s