PREVIEW / stock_1hour / 2012-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-23.parquet
  size:    957 KB
  rows:    45,998
  symbols: 3,525

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-04-23 04:00:00	AAPL	Stock	20.4643	20.4643	20.2857	20.3214	179060.0
2012-04-23 05:00:00	AAPL	Stock	20.2904	20.2904	20.1821	20.25	336980.0
2012-04-23 06:00:00	AAPL	Stock	20.2675	20.2679	20.2143	20.2639	159348.0
2012-04-23 07:00:00	AAPL	Stock	20.2639	20.3489	20.25	20.2857	1774696.0
2012-04-23 08:00:00	AAPL	Stock	20.2939	20.4754	20.2686	20.4339	7306012.0
2012-04-23 09:00:00	AAPL	Stock	20.4321	20.5954	20.1861	20.4425	157970512.0
2012-04-23 10:00:00	AAPL	Stock	20.4425	20.4457	19.8793	20.0114	228281424.0
2012-04-23 11:00:00	AAPL	Stock	20.0107	20.3214	19.9682	20.3212	123597908.0
2012-04-23 12:00:00	AAPL	Stock	20.3186	20.5589	20.2739	20.3621	147807912.0
2012-04-23 13:00:00	AAPL	Stock	20.3621	20.5668	20.3039	20.4714	85585640.0
2012-04-23 14:00:00	AAPL	Stock	20.4775	20.5161	20.3243	20.3498	75248348.0
2012-04-23 15:00:00	AAPL	Stock	20.3529	20.4982	20.3468	20.4286	95216240.0
2012-04-23 16:00:00	AAPL	Stock	20.4282	20.5536	20.302	20.45	23165072.0
2012-04-23 17:00:00	AAPL	Stock	20.45	20.4629	20.4179	20.4564	503524.0
2012-04-23 18:00:00	AAPL	Stock	20.4554	20.4554	20.4325	20.4375	334572.0
2012-04-23 19:00:00	AAPL	Stock	20.4446	20.4482	20.43	20.4411	446600.0
2012-04-23 04:00:00	MSFT	Stock	32.38	32.38	32.28	32.28	800.0
2012-04-23 05:00:00	MSFT	Stock	32.2	32.2	32.2	32.2	450.0
2012-04-23 06:00:00	MSFT	Stock	32.25	32.25	32.16	32.16	2400.0
2012-04-23 07:00:00	MSFT	Stock	32.25	32.25	32.2	32.2	7200.0
2012-04-23 08:00:00	MSFT	Stock	32.24	32.25	32.15	32.21	40609.0
2012-04-23 09:00:00	MSFT	Stock	32.2	32.5	32.15	32.18	10185275.0
2012-04-23 10:00:00	MSFT	Stock	32.18	32.29	32.08	32.1	10845282.0
2012-04-23 11:00:00	MSFT	Stock	32.1	32.2	32.03	32.107	5770802.0
2012-04-23 12:00:00	MSFT	Stock	32.1	32.26	32.09	32.128	7943450.0
2012-04-23 13:00:00	MSFT	Stock	32.12	32.19	32.1	32.18	4624769.0
2012-04-23 14:00:00	MSFT	Stock	32.17	32.26	32.11	32.13	5224266.0
2012-04-23 15:00:00	MSFT	Stock	32.13	32.18	32.09	32.11	9359464.0
2012-04-23 16:00:00	MSFT	Stock	32.12	32.185	32.04	32.12	6463179.0
2012-04-23 17:00:00	MSFT	Stock	32.1	32.11	32.08	32.08	5375.0
2012-04-23 18:00:00	MSFT	Stock	32.1	32.11	32.1	32.11	2500.0
2012-04-23 19:00:00	MSFT	Stock	32.09	32.1	32.09	32.1	6295.0
2012-04-23 06:00:00	NVDA	Stock	0.3328	0.3328	0.3328	0.3328	4000.0
2012-04-23 08:00:00	NVDA	Stock	0.3338	0.334	0.3288	0.3288	248400.0
2012-04-23 09:00:00	NVDA	Stock	0.331	0.3313	0.3258	0.3258	54712880.0
2012-04-23 10:00:00	NVDA	Stock	0.3259	0.327	0.3228	0.3228	157385120.0
2012-04-23 11:00:00	NVDA	Stock	0.3228	0.327	0.3228	0.326	128137760.0
2012-04-23 12:00:00	NVDA	Stock	0.3263	0.328	0.3248	0.3278	88801680.0
2012-04-23 13:00:00	NVDA	Stock	0.3278	0.329	0.3265	0.3269	55705040.0
2012-04-23 14:00:00	NVDA	Stock	0.3269	0.3298	0.3258	0.3296	60742080.0
2012-04-23 15:00:00	NVDA	Stock	0.3296	0.3321	0.3295	0.3308	139462840.0
2012-04-23 16:00:00	NVDA	Stock	0.3308	0.3322	0.327	0.3287	4590640.0
2012-04-23 17:00:00	NVDA	Stock	0.332	0.332	0.3313	0.3313	585840.0
2012-04-23 18:00:00	NVDA	Stock	0.3313	0.3315	0.3313	0.3315	220000.0
2012-04-23 19:00:00	NVDA	Stock	0.3335	0.3335	0.3335	0.3335	8160.0
2012-04-23 07:00:00	AMZN	Stock	9.3645	9.3645	9.3645	9.3645	2000.0
2012-04-23 08:00:00	AMZN	Stock	9.4375	9.4695	9.4025	9.4695	126940.0
2012-04-23 09:00:00	AMZN	Stock	9.4635	9.4715	9.2755	9.361	10584660.0
2012-04-23 10:00:00	AMZN	Stock	9.361	9.4095	9.2975	9.324	15219440.0
2012-04-23 11:00:00	AMZN	Stock	9.3235	9.3525	9.286	9.3285	9913440.0

> showing 50 of 45,998 rows — these rows as CSV

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