PREVIEW / stock_1hour / 2014-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-31.parquet
  size:    1.1 MB
  rows:    49,868
  symbols: 3,589

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-10-31 04:00:00	AAPL	Stock	26.75	27.5	26.75	27.0025	89224.0
2014-10-31 05:00:00	AAPL	Stock	27.0025	27.11	27.0	27.075	69700.0
2014-10-31 06:00:00	AAPL	Stock	27.085	27.0925	27.0625	27.0875	31052.0
2014-10-31 07:00:00	AAPL	Stock	27.0775	27.0775	26.97	26.975	368684.0
2014-10-31 08:00:00	AAPL	Stock	26.9775	27.0925	26.95	26.9825	1209308.0
2014-10-31 09:00:00	AAPL	Stock	26.9825	27.0375	26.885	26.9275	28224520.0
2014-10-31 10:00:00	AAPL	Stock	26.9288	26.945	26.8025	26.88	28982712.0
2014-10-31 11:00:00	AAPL	Stock	26.88	26.935	26.8645	26.9025	16192608.0
2014-10-31 12:00:00	AAPL	Stock	26.9025	26.9075	26.855	26.8875	11044100.0
2014-10-31 13:00:00	AAPL	Stock	26.8875	26.9175	26.8825	26.9025	9875428.0
2014-10-31 14:00:00	AAPL	Stock	26.9038	26.935	26.8988	26.9215	13217296.0
2014-10-31 15:00:00	AAPL	Stock	26.9225	27.0	26.9125	26.9925	35306384.0
2014-10-31 16:00:00	AAPL	Stock	27.0	27.0075	26.897	26.9975	20839464.0
2014-10-31 17:00:00	AAPL	Stock	26.9975	27.0	26.9875	26.99	520448.0
2014-10-31 18:00:00	AAPL	Stock	26.9975	27.0	26.99	26.995	194524.0
2014-10-31 19:00:00	AAPL	Stock	26.9975	27.0025	26.99	27.0	87608.0
2014-10-31 04:00:00	MSFT	Stock	46.2	46.55	46.2	46.55	800.0
2014-10-31 05:00:00	MSFT	Stock	46.61	46.62	46.61	46.62	400.0
2014-10-31 06:00:00	MSFT	Stock	46.6	46.65	46.6	46.65	6544.0
2014-10-31 07:00:00	MSFT	Stock	46.6	46.6	46.48	46.48	27301.0
2014-10-31 08:00:00	MSFT	Stock	46.52	46.6	46.46	46.5	33133.0
2014-10-31 09:00:00	MSFT	Stock	46.54	46.99	46.48	46.63	4787696.0
2014-10-31 10:00:00	MSFT	Stock	46.621	46.89	46.621	46.71	3800114.0
2014-10-31 11:00:00	MSFT	Stock	46.71	46.85	46.63	46.68	3261258.0
2014-10-31 12:00:00	MSFT	Stock	46.68	46.79	46.67	46.78	2768908.0
2014-10-31 13:00:00	MSFT	Stock	46.79	46.85	46.68	46.83	2652191.0
2014-10-31 14:00:00	MSFT	Stock	46.83	46.84	46.72	46.8	2886520.0
2014-10-31 15:00:00	MSFT	Stock	46.8	46.94	46.695	46.93	7928854.0
2014-10-31 16:00:00	MSFT	Stock	46.95	46.96	46.128	46.94	6141612.0
2014-10-31 17:00:00	MSFT	Stock	46.94	46.95	46.93	46.95	8921.0
2014-10-31 18:00:00	MSFT	Stock	46.95	46.95	46.93	46.93	20004.0
2014-10-31 19:00:00	MSFT	Stock	46.93	46.93	46.88	46.88	1333.0
2014-10-31 09:00:00	NVDA	Stock	0.4782	0.4848	0.4755	0.4835	39011440.0
2014-10-31 10:00:00	NVDA	Stock	0.4832	0.4872	0.4825	0.4825	34054440.0
2014-10-31 11:00:00	NVDA	Stock	0.4828	0.485	0.4812	0.482	16810960.0
2014-10-31 12:00:00	NVDA	Stock	0.482	0.483	0.4803	0.4826	17865000.0
2014-10-31 13:00:00	NVDA	Stock	0.4828	0.484	0.4822	0.4829	19375920.0
2014-10-31 14:00:00	NVDA	Stock	0.4828	0.484	0.4819	0.4839	17460360.0
2014-10-31 15:00:00	NVDA	Stock	0.484	0.4888	0.483	0.4883	66949320.0
2014-10-31 16:00:00	NVDA	Stock	0.4885	0.4888	0.4664	0.4885	13766440.0
2014-10-31 17:00:00	NVDA	Stock	0.4885	0.4885	0.4885	0.4885	8000.0
2014-10-31 18:00:00	NVDA	Stock	0.487	0.487	0.487	0.487	12000.0
2014-10-31 19:00:00	NVDA	Stock	0.4875	0.4875	0.4875	0.4875	16000.0
2014-10-31 04:00:00	AMZN	Stock	15.036	15.14	15.036	15.14	11000.0
2014-10-31 06:00:00	AMZN	Stock	15.14	15.15	15.1175	15.15	8000.0
2014-10-31 07:00:00	AMZN	Stock	15.1425	15.15	15.1265	15.1265	80680.0
2014-10-31 08:00:00	AMZN	Stock	15.15	15.1725	15.1215	15.1505	194940.0
2014-10-31 09:00:00	AMZN	Stock	15.1675	15.2905	15.1125	15.1448	12460400.0
2014-10-31 10:00:00	AMZN	Stock	15.14	15.245	15.075	15.1795	15577240.0
2014-10-31 11:00:00	AMZN	Stock	15.1795	15.21	15.134	15.1442	9728240.0

> showing 50 of 49,868 rows — these rows as CSV

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