PREVIEW / stock_1hour / 2011-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-12.parquet
  size:    939 KB
  rows:    44,424
  symbols: 3,534

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-07-12 04:00:00	AAPL	Stock	12.5096	12.5096	12.3593	12.4482	196000.0
2011-07-12 05:00:00	AAPL	Stock	12.4657	12.5089	12.4632	12.5036	191016.0
2011-07-12 06:00:00	AAPL	Stock	12.5	12.5286	12.5	12.5286	64400.0
2011-07-12 07:00:00	AAPL	Stock	12.5268	12.6171	12.4964	12.5932	1492148.0
2011-07-12 08:00:00	AAPL	Stock	12.6004	12.6929	12.5179	12.6654	4214784.0
2011-07-12 09:00:00	AAPL	Stock	12.6679	12.7	12.4507	12.5711	121127972.0
2011-07-12 10:00:00	AAPL	Stock	12.5711	12.6489	12.5675	12.6136	75440344.0
2011-07-12 11:00:00	AAPL	Stock	12.6161	12.6939	12.6104	12.6607	49253764.0
2011-07-12 12:00:00	AAPL	Stock	12.6614	12.6875	12.6461	12.6718	30466464.0
2011-07-12 13:00:00	AAPL	Stock	12.6689	12.7371	12.6625	12.7321	38100636.0
2011-07-12 14:00:00	AAPL	Stock	12.7329	12.7743	12.7196	12.7293	56929684.0
2011-07-12 15:00:00	AAPL	Stock	12.7293	12.7511	12.6339	12.6375	65089472.0
2011-07-12 16:00:00	AAPL	Stock	12.6364	12.6789	12.6336	12.6364	5629736.0
2011-07-12 17:00:00	AAPL	Stock	12.6414	12.6429	12.6261	12.6311	289128.0
2011-07-12 18:00:00	AAPL	Stock	12.6311	12.6357	12.625	12.6329	306572.0
2011-07-12 19:00:00	AAPL	Stock	12.6289	12.65	12.6289	12.65	278992.0
2011-07-12 04:00:00	MSFT	Stock	26.34	26.34	26.15	26.15	300.0
2011-07-12 07:00:00	MSFT	Stock	26.39	26.49	26.3	26.49	6879.0
2011-07-12 08:00:00	MSFT	Stock	26.45	26.6	26.45	26.57	28703.0
2011-07-12 09:00:00	MSFT	Stock	26.6	26.65	26.44	26.52	6137864.0
2011-07-12 10:00:00	MSFT	Stock	26.52	26.64	26.34	26.451	7945487.0
2011-07-12 11:00:00	MSFT	Stock	26.45	26.625	26.43	26.56	5019960.0
2011-07-12 12:00:00	MSFT	Stock	26.56	26.64	26.54	26.61	3402335.0
2011-07-12 13:00:00	MSFT	Stock	26.6	26.7	26.535	26.58	3672489.0
2011-07-12 14:00:00	MSFT	Stock	26.58	26.79	26.58	26.614	7656150.0
2011-07-12 15:00:00	MSFT	Stock	26.615	26.66	26.52	26.54	10279216.0
2011-07-12 16:00:00	MSFT	Stock	26.54	26.62	26.54	26.55	2727977.0
2011-07-12 17:00:00	MSFT	Stock	26.57	26.57	26.57	26.57	2000.0
2011-07-12 18:00:00	MSFT	Stock	26.54	26.59	26.54	26.55	31271.0
2011-07-12 19:00:00	MSFT	Stock	26.55	26.59	26.55	26.59	450.0
2011-07-12 05:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	8000.0
2011-07-12 07:00:00	NVDA	Stock	0.3715	0.3715	0.3625	0.3625	94800.0
2011-07-12 08:00:00	NVDA	Stock	0.371	0.371	0.3688	0.37	131200.0
2011-07-12 09:00:00	NVDA	Stock	0.37	0.3708	0.361	0.3638	138501440.0
2011-07-12 10:00:00	NVDA	Stock	0.364	0.374	0.3638	0.3678	178494040.0
2011-07-12 11:00:00	NVDA	Stock	0.3676	0.3695	0.366	0.3664	94424800.0
2011-07-12 12:00:00	NVDA	Stock	0.3665	0.368	0.3662	0.3665	95553560.0
2011-07-12 13:00:00	NVDA	Stock	0.3668	0.3682	0.3662	0.3666	66060920.0
2011-07-12 14:00:00	NVDA	Stock	0.3665	0.3708	0.3662	0.3685	108948920.0
2011-07-12 15:00:00	NVDA	Stock	0.3685	0.3695	0.367	0.3672	160131360.0
2011-07-12 16:00:00	NVDA	Stock	0.367	0.3676	0.3665	0.3675	7683040.0
2011-07-12 18:00:00	NVDA	Stock	0.368	0.368	0.368	0.368	400000.0
2011-07-12 19:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	36000.0
2011-07-12 04:00:00	AMZN	Stock	10.454	10.5095	10.454	10.5095	4000.0
2011-07-12 05:00:00	AMZN	Stock	10.535	10.535	10.4725	10.4725	4000.0
2011-07-12 07:00:00	AMZN	Stock	10.5005	10.5725	10.5	10.5725	24000.0
2011-07-12 08:00:00	AMZN	Stock	10.5535	10.7375	10.553	10.696	348320.0
2011-07-12 09:00:00	AMZN	Stock	10.69	10.77	10.65	10.7095	14294940.0
2011-07-12 10:00:00	AMZN	Stock	10.7095	10.7825	10.69	10.698	13324000.0
2011-07-12 11:00:00	AMZN	Stock	10.699	10.7668	10.6665	10.684	8091400.0

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

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