PREVIEW / stock_1hour / 2011-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-26.parquet
  size:    951 KB
  rows:    44,822
  symbols: 3,564

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-04-26 04:00:00	AAPL	Stock	12.6432	12.6518	12.6375	12.6496	22400.0
2011-04-26 05:00:00	AAPL	Stock	12.6607	12.6607	12.6607	12.6607	4200.0
2011-04-26 07:00:00	AAPL	Stock	12.6429	12.65	12.6375	12.6482	169344.0
2011-04-26 08:00:00	AAPL	Stock	12.65	12.6571	12.6243	12.6243	766780.0
2011-04-26 09:00:00	AAPL	Stock	12.6243	12.6782	12.5636	12.6006	50449784.0
2011-04-26 10:00:00	AAPL	Stock	12.6	12.6264	12.5536	12.6257	51796052.0
2011-04-26 11:00:00	AAPL	Stock	12.6243	12.625	12.5743	12.5949	28291284.0
2011-04-26 12:00:00	AAPL	Stock	12.5959	12.6107	12.5479	12.5602	31517640.0
2011-04-26 13:00:00	AAPL	Stock	12.5607	12.5611	12.4768	12.5217	48047664.0
2011-04-26 14:00:00	AAPL	Stock	12.5214	12.544	12.4975	12.5066	32575116.0
2011-04-26 15:00:00	AAPL	Stock	12.5071	12.5425	12.4864	12.5164	60473476.0
2011-04-26 16:00:00	AAPL	Stock	12.5161	12.6155	12.4786	12.5011	26638612.0
2011-04-26 17:00:00	AAPL	Stock	12.5036	12.5157	12.5014	12.5014	91168.0
2011-04-26 18:00:00	AAPL	Stock	12.5036	12.515	12.5018	12.5071	232204.0
2011-04-26 19:00:00	AAPL	Stock	12.5071	12.5146	12.5	12.5036	248220.0
2011-04-26 04:00:00	MSFT	Stock	25.76	25.79	25.76	25.79	700.0
2011-04-26 05:00:00	MSFT	Stock	25.79	25.79	25.65	25.65	300.0
2011-04-26 06:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	200.0
2011-04-26 07:00:00	MSFT	Stock	25.78	25.78	25.69	25.69	4820.0
2011-04-26 08:00:00	MSFT	Stock	25.69	25.8	25.69	25.79	55434.0
2011-04-26 09:00:00	MSFT	Stock	25.78	25.97	25.67	25.92	7133179.0
2011-04-26 10:00:00	MSFT	Stock	25.92	26.23	25.87	26.18	13369426.0
2011-04-26 11:00:00	MSFT	Stock	26.175	26.34	26.15	26.34	12073352.0
2011-04-26 12:00:00	MSFT	Stock	26.335	26.44	26.26	26.28	6974401.0
2011-04-26 13:00:00	MSFT	Stock	26.28	26.28	26.13	26.165	5969472.0
2011-04-26 14:00:00	MSFT	Stock	26.17	26.28	26.16	26.24	6269779.0
2011-04-26 15:00:00	MSFT	Stock	26.235	26.35	26.16	26.2	13823313.0
2011-04-26 16:00:00	MSFT	Stock	26.2	26.307	25.743	26.19	2186053.0
2011-04-26 17:00:00	MSFT	Stock	26.19	26.26	26.19	26.26	2115.0
2011-04-26 18:00:00	MSFT	Stock	26.2	26.24	26.15	26.23	27605.0
2011-04-26 19:00:00	MSFT	Stock	26.22	26.24	26.22	26.23	3928.0
2011-04-26 08:00:00	NVDA	Stock	0.4748	0.4748	0.4728	0.4728	28000.0
2011-04-26 09:00:00	NVDA	Stock	0.4748	0.4785	0.4695	0.4762	80292440.0
2011-04-26 10:00:00	NVDA	Stock	0.4763	0.4805	0.4725	0.4793	118765680.0
2011-04-26 11:00:00	NVDA	Stock	0.479	0.4818	0.4788	0.481	77570720.0
2011-04-26 12:00:00	NVDA	Stock	0.4808	0.482	0.479	0.4795	52007240.0
2011-04-26 13:00:00	NVDA	Stock	0.4795	0.4825	0.478	0.4818	62304880.0
2011-04-26 14:00:00	NVDA	Stock	0.4818	0.4869	0.4808	0.4865	85638080.0
2011-04-26 15:00:00	NVDA	Stock	0.4865	0.4873	0.4808	0.4828	168474400.0
2011-04-26 16:00:00	NVDA	Stock	0.4828	0.483	0.4792	0.4825	18162880.0
2011-04-26 17:00:00	NVDA	Stock	0.482	0.482	0.48	0.4812	118000.0
2011-04-26 18:00:00	NVDA	Stock	0.4812	0.4825	0.4812	0.4825	180040.0
2011-04-26 19:00:00	NVDA	Stock	0.4825	0.4825	0.4812	0.4812	201880.0
2011-04-26 04:00:00	AMZN	Stock	9.344	9.349	9.3	9.349	10000.0
2011-04-26 06:00:00	AMZN	Stock	9.3485	9.3485	9.3485	9.3485	2000.0
2011-04-26 07:00:00	AMZN	Stock	9.3045	9.3455	9.3045	9.3375	14000.0
2011-04-26 08:00:00	AMZN	Stock	9.308	9.339	9.285	9.3235	305860.0
2011-04-26 09:00:00	AMZN	Stock	9.3235	9.329	9.275	9.311	9976440.0
2011-04-26 10:00:00	AMZN	Stock	9.309	9.3115	9.2075	9.2635	17552180.0
2011-04-26 11:00:00	AMZN	Stock	9.264	9.266	9.172	9.182	14375820.0

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

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