connorhPolygon Volumes
Updated 2021-10-05
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT DATE_TRUNC('month',block_timestamp) as balance_month,
from_address AS user_address,
to_address AS sent_to,
to_label,
SUM(CASE WHEN amount_usd IS NULL THEN 0 ELSE amount_usd END) AS volume_usd,
COUNT(DISTINCT tx_id) AS n_txn
FROM polygon.udm_events
WHERE block_timestamp >= CURRENT_DATE - 120 AND amount > 0
GROUP BY 1,2,3,4
Run a query to Download Data