PREVIEW / stock_1hour / 2014-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-24.parquet
  size:    1.0 MB
  rows:    48,988
  symbols: 3,557

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-24 04:00:00	AAPL	Stock	24.3275	24.3725	24.3125	24.32	40780.0
2014-07-24 05:00:00	AAPL	Stock	24.3225	24.325	24.3	24.3125	11496.0
2014-07-24 06:00:00	AAPL	Stock	24.325	24.3625	24.325	24.35	100420.0
2014-07-24 07:00:00	AAPL	Stock	24.325	24.35	24.245	24.3	578872.0
2014-07-24 08:00:00	AAPL	Stock	24.3	24.3475	24.16	24.2175	942160.0
2014-07-24 09:00:00	AAPL	Stock	24.2125	24.33	24.145	24.195	29623536.0
2014-07-24 10:00:00	AAPL	Stock	24.1975	24.21	24.105	24.1425	25919460.0
2014-07-24 11:00:00	AAPL	Stock	24.145	24.27	24.145	24.2475	20408220.0
2014-07-24 12:00:00	AAPL	Stock	24.2475	24.325	24.1925	24.2175	15546192.0
2014-07-24 13:00:00	AAPL	Stock	24.2175	24.235	24.1525	24.205	13106828.0
2014-07-24 14:00:00	AAPL	Stock	24.205	24.25	24.195	24.2125	12990728.0
2014-07-24 15:00:00	AAPL	Stock	24.215	24.265	24.2082	24.255	24534956.0
2014-07-24 16:00:00	AAPL	Stock	24.2575	24.3258	24.2	24.2125	19138676.0
2014-07-24 17:00:00	AAPL	Stock	24.2362	24.2975	24.125	24.1875	793744.0
2014-07-24 18:00:00	AAPL	Stock	24.1875	24.2575	24.185	24.205	225588.0
2014-07-24 19:00:00	AAPL	Stock	24.215	24.22	24.1875	24.1875	92620.0
2014-07-24 05:00:00	MSFT	Stock	44.99	44.99	44.99	44.99	100.0
2014-07-24 07:00:00	MSFT	Stock	45.04	45.04	45.04	45.04	100.0
2014-07-24 08:00:00	MSFT	Stock	44.87	45.06	44.8	44.89	10900.0
2014-07-24 09:00:00	MSFT	Stock	44.86	45.0	44.59	44.6	3612576.0
2014-07-24 10:00:00	MSFT	Stock	44.6	44.7	44.48	44.675	4539497.0
2014-07-24 11:00:00	MSFT	Stock	44.67	44.72	44.65	44.655	3026843.0
2014-07-24 12:00:00	MSFT	Stock	44.65	44.68	44.375	44.38	3073801.0
2014-07-24 13:00:00	MSFT	Stock	44.38	44.52	44.32	44.52	3213018.0
2014-07-24 14:00:00	MSFT	Stock	44.515	44.52	44.41	44.455	2312621.0
2014-07-24 15:00:00	MSFT	Stock	44.46	44.51	44.38	44.38	6961147.0
2014-07-24 16:00:00	MSFT	Stock	44.4	44.734	44.34	44.39	2572398.0
2014-07-24 17:00:00	MSFT	Stock	44.495	44.495	44.29	44.29	14154.0
2014-07-24 18:00:00	MSFT	Stock	44.35	44.41	44.3	44.41	30337.0
2014-07-24 19:00:00	MSFT	Stock	44.31	44.31	44.31	44.31	100.0
2014-07-24 09:00:00	NVDA	Stock	0.4535	0.4558	0.452	0.454	21298560.0
2014-07-24 10:00:00	NVDA	Stock	0.454	0.4556	0.4522	0.4542	39549320.0
2014-07-24 11:00:00	NVDA	Stock	0.454	0.4541	0.4518	0.452	34986520.0
2014-07-24 12:00:00	NVDA	Stock	0.4521	0.4524	0.4495	0.4514	34221600.0
2014-07-24 13:00:00	NVDA	Stock	0.4515	0.4526	0.45	0.4525	12166320.0
2014-07-24 14:00:00	NVDA	Stock	0.4524	0.453	0.4515	0.4518	32163760.0
2014-07-24 15:00:00	NVDA	Stock	0.4518	0.4535	0.451	0.4525	59422480.0
2014-07-24 16:00:00	NVDA	Stock	0.4528	0.4528	0.4527	0.4528	8624480.0
2014-07-24 18:00:00	NVDA	Stock	0.4528	0.4528	0.4528	0.4528	4000.0
2014-07-24 06:00:00	AMZN	Stock	17.991	17.991	17.902	17.902	15080.0
2014-07-24 07:00:00	AMZN	Stock	17.984	17.984	17.95	17.9625	14100.0
2014-07-24 08:00:00	AMZN	Stock	17.955	17.975	17.9	17.97	128480.0
2014-07-24 09:00:00	AMZN	Stock	17.975	18.2425	17.97	18.056	11081180.0
2014-07-24 10:00:00	AMZN	Stock	18.049	18.0554	17.926	17.9422	12393520.0
2014-07-24 11:00:00	AMZN	Stock	17.937	18.1224	17.9315	18.113	10354260.0
2014-07-24 12:00:00	AMZN	Stock	18.1138	18.1245	17.9885	18.0128	6522080.0
2014-07-24 13:00:00	AMZN	Stock	18.0085	18.028	17.967	18.026	7721260.0
2014-07-24 14:00:00	AMZN	Stock	18.0275	18.0895	17.952	17.987	11770740.0
2014-07-24 15:00:00	AMZN	Stock	17.992	18.0075	17.93	17.945	21303440.0
2014-07-24 16:00:00	AMZN	Stock	17.9305	18.1	16.5465	16.605	25267760.0

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

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