PREVIEW / stock_1hour / 2014-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-10.parquet
  size:    1.0 MB
  rows:    48,952
  symbols: 3,547

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-10 04:00:00	AAPL	Stock	25.2275	25.2275	25.1225	25.1225	17956.0
2014-10-10 05:00:00	AAPL	Stock	25.125	25.1375	25.0275	25.0625	104764.0
2014-10-10 06:00:00	AAPL	Stock	25.0875	25.0875	25.01	25.0625	56612.0
2014-10-10 07:00:00	AAPL	Stock	25.0575	25.145	25.0375	25.1	441088.0
2014-10-10 08:00:00	AAPL	Stock	25.1	25.2225	25.05	25.2225	848628.0
2014-10-10 09:00:00	AAPL	Stock	25.22	25.4725	25.125	25.3962	36416736.0
2014-10-10 10:00:00	AAPL	Stock	25.395	25.425	25.075	25.3588	52297424.0
2014-10-10 11:00:00	AAPL	Stock	25.3575	25.45	25.2775	25.36	28837100.0
2014-10-10 12:00:00	AAPL	Stock	25.3612	25.4825	25.36	25.4325	26959808.0
2014-10-10 13:00:00	AAPL	Stock	25.43	25.4675	25.36	25.46	18712668.0
2014-10-10 14:00:00	AAPL	Stock	25.4575	25.5075	25.3875	25.4225	24608872.0
2014-10-10 15:00:00	AAPL	Stock	25.425	25.4425	25.1825	25.1825	45654892.0
2014-10-10 16:00:00	AAPL	Stock	25.185	25.421	21.9815	25.1625	16798172.0
2014-10-10 17:00:00	AAPL	Stock	25.1825	25.1975	25.1525	25.19	926004.0
2014-10-10 18:00:00	AAPL	Stock	25.1925	25.2	25.1825	25.195	67352.0
2014-10-10 19:00:00	AAPL	Stock	25.1975	25.2225	25.1925	25.2125	165712.0
2014-10-10 04:00:00	MSFT	Stock	45.77	45.77	45.67	45.67	900.0
2014-10-10 05:00:00	MSFT	Stock	45.57	45.57	45.5	45.5	532.0
2014-10-10 06:00:00	MSFT	Stock	45.46	45.46	45.4	45.46	1000.0
2014-10-10 07:00:00	MSFT	Stock	45.43	45.5	45.43	45.5	4000.0
2014-10-10 08:00:00	MSFT	Stock	45.58	45.78	45.46	45.78	57166.0
2014-10-10 09:00:00	MSFT	Stock	45.8	46.12	45.55	45.77	4418607.0
2014-10-10 10:00:00	MSFT	Stock	45.76	45.76	45.43	45.54	5733409.0
2014-10-10 11:00:00	MSFT	Stock	45.54	45.58	45.06	45.115	5996308.0
2014-10-10 12:00:00	MSFT	Stock	45.115	45.37	45.01	45.013	4448783.0
2014-10-10 13:00:00	MSFT	Stock	45.02	45.02	44.58	44.585	6365646.0
2014-10-10 14:00:00	MSFT	Stock	44.58	44.72	44.42	44.475	6127342.0
2014-10-10 15:00:00	MSFT	Stock	44.475	44.48	43.95	44.03	12740219.0
2014-10-10 16:00:00	MSFT	Stock	44.03	45.935	43.92	44.03	4169813.0
2014-10-10 17:00:00	MSFT	Stock	44.03	44.11	43.95	44.0	293728.0
2014-10-10 18:00:00	MSFT	Stock	44.0	44.03	43.95	44.0	95406.0
2014-10-10 19:00:00	MSFT	Stock	43.95	44.0	43.95	44.0	3659.0
2014-10-10 08:00:00	NVDA	Stock	0.4428	0.443	0.4428	0.443	100000.0
2014-10-10 09:00:00	NVDA	Stock	0.443	0.4458	0.4342	0.4349	73135680.0
2014-10-10 10:00:00	NVDA	Stock	0.435	0.4352	0.4248	0.4293	144176520.0
2014-10-10 11:00:00	NVDA	Stock	0.4291	0.4328	0.428	0.4286	71810040.0
2014-10-10 12:00:00	NVDA	Stock	0.4286	0.4322	0.4286	0.4302	60281760.0
2014-10-10 13:00:00	NVDA	Stock	0.43	0.4312	0.428	0.4298	45408560.0
2014-10-10 14:00:00	NVDA	Stock	0.4298	0.4305	0.428	0.4294	53236440.0
2014-10-10 15:00:00	NVDA	Stock	0.4293	0.4295	0.421	0.4213	195857200.0
2014-10-10 16:00:00	NVDA	Stock	0.4213	0.4469	0.4188	0.4188	19726880.0
2014-10-10 17:00:00	NVDA	Stock	0.4211	0.4211	0.4128	0.4128	633600.0
2014-10-10 04:00:00	AMZN	Stock	15.7775	15.7775	15.7775	15.7775	2000.0
2014-10-10 05:00:00	AMZN	Stock	15.725	15.725	15.661	15.661	4000.0
2014-10-10 06:00:00	AMZN	Stock	15.6085	15.64	15.6005	15.64	16380.0
2014-10-10 07:00:00	AMZN	Stock	15.674	15.68	15.656	15.675	26000.0
2014-10-10 08:00:00	AMZN	Stock	15.6745	15.7685	15.554	15.6975	385320.0
2014-10-10 09:00:00	AMZN	Stock	15.6985	15.8645	15.65	15.802	9057580.0
2014-10-10 10:00:00	AMZN	Stock	15.7975	15.8282	15.609	15.6994	17228900.0
2014-10-10 11:00:00	AMZN	Stock	15.7035	15.7683	15.676	15.7145	6451840.0

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

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