PREVIEW / stock_1hour / 2008-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-30.parquet
  size:    811 KB
  rows:    40,849
  symbols: 3,269

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
2008-01-30 04:00:00	AAPL	Stock	4.6786	4.6786	4.6786	4.6786	4200.0
2008-01-30 05:00:00	AAPL	Stock	4.6761	4.6761	4.6761	4.6761	5600.0
2008-01-30 06:00:00	AAPL	Stock	4.6886	4.6964	4.6786	4.6786	43400.0
2008-01-30 07:00:00	AAPL	Stock	4.6821	4.6893	4.6696	4.6786	122668.0
2008-01-30 08:00:00	AAPL	Stock	4.6786	4.7014	4.675	4.6821	2462236.0
2008-01-30 09:00:00	AAPL	Stock	4.6839	4.7232	4.6518	4.6754	120993712.0
2008-01-30 10:00:00	AAPL	Stock	4.675	4.7196	4.6429	4.7118	174244588.0
2008-01-30 11:00:00	AAPL	Stock	4.7121	4.7321	4.6786	4.7111	96074020.0
2008-01-30 12:00:00	AAPL	Stock	4.7111	4.7275	4.7018	4.7132	63136136.0
2008-01-30 13:00:00	AAPL	Stock	4.7132	4.7343	4.6982	4.7146	74767896.0
2008-01-30 14:00:00	AAPL	Stock	4.7143	4.8289	4.7057	4.8171	357503048.0
2008-01-30 15:00:00	AAPL	Stock	4.8171	4.8375	4.7018	4.7211	330357020.0
2008-01-30 16:00:00	AAPL	Stock	4.7179	4.7403	4.6929	4.6929	18945472.0
2008-01-30 17:00:00	AAPL	Stock	4.6929	4.7566	4.6486	4.6532	3190796.0
2008-01-30 18:00:00	AAPL	Stock	4.65	4.6675	4.65	4.6596	937888.0
2008-01-30 19:00:00	AAPL	Stock	4.6596	4.6779	4.6539	4.675	361116.0
2008-01-30 08:00:00	MSFT	Stock	32.55	32.68	32.35	32.56	46717.0
2008-01-30 09:00:00	MSFT	Stock	32.56	32.6	32.4	32.45	7600880.0
2008-01-30 10:00:00	MSFT	Stock	32.44	32.47	32.29	32.33	12169000.0
2008-01-30 11:00:00	MSFT	Stock	32.33	32.35	32.15	32.2	7023383.0
2008-01-30 12:00:00	MSFT	Stock	32.192	32.28	32.16	32.25	8862201.0
2008-01-30 13:00:00	MSFT	Stock	32.25	32.26	32.06	32.17	6659969.0
2008-01-30 14:00:00	MSFT	Stock	32.17	32.67	32.15	32.67	31305956.0
2008-01-30 15:00:00	MSFT	Stock	32.661	32.8	32.05	32.2	29558978.0
2008-01-30 16:00:00	MSFT	Stock	32.2	32.402	32.1	32.1	2840316.0
2008-01-30 17:00:00	MSFT	Stock	32.1	32.364	31.96	31.98	313953.0
2008-01-30 18:00:00	MSFT	Stock	31.99	32.0	31.9	31.99	60516.0
2008-01-30 19:00:00	MSFT	Stock	31.99	32.0	31.96	32.0	11073.0
2008-01-30 08:00:00	NVDA	Stock	0.6303	0.6353	0.6263	0.6303	907440.0
2008-01-30 09:00:00	NVDA	Stock	0.6303	0.6338	0.6233	0.6293	45705440.0
2008-01-30 10:00:00	NVDA	Stock	0.6293	0.6303	0.6205	0.6223	54757440.0
2008-01-30 11:00:00	NVDA	Stock	0.6223	0.6228	0.6125	0.6143	63487440.0
2008-01-30 12:00:00	NVDA	Stock	0.6143	0.6175	0.614	0.616	31171360.0
2008-01-30 13:00:00	NVDA	Stock	0.616	0.6173	0.6118	0.6133	37767280.0
2008-01-30 14:00:00	NVDA	Stock	0.6133	0.6315	0.613	0.6303	128988080.0
2008-01-30 15:00:00	NVDA	Stock	0.63	0.6393	0.6278	0.629	144665120.0
2008-01-30 16:00:00	NVDA	Stock	0.629	0.6298	0.6243	0.6295	22852880.0
2008-01-30 17:00:00	NVDA	Stock	0.6298	0.6298	0.6225	0.6268	183360.0
2008-01-30 19:00:00	NVDA	Stock	0.6228	0.6228	0.6195	0.6195	124000.0
2008-01-30 08:00:00	AMZN	Stock	3.65	3.6505	3.65	3.65	83500.0
2008-01-30 09:00:00	AMZN	Stock	3.6475	3.74	3.645	3.712	31982340.0
2008-01-30 10:00:00	AMZN	Stock	3.7135	3.783	3.6885	3.7575	26623300.0
2008-01-30 11:00:00	AMZN	Stock	3.7575	3.7625	3.69	3.694	20544600.0
2008-01-30 12:00:00	AMZN	Stock	3.6935	3.7106	3.6725	3.697	14958380.0
2008-01-30 13:00:00	AMZN	Stock	3.6974	3.72	3.6805	3.6885	14897320.0
2008-01-30 14:00:00	AMZN	Stock	3.688	3.775	3.6625	3.7655	62845020.0
2008-01-30 15:00:00	AMZN	Stock	3.7655	3.871	3.675	3.7105	91955720.0
2008-01-30 16:00:00	AMZN	Stock	3.7055	3.9235	3.2265	3.4605	157922200.0
2008-01-30 17:00:00	AMZN	Stock	3.4585	3.473	3.2535	3.2595	61297960.0
2008-01-30 18:00:00	AMZN	Stock	3.257	3.3095	3.237	3.2785	16436580.0

> showing 50 of 40,849 rows — these rows as CSV

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