0xasmrUntitled Query
Updated 2022-08-14
9
1
2
3
4
5
6
7
›
⌄
SELECT
CASE WHEN origin_function_signature = '0x53a8aa03' THEN 'GPL_minted' ELSE 'GPL_redeemed' END AS actions,
COUNT(DISTINCT(origin_from_address)) AS no_of_users
FROM avalanche.core.fact_token_transfers
WHERE origin_function_signature IN ('0x53a8aa03' , '0x0f3aa554')
AND block_timestamp > CURRENT_DATE() - interval '3 months'
GROUP BY 1
Run a query to Download Data