PREVIEW / stock_1hour / 2012-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-20.parquet
  size:    927 KB
  rows:    43,882
  symbols: 3,472

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
2012-11-20 04:00:00	AAPL	Stock	20.2764	20.2786	20.2257	20.2386	107940.0
2012-11-20 05:00:00	AAPL	Stock	20.2268	20.3	20.2268	20.2779	119588.0
2012-11-20 06:00:00	AAPL	Stock	20.2714	20.2714	20.2321	20.2321	239064.0
2012-11-20 07:00:00	AAPL	Stock	20.2407	20.25	20.1814	20.1839	1219484.0
2012-11-20 08:00:00	AAPL	Stock	20.1857	20.2961	20.1021	20.2857	3946348.0
2012-11-20 09:00:00	AAPL	Stock	20.2857	20.4411	20.0446	20.1425	151802336.0
2012-11-20 10:00:00	AAPL	Stock	20.1393	20.2596	19.9496	19.9586	111583836.0
2012-11-20 11:00:00	AAPL	Stock	19.9589	20.1568	19.8739	20.1271	81044684.0
2012-11-20 12:00:00	AAPL	Stock	20.13	20.1375	19.9414	20.0446	51177980.0
2012-11-20 13:00:00	AAPL	Stock	20.0464	20.0604	19.8064	19.9277	82755988.0
2012-11-20 14:00:00	AAPL	Stock	19.9279	20.0564	19.8629	19.9982	55869800.0
2012-11-20 15:00:00	AAPL	Stock	19.9973	20.0714	19.9286	20.0407	73706052.0
2012-11-20 16:00:00	AAPL	Stock	20.0221	20.0964	20.0221	20.0614	16375324.0
2012-11-20 17:00:00	AAPL	Stock	20.0593	21.2597	20.0436	20.0625	342412.0
2012-11-20 18:00:00	AAPL	Stock	20.0607	20.0786	20.0571	20.0782	167440.0
2012-11-20 19:00:00	AAPL	Stock	20.075	20.1032	20.0714	20.0982	224196.0
2012-11-20 07:00:00	MSFT	Stock	26.73	26.75	26.65	26.65	6500.0
2012-11-20 08:00:00	MSFT	Stock	26.7	26.82	26.7	26.8	49395.0
2012-11-20 09:00:00	MSFT	Stock	26.77	26.83	26.47	26.62	6708197.0
2012-11-20 10:00:00	MSFT	Stock	26.62	26.67	26.54	26.57	9397950.0
2012-11-20 11:00:00	MSFT	Stock	26.57	26.69	26.55	26.69	4396829.0
2012-11-20 12:00:00	MSFT	Stock	26.68	26.69	26.58	26.6	3346069.0
2012-11-20 13:00:00	MSFT	Stock	26.61	26.61	26.46	26.585	8222303.0
2012-11-20 14:00:00	MSFT	Stock	26.58	26.62	26.545	26.58	3595529.0
2012-11-20 15:00:00	MSFT	Stock	26.572	26.71	26.56	26.71	8664052.0
2012-11-20 16:00:00	MSFT	Stock	26.71	26.75	26.59	26.61	1804678.0
2012-11-20 17:00:00	MSFT	Stock	26.71	26.71	26.55	26.6	13890.0
2012-11-20 18:00:00	MSFT	Stock	26.65	26.67	26.65	26.66	6977.0
2012-11-20 19:00:00	MSFT	Stock	26.68	26.73	26.63	26.73	14038.0
2012-11-20 09:00:00	NVDA	Stock	0.2915	0.2915	0.285	0.2878	63920960.0
2012-11-20 10:00:00	NVDA	Stock	0.2878	0.289	0.2862	0.2872	56024400.0
2012-11-20 11:00:00	NVDA	Stock	0.2872	0.2899	0.2865	0.289	25545640.0
2012-11-20 12:00:00	NVDA	Stock	0.289	0.2898	0.2868	0.287	27039160.0
2012-11-20 13:00:00	NVDA	Stock	0.287	0.2872	0.2842	0.2856	35754480.0
2012-11-20 14:00:00	NVDA	Stock	0.2856	0.2875	0.285	0.2874	46883200.0
2012-11-20 15:00:00	NVDA	Stock	0.2875	0.288	0.287	0.2875	67451080.0
2012-11-20 16:00:00	NVDA	Stock	0.2872	0.2875	0.287	0.2875	1178520.0
2012-11-20 17:00:00	NVDA	Stock	0.2872	0.2875	0.2872	0.2875	355920.0
2012-11-20 18:00:00	NVDA	Stock	0.2875	0.2875	0.2875	0.2875	82000.0
2012-11-20 08:00:00	AMZN	Stock	11.618	11.618	11.45	11.494	642460.0
2012-11-20 09:00:00	AMZN	Stock	11.496	11.645	11.475	11.6245	10695520.0
2012-11-20 10:00:00	AMZN	Stock	11.6245	11.665	11.59	11.59	9508560.0
2012-11-20 11:00:00	AMZN	Stock	11.5925	11.6495	11.554	11.6435	5263600.0
2012-11-20 12:00:00	AMZN	Stock	11.6495	11.6805	11.6155	11.6735	5627100.0
2012-11-20 13:00:00	AMZN	Stock	11.6705	11.676	11.531	11.62	8554180.0
2012-11-20 14:00:00	AMZN	Stock	11.62	11.656	11.6	11.6528	3789800.0
2012-11-20 15:00:00	AMZN	Stock	11.652	11.691	11.6385	11.6895	9046140.0
2012-11-20 16:00:00	AMZN	Stock	11.6891	11.725	11.4855	11.703	2053300.0
2012-11-20 17:00:00	AMZN	Stock	11.724	11.741	11.7115	11.725	30200.0
2012-11-20 18:00:00	AMZN	Stock	11.713	11.715	11.7115	11.713	18040.0

> showing 50 of 43,882 rows — these rows as CSV

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