PREVIEW / stock_1hour / 2011-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-19.parquet
  size:    931 KB
  rows:    44,671
  symbols: 3,534

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-08-19 04:00:00	AAPL	Stock	13.1018	13.1018	12.8396	12.9286	59332.0
2011-08-19 05:00:00	AAPL	Stock	12.9357	12.9643	12.9189	12.9414	62440.0
2011-08-19 06:00:00	AAPL	Stock	12.9546	12.9546	12.8929	12.9032	56112.0
2011-08-19 07:00:00	AAPL	Stock	12.9286	13.0329	12.9286	13.0268	936768.0
2011-08-19 08:00:00	AAPL	Stock	13.0039	13.0604	12.9343	12.9489	4878720.0
2011-08-19 09:00:00	AAPL	Stock	12.9504	13.0939	12.9054	13.0507	148776404.0
2011-08-19 10:00:00	AAPL	Stock	13.0504	13.1071	13.0061	13.0268	120961904.0
2011-08-19 11:00:00	AAPL	Stock	13.0254	13.0429	12.9507	13.0268	76447616.0
2011-08-19 12:00:00	AAPL	Stock	13.02	13.0289	12.9643	12.9796	45148488.0
2011-08-19 13:00:00	AAPL	Stock	12.9831	12.9896	12.8775	12.8821	60856768.0
2011-08-19 14:00:00	AAPL	Stock	12.8832	12.8939	12.7571	12.7943	125600384.0
2011-08-19 15:00:00	AAPL	Stock	12.7954	12.8282	12.7143	12.7171	159972344.0
2011-08-19 16:00:00	AAPL	Stock	12.7167	13.0732	12.6839	12.7089	13695640.0
2011-08-19 17:00:00	AAPL	Stock	12.7121	12.775	12.7071	12.7429	1030176.0
2011-08-19 18:00:00	AAPL	Stock	12.7361	12.7643	12.7154	12.75	358708.0
2011-08-19 19:00:00	AAPL	Stock	12.7571	12.7643	12.75	12.75	131180.0
2011-08-19 04:00:00	MSFT	Stock	24.55	24.55	24.5	24.5	3400.0
2011-08-19 05:00:00	MSFT	Stock	24.5	24.5	24.5	24.5	100.0
2011-08-19 06:00:00	MSFT	Stock	24.45	24.45	24.36	24.36	2000.0
2011-08-19 07:00:00	MSFT	Stock	24.45	24.57	24.4	24.57	15833.0
2011-08-19 08:00:00	MSFT	Stock	24.54	24.67	24.46	24.56	84282.0
2011-08-19 09:00:00	MSFT	Stock	24.56	24.65	24.26	24.38	17145768.0
2011-08-19 10:00:00	MSFT	Stock	24.38	24.6	24.24	24.36	11617510.0
2011-08-19 11:00:00	MSFT	Stock	24.35	24.41	24.2	24.38	7451061.0
2011-08-19 12:00:00	MSFT	Stock	24.38	24.39	24.25	24.26	5478704.0
2011-08-19 13:00:00	MSFT	Stock	24.26	24.318	24.07	24.143	5726965.0
2011-08-19 14:00:00	MSFT	Stock	24.15	24.18	23.91	24.05	10855121.0
2011-08-19 15:00:00	MSFT	Stock	24.05	24.19	23.96	24.05	15426090.0
2011-08-19 16:00:00	MSFT	Stock	24.05	24.65	24.0	24.239	3192881.0
2011-08-19 17:00:00	MSFT	Stock	24.05	24.07	24.04	24.07	25884.0
2011-08-19 18:00:00	MSFT	Stock	24.07	24.11	24.05	24.09	17383.0
2011-08-19 19:00:00	MSFT	Stock	24.09	24.09	24.03	24.05	2725.0
2011-08-19 08:00:00	NVDA	Stock	0.296	0.2962	0.292	0.292	404000.0
2011-08-19 09:00:00	NVDA	Stock	0.2922	0.3028	0.2912	0.3026	111810720.0
2011-08-19 10:00:00	NVDA	Stock	0.3026	0.3098	0.301	0.3018	177319960.0
2011-08-19 11:00:00	NVDA	Stock	0.3015	0.3025	0.297	0.3018	107434400.0
2011-08-19 12:00:00	NVDA	Stock	0.3018	0.302	0.2995	0.2998	45136400.0
2011-08-19 13:00:00	NVDA	Stock	0.2998	0.301	0.2974	0.2984	39946400.0
2011-08-19 14:00:00	NVDA	Stock	0.2982	0.299	0.2942	0.2946	109045560.0
2011-08-19 15:00:00	NVDA	Stock	0.2948	0.2962	0.2922	0.2932	148955440.0
2011-08-19 16:00:00	NVDA	Stock	0.2926	0.2991	0.2908	0.2935	17372840.0
2011-08-19 17:00:00	NVDA	Stock	0.2935	0.2952	0.2932	0.2952	61840.0
2011-08-19 18:00:00	NVDA	Stock	0.295	0.295	0.295	0.295	24000.0
2011-08-19 19:00:00	NVDA	Stock	0.2942	0.2975	0.2942	0.2975	76000.0
2011-08-19 04:00:00	AMZN	Stock	9.0745	9.0745	9.0535	9.0535	4000.0
2011-08-19 06:00:00	AMZN	Stock	8.962	8.962	8.962	8.962	2000.0
2011-08-19 07:00:00	AMZN	Stock	8.97	9.0495	8.965	9.0455	106280.0
2011-08-19 08:00:00	AMZN	Stock	9.0315	9.134	8.98	8.995	295340.0
2011-08-19 09:00:00	AMZN	Stock	8.986	9.353	8.962	9.337	30081060.0
2011-08-19 10:00:00	AMZN	Stock	9.342	9.5	9.2915	9.349	26324980.0

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

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