PREVIEW / stock_1hour / 2010-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-20.parquet
  size:    915 KB
  rows:    43,450
  symbols: 3,485

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
2010-04-20 04:00:00	AAPL	Stock	8.8821	8.8907	8.8821	8.89	58800.0
2010-04-20 05:00:00	AAPL	Stock	8.875	8.875	8.875	8.875	36400.0
2010-04-20 06:00:00	AAPL	Stock	8.8732	8.8929	8.8732	8.8929	102536.0
2010-04-20 07:00:00	AAPL	Stock	8.8929	8.8929	8.8575	8.8607	190596.0
2010-04-20 08:00:00	AAPL	Stock	8.8643	8.8764	8.8571	8.8661	2893940.0
2010-04-20 09:00:00	AAPL	Stock	8.8661	8.9018	8.7543	8.7614	95636268.0
2010-04-20 10:00:00	AAPL	Stock	8.7607	8.7714	8.677	8.7429	129417764.0
2010-04-20 11:00:00	AAPL	Stock	8.7421	8.7729	8.7379	8.7661	50704472.0
2010-04-20 12:00:00	AAPL	Stock	8.7664	8.8171	8.7643	8.7857	50575784.0
2010-04-20 13:00:00	AAPL	Stock	8.7854	8.8	8.7575	8.758	43229144.0
2010-04-20 14:00:00	AAPL	Stock	8.7582	8.8004	8.7232	8.78	90368684.0
2010-04-20 15:00:00	AAPL	Stock	8.7804	8.7886	8.7	8.7361	104824972.0
2010-04-20 16:00:00	AAPL	Stock	8.7361	9.4643	8.7086	9.3393	88910752.0
2010-04-20 17:00:00	AAPL	Stock	9.3393	9.3411	8.8072	9.2218	66666908.0
2010-04-20 18:00:00	AAPL	Stock	9.2214	9.2446	8.7354	9.1929	6271300.0
2010-04-20 19:00:00	AAPL	Stock	9.1907	9.1957	9.1821	9.1946	3596264.0
2010-04-20 20:00:00	AAPL	Stock	8.7657	8.7657	8.7657	8.7657	198800.0
2010-04-20 06:00:00	MSFT	Stock	31.12	31.12	31.12	31.12	500.0
2010-04-20 07:00:00	MSFT	Stock	31.19	31.2	31.16	31.17	2900.0
2010-04-20 08:00:00	MSFT	Stock	31.17	31.21	31.1	31.19	22637.0
2010-04-20 09:00:00	MSFT	Stock	31.19	31.25	31.12	31.22	7526074.0
2010-04-20 10:00:00	MSFT	Stock	31.21	31.35	31.17	31.25	11546907.0
2010-04-20 11:00:00	MSFT	Stock	31.26	31.4	31.25	31.376	5753667.0
2010-04-20 12:00:00	MSFT	Stock	31.372	31.44	31.29	31.3	5437295.0
2010-04-20 13:00:00	MSFT	Stock	31.3	31.34	31.28	31.32	2998545.0
2010-04-20 14:00:00	MSFT	Stock	31.33	31.41	31.25	31.4	4586704.0
2010-04-20 15:00:00	MSFT	Stock	31.4	31.42	31.168	31.35	8568690.0
2010-04-20 16:00:00	MSFT	Stock	31.36	31.53	31.19	31.51	2905511.0
2010-04-20 17:00:00	MSFT	Stock	31.52	31.57	31.45	31.57	53792.0
2010-04-20 18:00:00	MSFT	Stock	31.56	31.56	31.41	31.41	6398.0
2010-04-20 19:00:00	MSFT	Stock	31.5	31.54	31.5	31.5	1289.0
2010-04-20 20:00:00	MSFT	Stock	31.37	31.37	31.37	31.37	200.0
2010-04-20 08:00:00	NVDA	Stock	0.4245	0.4245	0.4245	0.4245	20000.0
2010-04-20 09:00:00	NVDA	Stock	0.4275	0.432	0.425	0.4295	42638040.0
2010-04-20 10:00:00	NVDA	Stock	0.4298	0.43	0.4205	0.4232	91741840.0
2010-04-20 11:00:00	NVDA	Stock	0.4235	0.426	0.4232	0.4245	73381160.0
2010-04-20 12:00:00	NVDA	Stock	0.4245	0.4255	0.4238	0.4245	90131000.0
2010-04-20 13:00:00	NVDA	Stock	0.4245	0.425	0.4228	0.4246	85592400.0
2010-04-20 14:00:00	NVDA	Stock	0.4245	0.4275	0.4237	0.4265	108492760.0
2010-04-20 15:00:00	NVDA	Stock	0.4265	0.4272	0.425	0.4258	158238800.0
2010-04-20 16:00:00	NVDA	Stock	0.4258	0.4298	0.4253	0.4275	12927640.0
2010-04-20 17:00:00	NVDA	Stock	0.4275	0.4288	0.4272	0.4272	211000.0
2010-04-20 18:00:00	NVDA	Stock	0.4275	0.4275	0.4272	0.4272	32000.0
2010-04-20 08:00:00	AMZN	Stock	7.15	7.1745	7.15	7.17	96700.0
2010-04-20 09:00:00	AMZN	Stock	7.165	7.2	7.105	7.143	11692300.0
2010-04-20 10:00:00	AMZN	Stock	7.141	7.1515	7.1095	7.1366	14678420.0
2010-04-20 11:00:00	AMZN	Stock	7.1375	7.169	7.112	7.1425	9692020.0
2010-04-20 12:00:00	AMZN	Stock	7.142	7.208	7.1408	7.187	12753860.0
2010-04-20 13:00:00	AMZN	Stock	7.187	7.224	7.187	7.209	9130360.0
2010-04-20 14:00:00	AMZN	Stock	7.2089	7.223	7.187	7.2095	9655900.0

> showing 50 of 43,450 rows — these rows as CSV

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