PREVIEW / stock_1hour / 2020-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-31.parquet
  size:    1.2 MB
  rows:    54,734
  symbols: 2,447

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
2020-03-31 04:00:00	AAPL	Stock	64.3275	64.675	64.1	64.625	60476.0
2020-03-31 05:00:00	AAPL	Stock	64.53	64.625	64.3075	64.3075	32364.0
2020-03-31 06:00:00	AAPL	Stock	64.435	64.5	63.9025	63.9025	36384.0
2020-03-31 07:00:00	AAPL	Stock	63.9725	64.125	63.635	63.87	296388.0
2020-03-31 08:00:00	AAPL	Stock	63.8575	64.1175	63.075	63.475	664028.0
2020-03-31 09:00:00	AAPL	Stock	63.475	64.3525	63.41	63.8125	17544196.0
2020-03-31 10:00:00	AAPL	Stock	63.8225	65.6225	63.81	64.955	31189564.0
2020-03-31 11:00:00	AAPL	Stock	64.9625	65.18	64.57	64.72	17077652.0
2020-03-31 12:00:00	AAPL	Stock	64.715	64.835	63.685	63.9625	17625284.0
2020-03-31 13:00:00	AAPL	Stock	63.96	64.285	63.625	64.2025	14775520.0
2020-03-31 14:00:00	AAPL	Stock	64.2088	64.2262	63.7275	63.9012	11657724.0
2020-03-31 15:00:00	AAPL	Stock	63.8975	64.12	63.0	63.575	27900348.0
2020-03-31 16:00:00	AAPL	Stock	63.574	64.1498	63.3	63.43	22235356.0
2020-03-31 17:00:00	AAPL	Stock	63.4375	63.4675	63.125	63.225	179472.0
2020-03-31 18:00:00	AAPL	Stock	63.1875	63.21	62.9	62.945	207720.0
2020-03-31 19:00:00	AAPL	Stock	62.95	62.9775	62.65	62.65	179920.0
2020-03-31 04:00:00	MSFT	Stock	163.62	164.5	163.5	163.8	34487.0
2020-03-31 05:00:00	MSFT	Stock	163.8	164.0	162.63	163.25	22886.0
2020-03-31 06:00:00	MSFT	Stock	162.82	163.46	160.23	160.3	168793.0
2020-03-31 07:00:00	MSFT	Stock	160.5	161.3	159.63	160.0	322269.0
2020-03-31 08:00:00	MSFT	Stock	159.97	161.1	157.0	158.75	455147.0
2020-03-31 09:00:00	MSFT	Stock	158.74	159.97	157.96	158.63	7638345.0
2020-03-31 10:00:00	MSFT	Stock	158.59	164.78	158.59	162.75	13119900.0
2020-03-31 11:00:00	MSFT	Stock	162.75	163.61	160.28	161.102	7313633.0
2020-03-31 12:00:00	MSFT	Stock	161.101	161.26	158.81	159.268	6669662.0
2020-03-31 13:00:00	MSFT	Stock	159.263	160.93	158.86	160.67	4760251.0
2020-03-31 14:00:00	MSFT	Stock	160.675	160.76	159.45	160.19	4179396.0
2020-03-31 15:00:00	MSFT	Stock	160.22	160.62	156.56	157.64	12378625.0
2020-03-31 16:00:00	MSFT	Stock	157.7	160.185	157.1	157.3	9265908.0
2020-03-31 17:00:00	MSFT	Stock	157.36	157.48	157.15	157.2	21371.0
2020-03-31 18:00:00	MSFT	Stock	157.2	157.26	155.68	155.78	91344.0
2020-03-31 19:00:00	MSFT	Stock	155.8	156.1	155.2	155.25	74121.0
2020-03-31 04:00:00	NVDA	Stock	6.7653	6.802	6.763	6.763	168200.0
2020-03-31 05:00:00	NVDA	Stock	6.765	6.7775	6.726	6.7375	185520.0
2020-03-31 06:00:00	NVDA	Stock	6.7475	6.7475	6.7	6.7	153720.0
2020-03-31 07:00:00	NVDA	Stock	6.7302	6.737	6.6625	6.737	1346200.0
2020-03-31 08:00:00	NVDA	Stock	6.6875	6.725	6.6088	6.6805	2776840.0
2020-03-31 09:00:00	NVDA	Stock	6.675	6.8042	6.6353	6.6858	113350080.0
2020-03-31 10:00:00	NVDA	Stock	6.686	6.885	6.68	6.8012	139153040.0
2020-03-31 11:00:00	NVDA	Stock	6.8042	6.8225	6.6948	6.7114	82577760.0
2020-03-31 12:00:00	NVDA	Stock	6.7104	6.7623	6.562	6.6325	112865040.0
2020-03-31 13:00:00	NVDA	Stock	6.625	6.6405	6.535	6.627	93153320.0
2020-03-31 14:00:00	NVDA	Stock	6.628	6.645	6.5578	6.58	50844000.0
2020-03-31 15:00:00	NVDA	Stock	6.5788	6.6213	6.4438	6.5903	132578000.0
2020-03-31 16:00:00	NVDA	Stock	6.59	6.6	6.55	6.5805	142155160.0
2020-03-31 17:00:00	NVDA	Stock	6.587	6.5938	6.5638	6.564	185040.0
2020-03-31 18:00:00	NVDA	Stock	6.5635	6.5635	6.5	6.5063	810200.0
2020-03-31 19:00:00	NVDA	Stock	6.5063	6.5222	6.485	6.4875	676520.0
2020-03-31 04:00:00	AMZN	Stock	99.0	99.2	99.0	99.2	7200.0
2020-03-31 05:00:00	AMZN	Stock	98.88	99.0	98.88	98.8995	23540.0

> showing 50 of 54,734 rows — these rows as CSV

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