PREVIEW / stock_1hour / 2022-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-27.parquet
  size:    1.4 MB
  rows:    62,523
  symbols: 2,376

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
2022-05-27 04:00:00	AAPL	Stock	143.99	144.24	143.0	144.06	26564.0
2022-05-27 05:00:00	AAPL	Stock	144.0	144.45	143.85	144.4	20640.0
2022-05-27 06:00:00	AAPL	Stock	144.35	144.35	143.97	144.29	23742.0
2022-05-27 07:00:00	AAPL	Stock	144.18	144.3	143.65	143.75	66948.0
2022-05-27 08:00:00	AAPL	Stock	144.25	145.58	143.03	145.36	1008981.0
2022-05-27 09:00:00	AAPL	Stock	145.39	147.32	145.0	147.06	12743474.0
2022-05-27 10:00:00	AAPL	Stock	147.05	148.66	146.92	147.43	14109764.0
2022-05-27 11:00:00	AAPL	Stock	147.44	148.7	147.25	148.5931	8453452.0
2022-05-27 12:00:00	AAPL	Stock	148.6	148.83	147.95	148.32	6418444.0
2022-05-27 13:00:00	AAPL	Stock	148.31	148.71	148.06	148.295	5197807.0
2022-05-27 14:00:00	AAPL	Stock	148.3	148.85	148.18	148.765	5217665.0
2022-05-27 15:00:00	AAPL	Stock	148.765	149.68	148.56	149.65	16636034.0
2022-05-27 16:00:00	AAPL	Stock	149.64	149.95	149.48	149.93	11168411.0
2022-05-27 17:00:00	AAPL	Stock	149.92	149.95	149.64	149.85	194028.0
2022-05-27 18:00:00	AAPL	Stock	149.8301	150.0	149.8	149.99	39176.0
2022-05-27 19:00:00	AAPL	Stock	149.99	150.0	149.97	150.0	112586.0
2022-05-27 04:00:00	MSFT	Stock	266.08	267.38	266.08	266.98	2758.0
2022-05-27 05:00:00	MSFT	Stock	266.75	267.89	266.55	267.89	14208.0
2022-05-27 06:00:00	MSFT	Stock	267.77	267.8	267.0	267.5	2777.0
2022-05-27 07:00:00	MSFT	Stock	267.18	267.29	266.02	266.22	12450.0
2022-05-27 08:00:00	MSFT	Stock	267.0023	268.6599	265.236	268.2	112051.0
2022-05-27 09:00:00	MSFT	Stock	268.2	270.95	267.16	270.7788	2538524.0
2022-05-27 10:00:00	MSFT	Stock	270.83	272.28	270.5211	271.17	2606261.0
2022-05-27 11:00:00	MSFT	Stock	271.2	272.35	270.77	272.22	1666948.0
2022-05-27 12:00:00	MSFT	Stock	272.22	272.44	271.19	271.625	1365236.0
2022-05-27 13:00:00	MSFT	Stock	271.61	271.98	270.685	270.87	1361938.0
2022-05-27 14:00:00	MSFT	Stock	270.87	271.12	270.41	271.0934	1468170.0
2022-05-27 15:00:00	MSFT	Stock	271.09	273.34	270.93	273.23	3827422.0
2022-05-27 16:00:00	MSFT	Stock	273.24	273.92	272.7302	273.72	5343696.0
2022-05-27 17:00:00	MSFT	Stock	273.7399	273.7399	273.0	273.5	101968.0
2022-05-27 18:00:00	MSFT	Stock	273.4592	273.75	273.42	273.65	11282.0
2022-05-27 19:00:00	MSFT	Stock	273.88	274.0	273.65	274.0	4949.0
2022-05-27 04:00:00	NVDA	Stock	17.61	17.988	17.61	17.988	255280.0
2022-05-27 05:00:00	NVDA	Stock	17.972	18.08	17.949	18.07	140810.0
2022-05-27 06:00:00	NVDA	Stock	18.071	18.076	17.934	17.98	176020.0
2022-05-27 07:00:00	NVDA	Stock	17.984	18.015	17.8	17.825	743100.0
2022-05-27 08:00:00	NVDA	Stock	18.01	18.18	17.75	18.13	3084020.0
2022-05-27 09:00:00	NVDA	Stock	18.127	18.588	18.091	18.309	100180980.0
2022-05-27 10:00:00	NVDA	Stock	18.304	18.68	18.27	18.4347	126565160.0
2022-05-27 11:00:00	NVDA	Stock	18.436	18.586	18.363	18.5515	61758260.0
2022-05-27 12:00:00	NVDA	Stock	18.5515	18.622	18.463	18.585	45317010.0
2022-05-27 13:00:00	NVDA	Stock	18.585	18.649	18.531	18.6332	42784120.0
2022-05-27 14:00:00	NVDA	Stock	18.634	18.774	18.56	18.742	55912150.0
2022-05-27 15:00:00	NVDA	Stock	18.742	18.881	18.688	18.836	89243400.0
2022-05-27 16:00:00	NVDA	Stock	18.829	18.919	18.775	18.905	30037280.0
2022-05-27 17:00:00	NVDA	Stock	18.911	18.928	18.811	18.909	668540.0
2022-05-27 18:00:00	NVDA	Stock	18.909	18.92	18.9	18.919	240220.0
2022-05-27 19:00:00	NVDA	Stock	18.915	18.948	18.915	18.945	324920.0
2022-05-27 04:00:00	AMZN	Stock	111.0	112.0	110.95	112.0	34920.0
2022-05-27 05:00:00	AMZN	Stock	111.9	111.9	111.9	111.9	2040.0

> showing 50 of 62,523 rows — these rows as CSV

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