PREVIEW / stock_1hour / 2014-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-08.parquet
  size:    1.0 MB
  rows:    48,177
  symbols: 3,579

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-08 04:00:00	AAPL	Stock	23.3125	23.5	23.3125	23.4225	46032.0
2014-08-08 05:00:00	AAPL	Stock	23.4225	23.4225	23.3825	23.4175	48628.0
2014-08-08 06:00:00	AAPL	Stock	23.4125	23.48	23.4025	23.4675	101588.0
2014-08-08 07:00:00	AAPL	Stock	23.4675	23.605	23.46	23.5625	291460.0
2014-08-08 08:00:00	AAPL	Stock	23.565	23.635	23.4125	23.5975	686928.0
2014-08-08 09:00:00	AAPL	Stock	23.59	23.615	23.4	23.4875	25561060.0
2014-08-08 10:00:00	AAPL	Stock	23.4875	23.55	23.32	23.455	28771648.0
2014-08-08 11:00:00	AAPL	Stock	23.4525	23.495	23.4	23.4475	15039112.0
2014-08-08 12:00:00	AAPL	Stock	23.4488	23.475	23.41	23.4725	10020296.0
2014-08-08 13:00:00	AAPL	Stock	23.47	23.6525	23.4575	23.6175	22671560.0
2014-08-08 14:00:00	AAPL	Stock	23.62	23.7025	23.6075	23.685	17080924.0
2014-08-08 15:00:00	AAPL	Stock	23.6872	23.705	23.615	23.6825	28572336.0
2014-08-08 16:00:00	AAPL	Stock	23.6825	23.6925	23.49	23.65	7945984.0
2014-08-08 17:00:00	AAPL	Stock	23.6475	23.65	23.625	23.64	186232.0
2014-08-08 18:00:00	AAPL	Stock	23.6375	23.685	23.635	23.6425	54436.0
2014-08-08 19:00:00	AAPL	Stock	23.64	23.64	23.63	23.6325	95116.0
2014-08-08 04:00:00	MSFT	Stock	42.98	42.98	42.98	42.98	100.0
2014-08-08 07:00:00	MSFT	Stock	42.97	42.97	42.97	42.97	350.0
2014-08-08 08:00:00	MSFT	Stock	43.05	43.43	43.05	43.3	7616.0
2014-08-08 09:00:00	MSFT	Stock	43.26	43.32	42.95	43.08	4633203.0
2014-08-08 10:00:00	MSFT	Stock	43.08	43.18	42.99	43.026	5253698.0
2014-08-08 11:00:00	MSFT	Stock	43.02	43.18	42.95	42.99	2103892.0
2014-08-08 12:00:00	MSFT	Stock	42.99	43.02	42.91	42.964	1191914.0
2014-08-08 13:00:00	MSFT	Stock	42.97	43.22	42.94	43.15	3283148.0
2014-08-08 14:00:00	MSFT	Stock	43.155	43.23	43.115	43.19	3274823.0
2014-08-08 15:00:00	MSFT	Stock	43.195	43.22	43.08	43.19	5657330.0
2014-08-08 16:00:00	MSFT	Stock	43.2	43.23	43.12	43.2	2396321.0
2014-08-08 17:00:00	MSFT	Stock	43.15	43.18	43.15	43.18	841.0
2014-08-08 19:00:00	MSFT	Stock	43.12	43.18	43.12	43.18	200.0
2014-08-08 07:00:00	NVDA	Stock	0.4562	0.4562	0.4525	0.4562	1314960.0
2014-08-08 08:00:00	NVDA	Stock	0.4532	0.4585	0.452	0.4538	4325600.0
2014-08-08 09:00:00	NVDA	Stock	0.4528	0.4702	0.4518	0.468	223937600.0
2014-08-08 10:00:00	NVDA	Stock	0.4682	0.4715	0.4648	0.4698	191119800.0
2014-08-08 11:00:00	NVDA	Stock	0.4695	0.4725	0.4668	0.4673	99632400.0
2014-08-08 12:00:00	NVDA	Stock	0.467	0.4683	0.4658	0.4668	43553120.0
2014-08-08 13:00:00	NVDA	Stock	0.4668	0.4695	0.4659	0.4695	63638160.0
2014-08-08 14:00:00	NVDA	Stock	0.4695	0.472	0.4692	0.4711	46516840.0
2014-08-08 15:00:00	NVDA	Stock	0.4711	0.4775	0.4695	0.4748	188210720.0
2014-08-08 16:00:00	NVDA	Stock	0.4745	0.4751	0.471	0.4751	1005000.0
2014-08-08 17:00:00	NVDA	Stock	0.475	0.4753	0.475	0.4753	32000.0
2014-08-08 18:00:00	NVDA	Stock	0.475	0.477	0.475	0.477	197000.0
2014-08-08 19:00:00	NVDA	Stock	0.4755	0.477	0.4755	0.477	100000.0
2014-08-08 04:00:00	AMZN	Stock	15.4635	15.4655	15.462	15.4655	6000.0
2014-08-08 05:00:00	AMZN	Stock	15.428	15.4565	15.428	15.4565	4000.0
2014-08-08 06:00:00	AMZN	Stock	15.4615	15.4615	15.461	15.461	4000.0
2014-08-08 07:00:00	AMZN	Stock	15.519	15.525	15.513	15.513	10000.0
2014-08-08 08:00:00	AMZN	Stock	15.6	15.608	15.5685	15.6	82480.0
2014-08-08 09:00:00	AMZN	Stock	15.579	15.7385	15.533	15.7	8595760.0
2014-08-08 10:00:00	AMZN	Stock	15.6842	15.7475	15.642	15.7095	8082960.0
2014-08-08 11:00:00	AMZN	Stock	15.7065	15.7455	15.686	15.729	5215600.0

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

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