PREVIEW / stock_1hour / 2021-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-19.parquet
  size:    1.5 MB
  rows:    68,511
  symbols: 2,715

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2021-01-19 04:00:00	AAPL	Stock	128.55	129.0	128.51	128.9	59845.0
2021-01-19 05:00:00	AAPL	Stock	128.87	128.99	128.8	128.93	16430.0
2021-01-19 06:00:00	AAPL	Stock	128.95	129.0	128.7	128.89	24972.0
2021-01-19 07:00:00	AAPL	Stock	128.91	128.93	128.1	128.35	333557.0
2021-01-19 08:00:00	AAPL	Stock	128.36	128.9	127.93	127.97	363429.0
2021-01-19 09:00:00	AAPL	Stock	127.95	128.71	127.32	127.46	12763056.0
2021-01-19 10:00:00	AAPL	Stock	127.46	127.5	126.938	127.107	12369839.0
2021-01-19 11:00:00	AAPL	Stock	127.1	127.79	127.05	127.71	8488948.0
2021-01-19 12:00:00	AAPL	Stock	127.701	128.081	127.28	128.03	7289629.0
2021-01-19 13:00:00	AAPL	Stock	128.039	128.26	127.89	127.95	5954017.0
2021-01-19 14:00:00	AAPL	Stock	127.945	128.19	127.68	127.89	5651067.0
2021-01-19 15:00:00	AAPL	Stock	127.89	128.13	127.64	127.82	9243825.0
2021-01-19 16:00:00	AAPL	Stock	127.83	128.14	127.251	128.12	11324993.0
2021-01-19 17:00:00	AAPL	Stock	128.11	128.14	128.01	128.09	92160.0
2021-01-19 18:00:00	AAPL	Stock	128.08	128.24	128.06	128.15	105615.0
2021-01-19 19:00:00	AAPL	Stock	128.16	128.18	128.05	128.18	119865.0
2021-01-19 04:00:00	MSFT	Stock	214.0	214.65	214.0	214.48	6562.0
2021-01-19 05:00:00	MSFT	Stock	214.47	214.47	214.36	214.41	866.0
2021-01-19 06:00:00	MSFT	Stock	214.38	214.38	214.02	214.02	2020.0
2021-01-19 07:00:00	MSFT	Stock	214.02	214.05	213.55	213.78	27864.0
2021-01-19 08:00:00	MSFT	Stock	214.05	214.05	212.12	213.5	53028.0
2021-01-19 09:00:00	MSFT	Stock	213.5	214.92	213.053	214.17	2810736.0
2021-01-19 10:00:00	MSFT	Stock	214.17	214.605	213.12	213.87	2187718.0
2021-01-19 11:00:00	MSFT	Stock	213.88	213.9	212.63	213.615	1894826.0
2021-01-19 12:00:00	MSFT	Stock	213.618	215.09	213.59	215.0	1893364.0
2021-01-19 13:00:00	MSFT	Stock	214.99	216.09	214.99	215.976	1838989.0
2021-01-19 14:00:00	MSFT	Stock	215.98	216.51	215.76	216.23	1872245.0
2021-01-19 15:00:00	MSFT	Stock	216.23	216.98	216.12	216.44	3578213.0
2021-01-19 16:00:00	MSFT	Stock	216.44	216.88	216.02	216.7	7653091.0
2021-01-19 17:00:00	MSFT	Stock	216.77	216.87	216.55	216.87	30588.0
2021-01-19 18:00:00	MSFT	Stock	216.92	217.3	216.75	217.03	14602.0
2021-01-19 19:00:00	MSFT	Stock	217.03	217.16	217.0	217.02	10125.0
2021-01-19 04:00:00	NVDA	Stock	12.984	13.085	12.984	13.085	47000.0
2021-01-19 05:00:00	NVDA	Stock	13.1	13.1	13.0875	13.0875	29920.0
2021-01-19 06:00:00	NVDA	Stock	13.1125	13.1125	13.1125	13.1125	13240.0
2021-01-19 07:00:00	NVDA	Stock	13.1	13.1143	12.9485	12.9613	1117120.0
2021-01-19 08:00:00	NVDA	Stock	12.9605	13.1	12.9252	12.9708	757280.0
2021-01-19 09:00:00	NVDA	Stock	12.9688	13.094	12.9072	12.961	35731160.0
2021-01-19 10:00:00	NVDA	Stock	12.9635	13.0232	12.8825	12.9168	28260800.0
2021-01-19 11:00:00	NVDA	Stock	12.9161	12.9528	12.844	12.8786	23313760.0
2021-01-19 12:00:00	NVDA	Stock	12.8768	12.9685	12.865	12.9598	14614680.0
2021-01-19 13:00:00	NVDA	Stock	12.9595	13.0085	12.9565	12.985	15040520.0
2021-01-19 14:00:00	NVDA	Stock	12.987	13.0258	12.9593	13.008	14887280.0
2021-01-19 15:00:00	NVDA	Stock	13.0064	13.0438	12.9732	13.0252	23724760.0
2021-01-19 16:00:00	NVDA	Stock	13.0252	13.0688	13.0125	13.0595	12416800.0
2021-01-19 17:00:00	NVDA	Stock	13.066	13.075	13.05	13.05	211120.0
2021-01-19 18:00:00	NVDA	Stock	13.0625	13.0873	13.0625	13.075	219680.0
2021-01-19 19:00:00	NVDA	Stock	13.075	13.075	13.05	13.05	92600.0
2021-01-19 05:00:00	AMZN	Stock	156.55	156.55	156.55	156.55	2000.0
2021-01-19 07:00:00	AMZN	Stock	156.015	156.132	155.95	156.0	117200.0

> showing 50 of 68,511 rows — these rows as CSV

> unlock the full archive -- $79 one-time