-
Discord user IDNo response Describe your question in detail.Is there any way I can query the main net API to get the last transaction version for a particular date? What error, if any, are you getting?No response What have you tried or looked at? Or how can we reproduce the error?No response Which operating system are you using?macOS Which SDK or tool are you using? (if any)N/A Describe your environment or tooling in detailNo response |
Beta Was this translation helpful? Give feedback.
Answered by
ying-w
Feb 12, 2025
Replies: 1 comment
-
|
I don't think you can get it from indexer graphql or node rest endpoint. Instead use bigquery (or dune). Example using bigquery SELECT block_timestamp, tx_version
FROM `bigquery-public-data.crypto_aptos_mainnet_us.transactions`
WHERE block_timestamp > '2025-01-01' AND block_timestamp < '2025-01-07'
QUALIFY ROW_NUMBER() OVER (PARTITION BY DATE(block_timestamp) ORDER BY tx_version DESC) = 1
ORDER BY block_timestamp |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
aarush04
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I don't think you can get it from indexer graphql or node rest endpoint. Instead use bigquery (or dune). Example using bigquery