PREVIEW / stock_1hour / 2011-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-29.parquet
  size:    922 KB
  rows:    44,017
  symbols: 3,537

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-08-29 04:00:00	AAPL	Stock	13.8086	13.8546	13.8086	13.8136	30240.0
2011-08-29 05:00:00	AAPL	Stock	13.8571	13.8571	13.8493	13.8493	11200.0
2011-08-29 06:00:00	AAPL	Stock	13.8393	13.8393	13.8204	13.8204	36400.0
2011-08-29 07:00:00	AAPL	Stock	13.8079	13.8679	13.8079	13.8286	1054592.0
2011-08-29 08:00:00	AAPL	Stock	13.8461	13.8875	13.8171	13.8757	3157560.0
2011-08-29 09:00:00	AAPL	Stock	13.875	13.9821	13.8482	13.9511	91056588.0
2011-08-29 10:00:00	AAPL	Stock	13.9482	13.9632	13.9043	13.9221	64904980.0
2011-08-29 11:00:00	AAPL	Stock	13.9207	13.9625	13.8957	13.9429	43313956.0
2011-08-29 12:00:00	AAPL	Stock	13.9433	13.9682	13.9289	13.9339	38572212.0
2011-08-29 13:00:00	AAPL	Stock	13.9361	13.9464	13.8714	13.9036	50698620.0
2011-08-29 14:00:00	AAPL	Stock	13.9025	13.9339	13.8839	13.9204	36493660.0
2011-08-29 15:00:00	AAPL	Stock	13.9204	13.9332	13.9068	13.9248	60171104.0
2011-08-29 16:00:00	AAPL	Stock	13.9261	13.9371	13.8969	13.9286	8195572.0
2011-08-29 17:00:00	AAPL	Stock	13.9275	13.9293	13.925	13.925	625744.0
2011-08-29 18:00:00	AAPL	Stock	13.925	13.9275	13.8961	13.9018	159012.0
2011-08-29 19:00:00	AAPL	Stock	13.8957	13.9318	13.8929	13.9214	406420.0
2011-08-29 07:00:00	MSFT	Stock	25.5	25.5	25.42	25.42	600.0
2011-08-29 08:00:00	MSFT	Stock	25.41	25.55	25.41	25.53	18480.0
2011-08-29 09:00:00	MSFT	Stock	25.56	25.64	25.37	25.635	4124347.0
2011-08-29 10:00:00	MSFT	Stock	25.63	25.7	25.57	25.7	5493064.0
2011-08-29 11:00:00	MSFT	Stock	25.695	25.7	25.58	25.6	4058310.0
2011-08-29 12:00:00	MSFT	Stock	25.6	25.66	25.59	25.643	3545397.0
2011-08-29 13:00:00	MSFT	Stock	25.64	25.71	25.625	25.69	3029886.0
2011-08-29 14:00:00	MSFT	Stock	25.69	25.795	25.65	25.684	4207562.0
2011-08-29 15:00:00	MSFT	Stock	25.68	25.86	25.66	25.85	9971321.0
2011-08-29 16:00:00	MSFT	Stock	25.84	25.855	25.674	25.76	3250715.0
2011-08-29 17:00:00	MSFT	Stock	25.85	25.85	25.688	25.75	192654.0
2011-08-29 18:00:00	MSFT	Stock	25.84	25.84	25.7	25.7	20374.0
2011-08-29 19:00:00	MSFT	Stock	25.72	25.72	25.72	25.72	13489.0
2011-08-29 07:00:00	NVDA	Stock	0.3275	0.3275	0.3275	0.3275	4000.0
2011-08-29 08:00:00	NVDA	Stock	0.3275	0.33	0.3275	0.33	32000.0
2011-08-29 09:00:00	NVDA	Stock	0.3325	0.3345	0.3268	0.3285	51503920.0
2011-08-29 10:00:00	NVDA	Stock	0.3287	0.3325	0.3273	0.3313	100248440.0
2011-08-29 11:00:00	NVDA	Stock	0.331	0.334	0.3305	0.3334	63605640.0
2011-08-29 12:00:00	NVDA	Stock	0.3333	0.3345	0.333	0.334	58555360.0
2011-08-29 13:00:00	NVDA	Stock	0.3341	0.3353	0.3322	0.3328	52690200.0
2011-08-29 14:00:00	NVDA	Stock	0.3326	0.3353	0.3325	0.3333	72237840.0
2011-08-29 15:00:00	NVDA	Stock	0.3331	0.3342	0.332	0.334	183075280.0
2011-08-29 16:00:00	NVDA	Stock	0.3338	0.3341	0.3323	0.3333	4754840.0
2011-08-29 17:00:00	NVDA	Stock	0.334	0.334	0.3335	0.3335	423120.0
2011-08-29 18:00:00	NVDA	Stock	0.334	0.3348	0.3335	0.3345	239280.0
2011-08-29 19:00:00	NVDA	Stock	0.3353	0.3353	0.3353	0.3353	76000.0
2011-08-29 04:00:00	AMZN	Stock	9.9945	10.0035	9.9945	10.0035	4000.0
2011-08-29 07:00:00	AMZN	Stock	10.08	10.1305	10.08	10.1175	95040.0
2011-08-29 08:00:00	AMZN	Stock	10.1125	10.1385	10.0775	10.115	235480.0
2011-08-29 09:00:00	AMZN	Stock	10.115	10.2075	10.115	10.1885	14961320.0
2011-08-29 10:00:00	AMZN	Stock	10.194	10.315	10.15	10.228	19279920.0
2011-08-29 11:00:00	AMZN	Stock	10.231	10.3	10.2	10.2975	9302760.0
2011-08-29 12:00:00	AMZN	Stock	10.294	10.312	10.252	10.2894	7066620.0
2011-08-29 13:00:00	AMZN	Stock	10.2865	10.3105	10.225	10.2504	8132020.0

> showing 50 of 44,017 rows — these rows as CSV

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