PREVIEW / stock_1hour / 2015-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-11.parquet
  size:    1.0 MB
  rows:    48,789
  symbols: 3,512

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-05-11 04:00:00	AAPL	Stock	31.885	31.9575	31.885	31.89	10900.0
2015-05-11 05:00:00	AAPL	Stock	31.895	31.915	31.8725	31.8875	2684.0
2015-05-11 06:00:00	AAPL	Stock	31.8875	31.8875	31.85	31.8875	31320.0
2015-05-11 07:00:00	AAPL	Stock	31.875	31.875	31.8175	31.85	66896.0
2015-05-11 08:00:00	AAPL	Stock	31.85	31.9	31.815	31.8325	476676.0
2015-05-11 09:00:00	AAPL	Stock	31.835	31.89	31.47	31.552	31407400.0
2015-05-11 10:00:00	AAPL	Stock	31.55	31.6325	31.4062	31.5338	29220196.0
2015-05-11 11:00:00	AAPL	Stock	31.535	31.6825	31.455	31.68	18145424.0
2015-05-11 12:00:00	AAPL	Stock	31.68	31.6925	31.5625	31.6225	12125496.0
2015-05-11 13:00:00	AAPL	Stock	31.62	31.74	31.6112	31.6625	11484828.0
2015-05-11 14:00:00	AAPL	Stock	31.66	31.72	31.6	31.6275	11644552.0
2015-05-11 15:00:00	AAPL	Stock	31.6275	31.6675	31.545	31.58	18214464.0
2015-05-11 16:00:00	AAPL	Stock	31.58	31.6478	31.55	31.5575	14672240.0
2015-05-11 17:00:00	AAPL	Stock	31.555	31.6125	31.555	31.595	172928.0
2015-05-11 18:00:00	AAPL	Stock	31.5875	31.6075	31.585	31.5975	60364.0
2015-05-11 19:00:00	AAPL	Stock	31.6075	31.6075	31.5475	31.5848	133540.0
2015-05-11 07:00:00	MSFT	Stock	47.7	47.7	47.7	47.7	3000.0
2015-05-11 08:00:00	MSFT	Stock	47.75	47.75	47.61	47.61	3200.0
2015-05-11 09:00:00	MSFT	Stock	47.61	47.91	47.5	47.67	3382322.0
2015-05-11 10:00:00	MSFT	Stock	47.66	47.85	47.6	47.625	2920726.0
2015-05-11 11:00:00	MSFT	Stock	47.62	47.75	47.52	47.73	2038804.0
2015-05-11 12:00:00	MSFT	Stock	47.73	47.735	47.525	47.633	2188020.0
2015-05-11 13:00:00	MSFT	Stock	47.63	47.71	47.58	47.587	1470524.0
2015-05-11 14:00:00	MSFT	Stock	47.58	47.64	47.48	47.525	1914845.0
2015-05-11 15:00:00	MSFT	Stock	47.515	47.52	47.37	47.37	3475087.0
2015-05-11 16:00:00	MSFT	Stock	47.37	47.38	47.36	47.36	3569749.0
2015-05-11 17:00:00	MSFT	Stock	47.35	47.42	47.3	47.3	1927.0
2015-05-11 18:00:00	MSFT	Stock	47.379	47.379	47.37	47.37	400.0
2015-05-11 08:00:00	NVDA	Stock	0.52	0.52	0.52	0.52	247200.0
2015-05-11 09:00:00	NVDA	Stock	0.518	0.518	0.5095	0.5131	72724960.0
2015-05-11 10:00:00	NVDA	Stock	0.513	0.517	0.5122	0.515	75403440.0
2015-05-11 11:00:00	NVDA	Stock	0.515	0.5171	0.5135	0.5161	76579840.0
2015-05-11 12:00:00	NVDA	Stock	0.5162	0.5207	0.5148	0.5198	53123720.0
2015-05-11 13:00:00	NVDA	Stock	0.5198	0.521	0.5178	0.5179	49163400.0
2015-05-11 14:00:00	NVDA	Stock	0.518	0.5185	0.5152	0.5178	46543160.0
2015-05-11 15:00:00	NVDA	Stock	0.5178	0.518	0.5149	0.5158	136742160.0
2015-05-11 16:00:00	NVDA	Stock	0.5158	0.5158	0.5122	0.5158	11968400.0
2015-05-11 17:00:00	NVDA	Stock	0.5138	0.5138	0.5138	0.5138	20000.0
2015-05-11 19:00:00	NVDA	Stock	0.514	0.514	0.514	0.514	8000.0
2015-05-11 04:00:00	AMZN	Stock	21.67	21.67	21.67	21.67	5000.0
2015-05-11 07:00:00	AMZN	Stock	21.66	21.66	21.66	21.66	6500.0
2015-05-11 08:00:00	AMZN	Stock	21.6505	21.6505	21.6325	21.6325	13260.0
2015-05-11 09:00:00	AMZN	Stock	21.699	21.95	21.5685	21.8635	10604820.0
2015-05-11 10:00:00	AMZN	Stock	21.8538	21.8555	21.6265	21.6545	10212700.0
2015-05-11 11:00:00	AMZN	Stock	21.6585	21.763	21.649	21.7265	4478820.0
2015-05-11 12:00:00	AMZN	Stock	21.7265	21.745	21.6525	21.7205	2741680.0
2015-05-11 13:00:00	AMZN	Stock	21.7355	21.75	21.6925	21.7025	2922560.0
2015-05-11 14:00:00	AMZN	Stock	21.7035	21.7645	21.675	21.6845	4498160.0
2015-05-11 15:00:00	AMZN	Stock	21.68	21.7545	21.6365	21.6405	7137880.0
2015-05-11 16:00:00	AMZN	Stock	21.6425	21.6465	21.625	21.645	163560.0

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

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