PREVIEW / stock_1hour / 2023-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-27.parquet
  size:    1.3 MB
  rows:    59,731
  symbols: 1,577

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
2023-06-27 04:00:00	AAPL	Stock	185.85	186.15	185.65	185.65	7102.0
2023-06-27 05:00:00	AAPL	Stock	185.81	185.97	185.8	185.81	1976.0
2023-06-27 06:00:00	AAPL	Stock	185.7	185.88	185.7	185.83	2210.0
2023-06-27 07:00:00	AAPL	Stock	185.8	185.86	185.42	185.55	30592.0
2023-06-27 08:00:00	AAPL	Stock	185.82	186.05	185.27	185.87	108759.0
2023-06-27 09:00:00	AAPL	Stock	185.84	187.0442	185.67	186.89	5683897.0
2023-06-27 10:00:00	AAPL	Stock	186.87	187.0	186.23	186.72	5352225.0
2023-06-27 11:00:00	AAPL	Stock	186.725	187.22	186.05	187.115	4484265.0
2023-06-27 12:00:00	AAPL	Stock	187.12	187.84	187.05	187.665	4227380.0
2023-06-27 13:00:00	AAPL	Stock	187.66	188.19	187.52	188.13	4360710.0
2023-06-27 14:00:00	AAPL	Stock	188.13	188.285	187.93	188.015	3165070.0
2023-06-27 15:00:00	AAPL	Stock	188.02	188.39	187.96	188.04	7042218.0
2023-06-27 16:00:00	AAPL	Stock	188.04	188.08	187.8	187.96	6901681.0
2023-06-27 17:00:00	AAPL	Stock	187.94	187.98	187.86	187.9	18961.0
2023-06-27 18:00:00	AAPL	Stock	187.9	187.98	187.7	187.8498	64975.0
2023-06-27 19:00:00	AAPL	Stock	187.84	188.08	187.72	187.9999	43728.0
2023-06-27 04:00:00	MSFT	Stock	329.47	329.89	329.3	329.89	6214.0
2023-06-27 05:00:00	MSFT	Stock	329.61	330.2	329.61	330.15	819.0
2023-06-27 06:00:00	MSFT	Stock	330.5	331.0	330.15	330.4	3108.0
2023-06-27 07:00:00	MSFT	Stock	330.46	330.61	330.18	330.46	18879.0
2023-06-27 08:00:00	MSFT	Stock	330.46	331.41	329.0	330.45	45867.0
2023-06-27 09:00:00	MSFT	Stock	330.5013	334.1144	330.5	333.24	2100283.0
2023-06-27 10:00:00	MSFT	Stock	333.235	333.75	330.28	330.77	2204575.0
2023-06-27 11:00:00	MSFT	Stock	330.8	332.84	329.3	332.47	1852816.0
2023-06-27 12:00:00	MSFT	Stock	332.48	333.0	331.27	332.762	1326447.0
2023-06-27 13:00:00	MSFT	Stock	332.75	334.75	332.27	334.71	1159108.0
2023-06-27 14:00:00	MSFT	Stock	334.74	336.15	334.445	335.6282	1538778.0
2023-06-27 15:00:00	MSFT	Stock	335.66	335.98	334.31	334.54	2300009.0
2023-06-27 16:00:00	MSFT	Stock	334.655	334.71	333.89	334.1264	3588769.0
2023-06-27 17:00:00	MSFT	Stock	334.1201	334.21	333.62	333.75	5224.0
2023-06-27 18:00:00	MSFT	Stock	333.9999	334.5	333.61	333.95	31697.0
2023-06-27 19:00:00	MSFT	Stock	333.95	334.54	333.7501	334.54	16169.0
2023-06-27 04:00:00	NVDA	Stock	40.8	41.058	40.8	40.978	170970.0
2023-06-27 05:00:00	NVDA	Stock	41.035	41.078	40.99	41.02	40760.0
2023-06-27 06:00:00	NVDA	Stock	41.023	41.049	40.9	40.962	84290.0
2023-06-27 07:00:00	NVDA	Stock	40.99	41.0	40.85	40.923	339940.0
2023-06-27 08:00:00	NVDA	Stock	40.962	40.995	40.5	40.805	1026770.0
2023-06-27 09:00:00	NVDA	Stock	40.8	41.299	40.79	40.9976	45973260.0
2023-06-27 10:00:00	NVDA	Stock	40.983	41.127	40.448	40.6104	66469320.0
2023-06-27 11:00:00	NVDA	Stock	40.616	41.187	40.461	41.181	48124680.0
2023-06-27 12:00:00	NVDA	Stock	41.177	41.5217	41.1612	41.4008	45637130.0
2023-06-27 13:00:00	NVDA	Stock	41.4	41.697	41.305	41.676	32817380.0
2023-06-27 14:00:00	NVDA	Stock	41.6788	41.7809	41.475	41.535	33477630.0
2023-06-27 15:00:00	NVDA	Stock	41.536	41.94	41.536	41.875	49622000.0
2023-06-27 16:00:00	NVDA	Stock	41.876	41.892	41.752	41.824	18486540.0
2023-06-27 17:00:00	NVDA	Stock	41.823	41.85	41.78	41.802	324440.0
2023-06-27 18:00:00	NVDA	Stock	41.813	41.813	40.695	40.8	5264680.0
2023-06-27 19:00:00	NVDA	Stock	40.775	40.799	40.518	40.585	4088490.0
2023-06-27 04:00:00	AMZN	Stock	128.4	128.4	127.66	127.8	10033.0
2023-06-27 05:00:00	AMZN	Stock	127.86	128.25	127.82	128.2	7492.0

> showing 50 of 59,731 rows — these rows as CSV

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