PREVIEW / stock_1hour / 2015-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-30.parquet
  size:    1.1 MB
  rows:    49,101
  symbols: 3,515

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-04-30 04:00:00	AAPL	Stock	31.9525	31.9525	31.6625	31.78	185196.0
2015-04-30 05:00:00	AAPL	Stock	31.77	31.895	31.75	31.895	81448.0
2015-04-30 06:00:00	AAPL	Stock	31.8875	31.9	31.8	31.8575	124972.0
2015-04-30 07:00:00	AAPL	Stock	31.8675	31.99	31.85	31.975	414868.0
2015-04-30 08:00:00	AAPL	Stock	31.9675	32.275	31.8475	31.965	1245816.0
2015-04-30 09:00:00	AAPL	Stock	31.9625	31.9975	31.57	31.5772	46148812.0
2015-04-30 10:00:00	AAPL	Stock	31.5758	31.6575	31.3625	31.515	63332232.0
2015-04-30 11:00:00	AAPL	Stock	31.5138	31.7	31.4525	31.4625	30951692.0
2015-04-30 12:00:00	AAPL	Stock	31.465	31.5475	31.3125	31.4185	29618276.0
2015-04-30 13:00:00	AAPL	Stock	31.42	31.4975	31.355	31.405	25153448.0
2015-04-30 14:00:00	AAPL	Stock	31.4078	31.455	31.2675	31.29	27119952.0
2015-04-30 15:00:00	AAPL	Stock	31.2875	31.37	31.145	31.305	55511616.0
2015-04-30 16:00:00	AAPL	Stock	31.31	31.8328	31.22	31.2525	23759900.0
2015-04-30 17:00:00	AAPL	Stock	31.2525	31.3	31.2125	31.295	487760.0
2015-04-30 18:00:00	AAPL	Stock	31.2875	31.3175	31.26	31.28	318848.0
2015-04-30 19:00:00	AAPL	Stock	31.2875	31.3225	31.2875	31.32	253592.0
2015-04-30 04:00:00	MSFT	Stock	48.79	48.85	48.72	48.85	13083.0
2015-04-30 05:00:00	MSFT	Stock	48.83	48.85	48.73	48.79	3900.0
2015-04-30 06:00:00	MSFT	Stock	48.76	48.8	48.75	48.8	5873.0
2015-04-30 07:00:00	MSFT	Stock	48.85	48.92	48.5	48.89	19797.0
2015-04-30 08:00:00	MSFT	Stock	48.85	49.0	48.81	48.85	314595.0
2015-04-30 09:00:00	MSFT	Stock	48.85	49.41	48.64	48.95	10738677.0
2015-04-30 10:00:00	MSFT	Stock	48.95	49.1	48.62	48.67	8663454.0
2015-04-30 11:00:00	MSFT	Stock	48.677	49.37	48.67	49.254	8124022.0
2015-04-30 12:00:00	MSFT	Stock	49.255	49.54	49.15	49.24	7007130.0
2015-04-30 13:00:00	MSFT	Stock	49.24	49.32	49.05	49.165	4280130.0
2015-04-30 14:00:00	MSFT	Stock	49.17	49.21	48.87	48.89	5982315.0
2015-04-30 15:00:00	MSFT	Stock	48.89	48.9	48.6	48.66	12157636.0
2015-04-30 16:00:00	MSFT	Stock	48.64	49.06	48.64	48.79	4533060.0
2015-04-30 17:00:00	MSFT	Stock	48.72	48.78	48.71	48.72	1882.0
2015-04-30 18:00:00	MSFT	Stock	48.77	48.78	48.74	48.77	6630.0
2015-04-30 19:00:00	MSFT	Stock	48.74	48.74	48.72	48.74	4900.0
2015-04-30 08:00:00	NVDA	Stock	0.5522	0.5522	0.55	0.5502	64000.0
2015-04-30 09:00:00	NVDA	Stock	0.5502	0.5542	0.5502	0.5505	17793560.0
2015-04-30 10:00:00	NVDA	Stock	0.5505	0.5541	0.5495	0.5538	43404640.0
2015-04-30 11:00:00	NVDA	Stock	0.5538	0.5565	0.5524	0.5532	17280480.0
2015-04-30 12:00:00	NVDA	Stock	0.5535	0.5576	0.5535	0.555	19834880.0
2015-04-30 13:00:00	NVDA	Stock	0.555	0.5568	0.5541	0.5555	20265880.0
2015-04-30 14:00:00	NVDA	Stock	0.5555	0.556	0.5515	0.5525	17409600.0
2015-04-30 15:00:00	NVDA	Stock	0.5524	0.555	0.5508	0.5548	52549960.0
2015-04-30 16:00:00	NVDA	Stock	0.5549	0.555	0.5548	0.5549	20352920.0
2015-04-30 08:00:00	AMZN	Stock	21.4665	21.4665	21.41	21.425	27840.0
2015-04-30 09:00:00	AMZN	Stock	21.425	21.5875	21.355	21.4975	7138020.0
2015-04-30 10:00:00	AMZN	Stock	21.487	21.515	21.231	21.264	9419580.0
2015-04-30 11:00:00	AMZN	Stock	21.2645	21.488	21.2615	21.36	7099860.0
2015-04-30 12:00:00	AMZN	Stock	21.37	21.3995	21.2275	21.2635	5066300.0
2015-04-30 13:00:00	AMZN	Stock	21.2722	21.303	21.2125	21.2373	4592760.0
2015-04-30 14:00:00	AMZN	Stock	21.234	21.2465	21.0626	21.0745	10223460.0
2015-04-30 15:00:00	AMZN	Stock	21.0705	21.1395	20.962	21.0845	20789340.0
2015-04-30 16:00:00	AMZN	Stock	21.0805	21.119	21.077	21.1	1268660.0

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

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