PREVIEW / stock_1hour / 2010-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-11.parquet
  size:    873 KB
  rows:    42,209
  symbols: 3,457

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-06-11 05:00:00	AAPL	Stock	8.9911	8.9911	8.9911	8.9911	2800.0
2010-06-11 06:00:00	AAPL	Stock	8.9821	8.9821	8.9821	8.9821	2800.0
2010-06-11 07:00:00	AAPL	Stock	8.9732	8.9732	8.9396	8.9429	110236.0
2010-06-11 08:00:00	AAPL	Stock	8.9504	8.9618	8.8564	8.8589	4870348.0
2010-06-11 09:00:00	AAPL	Stock	8.86	8.9107	8.8346	8.9046	86244956.0
2010-06-11 10:00:00	AAPL	Stock	8.9018	8.98	8.8896	8.9033	102530484.0
2010-06-11 11:00:00	AAPL	Stock	8.9057	8.9264	8.85	8.9218	71500800.0
2010-06-11 12:00:00	AAPL	Stock	8.9225	8.9314	8.8818	8.9214	38067344.0
2010-06-11 13:00:00	AAPL	Stock	8.9211	8.9729	8.9093	8.9275	53593428.0
2010-06-11 14:00:00	AAPL	Stock	8.9289	8.9643	8.8946	8.9472	46587268.0
2010-06-11 15:00:00	AAPL	Stock	8.9479	9.0664	8.9407	9.0539	124667200.0
2010-06-11 16:00:00	AAPL	Stock	9.0539	9.0882	8.8703	9.0575	8679692.0
2010-06-11 17:00:00	AAPL	Stock	8.9168	9.0586	8.9168	9.0564	2563484.0
2010-06-11 18:00:00	AAPL	Stock	9.0582	9.0625	9.0539	9.0564	222096.0
2010-06-11 19:00:00	AAPL	Stock	9.0571	9.0632	9.0493	9.0543	843052.0
2010-06-11 05:00:00	MSFT	Stock	25.05	25.09	25.05	25.09	1500.0
2010-06-11 06:00:00	MSFT	Stock	25.07	25.07	25.07	25.07	100.0
2010-06-11 07:00:00	MSFT	Stock	25.07	25.11	25.0	25.05	45400.0
2010-06-11 08:00:00	MSFT	Stock	25.05	25.05	24.84	24.88	87623.0
2010-06-11 09:00:00	MSFT	Stock	24.88	25.17	24.77	25.16	7639414.0
2010-06-11 10:00:00	MSFT	Stock	25.152	25.52	25.14	25.39	12748208.0
2010-06-11 11:00:00	MSFT	Stock	25.39	25.57	25.29	25.5	7329874.0
2010-06-11 12:00:00	MSFT	Stock	25.5	25.52	25.39	25.4	4300345.0
2010-06-11 13:00:00	MSFT	Stock	25.408	25.47	25.23	25.34	4865374.0
2010-06-11 14:00:00	MSFT	Stock	25.34	25.49	25.31	25.425	5402018.0
2010-06-11 15:00:00	MSFT	Stock	25.42	25.72	25.37	25.67	18572459.0
2010-06-11 16:00:00	MSFT	Stock	25.68	25.71	24.99	25.58	5940278.0
2010-06-11 17:00:00	MSFT	Stock	25.51	25.64	25.51	25.58	119665.0
2010-06-11 18:00:00	MSFT	Stock	25.66	25.66	25.63	25.63	58330.0
2010-06-11 19:00:00	MSFT	Stock	25.6	25.7	25.6	25.7	2250.0
2010-06-11 08:00:00	NVDA	Stock	0.2812	0.2812	0.2812	0.2812	6000.0
2010-06-11 09:00:00	NVDA	Stock	0.2805	0.2862	0.2795	0.2858	35818760.0
2010-06-11 10:00:00	NVDA	Stock	0.286	0.2914	0.2845	0.288	132316760.0
2010-06-11 11:00:00	NVDA	Stock	0.2882	0.2886	0.2848	0.2885	52608160.0
2010-06-11 12:00:00	NVDA	Stock	0.2885	0.2898	0.2871	0.2888	29118280.0
2010-06-11 13:00:00	NVDA	Stock	0.2885	0.2908	0.288	0.2885	32036280.0
2010-06-11 14:00:00	NVDA	Stock	0.2885	0.2888	0.2862	0.288	38098360.0
2010-06-11 15:00:00	NVDA	Stock	0.2881	0.2908	0.2872	0.29	103145040.0
2010-06-11 16:00:00	NVDA	Stock	0.2875	0.293	0.2836	0.293	4580760.0
2010-06-11 17:00:00	NVDA	Stock	0.2908	0.2908	0.2908	0.2908	14000.0
2010-06-11 18:00:00	NVDA	Stock	0.2928	0.2928	0.2928	0.2928	5080.0
2010-06-11 19:00:00	NVDA	Stock	0.2928	0.293	0.2928	0.293	38920.0
2010-06-11 08:00:00	AMZN	Stock	6.1875	6.1875	6.0875	6.0875	364100.0
2010-06-11 09:00:00	AMZN	Stock	6.0875	6.129	6.0145	6.117	15543860.0
2010-06-11 10:00:00	AMZN	Stock	6.1215	6.1765	6.093	6.1045	17046100.0
2010-06-11 11:00:00	AMZN	Stock	6.1065	6.1225	6.0394	6.1125	14218960.0
2010-06-11 12:00:00	AMZN	Stock	6.111	6.114	6.0725	6.092	6062300.0
2010-06-11 13:00:00	AMZN	Stock	6.0901	6.1305	6.0745	6.091	6811440.0
2010-06-11 14:00:00	AMZN	Stock	6.0917	6.1125	6.0715	6.0955	5800080.0
2010-06-11 15:00:00	AMZN	Stock	6.0965	6.164	6.0845	6.1515	14687220.0

> showing 50 of 42,209 rows — these rows as CSV

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