Skip to content

Updated time

To output the time the data was fetched, use this formula:

=QUERY(IMPORTDATA("https://cryptorates.ai/files/standard.csv", ",", "en_US"), "SELECT Col2 WHERE Col1 = 'Updated at'", 0)

SELECT Col2 is ATOM time, SELECT Col3 is Unix epoch time in seconds.