PREVIEW / stock_1hour / 2022-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-04.parquet
  size:    1.4 MB
  rows:    64,741
  symbols: 2,566

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-01-04 04:00:00	AAPL	Stock	182.22	182.95	182.1	182.87	33168.0
2022-01-04 05:00:00	AAPL	Stock	182.89	183.38	182.82	183.28	45682.0
2022-01-04 06:00:00	AAPL	Stock	183.24	183.37	183.02	183.08	28945.0
2022-01-04 07:00:00	AAPL	Stock	183.05	183.14	182.32	182.75	163958.0
2022-01-04 08:00:00	AAPL	Stock	183.0499	183.13	182.3304	182.77	471333.0
2022-01-04 09:00:00	AAPL	Stock	182.74	182.94	181.49	182.27	11683670.0
2022-01-04 10:00:00	AAPL	Stock	182.27	182.6799	180.97	181.01	14797201.0
2022-01-04 11:00:00	AAPL	Stock	181.02	181.05	179.47	179.815	13521123.0
2022-01-04 12:00:00	AAPL	Stock	179.815	180.37	179.2	179.325	7708179.0
2022-01-04 13:00:00	AAPL	Stock	179.3276	179.98	179.12	179.4516	5379825.0
2022-01-04 14:00:00	AAPL	Stock	179.4588	180.18	179.31	180.0	6028936.0
2022-01-04 15:00:00	AAPL	Stock	180.0	180.5	179.62	179.69	10095295.0
2022-01-04 16:00:00	AAPL	Stock	179.7	179.75	179.4	179.47	7191348.0
2022-01-04 17:00:00	AAPL	Stock	179.48	179.54	179.45	179.47	30806.0
2022-01-04 18:00:00	AAPL	Stock	179.5	179.55	179.34	179.35	29732.0
2022-01-04 19:00:00	AAPL	Stock	179.35	179.39	179.25	179.33	51291.0
2022-01-04 04:00:00	MSFT	Stock	334.85	335.4	334.85	335.25	3821.0
2022-01-04 05:00:00	MSFT	Stock	335.25	335.9	335.25	335.75	4283.0
2022-01-04 06:00:00	MSFT	Stock	335.9	336.4	335.41	335.41	7195.0
2022-01-04 07:00:00	MSFT	Stock	335.68	335.7	334.5	335.0	14912.0
2022-01-04 08:00:00	MSFT	Stock	335.27	335.69	334.41	335.49	36348.0
2022-01-04 09:00:00	MSFT	Stock	335.27	335.32	332.44	334.0	2382143.0
2022-01-04 10:00:00	MSFT	Stock	333.99	334.37	329.35	329.98	3182088.0
2022-01-04 11:00:00	MSFT	Stock	330.03	330.08	327.56	328.0	3655607.0
2022-01-04 12:00:00	MSFT	Stock	327.98	328.31	326.57	327.33	2012578.0
2022-01-04 13:00:00	MSFT	Stock	327.33	328.41	326.52	326.59	1739604.0
2022-01-04 14:00:00	MSFT	Stock	326.58	327.99	326.12	327.685	2394249.0
2022-01-04 15:00:00	MSFT	Stock	327.68	330.3	327.68	329.05	3870209.0
2022-01-04 16:00:00	MSFT	Stock	329.05	329.07	327.9	328.45	4853229.0
2022-01-04 17:00:00	MSFT	Stock	328.35	328.67	328.25	328.28	6076.0
2022-01-04 18:00:00	MSFT	Stock	328.47	328.5	327.55	327.8	6605.0
2022-01-04 19:00:00	MSFT	Stock	327.76	327.95	327.55	327.55	9846.0
2022-01-04 04:00:00	NVDA	Stock	30.135	30.455	30.135	30.429	120840.0
2022-01-04 05:00:00	NVDA	Stock	30.45	30.465	30.405	30.425	46020.0
2022-01-04 06:00:00	NVDA	Stock	30.42	30.495	30.42	30.45	93930.0
2022-01-04 07:00:00	NVDA	Stock	30.46	30.46	30.3	30.376	455950.0
2022-01-04 08:00:00	NVDA	Stock	30.4	30.45	30.1963	30.344	1054110.0
2022-01-04 09:00:00	NVDA	Stock	30.349	30.5	29.678	29.72	44589920.0
2022-01-04 10:00:00	NVDA	Stock	29.7145	29.754	28.625	28.627	84786310.0
2022-01-04 11:00:00	NVDA	Stock	28.634	28.86	28.349	28.7	69714060.0
2022-01-04 12:00:00	NVDA	Stock	28.6905	28.855	28.507	28.519	32224610.0
2022-01-04 13:00:00	NVDA	Stock	28.523	28.721	28.47	28.525	27454360.0
2022-01-04 14:00:00	NVDA	Stock	28.516	28.891	28.511	28.839	32023290.0
2022-01-04 15:00:00	NVDA	Stock	28.841	29.395	28.839	29.299	63026340.0
2022-01-04 16:00:00	NVDA	Stock	29.2935	29.299	29.15	29.16	24642960.0
2022-01-04 17:00:00	NVDA	Stock	29.16	29.162	29.126	29.14	217170.0
2022-01-04 18:00:00	NVDA	Stock	29.145	29.154	29.007	29.036	373890.0
2022-01-04 19:00:00	NVDA	Stock	29.02	29.036	28.975	29.0	386650.0
2022-01-04 04:00:00	AMZN	Stock	170.3375	170.3375	170.3375	170.3375	5500.0
2022-01-04 05:00:00	AMZN	Stock	170.7495	170.7495	170.7495	170.7495	2040.0

> showing 50 of 64,741 rows — these rows as CSV

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