PREVIEW / stock_1hour / 2011-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-27.parquet
  size:    930 KB
  rows:    44,097
  symbols: 3,540

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-01-27 04:00:00	AAPL	Stock	12.3032	12.3032	12.3032	12.3032	5600.0
2011-01-27 05:00:00	AAPL	Stock	12.3107	12.3386	12.3107	12.3386	42000.0
2011-01-27 06:00:00	AAPL	Stock	12.3257	12.3375	12.3189	12.3268	58520.0
2011-01-27 07:00:00	AAPL	Stock	12.3268	12.3304	12.295	12.3186	200844.0
2011-01-27 08:00:00	AAPL	Stock	12.3054	12.3193	12.25	12.2661	1940512.0
2011-01-27 09:00:00	AAPL	Stock	12.2661	12.3025	12.244	12.2914	52801392.0
2011-01-27 10:00:00	AAPL	Stock	12.2936	12.3105	12.2646	12.2764	44240392.0
2011-01-27 11:00:00	AAPL	Stock	12.2764	12.2857	12.2571	12.2796	37006648.0
2011-01-27 12:00:00	AAPL	Stock	12.2805	12.3014	12.2711	12.2989	28678496.0
2011-01-27 13:00:00	AAPL	Stock	12.2989	12.2989	12.271	12.2804	19875240.0
2011-01-27 14:00:00	AAPL	Stock	12.2796	12.2875	12.2643	12.2854	25740708.0
2011-01-27 15:00:00	AAPL	Stock	12.2854	12.2954	12.2486	12.2589	55647564.0
2011-01-27 16:00:00	AAPL	Stock	12.2585	12.2909	12.2361	12.2396	10336620.0
2011-01-27 17:00:00	AAPL	Stock	12.2393	12.2411	12.2321	12.2339	352352.0
2011-01-27 18:00:00	AAPL	Stock	12.2357	12.2575	12.2268	12.2321	127960.0
2011-01-27 19:00:00	AAPL	Stock	12.2343	12.2371	12.2143	12.2261	223524.0
2011-01-27 07:00:00	MSFT	Stock	28.85	28.91	28.8	28.91	5680.0
2011-01-27 08:00:00	MSFT	Stock	28.9	28.92	28.85	28.88	36075.0
2011-01-27 09:00:00	MSFT	Stock	28.86	28.91	28.6	28.738	8357736.0
2011-01-27 10:00:00	MSFT	Stock	28.73	28.74	28.49	28.635	13106452.0
2011-01-27 11:00:00	MSFT	Stock	28.63	28.65	28.53	28.581	7424513.0
2011-01-27 12:00:00	MSFT	Stock	28.58	28.81	28.58	28.81	6617857.0
2011-01-27 13:00:00	MSFT	Stock	28.803	28.9	28.76	28.85	8715654.0
2011-01-27 14:00:00	MSFT	Stock	28.85	28.87	28.75	28.76	9113043.0
2011-01-27 15:00:00	MSFT	Stock	28.755	29.46	28.55	28.89	83700406.0
2011-01-27 16:00:00	MSFT	Stock	28.84	29.05	28.6	28.66	4650317.0
2011-01-27 17:00:00	MSFT	Stock	28.67	28.95	28.6	28.77	1216102.0
2011-01-27 18:00:00	MSFT	Stock	28.77	28.87	28.65	28.76	258739.0
2011-01-27 19:00:00	MSFT	Stock	28.78	28.8	28.73	28.73	88665.0
2011-01-27 08:00:00	NVDA	Stock	0.617	0.62	0.6138	0.6195	536320.0
2011-01-27 09:00:00	NVDA	Stock	0.6195	0.6238	0.6133	0.6173	72165080.0
2011-01-27 10:00:00	NVDA	Stock	0.617	0.6185	0.6103	0.6108	119177360.0
2011-01-27 11:00:00	NVDA	Stock	0.6108	0.6118	0.6	0.604	170140760.0
2011-01-27 12:00:00	NVDA	Stock	0.604	0.6088	0.602	0.6086	66675200.0
2011-01-27 13:00:00	NVDA	Stock	0.6087	0.612	0.6063	0.612	59041760.0
2011-01-27 14:00:00	NVDA	Stock	0.612	0.6122	0.6082	0.6113	50857280.0
2011-01-27 15:00:00	NVDA	Stock	0.6113	0.6133	0.61	0.612	109118840.0
2011-01-27 16:00:00	NVDA	Stock	0.6118	0.613	0.6095	0.6098	2831960.0
2011-01-27 17:00:00	NVDA	Stock	0.6098	0.6138	0.6098	0.6138	647720.0
2011-01-27 18:00:00	NVDA	Stock	0.6138	0.6138	0.6108	0.6108	180000.0
2011-01-27 19:00:00	NVDA	Stock	0.6122	0.6125	0.6122	0.6125	107000.0
2011-01-27 04:00:00	AMZN	Stock	8.84	8.84	8.84	8.84	8000.0
2011-01-27 06:00:00	AMZN	Stock	8.8635	8.8635	8.8635	8.8635	5480.0
2011-01-27 07:00:00	AMZN	Stock	8.8745	8.8945	8.86	8.8945	80540.0
2011-01-27 08:00:00	AMZN	Stock	8.8775	8.894	8.84	8.8405	244640.0
2011-01-27 09:00:00	AMZN	Stock	8.8405	9.11	8.7695	9.0805	32256780.0
2011-01-27 10:00:00	AMZN	Stock	9.0795	9.129	9.0115	9.012	30767020.0
2011-01-27 11:00:00	AMZN	Stock	9.0119	9.02	8.9375	9.012	21697040.0
2011-01-27 12:00:00	AMZN	Stock	9.0085	9.109	8.995	9.083	15952320.0
2011-01-27 13:00:00	AMZN	Stock	9.083	9.13	9.0575	9.1235	15394420.0

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

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