PREVIEW / stock_1hour / 2015-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-10.parquet
  size:    1.1 MB
  rows:    49,135
  symbols: 3,497

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
2015-06-10 04:00:00	AAPL	Stock	32.0	32.0475	31.9175	31.9225	25600.0
2015-06-10 05:00:00	AAPL	Stock	31.995	32.075	31.975	32.075	34420.0
2015-06-10 06:00:00	AAPL	Stock	32.0425	32.0475	32.005	32.0175	43064.0
2015-06-10 07:00:00	AAPL	Stock	32.0075	32.0125	31.965	32.0	125692.0
2015-06-10 08:00:00	AAPL	Stock	32.0	32.0125	31.94	31.98	539800.0
2015-06-10 09:00:00	AAPL	Stock	31.98	32.205	31.9625	32.14	23622760.0
2015-06-10 10:00:00	AAPL	Stock	32.1425	32.2512	32.11	32.17	25209412.0
2015-06-10 11:00:00	AAPL	Stock	32.165	32.2725	32.1375	32.2322	21147988.0
2015-06-10 12:00:00	AAPL	Stock	32.23	32.2575	32.165	32.24	12693008.0
2015-06-10 13:00:00	AAPL	Stock	32.2388	32.26	32.1825	32.2438	11246528.0
2015-06-10 14:00:00	AAPL	Stock	32.245	32.335	32.2375	32.3	19594944.0
2015-06-10 15:00:00	AAPL	Stock	32.305	32.305	32.21	32.2175	23776160.0
2015-06-10 16:00:00	AAPL	Stock	32.22	32.235	32.21	32.235	9256108.0
2015-06-10 17:00:00	AAPL	Stock	32.2275	32.2425	32.22	32.24	35924.0
2015-06-10 18:00:00	AAPL	Stock	32.235	32.25	32.215	32.2375	138736.0
2015-06-10 19:00:00	AAPL	Stock	32.23	32.24	32.225	32.23	42440.0
2015-06-10 07:00:00	MSFT	Stock	45.9	45.9	45.9	45.9	2400.0
2015-06-10 08:00:00	MSFT	Stock	45.9	46.03	45.9	45.95	28468.0
2015-06-10 09:00:00	MSFT	Stock	45.96	46.15	45.69	46.02	3033466.0
2015-06-10 10:00:00	MSFT	Stock	46.02	46.51	46.0	46.455	3877688.0
2015-06-10 11:00:00	MSFT	Stock	46.45	46.785	46.36	46.675	4230941.0
2015-06-10 12:00:00	MSFT	Stock	46.67	46.78	46.61	46.74	2027186.0
2015-06-10 13:00:00	MSFT	Stock	46.74	46.79	46.61	46.723	2005912.0
2015-06-10 14:00:00	MSFT	Stock	46.73	46.83	46.69	46.78	2160367.0
2015-06-10 15:00:00	MSFT	Stock	46.78	46.785	46.58	46.59	4736099.0
2015-06-10 16:00:00	MSFT	Stock	46.61	46.61	46.34	46.5	4448740.0
2015-06-10 17:00:00	MSFT	Stock	46.61	46.61	46.61	46.61	35900.0
2015-06-10 18:00:00	MSFT	Stock	46.5	46.5	46.46	46.46	936.0
2015-06-10 19:00:00	MSFT	Stock	46.54	46.54	46.51	46.51	300.0
2015-06-10 04:00:00	NVDA	Stock	0.5425	0.5425	0.5418	0.5418	20000.0
2015-06-10 05:00:00	NVDA	Stock	0.5418	0.5418	0.5418	0.5418	4000.0
2015-06-10 08:00:00	NVDA	Stock	0.5415	0.5425	0.5375	0.542	1148160.0
2015-06-10 09:00:00	NVDA	Stock	0.54	0.5432	0.5342	0.5371	81101280.0
2015-06-10 10:00:00	NVDA	Stock	0.537	0.5385	0.5338	0.5365	97520200.0
2015-06-10 11:00:00	NVDA	Stock	0.5365	0.5402	0.536	0.5398	106833840.0
2015-06-10 12:00:00	NVDA	Stock	0.5398	0.5435	0.539	0.542	64505640.0
2015-06-10 13:00:00	NVDA	Stock	0.542	0.5422	0.537	0.5382	33188240.0
2015-06-10 14:00:00	NVDA	Stock	0.538	0.5388	0.537	0.5371	24083240.0
2015-06-10 15:00:00	NVDA	Stock	0.5371	0.5385	0.5358	0.5364	85877960.0
2015-06-10 16:00:00	NVDA	Stock	0.5367	0.5367	0.5367	0.5367	13979800.0
2015-06-10 18:00:00	NVDA	Stock	0.5378	0.5378	0.5378	0.5378	16000.0
2015-06-10 19:00:00	NVDA	Stock	0.5372	0.5372	0.5372	0.5372	20000.0
2015-06-10 04:00:00	AMZN	Stock	21.3505	21.3505	21.3505	21.3505	2000.0
2015-06-10 08:00:00	AMZN	Stock	21.355	21.3585	21.325	21.325	42440.0
2015-06-10 09:00:00	AMZN	Stock	21.3355	21.4505	21.283	21.4368	4938680.0
2015-06-10 10:00:00	AMZN	Stock	21.4325	21.4995	21.3725	21.4825	5768320.0
2015-06-10 11:00:00	AMZN	Stock	21.488	21.582	21.4485	21.5485	7303360.0
2015-06-10 12:00:00	AMZN	Stock	21.5538	21.598	21.542	21.5725	3378980.0
2015-06-10 13:00:00	AMZN	Stock	21.5805	21.592	21.5235	21.5475	3330840.0
2015-06-10 14:00:00	AMZN	Stock	21.5505	21.61	21.5485	21.607	3691320.0

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

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