PREVIEW / stock_1hour / 2014-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-12.parquet
  size:    1.0 MB
  rows:    48,542
  symbols: 3,574

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-09-12 04:00:00	AAPL	Stock	25.3325	25.3325	25.2575	25.3	4760.0
2014-09-12 05:00:00	AAPL	Stock	25.295	25.295	25.2775	25.2775	7140.0
2014-09-12 06:00:00	AAPL	Stock	25.295	25.31	25.2775	25.2925	45604.0
2014-09-12 07:00:00	AAPL	Stock	25.2925	25.325	25.1475	25.2375	622540.0
2014-09-12 08:00:00	AAPL	Stock	25.165	25.35	25.165	25.25	1427004.0
2014-09-12 09:00:00	AAPL	Stock	25.26	25.45	25.2525	25.3325	37182140.0
2014-09-12 10:00:00	AAPL	Stock	25.3325	25.4225	25.29	25.41	32843216.0
2014-09-12 11:00:00	AAPL	Stock	25.4125	25.5175	25.3825	25.405	34385624.0
2014-09-12 12:00:00	AAPL	Stock	25.405	25.5475	25.3725	25.495	28459968.0
2014-09-12 13:00:00	AAPL	Stock	25.4925	25.5375	25.455	25.4925	21943924.0
2014-09-12 14:00:00	AAPL	Stock	25.49	25.535	25.37	25.395	30502560.0
2014-09-12 15:00:00	AAPL	Stock	25.395	25.4825	25.3425	25.4175	42375596.0
2014-09-12 16:00:00	AAPL	Stock	25.415	25.4275	25.375	25.4225	9771728.0
2014-09-12 17:00:00	AAPL	Stock	25.42	25.4475	25.4175	25.4175	190492.0
2014-09-12 18:00:00	AAPL	Stock	25.415	25.43	25.4	25.415	245100.0
2014-09-12 19:00:00	AAPL	Stock	25.425	25.435	25.4	25.4	5720052.0
2014-09-12 07:00:00	MSFT	Stock	46.96	46.97	46.9	46.96	6494.0
2014-09-12 08:00:00	MSFT	Stock	46.96	46.97	46.96	46.97	4300.0
2014-09-12 09:00:00	MSFT	Stock	46.93	47.02	46.61	46.72	6524508.0
2014-09-12 10:00:00	MSFT	Stock	46.725	46.88	46.65	46.8	6156497.0
2014-09-12 11:00:00	MSFT	Stock	46.792	46.83	46.7	46.74	2216970.0
2014-09-12 12:00:00	MSFT	Stock	46.74	46.75	46.65	46.65	3653296.0
2014-09-12 13:00:00	MSFT	Stock	46.66	46.71	46.6	46.66	3893110.0
2014-09-12 14:00:00	MSFT	Stock	46.66	46.71	46.61	46.67	4565846.0
2014-09-12 15:00:00	MSFT	Stock	46.67	46.75	46.65	46.7	5272857.0
2014-09-12 16:00:00	MSFT	Stock	46.695	46.727	46.65	46.65	4387624.0
2014-09-12 17:00:00	MSFT	Stock	46.65	46.67	46.65	46.65	991.0
2014-09-12 18:00:00	MSFT	Stock	46.65	46.7	46.61	46.61	19056.0
2014-09-12 19:00:00	MSFT	Stock	46.58	46.59	46.55	46.55	1611.0
2014-09-12 09:00:00	NVDA	Stock	0.4883	0.4883	0.4788	0.4808	24872560.0
2014-09-12 10:00:00	NVDA	Stock	0.4808	0.483	0.4798	0.4828	29123160.0
2014-09-12 11:00:00	NVDA	Stock	0.483	0.4832	0.4812	0.4825	31606480.0
2014-09-12 12:00:00	NVDA	Stock	0.4822	0.4822	0.4803	0.481	24225320.0
2014-09-12 13:00:00	NVDA	Stock	0.4808	0.4812	0.4782	0.4785	20049240.0
2014-09-12 14:00:00	NVDA	Stock	0.4785	0.4795	0.4776	0.478	37060360.0
2014-09-12 15:00:00	NVDA	Stock	0.4781	0.4794	0.4774	0.4782	51240800.0
2014-09-12 16:00:00	NVDA	Stock	0.478	0.4797	0.4778	0.478	14218120.0
2014-09-12 08:00:00	AMZN	Stock	16.525	16.525	16.418	16.4185	27200.0
2014-09-12 09:00:00	AMZN	Stock	16.4865	16.5095	16.4435	16.468	4979320.0
2014-09-12 10:00:00	AMZN	Stock	16.4615	16.579	16.4395	16.5379	9588360.0
2014-09-12 11:00:00	AMZN	Stock	16.533	16.6445	16.5211	16.573	20177120.0
2014-09-12 12:00:00	AMZN	Stock	16.579	16.5875	16.4625	16.485	3884640.0
2014-09-12 13:00:00	AMZN	Stock	16.479	16.4995	16.442	16.494	3617520.0
2014-09-12 14:00:00	AMZN	Stock	16.4975	16.5765	16.482	16.537	8191640.0
2014-09-12 15:00:00	AMZN	Stock	16.5425	16.57	16.5135	16.56	7790260.0
2014-09-12 16:00:00	AMZN	Stock	16.5595	16.5625	16.5162	16.5595	4803780.0
2014-09-12 18:00:00	AMZN	Stock	16.5595	16.5595	16.5595	16.5595	126280.0
2014-09-12 19:00:00	AMZN	Stock	16.555	16.555	16.555	16.555	5500.0
2014-09-12 08:00:00	GOOGL	Stock	29.632	29.639	29.632	29.639	4520.0
2014-09-12 09:00:00	GOOGL	Stock	29.565	29.574	29.37	29.3945	2729260.0

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

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