PREVIEW / stock_1hour / 2011-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-15.parquet
  size:    930 KB
  rows:    44,242
  symbols: 3,530

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-07-15 04:00:00	AAPL	Stock	12.7989	12.825	12.7989	12.8214	20300.0
2011-07-15 05:00:00	AAPL	Stock	12.8643	12.8643	12.8636	12.8636	8400.0
2011-07-15 07:00:00	AAPL	Stock	12.8732	12.9289	12.8639	12.8882	641368.0
2011-07-15 08:00:00	AAPL	Stock	12.8889	12.9214	12.8889	12.9125	3546396.0
2011-07-15 09:00:00	AAPL	Stock	12.9107	12.9268	12.8504	12.8743	97634600.0
2011-07-15 10:00:00	AAPL	Stock	12.8729	12.9007	12.8275	12.8543	67138540.0
2011-07-15 11:00:00	AAPL	Stock	12.8557	12.8786	12.8504	12.8636	31961188.0
2011-07-15 12:00:00	AAPL	Stock	12.8648	12.8968	12.8579	12.88	41598480.0
2011-07-15 13:00:00	AAPL	Stock	12.8796	12.9011	12.8671	12.8802	34146952.0
2011-07-15 14:00:00	AAPL	Stock	12.8786	12.8904	12.8729	12.885	34590416.0
2011-07-15 15:00:00	AAPL	Stock	12.8829	13.0357	12.8807	13.0343	147352408.0
2011-07-15 16:00:00	AAPL	Stock	13.0343	13.0461	12.911	13.0375	14615860.0
2011-07-15 17:00:00	AAPL	Stock	13.0375	13.0389	13.0339	13.0375	1943676.0
2011-07-15 18:00:00	AAPL	Stock	13.0375	13.0446	13.0329	13.0343	900172.0
2011-07-15 19:00:00	AAPL	Stock	13.0475	13.0639	13.0357	13.0536	690844.0
2011-07-15 07:00:00	MSFT	Stock	26.47	26.54	26.47	26.53	601.0
2011-07-15 08:00:00	MSFT	Stock	26.58	26.58	26.53	26.57	14433.0
2011-07-15 09:00:00	MSFT	Stock	26.59	26.76	26.47	26.505	10573656.0
2011-07-15 10:00:00	MSFT	Stock	26.505	26.67	26.49	26.525	7003846.0
2011-07-15 11:00:00	MSFT	Stock	26.52	26.71	26.49	26.58	4065891.0
2011-07-15 12:00:00	MSFT	Stock	26.58	26.79	26.58	26.77	5474176.0
2011-07-15 13:00:00	MSFT	Stock	26.77	26.93	26.74	26.76	6315267.0
2011-07-15 14:00:00	MSFT	Stock	26.75	26.865	26.7	26.71	4819365.0
2011-07-15 15:00:00	MSFT	Stock	26.7	26.86	26.69	26.78	7892055.0
2011-07-15 16:00:00	MSFT	Stock	26.79	26.827	26.684	26.76	2815444.0
2011-07-15 17:00:00	MSFT	Stock	26.47	26.87	26.47	26.82	10281.0
2011-07-15 18:00:00	MSFT	Stock	26.78	26.83	26.78	26.83	55759.0
2011-07-15 19:00:00	MSFT	Stock	26.85	26.85	26.8	26.8	1060.0
2011-07-15 08:00:00	NVDA	Stock	0.356	0.357	0.3555	0.3555	382000.0
2011-07-15 09:00:00	NVDA	Stock	0.3555	0.3562	0.3453	0.3502	146748240.0
2011-07-15 10:00:00	NVDA	Stock	0.35	0.3548	0.3495	0.3518	170025600.0
2011-07-15 11:00:00	NVDA	Stock	0.3517	0.3548	0.3508	0.353	92841160.0
2011-07-15 12:00:00	NVDA	Stock	0.353	0.3545	0.3528	0.3545	67624880.0
2011-07-15 13:00:00	NVDA	Stock	0.3542	0.3562	0.3535	0.3542	63483840.0
2011-07-15 14:00:00	NVDA	Stock	0.3542	0.3545	0.3508	0.3518	94983960.0
2011-07-15 15:00:00	NVDA	Stock	0.3515	0.3535	0.3515	0.3525	171818880.0
2011-07-15 16:00:00	NVDA	Stock	0.3525	0.354	0.35	0.3533	12323160.0
2011-07-15 17:00:00	NVDA	Stock	0.352	0.3533	0.352	0.3533	136000.0
2011-07-15 18:00:00	NVDA	Stock	0.3535	0.3565	0.3535	0.3565	110920.0
2011-07-15 19:00:00	NVDA	Stock	0.356	0.356	0.3553	0.3553	20000.0
2011-07-15 04:00:00	AMZN	Stock	10.615	10.615	10.615	10.615	2000.0
2011-07-15 06:00:00	AMZN	Stock	10.6595	10.66	10.6595	10.66	54000.0
2011-07-15 07:00:00	AMZN	Stock	10.661	10.759	10.6605	10.759	107220.0
2011-07-15 08:00:00	AMZN	Stock	10.7335	10.7335	10.672	10.69	180780.0
2011-07-15 09:00:00	AMZN	Stock	10.702	10.7265	10.5045	10.5285	20297780.0
2011-07-15 10:00:00	AMZN	Stock	10.5335	10.603	10.4645	10.496	15154300.0
2011-07-15 11:00:00	AMZN	Stock	10.499	10.5835	10.496	10.5745	8080740.0
2011-07-15 12:00:00	AMZN	Stock	10.5748	10.6025	10.5445	10.5715	5766420.0
2011-07-15 13:00:00	AMZN	Stock	10.5705	10.5955	10.519	10.522	5876200.0
2011-07-15 14:00:00	AMZN	Stock	10.5215	10.5665	10.519	10.5505	5639620.0

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

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