FlippyCrewthorchain users copy
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
-- forked from omer93 / thorchain users @ https://flipsidecrypto.xyz/omer93/q/usJjpkWAIYac/thorchain-users
SELECT
date_trunc('day',_INSERTED_TIMESTAMP) as day,
count(distinct from_address) as senders,
count(distinct to_address) as receivers
from thorchain.core.fact_transfer_events
where _INSERTED_TIMESTAMP>=current_date-INTERVAL '1 MONTH'
group by 1 order by 1 asc
Run a query to Download Data