PREVIEW / stock_1hour / 2016-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-23.parquet
  size:    1.0 MB
  rows:    48,850
  symbols: 3,340

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
2016-03-23 04:00:00	AAPL	Stock	26.675	26.7425	26.675	26.7425	13200.0
2016-03-23 05:00:00	AAPL	Stock	26.7325	26.735	26.7	26.715	11044.0
2016-03-23 06:00:00	AAPL	Stock	26.695	26.695	26.695	26.695	400.0
2016-03-23 07:00:00	AAPL	Stock	26.6875	26.74	26.68	26.7375	18952.0
2016-03-23 08:00:00	AAPL	Stock	26.7125	26.74	26.625	26.695	163464.0
2016-03-23 09:00:00	AAPL	Stock	26.685	26.705	26.555	26.57	13870232.0
2016-03-23 10:00:00	AAPL	Stock	26.57	26.6425	26.5425	26.6052	15805960.0
2016-03-23 11:00:00	AAPL	Stock	26.6062	26.7275	26.575	26.7	14821020.0
2016-03-23 12:00:00	AAPL	Stock	26.7025	26.7675	26.6775	26.7	9527360.0
2016-03-23 13:00:00	AAPL	Stock	26.6975	26.7525	26.685	26.7175	7138604.0
2016-03-23 14:00:00	AAPL	Stock	26.7198	26.725	26.5275	26.5612	12181564.0
2016-03-23 15:00:00	AAPL	Stock	26.5605	26.5825	26.475	26.535	15446844.0
2016-03-23 16:00:00	AAPL	Stock	26.5325	26.5575	26.53	26.5375	5737044.0
2016-03-23 17:00:00	AAPL	Stock	26.5375	26.545	26.53	26.53	23964.0
2016-03-23 18:00:00	AAPL	Stock	26.5175	26.535	26.5125	26.515	14196.0
2016-03-23 19:00:00	AAPL	Stock	26.515	26.535	26.515	26.53	39036.0
2016-03-23 07:00:00	MSFT	Stock	54.15	54.36	54.15	54.27	6154.0
2016-03-23 08:00:00	MSFT	Stock	54.13	54.27	54.13	54.2	6981.0
2016-03-23 09:00:00	MSFT	Stock	54.14	54.22	53.83	54.08	2495436.0
2016-03-23 10:00:00	MSFT	Stock	54.08	54.24	53.83	53.89	3142226.0
2016-03-23 11:00:00	MSFT	Stock	53.89	54.05	53.74	53.805	2331579.0
2016-03-23 12:00:00	MSFT	Stock	53.808	54.085	53.78	54.0	1372797.0
2016-03-23 13:00:00	MSFT	Stock	54.0	54.09	53.89	53.95	1114722.0
2016-03-23 14:00:00	MSFT	Stock	53.955	54.035	53.74	53.8	1701717.0
2016-03-23 15:00:00	MSFT	Stock	53.81	54.03	53.75	53.98	4322288.0
2016-03-23 16:00:00	MSFT	Stock	53.97	54.02	53.92	53.92	1990495.0
2016-03-23 17:00:00	MSFT	Stock	53.93	53.93	53.93	53.93	500.0
2016-03-23 18:00:00	MSFT	Stock	53.9	54.0	53.9	53.92	1400.0
2016-03-23 19:00:00	MSFT	Stock	53.9	53.9	53.9	53.9	3100.0
2016-03-23 08:00:00	NVDA	Stock	0.8525	0.8528	0.8525	0.8528	16000.0
2016-03-23 09:00:00	NVDA	Stock	0.849	0.862	0.845	0.8566	44472600.0
2016-03-23 10:00:00	NVDA	Stock	0.8565	0.8642	0.85	0.858	78021720.0
2016-03-23 11:00:00	NVDA	Stock	0.858	0.8618	0.8564	0.8605	62601040.0
2016-03-23 12:00:00	NVDA	Stock	0.8605	0.8642	0.8572	0.8588	32366160.0
2016-03-23 13:00:00	NVDA	Stock	0.8588	0.8638	0.858	0.8629	40050120.0
2016-03-23 14:00:00	NVDA	Stock	0.8628	0.867	0.8625	0.8639	60868880.0
2016-03-23 15:00:00	NVDA	Stock	0.8638	0.8658	0.86	0.8608	91016800.0
2016-03-23 16:00:00	NVDA	Stock	0.8608	0.8615	0.8595	0.86	10777640.0
2016-03-23 17:00:00	NVDA	Stock	0.8615	0.8615	0.8615	0.8615	20000.0
2016-03-23 08:00:00	AMZN	Stock	28.031	28.0995	28.025	28.025	79780.0
2016-03-23 09:00:00	AMZN	Stock	28.006	28.2135	27.905	28.1725	9275960.0
2016-03-23 10:00:00	AMZN	Stock	28.1695	28.5195	28.1467	28.385	17875760.0
2016-03-23 11:00:00	AMZN	Stock	28.385	28.425	28.1685	28.2588	7335420.0
2016-03-23 12:00:00	AMZN	Stock	28.2773	28.3755	28.25	28.327	4350180.0
2016-03-23 13:00:00	AMZN	Stock	28.321	28.5618	28.319	28.51	10204200.0
2016-03-23 14:00:00	AMZN	Stock	28.5155	28.624	28.426	28.445	8364580.0
2016-03-23 15:00:00	AMZN	Stock	28.448	28.521	28.39	28.481	10986680.0
2016-03-23 16:00:00	AMZN	Stock	28.4815	28.5	28.451	28.4515	2454000.0
2016-03-23 17:00:00	AMZN	Stock	28.4625	28.4625	28.425	28.425	10000.0
2016-03-23 18:00:00	AMZN	Stock	28.402	28.449	28.402	28.449	41780.0

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

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