PREVIEW / stock_1hour / 2012-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-31.parquet
  size:    941 KB
  rows:    44,277
  symbols: 3,495

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-10-31 04:00:00	AAPL	Stock	21.5357	21.5357	21.5357	21.5357	8456.0
2012-10-31 05:00:00	AAPL	Stock	21.5482	21.5689	21.5482	21.5689	12880.0
2012-10-31 06:00:00	AAPL	Stock	21.5482	21.5536	21.5157	21.5536	31864.0
2012-10-31 07:00:00	AAPL	Stock	21.5289	21.5289	21.3754	21.4179	1020796.0
2012-10-31 08:00:00	AAPL	Stock	21.4161	21.4232	21.2921	21.3214	3015768.0
2012-10-31 09:00:00	AAPL	Stock	21.325	21.3343	20.9893	21.1246	115452176.0
2012-10-31 10:00:00	AAPL	Stock	21.1246	21.2014	21.0193	21.1339	79354548.0
2012-10-31 11:00:00	AAPL	Stock	21.1382	21.3393	21.0714	21.1853	65276372.0
2012-10-31 12:00:00	AAPL	Stock	21.1771	21.3161	21.1036	21.3004	41615336.0
2012-10-31 13:00:00	AAPL	Stock	21.3004	21.3089	21.2143	21.2893	29179360.0
2012-10-31 14:00:00	AAPL	Stock	21.2921	21.4986	21.2857	21.3932	65337860.0
2012-10-31 15:00:00	AAPL	Stock	21.4004	21.4286	21.2007	21.2586	78085896.0
2012-10-31 16:00:00	AAPL	Stock	21.2536	21.4686	21.0	21.2036	16695952.0
2012-10-31 17:00:00	AAPL	Stock	21.2143	21.2614	21.2107	21.2257	306544.0
2012-10-31 18:00:00	AAPL	Stock	21.2275	21.2332	21.2071	21.2179	235648.0
2012-10-31 19:00:00	AAPL	Stock	21.2107	21.2232	21.2071	21.2139	210448.0
2012-10-31 05:00:00	MSFT	Stock	28.55	28.57	28.55	28.57	700.0
2012-10-31 06:00:00	MSFT	Stock	28.63	28.63	28.52	28.52	12309.0
2012-10-31 07:00:00	MSFT	Stock	28.52	28.61	28.5	28.55	10494.0
2012-10-31 08:00:00	MSFT	Stock	28.55	28.57	28.37	28.43	49677.0
2012-10-31 09:00:00	MSFT	Stock	28.45	28.88	28.45	28.725	9499125.0
2012-10-31 10:00:00	MSFT	Stock	28.72	28.77	28.6	28.63	11525674.0
2012-10-31 11:00:00	MSFT	Stock	28.63	28.7	28.57	28.68	10781935.0
2012-10-31 12:00:00	MSFT	Stock	28.67	28.68	28.56	28.59	7576655.0
2012-10-31 13:00:00	MSFT	Stock	28.59	28.64	28.56	28.6	5035312.0
2012-10-31 14:00:00	MSFT	Stock	28.598	28.61	28.52	28.54	6954737.0
2012-10-31 15:00:00	MSFT	Stock	28.532	28.63	28.51	28.54	12928436.0
2012-10-31 16:00:00	MSFT	Stock	28.535	28.72	28.5	28.59	4242958.0
2012-10-31 17:00:00	MSFT	Stock	28.59	28.59	28.59	28.59	5801.0
2012-10-31 18:00:00	MSFT	Stock	28.55	28.55	28.55	28.55	100.0
2012-10-31 19:00:00	MSFT	Stock	28.59	28.6	28.54	28.55	3600.0
2012-10-31 09:00:00	NVDA	Stock	0.3025	0.305	0.3008	0.3032	34618320.0
2012-10-31 10:00:00	NVDA	Stock	0.3032	0.3045	0.3008	0.3025	52598720.0
2012-10-31 11:00:00	NVDA	Stock	0.3028	0.3028	0.2998	0.3015	43867120.0
2012-10-31 12:00:00	NVDA	Stock	0.3012	0.3022	0.2999	0.3002	41678760.0
2012-10-31 13:00:00	NVDA	Stock	0.3005	0.3018	0.2995	0.3002	31873440.0
2012-10-31 14:00:00	NVDA	Stock	0.3002	0.3005	0.2992	0.2998	35301840.0
2012-10-31 15:00:00	NVDA	Stock	0.2999	0.3005	0.2988	0.2994	89429600.0
2012-10-31 16:00:00	NVDA	Stock	0.2994	0.3014	0.2989	0.3	16506760.0
2012-10-31 18:00:00	NVDA	Stock	0.2998	0.2998	0.2992	0.2992	60000.0
2012-10-31 04:00:00	AMZN	Stock	11.9095	11.95	11.9095	11.95	7900.0
2012-10-31 06:00:00	AMZN	Stock	11.95	11.95	11.95	11.95	2080.0
2012-10-31 07:00:00	AMZN	Stock	11.95	11.95	11.9055	11.9055	30000.0
2012-10-31 08:00:00	AMZN	Stock	11.878	11.8825	11.82	11.85	77120.0
2012-10-31 09:00:00	AMZN	Stock	11.8665	11.935	11.705	11.712	16002400.0
2012-10-31 10:00:00	AMZN	Stock	11.712	11.7125	11.626	11.651	19843240.0
2012-10-31 11:00:00	AMZN	Stock	11.647	11.6598	11.5745	11.636	11785420.0
2012-10-31 12:00:00	AMZN	Stock	11.638	11.6408	11.525	11.5715	8672360.0
2012-10-31 13:00:00	AMZN	Stock	11.572	11.5882	11.54	11.5775	7259420.0
2012-10-31 14:00:00	AMZN	Stock	11.576	11.645	11.575	11.6218	8510280.0

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

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