adambalaToken Activity
Updated 2022-05-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with convex as (
SELECT tx_id ,date_trunc('day',block_timestamp) as date , origin_function_name
FROM ethereum.udm_events
WHERE
symbol = 'PSP' and block_timestamp>'2021-11-01'
)
select
count(distinct tx_id) as tx_id_number,
date ,
origin_function_name
from convex
group by 2,3 having origin_function_name is not null order by 1 desc
Run a query to Download Data