PREVIEW / stock_1hour / 2015-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-21.parquet
  size:    1.0 MB
  rows:    48,677
  symbols: 3,495

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-04-21 04:00:00	AAPL	Stock	32.0	32.2	32.0	32.0625	36916.0
2015-04-21 05:00:00	AAPL	Stock	32.0875	32.0875	32.0175	32.05	67112.0
2015-04-21 06:00:00	AAPL	Stock	32.07	32.0725	32.0225	32.045	62372.0
2015-04-21 07:00:00	AAPL	Stock	32.025	32.075	32.01	32.015	192376.0
2015-04-21 08:00:00	AAPL	Stock	32.0125	32.0625	31.975	32.03	618104.0
2015-04-21 09:00:00	AAPL	Stock	32.035	32.0525	31.7525	31.7542	26047044.0
2015-04-21 10:00:00	AAPL	Stock	31.755	31.81	31.6675	31.7025	27889080.0
2015-04-21 11:00:00	AAPL	Stock	31.7025	31.7825	31.6868	31.741	12738664.0
2015-04-21 12:00:00	AAPL	Stock	31.74	31.8425	31.7375	31.7818	9139128.0
2015-04-21 13:00:00	AAPL	Stock	31.78	31.875	31.78	31.7835	10267604.0
2015-04-21 14:00:00	AAPL	Stock	31.785	31.815	31.7225	31.75	13042148.0
2015-04-21 15:00:00	AAPL	Stock	31.7525	31.765	31.6875	31.7225	17096004.0
2015-04-21 16:00:00	AAPL	Stock	31.7275	31.7338	31.6775	31.705	3283460.0
2015-04-21 17:00:00	AAPL	Stock	31.7075	31.72	31.6825	31.72	148588.0
2015-04-21 18:00:00	AAPL	Stock	31.72	31.7275	31.7125	31.7225	138556.0
2015-04-21 19:00:00	AAPL	Stock	31.7275	31.73	31.7125	31.725	125348.0
2015-04-21 04:00:00	MSFT	Stock	43.07	43.07	43.07	43.07	100.0
2015-04-21 05:00:00	MSFT	Stock	43.01	43.01	43.0	43.0	334.0
2015-04-21 06:00:00	MSFT	Stock	42.91	42.91	42.88	42.88	661.0
2015-04-21 07:00:00	MSFT	Stock	43.0	43.0	42.97	42.97	700.0
2015-04-21 08:00:00	MSFT	Stock	43.09	43.18	42.91	42.92	10525.0
2015-04-21 09:00:00	MSFT	Stock	42.96	43.15	42.78	42.78	4554926.0
2015-04-21 10:00:00	MSFT	Stock	42.79	42.85	42.68	42.714	4266247.0
2015-04-21 11:00:00	MSFT	Stock	42.71	42.77	42.54	42.62	2781618.0
2015-04-21 12:00:00	MSFT	Stock	42.615	42.8	42.6	42.67	2257774.0
2015-04-21 13:00:00	MSFT	Stock	42.66	42.8	42.594	42.6	2419889.0
2015-04-21 14:00:00	MSFT	Stock	42.6	42.66	42.53	42.62	2274165.0
2015-04-21 15:00:00	MSFT	Stock	42.63	42.74	42.585	42.64	4415368.0
2015-04-21 16:00:00	MSFT	Stock	42.635	42.78	42.635	42.65	1623063.0
2015-04-21 18:00:00	MSFT	Stock	42.651	42.651	42.651	42.651	200.0
2015-04-21 19:00:00	MSFT	Stock	42.65	42.739	42.65	42.739	400.0
2015-04-21 09:00:00	NVDA	Stock	0.5595	0.5595	0.5538	0.554	15370760.0
2015-04-21 10:00:00	NVDA	Stock	0.554	0.5558	0.5516	0.5522	27942680.0
2015-04-21 11:00:00	NVDA	Stock	0.5522	0.5546	0.55	0.5501	16817520.0
2015-04-21 12:00:00	NVDA	Stock	0.5502	0.5526	0.5488	0.5518	16941600.0
2015-04-21 13:00:00	NVDA	Stock	0.5519	0.5522	0.5495	0.5518	11766680.0
2015-04-21 14:00:00	NVDA	Stock	0.5518	0.5538	0.551	0.553	13143680.0
2015-04-21 15:00:00	NVDA	Stock	0.553	0.553	0.551	0.5514	50451200.0
2015-04-21 16:00:00	NVDA	Stock	0.5514	0.5514	0.5514	0.5514	68856760.0
2015-04-21 17:00:00	NVDA	Stock	0.5555	0.5555	0.5555	0.5555	4000.0
2015-04-21 04:00:00	AMZN	Stock	19.501	19.55	19.501	19.55	6000.0
2015-04-21 06:00:00	AMZN	Stock	19.555	19.555	19.525	19.525	14800.0
2015-04-21 07:00:00	AMZN	Stock	19.525	19.55	19.525	19.55	29420.0
2015-04-21 08:00:00	AMZN	Stock	19.568	19.597	19.425	19.535	294460.0
2015-04-21 09:00:00	AMZN	Stock	19.542	19.6445	19.4275	19.455	12655860.0
2015-04-21 10:00:00	AMZN	Stock	19.458	19.5325	19.34	19.3765	18346980.0
2015-04-21 11:00:00	AMZN	Stock	19.372	19.5625	19.3675	19.5085	12885920.0
2015-04-21 12:00:00	AMZN	Stock	19.5045	19.595	19.489	19.5675	7479900.0
2015-04-21 13:00:00	AMZN	Stock	19.567	19.638	19.5635	19.6065	7400760.0
2015-04-21 14:00:00	AMZN	Stock	19.6015	19.73	19.5913	19.63	11850460.0

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

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