PREVIEW / stock_1hour / 2021-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-25.parquet
  size:    1.5 MB
  rows:    69,177
  symbols: 2,727

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
2021-01-25 04:00:00	AAPL	Stock	141.02	143.0	141.02	141.87	183305.0
2021-01-25 05:00:00	AAPL	Stock	141.9	142.35	141.51	142.17	91047.0
2021-01-25 06:00:00	AAPL	Stock	142.12	142.43	141.6	141.9	104272.0
2021-01-25 07:00:00	AAPL	Stock	141.92	143.1	141.89	142.82	991619.0
2021-01-25 08:00:00	AAPL	Stock	142.81	143.09	139.07	142.65	1204065.0
2021-01-25 09:00:00	AAPL	Stock	142.67	145.09	142.5	144.935	23863900.0
2021-01-25 10:00:00	AAPL	Stock	144.94	144.99	140.88	141.13	21577681.0
2021-01-25 11:00:00	AAPL	Stock	141.09	142.77	136.54	142.59	29566887.0
2021-01-25 12:00:00	AAPL	Stock	142.6	142.95	140.91	142.43	14471754.0
2021-01-25 13:00:00	AAPL	Stock	142.43	143.29	142.16	142.66	11963593.0
2021-01-25 14:00:00	AAPL	Stock	142.67	143.0	141.79	142.69	8694457.0
2021-01-25 15:00:00	AAPL	Stock	142.695	143.13	141.75	142.9	14247352.0
2021-01-25 16:00:00	AAPL	Stock	142.92	143.8	142.88	143.55	6321006.0
2021-01-25 17:00:00	AAPL	Stock	143.55	143.57	142.51	142.82	262823.0
2021-01-25 18:00:00	AAPL	Stock	142.75	143.2	142.71	143.02	157952.0
2021-01-25 19:00:00	AAPL	Stock	143.02	143.09	142.61	142.72	183434.0
2021-01-25 04:00:00	MSFT	Stock	228.3	230.01	228.3	229.7	41026.0
2021-01-25 05:00:00	MSFT	Stock	229.82	229.86	229.21	229.73	17795.0
2021-01-25 06:00:00	MSFT	Stock	229.73	230.05	229.21	229.21	23539.0
2021-01-25 07:00:00	MSFT	Stock	229.04	229.89	228.85	228.85	82450.0
2021-01-25 08:00:00	MSFT	Stock	229.207	229.69	225.39	228.8	131315.0
2021-01-25 09:00:00	MSFT	Stock	228.9	229.74	227.26	227.395	3068948.0
2021-01-25 10:00:00	MSFT	Stock	227.37	229.17	225.96	226.184	4578375.0
2021-01-25 11:00:00	MSFT	Stock	226.17	227.06	224.22	226.98	3300502.0
2021-01-25 12:00:00	MSFT	Stock	226.99	227.75	225.28	227.56	2320631.0
2021-01-25 13:00:00	MSFT	Stock	227.6	229.09	227.1	228.626	2572013.0
2021-01-25 14:00:00	MSFT	Stock	228.63	229.19	228.08	228.622	1743029.0
2021-01-25 15:00:00	MSFT	Stock	228.63	229.78	227.27	229.52	3798458.0
2021-01-25 16:00:00	MSFT	Stock	229.53	230.0	229.47	229.7	3653104.0
2021-01-25 17:00:00	MSFT	Stock	229.74	230.0	229.5	229.5	17496.0
2021-01-25 18:00:00	MSFT	Stock	229.49	229.97	229.39	229.75	13399.0
2021-01-25 19:00:00	MSFT	Stock	229.75	229.9	229.65	229.75	15118.0
2021-01-25 04:00:00	NVDA	Stock	13.7368	13.8748	13.7368	13.8748	26440.0
2021-01-25 05:00:00	NVDA	Stock	13.824	13.8255	13.824	13.8255	8000.0
2021-01-25 06:00:00	NVDA	Stock	13.85	13.85	13.8412	13.8498	22560.0
2021-01-25 07:00:00	NVDA	Stock	13.8188	13.8188	13.775	13.7762	422200.0
2021-01-25 08:00:00	NVDA	Stock	13.7988	13.8125	13.7125	13.774	501120.0
2021-01-25 09:00:00	NVDA	Stock	13.7628	13.8285	13.7312	13.7545	30127960.0
2021-01-25 10:00:00	NVDA	Stock	13.759	13.7788	13.3778	13.3855	42681600.0
2021-01-25 11:00:00	NVDA	Stock	13.3888	13.5375	13.2365	13.5194	35751600.0
2021-01-25 12:00:00	NVDA	Stock	13.525	13.55	13.3908	13.5435	17295040.0
2021-01-25 13:00:00	NVDA	Stock	13.5421	13.6682	13.5348	13.6638	19111360.0
2021-01-25 14:00:00	NVDA	Stock	13.6633	13.6702	13.5923	13.6158	12651000.0
2021-01-25 15:00:00	NVDA	Stock	13.6151	13.6712	13.5173	13.6598	28169720.0
2021-01-25 16:00:00	NVDA	Stock	13.6532	13.6532	13.625	13.6325	3564360.0
2021-01-25 17:00:00	NVDA	Stock	13.6325	13.6325	13.6162	13.622	321000.0
2021-01-25 18:00:00	NVDA	Stock	13.589	13.6035	13.5852	13.6035	85560.0
2021-01-25 19:00:00	NVDA	Stock	13.6002	13.6002	13.585	13.585	27120.0
2021-01-25 04:00:00	AMZN	Stock	166.125	166.125	166.125	166.125	10160.0
2021-01-25 05:00:00	AMZN	Stock	166.05	166.05	165.5	165.5	15180.0

> showing 50 of 69,177 rows — these rows as CSV

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