PREVIEW / stock_1hour / 2015-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-06.parquet
  size:    1.0 MB
  rows:    49,187
  symbols: 3,520

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-06 04:00:00	AAPL	Stock	31.495	31.53	31.4625	31.53	57444.0
2015-05-06 05:00:00	AAPL	Stock	31.54	31.5675	31.54	31.5675	16132.0
2015-05-06 06:00:00	AAPL	Stock	31.55	31.5625	31.5225	31.5325	42576.0
2015-05-06 07:00:00	AAPL	Stock	31.545	31.7	31.5325	31.6875	523944.0
2015-05-06 08:00:00	AAPL	Stock	31.6825	31.7275	31.5325	31.6575	1201196.0
2015-05-06 09:00:00	AAPL	Stock	31.67	31.7	31.0675	31.13	46922252.0
2015-05-06 10:00:00	AAPL	Stock	31.13	31.3475	30.84	31.325	71258596.0
2015-05-06 11:00:00	AAPL	Stock	31.3275	31.4475	31.205	31.295	29945532.0
2015-05-06 12:00:00	AAPL	Stock	31.295	31.2975	31.0575	31.0925	17908660.0
2015-05-06 13:00:00	AAPL	Stock	31.094	31.1075	30.905	31.0	21404404.0
2015-05-06 14:00:00	AAPL	Stock	31.0012	31.035	30.905	31.006	24740392.0
2015-05-06 15:00:00	AAPL	Stock	31.005	31.2825	30.965	31.2712	42138708.0
2015-05-06 16:00:00	AAPL	Stock	31.2725	31.361	31.15	31.295	4947720.0
2015-05-06 17:00:00	AAPL	Stock	31.2875	31.2975	31.28	31.285	67544.0
2015-05-06 18:00:00	AAPL	Stock	31.285	31.3	31.2775	31.295	158436.0
2015-05-06 19:00:00	AAPL	Stock	31.29	31.3125	31.2775	31.3125	107216.0
2015-05-06 06:00:00	MSFT	Stock	47.71	47.71	47.51	47.51	1700.0
2015-05-06 07:00:00	MSFT	Stock	47.59	47.69	47.57	47.69	12010.0
2015-05-06 08:00:00	MSFT	Stock	47.66	47.75	47.52	47.629	45971.0
2015-05-06 09:00:00	MSFT	Stock	47.64	47.77	46.85	46.91	6526402.0
2015-05-06 10:00:00	MSFT	Stock	46.92	46.945	46.58	46.69	8271959.0
2015-05-06 11:00:00	MSFT	Stock	46.69	46.84	46.57	46.81	5863370.0
2015-05-06 12:00:00	MSFT	Stock	46.81	46.82	46.6	46.627	3981650.0
2015-05-06 13:00:00	MSFT	Stock	46.63	46.81	46.36	46.48	3913482.0
2015-05-06 14:00:00	MSFT	Stock	46.49	46.51	46.09	46.215	6863343.0
2015-05-06 15:00:00	MSFT	Stock	46.23	46.3	46.02	46.29	12174231.0
2015-05-06 16:00:00	MSFT	Stock	46.28	46.62	46.211	46.299	2333465.0
2015-05-06 17:00:00	MSFT	Stock	46.23	46.31	46.23	46.3	1818.0
2015-05-06 18:00:00	MSFT	Stock	46.22	46.25	46.22	46.25	700.0
2015-05-06 19:00:00	MSFT	Stock	46.29	46.29	46.22	46.22	1600.0
2015-05-06 09:00:00	NVDA	Stock	0.552	0.559	0.5489	0.5495	55918520.0
2015-05-06 10:00:00	NVDA	Stock	0.549	0.5512	0.5455	0.5478	51775920.0
2015-05-06 11:00:00	NVDA	Stock	0.5478	0.551	0.5452	0.5482	32248320.0
2015-05-06 12:00:00	NVDA	Stock	0.548	0.5495	0.5471	0.5492	21689880.0
2015-05-06 13:00:00	NVDA	Stock	0.5495	0.5502	0.547	0.548	40159680.0
2015-05-06 14:00:00	NVDA	Stock	0.5481	0.549	0.5465	0.5481	29087640.0
2015-05-06 15:00:00	NVDA	Stock	0.548	0.5525	0.5472	0.5522	56327200.0
2015-05-06 16:00:00	NVDA	Stock	0.552	0.553	0.5496	0.5496	3853360.0
2015-05-06 18:00:00	NVDA	Stock	0.5522	0.5522	0.5522	0.5522	6960.0
2015-05-06 19:00:00	NVDA	Stock	0.5522	0.5522	0.5522	0.5522	33040.0
2015-05-06 07:00:00	AMZN	Stock	21.1065	21.1065	21.1065	21.1065	6400.0
2015-05-06 08:00:00	AMZN	Stock	21.108	21.15	21.105	21.15	86200.0
2015-05-06 09:00:00	AMZN	Stock	21.127	21.1445	20.849	20.927	6054660.0
2015-05-06 10:00:00	AMZN	Stock	20.919	21.022	20.8855	20.975	7373840.0
2015-05-06 11:00:00	AMZN	Stock	20.978	21.0475	20.9395	20.9935	4979820.0
2015-05-06 12:00:00	AMZN	Stock	20.998	21.0108	20.92	20.967	3413120.0
2015-05-06 13:00:00	AMZN	Stock	20.953	20.97	20.834	20.8715	4362800.0
2015-05-06 14:00:00	AMZN	Stock	20.8715	20.918	20.7525	20.7975	5558840.0
2015-05-06 15:00:00	AMZN	Stock	20.7875	20.9585	20.7275	20.956	11495420.0
2015-05-06 16:00:00	AMZN	Stock	20.955	20.979	20.9175	20.9176	1806140.0

> showing 50 of 49,187 rows — these rows as CSV

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