PREVIEW / stock_1hour / 2015-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-15.parquet
  size:    1.0 MB
  rows:    48,558
  symbols: 3,439

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-10-15 04:00:00	AAPL	Stock	27.7125	27.7475	27.7125	27.725	11672.0
2015-10-15 05:00:00	AAPL	Stock	27.725	27.7375	27.675	27.715	12608.0
2015-10-15 06:00:00	AAPL	Stock	27.71	27.7125	27.675	27.7125	20500.0
2015-10-15 07:00:00	AAPL	Stock	27.685	27.715	27.6425	27.685	42260.0
2015-10-15 08:00:00	AAPL	Stock	27.6875	27.8	27.65	27.7025	630700.0
2015-10-15 09:00:00	AAPL	Stock	27.6925	28.025	27.6225	28.0025	29868560.0
2015-10-15 10:00:00	AAPL	Stock	28.0025	28.0048	27.7778	27.865	22033088.0
2015-10-15 11:00:00	AAPL	Stock	27.8625	27.875	27.6275	27.6625	16546712.0
2015-10-15 12:00:00	AAPL	Stock	27.6625	27.82	27.6325	27.8125	13920148.0
2015-10-15 13:00:00	AAPL	Stock	27.81	27.935	27.8025	27.89	14266256.0
2015-10-15 14:00:00	AAPL	Stock	27.89	28.005	27.8888	27.9225	15458200.0
2015-10-15 15:00:00	AAPL	Stock	27.9215	27.975	27.895	27.9625	21292380.0
2015-10-15 16:00:00	AAPL	Stock	27.965	27.965	27.94	27.95	6300760.0
2015-10-15 17:00:00	AAPL	Stock	27.95	27.96	27.94	27.9525	58856.0
2015-10-15 18:00:00	AAPL	Stock	27.955	27.9875	27.9475	27.985	38996.0
2015-10-15 19:00:00	AAPL	Stock	27.9825	27.9875	27.97	27.985	53928.0
2015-10-15 07:00:00	MSFT	Stock	46.9	46.91	46.85	46.9	3100.0
2015-10-15 08:00:00	MSFT	Stock	46.94	46.94	46.8	46.85	5570.0
2015-10-15 09:00:00	MSFT	Stock	46.9	47.04	46.53	46.595	2393380.0
2015-10-15 10:00:00	MSFT	Stock	46.59	46.93	46.53	46.91	2229994.0
2015-10-15 11:00:00	MSFT	Stock	46.9	47.01	46.78	46.79	2823642.0
2015-10-15 12:00:00	MSFT	Stock	46.79	46.79	46.63	46.7	2656175.0
2015-10-15 13:00:00	MSFT	Stock	46.69	46.85	46.65	46.7	2512840.0
2015-10-15 14:00:00	MSFT	Stock	46.69	46.87	46.69	46.745	3318497.0
2015-10-15 15:00:00	MSFT	Stock	46.75	47.03	46.75	47.03	7737750.0
2015-10-15 16:00:00	MSFT	Stock	47.01	47.01	46.96	47.0	2390022.0
2015-10-15 17:00:00	MSFT	Stock	46.91	47.0	46.91	47.0	1300.0
2015-10-15 18:00:00	MSFT	Stock	47.0	47.05	47.0	47.05	1218.0
2015-10-15 19:00:00	MSFT	Stock	47.05	47.08	47.05	47.08	600.0
2015-10-15 05:00:00	NVDA	Stock	0.6862	0.6862	0.6862	0.6862	76000.0
2015-10-15 08:00:00	NVDA	Stock	0.6912	0.6912	0.6862	0.6862	60000.0
2015-10-15 09:00:00	NVDA	Stock	0.6895	0.6972	0.6832	0.697	47709160.0
2015-10-15 10:00:00	NVDA	Stock	0.6972	0.6998	0.6905	0.6932	83593080.0
2015-10-15 11:00:00	NVDA	Stock	0.6932	0.6947	0.6815	0.6828	65088640.0
2015-10-15 12:00:00	NVDA	Stock	0.6826	0.684	0.6782	0.6798	48766960.0
2015-10-15 13:00:00	NVDA	Stock	0.68	0.683	0.6793	0.6821	35145200.0
2015-10-15 14:00:00	NVDA	Stock	0.6822	0.685	0.682	0.6841	62017240.0
2015-10-15 15:00:00	NVDA	Stock	0.6838	0.6861	0.6828	0.6858	92810480.0
2015-10-15 16:00:00	NVDA	Stock	0.6852	0.6858	0.6848	0.685	1025160.0
2015-10-15 18:00:00	NVDA	Stock	0.6872	0.6872	0.6872	0.6872	8000.0
2015-10-15 05:00:00	AMZN	Stock	27.4125	27.4125	27.4125	27.4125	2000.0
2015-10-15 06:00:00	AMZN	Stock	27.35	27.35	27.35	27.35	10000.0
2015-10-15 07:00:00	AMZN	Stock	27.356	27.398	27.3465	27.398	30020.0
2015-10-15 08:00:00	AMZN	Stock	27.3935	27.432	27.301	27.3695	194080.0
2015-10-15 09:00:00	AMZN	Stock	27.38	27.7235	27.3375	27.631	18537880.0
2015-10-15 10:00:00	AMZN	Stock	27.633	27.7	27.5055	27.608	10316920.0
2015-10-15 11:00:00	AMZN	Stock	27.602	27.6735	27.362	27.489	7613800.0
2015-10-15 12:00:00	AMZN	Stock	27.5	27.7	27.4785	27.6855	5588220.0
2015-10-15 13:00:00	AMZN	Stock	27.6875	27.8687	27.662	27.8635	8729520.0
2015-10-15 14:00:00	AMZN	Stock	27.866	28.0255	27.8425	27.9585	12886440.0

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

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