PREVIEW / stock_1hour / 2022-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-01.parquet
  size:    1.4 MB
  rows:    61,602
  symbols: 2,126

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-11-01 04:00:00	AAPL	Stock	153.59	154.6	153.04	154.55	36351.0
2022-11-01 05:00:00	AAPL	Stock	154.4	154.82	154.26	154.8	17856.0
2022-11-01 06:00:00	AAPL	Stock	154.82	155.15	154.64	155.0	33753.0
2022-11-01 07:00:00	AAPL	Stock	154.9	155.06	154.69	154.94	67779.0
2022-11-01 08:00:00	AAPL	Stock	154.79	155.65	154.0	155.57	323707.0
2022-11-01 09:00:00	AAPL	Stock	155.57	155.6501	152.68	152.863	9304836.0
2022-11-01 10:00:00	AAPL	Stock	152.87	152.99	149.66	150.05	16860249.0
2022-11-01 11:00:00	AAPL	Stock	150.05	150.31	149.13	150.06	8907564.0
2022-11-01 12:00:00	AAPL	Stock	150.05	150.5	149.61	150.065	6804919.0
2022-11-01 13:00:00	AAPL	Stock	150.06	150.37	149.615	150.11	4591602.0
2022-11-01 14:00:00	AAPL	Stock	150.105	151.09	149.96	150.97	6416335.0
2022-11-01 15:00:00	AAPL	Stock	150.96	151.05	150.421	150.57	10270283.0
2022-11-01 16:00:00	AAPL	Stock	150.57	150.69	150.1	150.32	6566727.0
2022-11-01 17:00:00	AAPL	Stock	150.31	150.4699	150.25	150.25	34908.0
2022-11-01 18:00:00	AAPL	Stock	150.27	150.65	150.27	150.46	37840.0
2022-11-01 19:00:00	AAPL	Stock	150.42	150.63	150.38	150.41	32139.0
2022-11-01 04:00:00	MSFT	Stock	234.0	234.6	234.0	234.35	2667.0
2022-11-01 05:00:00	MSFT	Stock	234.34	234.65	233.8	234.65	1624.0
2022-11-01 06:00:00	MSFT	Stock	234.5	235.45	234.5	235.19	3054.0
2022-11-01 07:00:00	MSFT	Stock	235.2	235.2	233.0	234.75	26759.0
2022-11-01 08:00:00	MSFT	Stock	234.5549	235.0	234.26	234.7	43015.0
2022-11-01 09:00:00	MSFT	Stock	234.37	235.74	230.32	230.63	2961542.0
2022-11-01 10:00:00	MSFT	Stock	230.66	230.91	228.1	228.735	3803077.0
2022-11-01 11:00:00	MSFT	Stock	228.76	230.59	228.64	229.45	2548248.0
2022-11-01 12:00:00	MSFT	Stock	229.45	230.22	227.325	228.46	2417388.0
2022-11-01 13:00:00	MSFT	Stock	228.48	228.58	227.37	228.27	1661419.0
2022-11-01 14:00:00	MSFT	Stock	228.26	228.98	228.06	228.6711	2150369.0
2022-11-01 15:00:00	MSFT	Stock	228.68	229.1	228.07	228.16	4174193.0
2022-11-01 16:00:00	MSFT	Stock	228.17	228.35	227.16	227.58	3787161.0
2022-11-01 17:00:00	MSFT	Stock	227.58	227.9	227.58	227.87	6662.0
2022-11-01 18:00:00	MSFT	Stock	227.96	228.15	227.8	227.99	8987.0
2022-11-01 19:00:00	MSFT	Stock	228.0	228.15	227.8	227.8	6980.0
2022-11-01 04:00:00	NVDA	Stock	13.526	13.747	13.526	13.738	180300.0
2022-11-01 05:00:00	NVDA	Stock	13.72	13.759	13.72	13.727	54370.0
2022-11-01 06:00:00	NVDA	Stock	13.75	13.766	13.732	13.754	66060.0
2022-11-01 07:00:00	NVDA	Stock	13.747	13.76	13.703	13.754	153760.0
2022-11-01 08:00:00	NVDA	Stock	13.733	13.858	13.437	13.815	1439500.0
2022-11-01 09:00:00	NVDA	Stock	13.812	13.925	13.7058	13.767	64528450.0
2022-11-01 10:00:00	NVDA	Stock	13.769	13.785	13.519	13.61	75978200.0
2022-11-01 11:00:00	NVDA	Stock	13.61	13.78	13.582	13.763	58549800.0
2022-11-01 12:00:00	NVDA	Stock	13.761	13.855	13.658	13.688	40471090.0
2022-11-01 13:00:00	NVDA	Stock	13.688	13.733	13.594	13.6373	29506120.0
2022-11-01 14:00:00	NVDA	Stock	13.6375	13.714	13.612	13.6885	30275270.0
2022-11-01 15:00:00	NVDA	Stock	13.689	13.701	13.53	13.54	45831710.0
2022-11-01 16:00:00	NVDA	Stock	13.542	13.726	13.352	13.7	17598590.0
2022-11-01 17:00:00	NVDA	Stock	13.686	13.82	13.685	13.71	1585310.0
2022-11-01 18:00:00	NVDA	Stock	13.727	13.744	13.543	13.73	172000.0
2022-11-01 19:00:00	NVDA	Stock	13.74	13.74	13.68	13.69	293250.0
2022-11-01 04:00:00	AMZN	Stock	103.01	103.63	102.75	103.5	27058.0
2022-11-01 05:00:00	AMZN	Stock	103.4	103.55	103.19	103.54	10686.0

> showing 50 of 61,602 rows — these rows as CSV

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