PREVIEW / stock_1hour / 2014-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-25.parquet
  size:    1.0 MB
  rows:    48,859
  symbols: 3,570

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-07-25 04:00:00	AAPL	Stock	24.225	24.225	24.225	24.225	800.0
2014-07-25 05:00:00	AAPL	Stock	24.2175	24.225	24.195	24.2125	18000.0
2014-07-25 06:00:00	AAPL	Stock	24.2125	24.2275	24.195	24.195	13936.0
2014-07-25 07:00:00	AAPL	Stock	24.205	24.205	24.1875	24.2	57068.0
2014-07-25 08:00:00	AAPL	Stock	24.195	24.2575	24.18	24.2175	283492.0
2014-07-25 09:00:00	AAPL	Stock	24.2075	24.36	24.16	24.32	23968096.0
2014-07-25 10:00:00	AAPL	Stock	24.3225	24.46	24.2825	24.3062	34690036.0
2014-07-25 11:00:00	AAPL	Stock	24.305	24.325	24.2125	24.2998	26169892.0
2014-07-25 12:00:00	AAPL	Stock	24.3	24.38	24.3	24.3728	12838484.0
2014-07-25 13:00:00	AAPL	Stock	24.3738	24.38	24.31	24.325	11464640.0
2014-07-25 14:00:00	AAPL	Stock	24.325	24.3725	24.3025	24.3348	12167616.0
2014-07-25 15:00:00	AAPL	Stock	24.335	24.4225	24.32	24.42	26423356.0
2014-07-25 16:00:00	AAPL	Stock	24.4225	24.43	24.3365	24.4	11370992.0
2014-07-25 17:00:00	AAPL	Stock	24.4	24.4178	24.395	24.4075	2011812.0
2014-07-25 18:00:00	AAPL	Stock	24.4025	24.4225	24.3975	24.41	208440.0
2014-07-25 19:00:00	AAPL	Stock	24.4075	24.4125	24.3975	24.405	71920.0
2014-07-25 05:00:00	MSFT	Stock	44.21	44.21	44.21	44.21	200.0
2014-07-25 06:00:00	MSFT	Stock	44.21	44.21	44.21	44.21	600.0
2014-07-25 07:00:00	MSFT	Stock	44.17	44.29	44.17	44.24	2500.0
2014-07-25 08:00:00	MSFT	Stock	44.3	44.43	44.28	44.35	6740.0
2014-07-25 09:00:00	MSFT	Stock	44.39	44.66	44.29	44.525	4161970.0
2014-07-25 10:00:00	MSFT	Stock	44.525	44.595	44.33	44.35	5123271.0
2014-07-25 11:00:00	MSFT	Stock	44.36	44.51	44.33	44.477	2758365.0
2014-07-25 12:00:00	MSFT	Stock	44.47	44.53	44.405	44.506	2423276.0
2014-07-25 13:00:00	MSFT	Stock	44.505	44.53	44.41	44.5	2173053.0
2014-07-25 14:00:00	MSFT	Stock	44.49	44.55	44.46	44.501	2609053.0
2014-07-25 15:00:00	MSFT	Stock	44.503	44.51	44.46	44.495	4391500.0
2014-07-25 16:00:00	MSFT	Stock	44.5	44.509	44.44	44.5	2295367.0
2014-07-25 17:00:00	MSFT	Stock	44.49	44.5	44.49	44.5	1523.0
2014-07-25 18:00:00	MSFT	Stock	44.5	44.5	44.5	44.5	35736.0
2014-07-25 19:00:00	MSFT	Stock	44.51	44.51	44.51	44.51	200.0
2014-07-25 09:00:00	NVDA	Stock	0.4528	0.4528	0.446	0.4479	31338320.0
2014-07-25 10:00:00	NVDA	Stock	0.4478	0.45	0.4475	0.4476	29876840.0
2014-07-25 11:00:00	NVDA	Stock	0.4475	0.4482	0.4458	0.448	36286720.0
2014-07-25 12:00:00	NVDA	Stock	0.448	0.449	0.4478	0.4482	12853960.0
2014-07-25 13:00:00	NVDA	Stock	0.4485	0.4485	0.4455	0.447	32635680.0
2014-07-25 14:00:00	NVDA	Stock	0.447	0.4475	0.4458	0.4459	20748120.0
2014-07-25 15:00:00	NVDA	Stock	0.446	0.4465	0.444	0.4448	91764840.0
2014-07-25 16:00:00	NVDA	Stock	0.4448	0.4448	0.4442	0.4448	9041360.0
2014-07-25 17:00:00	NVDA	Stock	0.4445	0.4445	0.4445	0.4445	20000.0
2014-07-25 04:00:00	AMZN	Stock	16.0325	16.313	16.0325	16.25	103180.0
2014-07-25 05:00:00	AMZN	Stock	16.265	16.265	16.125	16.158	200880.0
2014-07-25 06:00:00	AMZN	Stock	16.175	16.195	16.066	16.125	313480.0
2014-07-25 07:00:00	AMZN	Stock	16.125	16.18	16.05	16.151	903500.0
2014-07-25 08:00:00	AMZN	Stock	16.08	16.19	15.825	15.8625	8087200.0
2014-07-25 09:00:00	AMZN	Stock	15.859	16.05	15.7275	15.966	104796980.0
2014-07-25 10:00:00	AMZN	Stock	15.964	16.091	15.83	15.8885	62765100.0
2014-07-25 11:00:00	AMZN	Stock	15.8885	15.985	15.85	15.9628	33866960.0
2014-07-25 12:00:00	AMZN	Stock	15.9675	16.243	15.9525	16.1754	41415060.0
2014-07-25 13:00:00	AMZN	Stock	16.175	16.2435	16.097	16.0973	23880540.0

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

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