PREVIEW / stock_1hour / 2013-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-25.parquet
  size:    1023 KB
  rows:    47,649
  symbols: 3,536

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
2013-09-25 04:00:00	AAPL	Stock	17.4643	17.4643	17.2361	17.3589	104972.0
2013-09-25 05:00:00	AAPL	Stock	17.3571	17.44	17.3571	17.4396	125748.0
2013-09-25 06:00:00	AAPL	Stock	17.4375	17.4589	17.4196	17.4589	134540.0
2013-09-25 07:00:00	AAPL	Stock	17.4614	17.4814	17.4146	17.4361	378840.0
2013-09-25 08:00:00	AAPL	Stock	17.4482	17.545	17.4125	17.5286	2363368.0
2013-09-25 09:00:00	AAPL	Stock	17.5271	17.5625	17.2014	17.2246	86666412.0
2013-09-25 10:00:00	AAPL	Stock	17.2232	17.3125	17.195	17.2171	64790684.0
2013-09-25 11:00:00	AAPL	Stock	17.2161	17.2768	17.1939	17.2561	29753500.0
2013-09-25 12:00:00	AAPL	Stock	17.2575	17.3179	17.2339	17.2907	20854932.0
2013-09-25 13:00:00	AAPL	Stock	17.2921	17.3125	17.2354	17.2657	19463696.0
2013-09-25 14:00:00	AAPL	Stock	17.2646	17.2914	17.2346	17.2407	16705752.0
2013-09-25 15:00:00	AAPL	Stock	17.2379	17.2746	17.1964	17.1979	46217752.0
2013-09-25 16:00:00	AAPL	Stock	17.1975	17.4679	17.1941	17.2196	11671716.0
2013-09-25 17:00:00	AAPL	Stock	17.2179	17.2225	17.1975	17.215	660520.0
2013-09-25 18:00:00	AAPL	Stock	17.2179	17.2282	17.1975	17.2271	407904.0
2013-09-25 19:00:00	AAPL	Stock	17.2271	17.2304	17.2218	17.2304	107996.0
2013-09-25 04:00:00	MSFT	Stock	32.15	32.15	32.15	32.15	1000.0
2013-09-25 07:00:00	MSFT	Stock	32.51	32.54	32.45	32.46	1200.0
2013-09-25 08:00:00	MSFT	Stock	32.31	32.5	32.31	32.5	9750.0
2013-09-25 09:00:00	MSFT	Stock	32.5	32.68	32.455	32.66	4127543.0
2013-09-25 10:00:00	MSFT	Stock	32.67	32.67	32.42	32.604	3808160.0
2013-09-25 11:00:00	MSFT	Stock	32.605	32.8	32.5	32.69	4145934.0
2013-09-25 12:00:00	MSFT	Stock	32.695	32.73	32.525	32.561	2858836.0
2013-09-25 13:00:00	MSFT	Stock	32.57	32.6	32.4	32.49	2720063.0
2013-09-25 14:00:00	MSFT	Stock	32.488	32.6	32.43	32.536	2031440.0
2013-09-25 15:00:00	MSFT	Stock	32.53	32.63	32.48	32.5	4538261.0
2013-09-25 16:00:00	MSFT	Stock	32.49	32.636	32.455	32.52	4302107.0
2013-09-25 17:00:00	MSFT	Stock	32.768	32.768	32.44	32.48	9665.0
2013-09-25 18:00:00	MSFT	Stock	32.48	32.52	32.48	32.52	76496.0
2013-09-25 09:00:00	NVDA	Stock	0.392	0.3925	0.39	0.3908	22017440.0
2013-09-25 10:00:00	NVDA	Stock	0.3908	0.394	0.3905	0.3934	30688800.0
2013-09-25 11:00:00	NVDA	Stock	0.3935	0.395	0.392	0.3949	45083080.0
2013-09-25 12:00:00	NVDA	Stock	0.3949	0.3958	0.394	0.3953	31051360.0
2013-09-25 13:00:00	NVDA	Stock	0.3955	0.396	0.3938	0.3948	23755720.0
2013-09-25 14:00:00	NVDA	Stock	0.3948	0.3954	0.3942	0.3948	21638920.0
2013-09-25 15:00:00	NVDA	Stock	0.3949	0.3951	0.393	0.393	33621440.0
2013-09-25 16:00:00	NVDA	Stock	0.393	0.3954	0.3925	0.393	24965160.0
2013-09-25 17:00:00	NVDA	Stock	0.392	0.392	0.3915	0.3915	44000.0
2013-09-25 18:00:00	NVDA	Stock	0.393	0.393	0.393	0.393	217240.0
2013-09-25 04:00:00	AMZN	Stock	15.7775	15.7775	15.7775	15.7775	6000.0
2013-09-25 05:00:00	AMZN	Stock	15.75	15.75	15.75	15.75	2000.0
2013-09-25 06:00:00	AMZN	Stock	15.73	15.73	15.73	15.73	2000.0
2013-09-25 08:00:00	AMZN	Stock	15.75	15.7875	15.7065	15.775	56000.0
2013-09-25 09:00:00	AMZN	Stock	15.77	15.8105	15.5725	15.6535	4925000.0
2013-09-25 10:00:00	AMZN	Stock	15.6662	15.8	15.616	15.7645	7010980.0
2013-09-25 11:00:00	AMZN	Stock	15.772	15.8355	15.721	15.814	3798840.0
2013-09-25 12:00:00	AMZN	Stock	15.806	15.8235	15.727	15.7365	3033020.0
2013-09-25 13:00:00	AMZN	Stock	15.7378	15.7545	15.5375	15.6495	9458880.0
2013-09-25 14:00:00	AMZN	Stock	15.6463	15.713	15.6102	15.6485	2854520.0
2013-09-25 15:00:00	AMZN	Stock	15.645	15.6885	15.6155	15.6325	4081820.0

> showing 50 of 47,649 rows — these rows as CSV

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