PREVIEW / stock_1hour / 2011-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-18.parquet
  size:    962 KB
  rows:    45,235
  symbols: 3,542

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
2011-01-18 04:00:00	AAPL	Stock	11.6429	11.8107	11.6429	11.8107	531412.0
2011-01-18 05:00:00	AAPL	Stock	11.8211	11.9454	11.8211	11.8493	885780.0
2011-01-18 06:00:00	AAPL	Stock	11.8571	11.9404	11.8411	11.9018	2053128.0
2011-01-18 07:00:00	AAPL	Stock	11.9018	11.9089	11.7529	11.9	15902684.0
2011-01-18 08:00:00	AAPL	Stock	11.8929	11.9286	11.7714	11.8361	28604968.0
2011-01-18 09:00:00	AAPL	Stock	11.8339	12.0714	11.6429	11.9507	515307072.0
2011-01-18 10:00:00	AAPL	Stock	11.9527	12.0021	11.89	11.98	240662268.0
2011-01-18 11:00:00	AAPL	Stock	11.9793	12.1239	11.9743	12.1	165699044.0
2011-01-18 12:00:00	AAPL	Stock	12.1021	12.1942	12.0736	12.1689	178147144.0
2011-01-18 13:00:00	AAPL	Stock	12.1682	12.2914	12.1632	12.2296	203757456.0
2011-01-18 14:00:00	AAPL	Stock	12.2296	12.2307	12.1622	12.21	125690376.0
2011-01-18 15:00:00	AAPL	Stock	12.2082	12.2607	12.1607	12.1786	198514064.0
2011-01-18 16:00:00	AAPL	Stock	12.1786	12.75	11.6803	12.3886	123858028.0
2011-01-18 17:00:00	AAPL	Stock	12.3929	12.4593	12.1807	12.3279	54844804.0
2011-01-18 18:00:00	AAPL	Stock	12.3275	12.3686	12.1661	12.3214	10162712.0
2011-01-18 19:00:00	AAPL	Stock	12.3214	12.3286	12.3143	12.3179	4711392.0
2011-01-18 07:00:00	MSFT	Stock	28.32	28.36	28.32	28.34	6200.0
2011-01-18 08:00:00	MSFT	Stock	28.34	28.34	28.27	28.31	27902.0
2011-01-18 09:00:00	MSFT	Stock	28.31	28.53	28.14	28.43	6496676.0
2011-01-18 10:00:00	MSFT	Stock	28.43	28.56	28.29	28.519	7368249.0
2011-01-18 11:00:00	MSFT	Stock	28.513	28.6	28.51	28.531	5201611.0
2011-01-18 12:00:00	MSFT	Stock	28.53	28.56	28.52	28.53	2759184.0
2011-01-18 13:00:00	MSFT	Stock	28.535	28.54	28.45	28.47	3807230.0
2011-01-18 14:00:00	MSFT	Stock	28.46	28.595	28.44	28.59	5160119.0
2011-01-18 15:00:00	MSFT	Stock	28.58	28.74	28.58	28.66	11540422.0
2011-01-18 16:00:00	MSFT	Stock	28.65	28.82	28.501	28.72	8161845.0
2011-01-18 17:00:00	MSFT	Stock	28.72	28.75	28.66	28.66	95330.0
2011-01-18 18:00:00	MSFT	Stock	28.65	28.75	28.61	28.69	43706.0
2011-01-18 19:00:00	MSFT	Stock	28.72	28.8	28.72	28.75	3970.0
2011-01-18 06:00:00	NVDA	Stock	0.5898	0.5898	0.5898	0.5898	8000.0
2011-01-18 07:00:00	NVDA	Stock	0.5752	0.58	0.5752	0.5782	484600.0
2011-01-18 08:00:00	NVDA	Stock	0.5795	0.5838	0.5782	0.5788	4393040.0
2011-01-18 09:00:00	NVDA	Stock	0.5788	0.585	0.5762	0.5772	234708520.0
2011-01-18 10:00:00	NVDA	Stock	0.5771	0.5858	0.566	0.5665	395026040.0
2011-01-18 11:00:00	NVDA	Stock	0.5665	0.5745	0.5628	0.5685	385044400.0
2011-01-18 12:00:00	NVDA	Stock	0.5685	0.5708	0.563	0.5638	142583480.0
2011-01-18 13:00:00	NVDA	Stock	0.5638	0.5775	0.5618	0.5772	237083320.0
2011-01-18 14:00:00	NVDA	Stock	0.5775	0.5775	0.571	0.5742	156888840.0
2011-01-18 15:00:00	NVDA	Stock	0.5742	0.5788	0.5702	0.5758	218516120.0
2011-01-18 16:00:00	NVDA	Stock	0.576	0.585	0.5734	0.5802	13342520.0
2011-01-18 17:00:00	NVDA	Stock	0.5782	0.58	0.575	0.5798	985600.0
2011-01-18 18:00:00	NVDA	Stock	0.5798	0.594	0.5798	0.589	6855960.0
2011-01-18 19:00:00	NVDA	Stock	0.589	0.5898	0.5853	0.5868	1150720.0
2011-01-18 07:00:00	AMZN	Stock	9.4605	9.4605	9.4605	9.4605	2000.0
2011-01-18 08:00:00	AMZN	Stock	9.439	9.444	9.4075	9.408	55500.0
2011-01-18 09:00:00	AMZN	Stock	9.408	9.4825	9.395	9.4718	11464520.0
2011-01-18 10:00:00	AMZN	Stock	9.4675	9.52	9.4605	9.4825	14977360.0
2011-01-18 11:00:00	AMZN	Stock	9.484	9.5475	9.482	9.498	9560500.0
2011-01-18 12:00:00	AMZN	Stock	9.4965	9.5225	9.4775	9.517	6476460.0
2011-01-18 13:00:00	AMZN	Stock	9.517	9.5175	9.482	9.5015	5102960.0

> showing 50 of 45,235 rows — these rows as CSV

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