PREVIEW / stock_1hour / 2014-10-22

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-22.parquet
  size:    1.0 MB
  rows:    48,383
  symbols: 3,544

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-22 04:00:00	AAPL	Stock	25.62	25.6225	25.5	25.595	36828.0
2014-10-22 05:00:00	AAPL	Stock	25.5875	25.5875	25.5725	25.575	19744.0
2014-10-22 06:00:00	AAPL	Stock	25.565	25.575	25.5425	25.55	43776.0
2014-10-22 07:00:00	AAPL	Stock	25.55	25.615	25.545	25.6	157096.0
2014-10-22 08:00:00	AAPL	Stock	25.6	25.7125	25.5375	25.7125	1259084.0
2014-10-22 09:00:00	AAPL	Stock	25.695	25.86	25.65	25.8475	46367320.0
2014-10-22 10:00:00	AAPL	Stock	25.8475	25.8575	25.7075	25.84	35449352.0
2014-10-22 11:00:00	AAPL	Stock	25.8412	26.0275	25.8075	25.9375	55012916.0
2014-10-22 12:00:00	AAPL	Stock	25.9375	25.9875	25.725	25.839	34515792.0
2014-10-22 13:00:00	AAPL	Stock	25.8385	25.9125	25.7825	25.87	21647864.0
2014-10-22 14:00:00	AAPL	Stock	25.87	25.9	25.7975	25.891	19341668.0
2014-10-22 15:00:00	AAPL	Stock	25.8925	25.9	25.7375	25.75	33886304.0
2014-10-22 16:00:00	AAPL	Stock	25.7475	25.8448	23.414	25.7725	6297468.0
2014-10-22 17:00:00	AAPL	Stock	25.765	25.77	25.75	25.7525	141204.0
2014-10-22 18:00:00	AAPL	Stock	25.75	25.7775	25.7475	25.7775	260616.0
2014-10-22 19:00:00	AAPL	Stock	25.7775	25.7975	25.7675	25.7825	139924.0
2014-10-22 07:00:00	MSFT	Stock	44.91	45.56	44.9	44.91	9950.0
2014-10-22 08:00:00	MSFT	Stock	44.98	45.04	44.93	45.0	3652.0
2014-10-22 09:00:00	MSFT	Stock	45.01	45.08	44.83	44.875	4007626.0
2014-10-22 10:00:00	MSFT	Stock	44.88	44.89	44.63	44.675	4733514.0
2014-10-22 11:00:00	MSFT	Stock	44.67	44.72	44.52	44.52	3844333.0
2014-10-22 12:00:00	MSFT	Stock	44.52	44.53	44.34	44.47	3355717.0
2014-10-22 13:00:00	MSFT	Stock	44.47	44.6	44.46	44.475	2791899.0
2014-10-22 14:00:00	MSFT	Stock	44.47	44.5	44.38	44.44	3267957.0
2014-10-22 15:00:00	MSFT	Stock	44.44	44.445	44.225	44.39	7788720.0
2014-10-22 16:00:00	MSFT	Stock	44.38	44.668	44.37	44.431	2128988.0
2014-10-22 17:00:00	MSFT	Stock	44.5	44.66	44.5	44.6	1170.0
2014-10-22 18:00:00	MSFT	Stock	44.38	44.46	44.38	44.45	8185.0
2014-10-22 19:00:00	MSFT	Stock	44.45	44.45	44.45	44.45	200.0
2014-10-22 08:00:00	NVDA	Stock	0.4575	0.4575	0.4575	0.4575	36000.0
2014-10-22 09:00:00	NVDA	Stock	0.4575	0.4588	0.453	0.4535	31882720.0
2014-10-22 10:00:00	NVDA	Stock	0.4535	0.457	0.4498	0.4562	33138560.0
2014-10-22 11:00:00	NVDA	Stock	0.4562	0.4572	0.4538	0.454	21419960.0
2014-10-22 12:00:00	NVDA	Stock	0.454	0.455	0.4508	0.4522	20562480.0
2014-10-22 13:00:00	NVDA	Stock	0.4522	0.453	0.4505	0.451	29085640.0
2014-10-22 14:00:00	NVDA	Stock	0.4508	0.451	0.4475	0.451	35372680.0
2014-10-22 15:00:00	NVDA	Stock	0.4508	0.4508	0.4472	0.4474	53678400.0
2014-10-22 16:00:00	NVDA	Stock	0.4472	0.4503	0.4472	0.4472	7212320.0
2014-10-22 18:00:00	NVDA	Stock	0.4468	0.4468	0.4468	0.4468	4000.0
2014-10-22 07:00:00	AMZN	Stock	15.789	15.789	15.789	15.789	8040.0
2014-10-22 08:00:00	AMZN	Stock	15.7665	15.8075	15.7655	15.775	168800.0
2014-10-22 09:00:00	AMZN	Stock	15.7845	15.9465	15.7055	15.9435	8385200.0
2014-10-22 10:00:00	AMZN	Stock	15.941	15.949	15.733	15.8185	8679760.0
2014-10-22 11:00:00	AMZN	Stock	15.8145	15.9165	15.8145	15.8575	5544320.0
2014-10-22 12:00:00	AMZN	Stock	15.8515	15.862	15.6745	15.7675	6566640.0
2014-10-22 13:00:00	AMZN	Stock	15.76	15.804	15.7152	15.7182	5491060.0
2014-10-22 14:00:00	AMZN	Stock	15.714	15.773	15.6575	15.773	6074680.0
2014-10-22 15:00:00	AMZN	Stock	15.7668	15.7935	15.632	15.6485	11469680.0
2014-10-22 16:00:00	AMZN	Stock	15.6485	15.8445	15.6454	15.6485	2564320.0
2014-10-22 17:00:00	AMZN	Stock	15.6485	15.6485	15.615	15.615	45800.0

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

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