PREVIEW / stock_1hour / 2022-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-01.parquet
  size:    1.4 MB
  rows:    62,011
  symbols: 2,416

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-06-01 04:00:00	AAPL	Stock	148.95	149.48	148.35	148.76	24015.0
2022-06-01 05:00:00	AAPL	Stock	148.85	149.04	148.76	148.85	6156.0
2022-06-01 06:00:00	AAPL	Stock	148.84	148.96	148.6	148.75	19073.0
2022-06-01 07:00:00	AAPL	Stock	148.75	149.27	148.52	149.27	75436.0
2022-06-01 08:00:00	AAPL	Stock	148.75	149.89	148.5312	149.6	427750.0
2022-06-01 09:00:00	AAPL	Stock	149.56	151.52	149.51	151.3401	10480321.0
2022-06-01 10:00:00	AAPL	Stock	151.3687	151.74	148.66	149.815	12487498.0
2022-06-01 11:00:00	AAPL	Stock	149.81	149.81	147.91	148.24	7403384.0
2022-06-01 12:00:00	AAPL	Stock	148.2309	148.59	147.68	148.25	5150504.0
2022-06-01 13:00:00	AAPL	Stock	148.25	148.88	148.01	148.575	5338384.0
2022-06-01 14:00:00	AAPL	Stock	148.57	149.86	148.5115	149.2175	6596138.0
2022-06-01 15:00:00	AAPL	Stock	149.215	149.99	148.52	148.7	10474199.0
2022-06-01 16:00:00	AAPL	Stock	148.7	148.79	148.39	148.4075	5540793.0
2022-06-01 17:00:00	AAPL	Stock	148.5	148.65	148.4902	148.62	28179.0
2022-06-01 18:00:00	AAPL	Stock	148.63	148.69	148.42	148.53	59587.0
2022-06-01 19:00:00	AAPL	Stock	148.48	148.5	147.9	148.01	77025.0
2022-06-01 04:00:00	MSFT	Stock	272.22	272.22	271.23	271.67	2193.0
2022-06-01 05:00:00	MSFT	Stock	271.68	271.9	271.68	271.9	1977.0
2022-06-01 06:00:00	MSFT	Stock	271.95	272.25	271.8	271.87	8445.0
2022-06-01 07:00:00	MSFT	Stock	272.0	273.87	271.94	273.87	28482.0
2022-06-01 08:00:00	MSFT	Stock	272.8	274.8	272.0209	274.0	58998.0
2022-06-01 09:00:00	MSFT	Stock	274.03	277.69	273.76	277.295	2969474.0
2022-06-01 10:00:00	MSFT	Stock	277.285	277.51	271.62	273.515	3117237.0
2022-06-01 11:00:00	MSFT	Stock	273.49	273.5	270.95	271.28	1810168.0
2022-06-01 12:00:00	MSFT	Stock	271.25	271.38	270.04	270.8	1535588.0
2022-06-01 13:00:00	MSFT	Stock	270.79	272.065	270.25	271.6687	1675286.0
2022-06-01 14:00:00	MSFT	Stock	271.64	274.45	271.53	273.6	1847330.0
2022-06-01 15:00:00	MSFT	Stock	273.619	274.76	272.13	272.35	3007999.0
2022-06-01 16:00:00	MSFT	Stock	272.42	273.0	271.7	271.7	2832917.0
2022-06-01 17:00:00	MSFT	Stock	272.05	272.35	271.9	272.31	8640.0
2022-06-01 18:00:00	MSFT	Stock	272.4	272.42	271.73	271.73	3783.0
2022-06-01 19:00:00	MSFT	Stock	271.97	272.3	271.5	271.6	9166.0
2022-06-01 04:00:00	NVDA	Stock	18.696	18.696	18.451	18.586	215720.0
2022-06-01 05:00:00	NVDA	Stock	18.577	18.62	18.552	18.552	104030.0
2022-06-01 06:00:00	NVDA	Stock	18.536	18.549	18.491	18.54	38340.0
2022-06-01 07:00:00	NVDA	Stock	18.567	18.67	18.55	18.67	499450.0
2022-06-01 08:00:00	NVDA	Stock	18.569	18.7679	18.55	18.651	1490910.0
2022-06-01 09:00:00	NVDA	Stock	18.665	19.0532	18.622	18.98	61990270.0
2022-06-01 10:00:00	NVDA	Stock	18.9825	19.024	18.458	18.759	94608970.0
2022-06-01 11:00:00	NVDA	Stock	18.758	18.765	18.331	18.3355	53572370.0
2022-06-01 12:00:00	NVDA	Stock	18.3356	18.376	18.122	18.347	56488340.0
2022-06-01 13:00:00	NVDA	Stock	18.343	18.444	18.272	18.349	42707320.0
2022-06-01 14:00:00	NVDA	Stock	18.349	18.568	18.3244	18.426	51588050.0
2022-06-01 15:00:00	NVDA	Stock	18.4241	18.563	18.294	18.304	56330430.0
2022-06-01 16:00:00	NVDA	Stock	18.3	18.339	18.252	18.284	21781570.0
2022-06-01 17:00:00	NVDA	Stock	18.286	18.339	18.276	18.305	300360.0
2022-06-01 18:00:00	NVDA	Stock	18.318	18.32	18.273	18.274	333870.0
2022-06-01 19:00:00	NVDA	Stock	18.273	18.297	18.23	18.25	401250.0
2022-06-01 04:00:00	AMZN	Stock	120.87	120.87	120.7	120.7	4000.0
2022-06-01 06:00:00	AMZN	Stock	120.8	121.5175	120.8	121.285	27140.0

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

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