PREVIEW / stock_1hour / 2022-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-07.parquet
  size:    1.4 MB
  rows:    62,788
  symbols: 2,408

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-07 04:00:00	AAPL	Stock	145.88	145.88	145.41	145.62	23059.0
2022-06-07 05:00:00	AAPL	Stock	145.6	145.72	145.45	145.46	11012.0
2022-06-07 06:00:00	AAPL	Stock	145.49	145.55	144.96	144.96	48143.0
2022-06-07 07:00:00	AAPL	Stock	144.96	145.36	143.95	144.16	207491.0
2022-06-07 08:00:00	AAPL	Stock	145.1	145.88	143.8	144.069	864838.0
2022-06-07 09:00:00	AAPL	Stock	144.05	147.0999	143.8614	146.6	9712929.0
2022-06-07 10:00:00	AAPL	Stock	146.62	148.3	145.93	147.745	10468387.0
2022-06-07 11:00:00	AAPL	Stock	147.75	147.85	146.785	147.57	6677630.0
2022-06-07 12:00:00	AAPL	Stock	147.565	147.885	147.09	147.68	4619760.0
2022-06-07 13:00:00	AAPL	Stock	147.685	148.36	147.62	148.1388	5158705.0
2022-06-07 14:00:00	AAPL	Stock	148.14	148.97	148.03	148.365	6152639.0
2022-06-07 15:00:00	AAPL	Stock	148.37	149.0	148.32	148.69	8739444.0
2022-06-07 16:00:00	AAPL	Stock	148.66	148.71	148.23	148.31	6531570.0
2022-06-07 17:00:00	AAPL	Stock	148.3474	148.41	148.2817	148.41	29588.0
2022-06-07 18:00:00	AAPL	Stock	148.41	148.49	148.4	148.48	34862.0
2022-06-07 19:00:00	AAPL	Stock	148.47	148.5	148.2	148.22	43820.0
2022-06-07 04:00:00	MSFT	Stock	267.39	267.5	267.12	267.12	5111.0
2022-06-07 05:00:00	MSFT	Stock	267.11	267.41	266.9	267.05	6737.0
2022-06-07 06:00:00	MSFT	Stock	266.9	266.9	265.71	265.74	2820.0
2022-06-07 07:00:00	MSFT	Stock	266.03	266.97	265.76	266.51	14945.0
2022-06-07 08:00:00	MSFT	Stock	266.33	268.079	265.3	265.38	36671.0
2022-06-07 09:00:00	MSFT	Stock	265.6	269.48	265.5024	268.4	1842285.0
2022-06-07 10:00:00	MSFT	Stock	268.48	272.0	267.61	270.93	2043985.0
2022-06-07 11:00:00	MSFT	Stock	270.94	271.58	269.84	270.7	1529371.0
2022-06-07 12:00:00	MSFT	Stock	270.75	271.03	269.61	270.73	1121459.0
2022-06-07 13:00:00	MSFT	Stock	270.79	271.21	270.47	270.75	1234286.0
2022-06-07 14:00:00	MSFT	Stock	270.75	272.08	270.6218	271.67	1197635.0
2022-06-07 15:00:00	MSFT	Stock	271.6658	273.13	271.59	272.5	2718661.0
2022-06-07 16:00:00	MSFT	Stock	272.5	272.5	271.7005	271.8	3381616.0
2022-06-07 17:00:00	MSFT	Stock	271.87	271.89	271.8008	271.85	9244.0
2022-06-07 18:00:00	MSFT	Stock	271.85	272.0	271.75	271.75	5537.0
2022-06-07 19:00:00	MSFT	Stock	271.93	272.0	271.2	271.46	10439.0
2022-06-07 04:00:00	NVDA	Stock	18.67	18.735	18.67	18.703	82060.0
2022-06-07 05:00:00	NVDA	Stock	18.681	18.699	18.636	18.645	55430.0
2022-06-07 06:00:00	NVDA	Stock	18.648	18.653	18.499	18.499	137680.0
2022-06-07 07:00:00	NVDA	Stock	18.526	18.57	18.4	18.51	392980.0
2022-06-07 08:00:00	NVDA	Stock	18.527	18.8329	18.4	18.442	1283560.0
2022-06-07 09:00:00	NVDA	Stock	18.44	18.744	18.188	18.575	49470180.0
2022-06-07 10:00:00	NVDA	Stock	18.565	18.933	18.452	18.8231	63084410.0
2022-06-07 11:00:00	NVDA	Stock	18.828	18.861	18.55	18.6915	41152390.0
2022-06-07 12:00:00	NVDA	Stock	18.692	18.76	18.596	18.754	26365590.0
2022-06-07 13:00:00	NVDA	Stock	18.7571	18.863	18.718	18.78	27861700.0
2022-06-07 14:00:00	NVDA	Stock	18.782	18.885	18.719	18.758	28936070.0
2022-06-07 15:00:00	NVDA	Stock	18.758	19.0	18.745	18.926	50070590.0
2022-06-07 16:00:00	NVDA	Stock	18.922	18.937	18.887	18.891	16635470.0
2022-06-07 17:00:00	NVDA	Stock	18.892	18.925	18.888	18.903	246400.0
2022-06-07 18:00:00	NVDA	Stock	18.905	18.918	18.878	18.898	226980.0
2022-06-07 19:00:00	NVDA	Stock	18.898	18.914	18.87	18.88	202840.0
2022-06-07 04:00:00	AMZN	Stock	124.76	124.8	124.28	124.52	36985.0
2022-06-07 05:00:00	AMZN	Stock	124.54	124.54	124.31	124.35	13463.0

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

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