PREVIEW / stock_1hour / 2012-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-13.parquet
  size:    929 KB
  rows:    43,818
  symbols: 3,457

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-13 04:00:00	AAPL	Stock	19.2957	19.2957	19.2696	19.2696	21616.0
2012-11-13 05:00:00	AAPL	Stock	19.2696	19.2857	19.2679	19.2857	39200.0
2012-11-13 06:00:00	AAPL	Stock	19.2714	19.3071	19.2214	19.3036	72240.0
2012-11-13 07:00:00	AAPL	Stock	19.3143	19.3554	19.25	19.2954	482104.0
2012-11-13 08:00:00	AAPL	Stock	19.2946	19.3282	19.2564	19.2682	1294776.0
2012-11-13 09:00:00	AAPL	Stock	19.2675	19.4818	19.1557	19.4629	89928020.0
2012-11-13 10:00:00	AAPL	Stock	19.4629	19.5461	19.2857	19.5048	103944456.0
2012-11-13 11:00:00	AAPL	Stock	19.5054	19.6211	19.4479	19.6107	65627212.0
2012-11-13 12:00:00	AAPL	Stock	19.6089	19.6239	19.4789	19.5107	44634632.0
2012-11-13 13:00:00	AAPL	Stock	19.5168	19.6339	19.4929	19.6297	37473072.0
2012-11-13 14:00:00	AAPL	Stock	19.6321	19.66	19.5021	19.525	52668476.0
2012-11-13 15:00:00	AAPL	Stock	19.5279	19.56	19.3571	19.3793	82797008.0
2012-11-13 16:00:00	AAPL	Stock	19.3786	19.4614	19.3763	19.4314	30710400.0
2012-11-13 17:00:00	AAPL	Stock	19.4321	19.4604	19.3782	19.4357	7968968.0
2012-11-13 18:00:00	AAPL	Stock	19.435	19.4446	19.4286	19.4321	110040.0
2012-11-13 19:00:00	AAPL	Stock	19.4393	19.4593	19.4286	19.4504	206808.0
2012-11-13 04:00:00	MSFT	Stock	27.99	27.99	27.99	27.99	300.0
2012-11-13 05:00:00	MSFT	Stock	27.81	27.81	27.7	27.7	1050.0
2012-11-13 06:00:00	MSFT	Stock	27.7	27.77	27.38	27.38	95740.0
2012-11-13 07:00:00	MSFT	Stock	27.45	27.6	27.14	27.18	1375412.0
2012-11-13 08:00:00	MSFT	Stock	27.18	27.44	26.87	26.95	4119951.0
2012-11-13 09:00:00	MSFT	Stock	26.96	27.25	26.75	27.17	32119002.0
2012-11-13 10:00:00	MSFT	Stock	27.17	27.23	27.02	27.1	20357877.0
2012-11-13 11:00:00	MSFT	Stock	27.09	27.3	27.09	27.25	17613896.0
2012-11-13 12:00:00	MSFT	Stock	27.26	27.29	27.11	27.19	9353417.0
2012-11-13 13:00:00	MSFT	Stock	27.19	27.29	27.135	27.245	9276071.0
2012-11-13 14:00:00	MSFT	Stock	27.25	27.26	27.1	27.17	10390136.0
2012-11-13 15:00:00	MSFT	Stock	27.17	27.23	27.03	27.06	21073152.0
2012-11-13 16:00:00	MSFT	Stock	27.06	27.21	27.02	27.19	2900935.0
2012-11-13 17:00:00	MSFT	Stock	27.09	27.26	27.06	27.2	34582.0
2012-11-13 18:00:00	MSFT	Stock	27.23	27.3	27.23	27.28	21390.0
2012-11-13 19:00:00	MSFT	Stock	27.25	27.26	27.25	27.26	7585.0
2012-11-13 06:00:00	NVDA	Stock	0.3025	0.3025	0.295	0.295	12000.0
2012-11-13 07:00:00	NVDA	Stock	0.296	0.296	0.296	0.296	40000.0
2012-11-13 08:00:00	NVDA	Stock	0.2962	0.2962	0.2955	0.2955	134400.0
2012-11-13 09:00:00	NVDA	Stock	0.295	0.3032	0.2922	0.3032	95446720.0
2012-11-13 10:00:00	NVDA	Stock	0.303	0.3032	0.2985	0.302	85962520.0
2012-11-13 11:00:00	NVDA	Stock	0.3022	0.303	0.2985	0.2992	55900960.0
2012-11-13 12:00:00	NVDA	Stock	0.2994	0.2999	0.2975	0.2992	28898760.0
2012-11-13 13:00:00	NVDA	Stock	0.2992	0.2999	0.2972	0.2979	43864160.0
2012-11-13 14:00:00	NVDA	Stock	0.2979	0.299	0.2968	0.2975	82056600.0
2012-11-13 15:00:00	NVDA	Stock	0.2975	0.2976	0.2955	0.2958	84840080.0
2012-11-13 16:00:00	NVDA	Stock	0.2958	0.3009	0.2955	0.2975	14249160.0
2012-11-13 18:00:00	NVDA	Stock	0.2975	0.2975	0.2975	0.2975	58000.0
2012-11-13 04:00:00	AMZN	Stock	11.25	11.25	11.25	11.25	2000.0
2012-11-13 07:00:00	AMZN	Stock	11.275	11.275	11.275	11.275	2000.0
2012-11-13 08:00:00	AMZN	Stock	11.2985	11.3	11.2625	11.2625	192940.0
2012-11-13 09:00:00	AMZN	Stock	11.256	11.3345	11.245	11.299	6727000.0
2012-11-13 10:00:00	AMZN	Stock	11.3015	11.3615	11.2355	11.347	12605680.0
2012-11-13 11:00:00	AMZN	Stock	11.347	11.383	11.309	11.345	4817700.0

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

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