PREVIEW / stock_1hour / 2014-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-06.parquet
  size:    1.0 MB
  rows:    48,148
  symbols: 3,550

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
2014-08-06 04:00:00	AAPL	Stock	23.875	23.875	23.6225	23.6875	16840.0
2014-08-06 05:00:00	AAPL	Stock	23.655	23.685	23.575	23.63	48552.0
2014-08-06 06:00:00	AAPL	Stock	23.63	23.7	23.59	23.595	45792.0
2014-08-06 07:00:00	AAPL	Stock	23.6225	23.7425	23.6	23.7	112996.0
2014-08-06 08:00:00	AAPL	Stock	23.7075	23.7675	23.5925	23.6975	523624.0
2014-08-06 09:00:00	AAPL	Stock	23.715	23.87	23.6775	23.72	23023720.0
2014-08-06 10:00:00	AAPL	Stock	23.72	23.82	23.68	23.8052	25499140.0
2014-08-06 11:00:00	AAPL	Stock	23.805	23.8325	23.7275	23.8025	17787536.0
2014-08-06 12:00:00	AAPL	Stock	23.805	23.815	23.725	23.7712	13029004.0
2014-08-06 13:00:00	AAPL	Stock	23.7712	23.7975	23.7275	23.7375	11321628.0
2014-08-06 14:00:00	AAPL	Stock	23.74	23.795	23.7	23.775	11698540.0
2014-08-06 15:00:00	AAPL	Stock	23.775	23.8075	23.73	23.74	18669064.0
2014-08-06 16:00:00	AAPL	Stock	23.7425	23.779	23.725	23.75	4958740.0
2014-08-06 17:00:00	AAPL	Stock	23.745	23.755	23.725	23.74	131908.0
2014-08-06 18:00:00	AAPL	Stock	23.7375	23.7425	23.72	23.735	127540.0
2014-08-06 19:00:00	AAPL	Stock	23.735	23.7525	23.7275	23.7425	157456.0
2014-08-06 05:00:00	MSFT	Stock	42.82	42.85	42.6	42.61	2650.0
2014-08-06 06:00:00	MSFT	Stock	42.62	42.74	42.61	42.7	9930.0
2014-08-06 07:00:00	MSFT	Stock	42.75	42.79	42.71	42.71	6100.0
2014-08-06 08:00:00	MSFT	Stock	42.74	42.79	42.66	42.72	17367.0
2014-08-06 09:00:00	MSFT	Stock	42.72	42.78	42.21	42.653	4440552.0
2014-08-06 10:00:00	MSFT	Stock	42.66	43.09	42.65	43.07	3173486.0
2014-08-06 11:00:00	MSFT	Stock	43.06	43.15	42.83	43.125	2408271.0
2014-08-06 12:00:00	MSFT	Stock	43.13	43.17	42.96	43.04	1833573.0
2014-08-06 13:00:00	MSFT	Stock	43.04	43.09	42.82	42.848	2446704.0
2014-08-06 14:00:00	MSFT	Stock	42.84	43.02	42.8	42.93	2369843.0
2014-08-06 15:00:00	MSFT	Stock	42.92	42.975	42.74	42.76	4981883.0
2014-08-06 16:00:00	MSFT	Stock	42.77	42.95	42.7	42.779	2292380.0
2014-08-06 17:00:00	MSFT	Stock	42.77	42.906	42.75	42.906	3840.0
2014-08-06 18:00:00	MSFT	Stock	42.82	42.84	42.75	42.75	4473.0
2014-08-06 09:00:00	NVDA	Stock	0.4385	0.4441	0.4352	0.4412	20669520.0
2014-08-06 10:00:00	NVDA	Stock	0.4415	0.4448	0.44	0.4448	29173640.0
2014-08-06 11:00:00	NVDA	Stock	0.4445	0.446	0.442	0.4459	30511640.0
2014-08-06 12:00:00	NVDA	Stock	0.446	0.4465	0.4426	0.4448	27290800.0
2014-08-06 13:00:00	NVDA	Stock	0.4445	0.445	0.4415	0.4415	15753640.0
2014-08-06 14:00:00	NVDA	Stock	0.4415	0.4438	0.4412	0.4424	24752520.0
2014-08-06 15:00:00	NVDA	Stock	0.4422	0.4428	0.441	0.4412	59667680.0
2014-08-06 16:00:00	NVDA	Stock	0.441	0.4424	0.441	0.4411	7007520.0
2014-08-06 17:00:00	NVDA	Stock	0.443	0.443	0.443	0.443	4800.0
2014-08-06 18:00:00	NVDA	Stock	0.4412	0.4412	0.4412	0.4412	10000.0
2014-08-06 04:00:00	AMZN	Stock	15.65	15.65	15.65	15.65	2000.0
2014-08-06 05:00:00	AMZN	Stock	15.55	15.55	15.55	15.55	2000.0
2014-08-06 06:00:00	AMZN	Stock	15.475	15.475	15.475	15.475	2160.0
2014-08-06 07:00:00	AMZN	Stock	15.478	15.525	15.478	15.525	7360.0
2014-08-06 08:00:00	AMZN	Stock	15.616	15.616	15.5055	15.5375	39480.0
2014-08-06 09:00:00	AMZN	Stock	15.522	15.719	15.51	15.674	6570100.0
2014-08-06 10:00:00	AMZN	Stock	15.675	15.783	15.6435	15.7525	10547200.0
2014-08-06 11:00:00	AMZN	Stock	15.7485	15.782	15.7005	15.7602	5228020.0
2014-08-06 12:00:00	AMZN	Stock	15.7549	15.789	15.7178	15.7303	3374260.0
2014-08-06 13:00:00	AMZN	Stock	15.7265	15.734	15.6775	15.693	3429200.0

> showing 50 of 48,148 rows — these rows as CSV

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