PREVIEW / stock_1hour / 2011-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-23.parquet
  size:    945 KB
  rows:    45,830
  symbols: 3,537

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-23 04:00:00	AAPL	Stock	12.8443	12.9804	12.8443	12.9286	178500.0
2011-08-23 05:00:00	AAPL	Stock	12.9179	12.9804	12.9179	12.9768	44800.0
2011-08-23 06:00:00	AAPL	Stock	12.9714	12.9714	12.9196	12.9286	186228.0
2011-08-23 07:00:00	AAPL	Stock	12.9111	12.9714	12.8614	12.8911	2094288.0
2011-08-23 08:00:00	AAPL	Stock	12.8911	12.9321	12.8254	12.8261	3313240.0
2011-08-23 09:00:00	AAPL	Stock	12.825	12.9214	12.75	12.8882	73708964.0
2011-08-23 10:00:00	AAPL	Stock	12.8882	13.0186	12.875	12.9453	97860644.0
2011-08-23 11:00:00	AAPL	Stock	12.9425	13.0929	12.9264	13.0921	77144088.0
2011-08-23 12:00:00	AAPL	Stock	13.0895	13.1775	13.0461	13.1564	72980964.0
2011-08-23 13:00:00	AAPL	Stock	13.1568	13.1964	13.0411	13.1021	84170268.0
2011-08-23 14:00:00	AAPL	Stock	13.1025	13.2275	13.0571	13.2071	88936400.0
2011-08-23 15:00:00	AAPL	Stock	13.2084	13.3443	13.205	13.3425	136512768.0
2011-08-23 16:00:00	AAPL	Stock	13.3293	13.3482	12.7269	13.3382	15101688.0
2011-08-23 17:00:00	AAPL	Stock	13.3375	13.3482	13.3279	13.3357	1192800.0
2011-08-23 18:00:00	AAPL	Stock	13.3393	13.3429	13.3346	13.3375	396760.0
2011-08-23 19:00:00	AAPL	Stock	13.3325	13.3325	13.29	13.3071	278460.0
2011-08-23 07:00:00	MSFT	Stock	24.25	24.39	24.25	24.29	7077.0
2011-08-23 08:00:00	MSFT	Stock	24.29	24.29	24.15	24.15	35346.0
2011-08-23 09:00:00	MSFT	Stock	24.12	24.46	24.03	24.415	5868665.0
2011-08-23 10:00:00	MSFT	Stock	24.42	24.64	24.38	24.4	7823750.0
2011-08-23 11:00:00	MSFT	Stock	24.405	24.68	24.331	24.655	5757612.0
2011-08-23 12:00:00	MSFT	Stock	24.655	24.75	24.58	24.63	4608443.0
2011-08-23 13:00:00	MSFT	Stock	24.635	24.68	24.4	24.51	5323096.0
2011-08-23 14:00:00	MSFT	Stock	24.51	24.605	24.4	24.57	5891699.0
2011-08-23 15:00:00	MSFT	Stock	24.575	24.75	24.53	24.71	15001115.0
2011-08-23 16:00:00	MSFT	Stock	24.71	24.76	24.067	24.73	7748976.0
2011-08-23 17:00:00	MSFT	Stock	24.67	24.72	24.65	24.68	230564.0
2011-08-23 18:00:00	MSFT	Stock	24.65	24.72	24.65	24.72	39791.0
2011-08-23 19:00:00	MSFT	Stock	24.65	24.65	24.65	24.65	500.0
2011-08-23 07:00:00	NVDA	Stock	0.3095	0.31	0.3095	0.31	64000.0
2011-08-23 08:00:00	NVDA	Stock	0.3105	0.3105	0.3062	0.3068	741000.0
2011-08-23 09:00:00	NVDA	Stock	0.3065	0.3213	0.3052	0.3203	160562720.0
2011-08-23 10:00:00	NVDA	Stock	0.3203	0.3288	0.32	0.3205	228593160.0
2011-08-23 11:00:00	NVDA	Stock	0.3206	0.3281	0.3198	0.3273	103243880.0
2011-08-23 12:00:00	NVDA	Stock	0.3273	0.3288	0.326	0.3279	67410720.0
2011-08-23 13:00:00	NVDA	Stock	0.3278	0.3288	0.3213	0.3228	87388680.0
2011-08-23 14:00:00	NVDA	Stock	0.3228	0.327	0.3208	0.327	77796360.0
2011-08-23 15:00:00	NVDA	Stock	0.327	0.331	0.327	0.3308	183686320.0
2011-08-23 16:00:00	NVDA	Stock	0.3303	0.3308	0.3235	0.3298	26066440.0
2011-08-23 17:00:00	NVDA	Stock	0.3308	0.3308	0.3288	0.3305	704760.0
2011-08-23 18:00:00	NVDA	Stock	0.3308	0.3308	0.3298	0.3305	205600.0
2011-08-23 19:00:00	NVDA	Stock	0.3285	0.3298	0.3285	0.3288	80000.0
2011-08-23 04:00:00	AMZN	Stock	9.0095	9.0095	9.0095	9.0095	2000.0
2011-08-23 06:00:00	AMZN	Stock	9.025	9.025	9.025	9.025	4000.0
2011-08-23 07:00:00	AMZN	Stock	9.02	9.0355	9.008	9.008	100000.0
2011-08-23 08:00:00	AMZN	Stock	9.0295	9.03	8.99	8.9915	168560.0
2011-08-23 09:00:00	AMZN	Stock	8.99	9.0929	8.926	9.048	12949980.0
2011-08-23 10:00:00	AMZN	Stock	9.048	9.247	9.0368	9.1795	19368840.0
2011-08-23 11:00:00	AMZN	Stock	9.1744	9.3135	9.135	9.3055	12724920.0
2011-08-23 12:00:00	AMZN	Stock	9.3055	9.4155	9.278	9.3988	14094080.0

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

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