nitsTCR sent daily
Updated 2022-03-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT date(block_timestamp) as day, count(DISTINCT tx_from_address) as unique_senders,
sum(total_tcr_tokens) as total_tcr_sent,
sum(total_tcr_sent) over (order by day) as cumulative_total_tcr_sent
from
(SELECT *,
EVENT_INPUTS:value/pow(10,18) as total_tcr_tokens
from ethereum.events_emitted
where
tx_to_address ilike '0xA84918F3280d488EB3369Cb713Ec53cE386b6cBa'
and total_tcr_tokens is not NULL and event_name = 'Transfer'
)
GROUP by 1
order by day desc
-- and total_tcr_tokens < pow(10,8)
Run a query to Download Data