PREVIEW / stock_1hour / 2014-12-03

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-03.parquet
  size:    1.0 MB
  rows:    48,491
  symbols: 3,565

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-12-03 04:00:00	AAPL	Stock	28.6475	28.7625	28.6175	28.69	47288.0
2014-12-03 05:00:00	AAPL	Stock	28.6775	28.6775	28.6025	28.6025	9280.0
2014-12-03 06:00:00	AAPL	Stock	28.5825	28.595	28.51	28.57	57748.0
2014-12-03 07:00:00	AAPL	Stock	28.57	28.6125	28.5375	28.5925	174088.0
2014-12-03 08:00:00	AAPL	Stock	28.6	28.6575	28.5375	28.625	519724.0
2014-12-03 09:00:00	AAPL	Stock	28.63	29.0875	28.63	28.955	35111192.0
2014-12-03 10:00:00	AAPL	Stock	28.955	28.98	28.7775	28.8125	31278560.0
2014-12-03 11:00:00	AAPL	Stock	28.81	28.975	28.81	28.915	18831092.0
2014-12-03 12:00:00	AAPL	Stock	28.9165	28.9325	28.82	28.9125	10469772.0
2014-12-03 13:00:00	AAPL	Stock	28.9125	28.96	28.86	28.955	9734376.0
2014-12-03 14:00:00	AAPL	Stock	28.955	28.9725	28.9175	28.9525	10072936.0
2014-12-03 15:00:00	AAPL	Stock	28.9525	29.0525	28.94	28.9825	23902992.0
2014-12-03 16:00:00	AAPL	Stock	28.9825	28.995	28.6048	28.9675	19958352.0
2014-12-03 17:00:00	AAPL	Stock	28.9675	28.995	28.9322	28.9922	349924.0
2014-12-03 18:00:00	AAPL	Stock	28.9875	28.9925	28.975	28.9875	87768.0
2014-12-03 19:00:00	AAPL	Stock	28.99	29.025	28.99	29.005	154728.0
2014-12-03 05:00:00	MSFT	Stock	48.52	48.52	48.48	48.48	1200.0
2014-12-03 07:00:00	MSFT	Stock	48.5	48.52	48.5	48.52	1000.0
2014-12-03 08:00:00	MSFT	Stock	48.51	48.52	48.35	48.42	3875.0
2014-12-03 09:00:00	MSFT	Stock	48.45	48.5	48.06	48.17	2686652.0
2014-12-03 10:00:00	MSFT	Stock	48.17	48.24	47.805	48.166	3384295.0
2014-12-03 11:00:00	MSFT	Stock	48.16	48.32	48.08	48.147	1929619.0
2014-12-03 12:00:00	MSFT	Stock	48.145	48.2	48.065	48.1	1124005.0
2014-12-03 13:00:00	MSFT	Stock	48.1	48.33	48.1	48.275	1182918.0
2014-12-03 14:00:00	MSFT	Stock	48.275	48.29	48.2	48.235	1098732.0
2014-12-03 15:00:00	MSFT	Stock	48.232	48.37	48.05	48.08	6152346.0
2014-12-03 16:00:00	MSFT	Stock	48.08	48.371	48.01	48.22	3959208.0
2014-12-03 17:00:00	MSFT	Stock	48.07	48.194	48.02	48.08	515630.0
2014-12-03 18:00:00	MSFT	Stock	48.079	48.08	48.079	48.08	422.0
2014-12-03 19:00:00	MSFT	Stock	48.04	48.17	48.04	48.17	1420.0
2014-12-03 08:00:00	NVDA	Stock	0.516	0.5162	0.516	0.5162	24000.0
2014-12-03 09:00:00	NVDA	Stock	0.516	0.5236	0.516	0.5209	21775200.0
2014-12-03 10:00:00	NVDA	Stock	0.521	0.5232	0.519	0.521	24019400.0
2014-12-03 11:00:00	NVDA	Stock	0.521	0.5245	0.521	0.5245	22362800.0
2014-12-03 12:00:00	NVDA	Stock	0.5245	0.5268	0.5245	0.5261	28822960.0
2014-12-03 13:00:00	NVDA	Stock	0.5262	0.5272	0.5253	0.5262	18365440.0
2014-12-03 14:00:00	NVDA	Stock	0.5261	0.5275	0.526	0.5264	24385600.0
2014-12-03 15:00:00	NVDA	Stock	0.5262	0.5287	0.5262	0.5282	113341840.0
2014-12-03 16:00:00	NVDA	Stock	0.5285	0.5298	0.5268	0.5298	26995520.0
2014-12-03 07:00:00	AMZN	Stock	16.3465	16.3465	16.329	16.329	12000.0
2014-12-03 08:00:00	AMZN	Stock	16.3175	16.35	16.3175	16.34	146500.0
2014-12-03 09:00:00	AMZN	Stock	16.306	16.3385	16.042	16.0745	10994360.0
2014-12-03 10:00:00	AMZN	Stock	16.072	16.0795	15.735	15.8475	39866440.0
2014-12-03 11:00:00	AMZN	Stock	15.8526	15.8874	15.718	15.8375	17282980.0
2014-12-03 12:00:00	AMZN	Stock	15.8386	15.88	15.8036	15.821	6532500.0
2014-12-03 13:00:00	AMZN	Stock	15.823	15.8885	15.816	15.852	5965740.0
2014-12-03 14:00:00	AMZN	Stock	15.8558	15.904	15.812	15.8425	7494860.0
2014-12-03 15:00:00	AMZN	Stock	15.8465	15.8465	15.7775	15.828	15170180.0
2014-12-03 16:00:00	AMZN	Stock	15.825	16.3155	15.8035	15.81	547000.0
2014-12-03 17:00:00	AMZN	Stock	15.8365	15.8425	15.8101	15.825	134040.0

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

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