PREVIEW / stock_1hour / 2014-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-01.parquet
  size:    1.1 MB
  rows:    50,665
  symbols: 3,559

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-08-01 04:00:00	AAPL	Stock	23.82	23.82	23.5	23.54	129116.0
2014-08-01 05:00:00	AAPL	Stock	23.5575	23.5575	23.3275	23.3875	198504.0
2014-08-01 06:00:00	AAPL	Stock	23.4	23.5575	23.3875	23.55	302456.0
2014-08-01 07:00:00	AAPL	Stock	23.54	23.6775	23.5	23.6775	698876.0
2014-08-01 08:00:00	AAPL	Stock	23.6825	23.8925	23.5	23.7875	2205944.0
2014-08-01 09:00:00	AAPL	Stock	23.7925	24.0375	23.7025	24.0075	33461968.0
2014-08-01 10:00:00	AAPL	Stock	24.01	24.0325	23.845	23.9138	28639368.0
2014-08-01 11:00:00	AAPL	Stock	23.9138	23.9875	23.815	23.86	22845040.0
2014-08-01 12:00:00	AAPL	Stock	23.86	23.9675	23.825	23.9005	16239412.0
2014-08-01 13:00:00	AAPL	Stock	23.902	24.0625	23.8625	24.0525	19360932.0
2014-08-01 14:00:00	AAPL	Stock	24.0525	24.155	24.0275	24.0625	19719884.0
2014-08-01 15:00:00	AAPL	Stock	24.06	24.15	24.015	24.034	27194488.0
2014-08-01 16:00:00	AAPL	Stock	24.0325	24.06	23.8985	24.0375	6164048.0
2014-08-01 17:00:00	AAPL	Stock	24.0375	24.0525	24.0275	24.04	363628.0
2014-08-01 18:00:00	AAPL	Stock	24.0525	24.0525	24.03	24.0425	138380.0
2014-08-01 19:00:00	AAPL	Stock	24.0325	24.05	24.0325	24.0475	47612.0
2014-08-01 04:00:00	MSFT	Stock	43.0	43.0	42.76	42.76	10560.0
2014-08-01 05:00:00	MSFT	Stock	42.76	42.76	42.4	42.49	8900.0
2014-08-01 06:00:00	MSFT	Stock	42.5	42.56	42.45	42.56	15100.0
2014-08-01 07:00:00	MSFT	Stock	42.58	42.87	42.58	42.75	18748.0
2014-08-01 08:00:00	MSFT	Stock	42.86	43.08	42.65	43.04	72115.0
2014-08-01 09:00:00	MSFT	Stock	43.05	43.25	42.85	43.23	4345890.0
2014-08-01 10:00:00	MSFT	Stock	43.23	43.24	42.98	43.015	4480131.0
2014-08-01 11:00:00	MSFT	Stock	43.01	43.24	42.68	42.81	4281201.0
2014-08-01 12:00:00	MSFT	Stock	42.82	42.89	42.6	42.75	2980152.0
2014-08-01 13:00:00	MSFT	Stock	42.745	42.99	42.61	42.88	3889598.0
2014-08-01 14:00:00	MSFT	Stock	42.875	43.0	42.8	42.855	3170049.0
2014-08-01 15:00:00	MSFT	Stock	42.86	42.93	42.79	42.87	4425578.0
2014-08-01 16:00:00	MSFT	Stock	42.86	42.959	42.84	42.86	2002886.0
2014-08-01 17:00:00	MSFT	Stock	42.86	42.86	42.84	42.84	100686.0
2014-08-01 18:00:00	MSFT	Stock	42.95	42.95	42.95	42.95	100.0
2014-08-01 19:00:00	MSFT	Stock	42.94	42.94	42.94	42.94	398.0
2014-08-01 08:00:00	NVDA	Stock	0.4372	0.4372	0.436	0.4372	36000.0
2014-08-01 09:00:00	NVDA	Stock	0.4372	0.444	0.4365	0.4427	22152120.0
2014-08-01 10:00:00	NVDA	Stock	0.4428	0.4448	0.438	0.439	49142760.0
2014-08-01 11:00:00	NVDA	Stock	0.4388	0.4394	0.4362	0.4365	22663920.0
2014-08-01 12:00:00	NVDA	Stock	0.4365	0.4392	0.436	0.4391	24691960.0
2014-08-01 13:00:00	NVDA	Stock	0.4391	0.4426	0.4385	0.442	25094520.0
2014-08-01 14:00:00	NVDA	Stock	0.4419	0.4428	0.441	0.4418	16687000.0
2014-08-01 15:00:00	NVDA	Stock	0.442	0.4435	0.441	0.442	46605440.0
2014-08-01 16:00:00	NVDA	Stock	0.442	0.4426	0.4412	0.442	1662800.0
2014-08-01 17:00:00	NVDA	Stock	0.442	0.442	0.442	0.442	257360.0
2014-08-01 04:00:00	AMZN	Stock	15.6	15.6	15.6	15.6	2000.0
2014-08-01 05:00:00	AMZN	Stock	15.5155	15.5155	15.5065	15.5155	44000.0
2014-08-01 06:00:00	AMZN	Stock	15.5425	15.5425	15.525	15.525	6880.0
2014-08-01 07:00:00	AMZN	Stock	15.535	15.5585	15.511	15.5585	89620.0
2014-08-01 08:00:00	AMZN	Stock	15.5895	15.685	15.55	15.6555	794280.0
2014-08-01 09:00:00	AMZN	Stock	15.655	15.7915	15.6155	15.7418	12058480.0
2014-08-01 10:00:00	AMZN	Stock	15.7455	15.772	15.5165	15.517	13009780.0
2014-08-01 11:00:00	AMZN	Stock	15.5175	15.5585	15.35	15.3604	24529060.0

> showing 50 of 50,665 rows — these rows as CSV

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