PREVIEW / stock_1hour / 2014-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-21.parquet
  size:    1.1 MB
  rows:    49,779
  symbols: 3,572

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-11-21 04:00:00	AAPL	Stock	29.1525	29.3	29.1525	29.295	62152.0
2014-11-21 05:00:00	AAPL	Stock	29.2925	29.3625	29.2625	29.3625	36948.0
2014-11-21 06:00:00	AAPL	Stock	29.32	29.3725	29.25	29.3025	89004.0
2014-11-21 07:00:00	AAPL	Stock	29.295	29.34	29.27	29.3025	374880.0
2014-11-21 08:00:00	AAPL	Stock	29.3025	29.35	29.2625	29.2875	933448.0
2014-11-21 09:00:00	AAPL	Stock	29.2875	29.42	29.13	29.2	48244620.0
2014-11-21 10:00:00	AAPL	Stock	29.2	29.2325	29.05	29.095	32116744.0
2014-11-21 11:00:00	AAPL	Stock	29.0912	29.1425	29.0175	29.0692	18224636.0
2014-11-21 12:00:00	AAPL	Stock	29.0675	29.1525	29.04	29.1188	11964012.0
2014-11-21 13:00:00	AAPL	Stock	29.1175	29.1375	29.03	29.0938	13184000.0
2014-11-21 14:00:00	AAPL	Stock	29.0925	29.125	29.02	29.1112	15395756.0
2014-11-21 15:00:00	AAPL	Stock	29.11	29.1625	29.0075	29.115	30418024.0
2014-11-21 16:00:00	AAPL	Stock	29.1175	29.3865	29.0775	29.1175	23677396.0
2014-11-21 17:00:00	AAPL	Stock	29.0975	29.1175	29.075	29.08	94568.0
2014-11-21 18:00:00	AAPL	Stock	29.0925	29.1175	29.0725	29.0725	1547300.0
2014-11-21 19:00:00	AAPL	Stock	29.075	29.085	29.0675	29.0675	46852.0
2014-11-21 04:00:00	MSFT	Stock	48.75	48.8	48.65	48.8	4696.0
2014-11-21 05:00:00	MSFT	Stock	48.68	48.9	48.68	48.71	5454.0
2014-11-21 06:00:00	MSFT	Stock	48.88	48.88	48.72	48.75	2600.0
2014-11-21 07:00:00	MSFT	Stock	48.77	48.78	48.73	48.73	4846.0
2014-11-21 08:00:00	MSFT	Stock	48.73	48.86	48.71	48.86	68339.0
2014-11-21 09:00:00	MSFT	Stock	48.85	49.09	48.72	48.83	8734249.0
2014-11-21 10:00:00	MSFT	Stock	48.82	48.87	48.36	48.44	4446777.0
2014-11-21 11:00:00	MSFT	Stock	48.435	48.5	48.2	48.25	2837463.0
2014-11-21 12:00:00	MSFT	Stock	48.245	48.31	47.8	47.81	4852808.0
2014-11-21 13:00:00	MSFT	Stock	47.81	47.89	47.63	47.74	4622276.0
2014-11-21 14:00:00	MSFT	Stock	47.735	47.8	47.57	47.76	3495557.0
2014-11-21 15:00:00	MSFT	Stock	47.755	47.97	47.752	47.96	6076258.0
2014-11-21 16:00:00	MSFT	Stock	47.98	48.261	47.773	47.98	5060892.0
2014-11-21 17:00:00	MSFT	Stock	48.0	48.0	47.9	47.9	21020.0
2014-11-21 18:00:00	MSFT	Stock	47.9	47.98	47.84	47.85	7891.0
2014-11-21 19:00:00	MSFT	Stock	47.85	47.85	47.83	47.83	1511.0
2014-11-21 08:00:00	NVDA	Stock	0.51	0.5125	0.5098	0.5125	112000.0
2014-11-21 09:00:00	NVDA	Stock	0.5135	0.5138	0.51	0.5122	33181920.0
2014-11-21 10:00:00	NVDA	Stock	0.5124	0.513	0.5108	0.5112	30570160.0
2014-11-21 11:00:00	NVDA	Stock	0.5112	0.5112	0.5091	0.5098	17698080.0
2014-11-21 12:00:00	NVDA	Stock	0.5098	0.5102	0.5088	0.5091	14295280.0
2014-11-21 13:00:00	NVDA	Stock	0.509	0.51	0.507	0.509	13595000.0
2014-11-21 14:00:00	NVDA	Stock	0.509	0.5108	0.5082	0.5108	15026000.0
2014-11-21 15:00:00	NVDA	Stock	0.5106	0.512	0.5105	0.5115	50447760.0
2014-11-21 16:00:00	NVDA	Stock	0.5114	0.5122	0.5104	0.5114	19269800.0
2014-11-21 05:00:00	AMZN	Stock	16.585	16.725	16.585	16.725	14000.0
2014-11-21 06:00:00	AMZN	Stock	16.652	16.699	16.65	16.65	18000.0
2014-11-21 07:00:00	AMZN	Stock	16.675	16.74	16.675	16.705	91100.0
2014-11-21 08:00:00	AMZN	Stock	16.7	16.74	16.6775	16.738	333780.0
2014-11-21 09:00:00	AMZN	Stock	16.7445	16.9165	16.7075	16.86	23140160.0
2014-11-21 10:00:00	AMZN	Stock	16.8625	16.8775	16.678	16.6943	13989720.0
2014-11-21 11:00:00	AMZN	Stock	16.6885	16.7305	16.614	16.7305	9429400.0
2014-11-21 12:00:00	AMZN	Stock	16.7325	16.772	16.701	16.717	5432520.0
2014-11-21 13:00:00	AMZN	Stock	16.717	16.7202	16.578	16.6555	7672320.0

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

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