This API endpoint, "Last Block Indexed," allows users to retrieve the most recent block indexed from a specified network's blockchain data. Users need to specify the 'network' query parameter as input. The 'network' is a string which represents the particular blockchain network from which the data will be extracted. The SQL query used for this API calculates the time elapsed since the block was indexed, the block number, and the timestamp of when the block was indexed. The results are ordered by the timestamp in descending order, thus the block with the most recent timestamp is returned. Outputs include 'seconds_ago', 'number', and 'timestamp', representing respectively the number of seconds elapsed since the block was indexed, the block's number, and the block's timestamp. The visual representation of the output is displayed in a table format.
Clone, Modify, Create API here at View query
post https://api.dev.dex.guru/wh/last_block_indexed