PREVIEW / stock_1hour / 2013-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-04.parquet
  size:    1002 KB
  rows:    46,456
  symbols: 3,502

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
2013-06-04 04:00:00	AAPL	Stock	16.1229	16.1268	16.1229	16.125	21000.0
2013-06-04 06:00:00	AAPL	Stock	16.1071	16.1071	16.0982	16.1004	8400.0
2013-06-04 07:00:00	AAPL	Stock	16.1079	16.1918	16.1071	16.1786	715008.0
2013-06-04 08:00:00	AAPL	Stock	16.175	16.225	16.0714	16.1879	2272872.0
2013-06-04 09:00:00	AAPL	Stock	16.1936	16.2224	16.0989	16.1721	46977504.0
2013-06-04 10:00:00	AAPL	Stock	16.175	16.2296	16.1318	16.1604	47515272.0
2013-06-04 11:00:00	AAPL	Stock	16.1604	16.1986	16.1125	16.1875	32321128.0
2013-06-04 12:00:00	AAPL	Stock	16.1871	16.1964	16.1071	16.1379	34133260.0
2013-06-04 13:00:00	AAPL	Stock	16.1364	16.1561	16.0243	16.0561	37459800.0
2013-06-04 14:00:00	AAPL	Stock	16.055	16.0616	15.9782	16.0243	31294116.0
2013-06-04 15:00:00	AAPL	Stock	16.025	16.1118	15.9929	16.0468	40870256.0
2013-06-04 16:00:00	AAPL	Stock	16.0468	16.065	16.0294	16.0643	9277268.0
2013-06-04 17:00:00	AAPL	Stock	16.0468	16.0643	15.7857	15.9321	3204684.0
2013-06-04 18:00:00	AAPL	Stock	15.9393	16.0468	15.9354	15.9621	819056.0
2013-06-04 19:00:00	AAPL	Stock	15.9554	15.9554	15.9375	15.9379	424144.0
2013-06-04 04:00:00	MSFT	Stock	35.6	35.8	35.6	35.8	286.0
2013-06-04 05:00:00	MSFT	Stock	35.7	35.7	35.7	35.7	100.0
2013-06-04 06:00:00	MSFT	Stock	35.7	35.7	35.7	35.7	400.0
2013-06-04 07:00:00	MSFT	Stock	35.6	35.62	35.59	35.61	5083.0
2013-06-04 08:00:00	MSFT	Stock	35.67	35.69	35.55	35.62	96372.0
2013-06-04 09:00:00	MSFT	Stock	35.64	35.74	35.49	35.52	7102952.0
2013-06-04 10:00:00	MSFT	Stock	35.525	35.59	35.36	35.475	9418512.0
2013-06-04 11:00:00	MSFT	Stock	35.47	35.685	35.45	35.652	9061118.0
2013-06-04 12:00:00	MSFT	Stock	35.65	35.66	35.475	35.543	7551645.0
2013-06-04 13:00:00	MSFT	Stock	35.545	35.56	35.25	35.27	5886881.0
2013-06-04 14:00:00	MSFT	Stock	35.275	35.3	35.0	35.009	6562350.0
2013-06-04 15:00:00	MSFT	Stock	35.01	35.065	34.771	34.98	16325402.0
2013-06-04 16:00:00	MSFT	Stock	34.98	35.55	34.84	34.99	2186747.0
2013-06-04 17:00:00	MSFT	Stock	34.99	34.99	34.91	34.91	11031.0
2013-06-04 18:00:00	MSFT	Stock	34.9	34.9	34.9	34.9	100.0
2013-06-04 19:00:00	MSFT	Stock	34.9	34.95	34.9	34.95	8839.0
2013-06-04 08:00:00	NVDA	Stock	0.361	0.3612	0.361	0.3612	53280.0
2013-06-04 09:00:00	NVDA	Stock	0.3592	0.3662	0.3592	0.3642	55025560.0
2013-06-04 10:00:00	NVDA	Stock	0.3642	0.37	0.3642	0.365	83377400.0
2013-06-04 11:00:00	NVDA	Stock	0.365	0.3661	0.364	0.3648	39657120.0
2013-06-04 12:00:00	NVDA	Stock	0.3649	0.365	0.363	0.3639	29383320.0
2013-06-04 13:00:00	NVDA	Stock	0.3638	0.365	0.3612	0.3617	29874840.0
2013-06-04 14:00:00	NVDA	Stock	0.3615	0.3635	0.3595	0.3619	29913760.0
2013-06-04 15:00:00	NVDA	Stock	0.3619	0.3629	0.3612	0.362	74003760.0
2013-06-04 16:00:00	NVDA	Stock	0.3618	0.3642	0.3616	0.3618	9097480.0
2013-06-04 17:00:00	NVDA	Stock	0.3618	0.3618	0.3618	0.3618	17160.0
2013-06-04 05:00:00	AMZN	Stock	13.344	13.344	13.3365	13.3365	4000.0
2013-06-04 06:00:00	AMZN	Stock	13.324	13.339	13.324	13.339	4000.0
2013-06-04 08:00:00	AMZN	Stock	13.305	13.344	13.304	13.312	77260.0
2013-06-04 09:00:00	AMZN	Stock	13.325	13.4105	13.2925	13.406	4740500.0
2013-06-04 10:00:00	AMZN	Stock	13.4075	13.444	13.3335	13.3355	6524000.0
2013-06-04 11:00:00	AMZN	Stock	13.3345	13.38	13.309	13.3695	4121380.0
2013-06-04 12:00:00	AMZN	Stock	13.3627	13.3696	13.281	13.3	2901060.0
2013-06-04 13:00:00	AMZN	Stock	13.2975	13.307	13.1805	13.2309	6532380.0
2013-06-04 14:00:00	AMZN	Stock	13.23	13.2475	13.151	13.22	5030260.0

> showing 50 of 46,456 rows — these rows as CSV

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