Amount of tx per user in ranges

pecio222Amount of tx per user in ranges

Updated 2022-10-03

swapExactTokensForTokens(uint256,uint256,address[],address,uint256) 0x38ed1739

swapExactTokensForAVAX(uint256,uint256,address[],address,uint256) 0x676528d1

swapExactAVAXForTokens(uint256,address[],address,uint256) 0xa2a1623d

swapTokensForExactTokens(uint256,uint256,address[],address,uint256) 0x8803dbee

swapAVAXForExactTokens(uint256,address[],address,uint256) 0x8a657e67

swapExactTokensForTokensSupportingFeeOnTransferTokens(uint256,uint256,address[],address,uint256) 0x5c11d795

swapExactTokensForAVAXSupportingFeeOnTransferTokens(uint256,uint256,address[],address,uint256) 0x762b1562

swapTokensForExactAVAX(uint256,uint256,address[],address,uint256) 0x7a42416a

swapExactAVAXForTokensSupportingFeeOnTransferTokens(uint256,address[],address,uint256) 0xc57559dd

Saturday, April 2, 2022 12:00:00 AM - 1648857600

Saturday, January 1, 2022 12:01:00 AM - 1640995260

SELECT FROM_ADDRESS, COUNT(FROM_ADDRESS) FROM avalanche.core.fact_transactions

WHERE TO_ADDRESS='0x60ae616a2155ee3d9a68541ba4544862310933d4'

AND ORIGIN_FUNCTION_SIGNATURE IN ('0x38ed1739','0x676528d1','0xa2a1623d','0x8803dbee','0x8a657e67','0x5c11d795','0x762b1562','0x7a42416a','0xc57559dd')

AND BLOCK_TIMESTAMP > '1648857600'

GROUP BY DATEADD(MONTH, DATEDIFF(MONTH, 0, DATE(BLOCK_TIMESTAMP), 0), FROM_ADDRESS

LIMIT 10

WITH INTERACTION_COUNT_TABLE AS (

SELECT

FROM_ADDRESS,

COUNT(FROM_ADDRESS) AS INTERACTION_AMOUNT,

EXTRACT(MONTH FROM DATE(BLOCK_TIMESTAMP)) AS MONTH

FROM avalanche.core.fact_transactions

WHERE TO_ADDRESS='0x60ae616a2155ee3d9a68541ba4544862310933d4'

AND ORIGIN_FUNCTION_SIGNATURE IN ('0x38ed1739','0x676528d1','0xa2a1623d','0x8803dbee','0x8a657e67','0x5c11d795','0x762b1562','0x7a42416a','0xc57559dd')

AND BLOCK_TIMESTAMP > '1640995260'

GROUP BY MONTH, FROM_ADDRESS

ORDER BY MONTH DESC)

--LIMIT 100)

SELECT INTERACTION_AMOUNT, COUNT(INTERACTION_AMOUNT), MONTH

Run a query to Download Data

flipside

flipside