isaqueprofeta/random_timeseries.sql

Last active August 9, 2021 15:52

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/isaqueprofeta/42807eac78d096488750fed3400d6e7c.js"></script>
Save isaqueprofeta/42807eac78d096488750fed3400d6e7c to your computer and use it in GitHub Desktop.

Download ZIP

Random timeseries with random data in postgres

Raw

random_timeseries.sql

	SELECT
	time,
	random()
	FROM
	generate_series(
	NOW() - '24 hour'::interval,
	NOW(),
	'1 hour'::interval
	) time;
	ORDER BY time

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment