PREVIEW / stock_1hour / 2016-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-15.parquet
  size:    1.0 MB
  rows:    48,466
  symbols: 3,279

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
2016-07-15 04:00:00	AAPL	Stock	24.6825	24.7	24.6825	24.7	2420.0
2016-07-15 05:00:00	AAPL	Stock	24.7	24.7025	24.6975	24.6975	2000.0
2016-07-15 06:00:00	AAPL	Stock	24.6625	24.675	24.6625	24.675	6492.0
2016-07-15 07:00:00	AAPL	Stock	24.65	24.6725	24.6325	24.67	16236.0
2016-07-15 08:00:00	AAPL	Stock	24.65	24.675	24.625	24.6475	140172.0
2016-07-15 09:00:00	AAPL	Stock	24.6375	24.825	24.6375	24.735	32475252.0
2016-07-15 10:00:00	AAPL	Stock	24.7375	24.7475	24.6875	24.725	14411528.0
2016-07-15 11:00:00	AAPL	Stock	24.7275	24.7475	24.6525	24.6562	12101452.0
2016-07-15 12:00:00	AAPL	Stock	24.6552	24.6925	24.625	24.685	10012140.0
2016-07-15 13:00:00	AAPL	Stock	24.685	24.735	24.6825	24.73	7627876.0
2016-07-15 14:00:00	AAPL	Stock	24.73	24.745	24.6485	24.6912	9204260.0
2016-07-15 15:00:00	AAPL	Stock	24.6925	24.72	24.6675	24.69	19179952.0
2016-07-15 16:00:00	AAPL	Stock	24.69	24.695	24.6175	24.6325	7862300.0
2016-07-15 17:00:00	AAPL	Stock	24.64	24.6525	24.6125	24.625	148984.0
2016-07-15 18:00:00	AAPL	Stock	24.615	24.62	24.6	24.62	111784.0
2016-07-15 19:00:00	AAPL	Stock	24.6025	24.6575	24.595	24.6375	117608.0
2016-07-15 06:00:00	MSFT	Stock	53.9	53.98	53.85	53.98	2833.0
2016-07-15 07:00:00	MSFT	Stock	53.74	53.85	53.71	53.85	1200.0
2016-07-15 08:00:00	MSFT	Stock	53.74	53.86	53.74	53.86	1506.0
2016-07-15 09:00:00	MSFT	Stock	53.85	54.0	53.59	53.686	6486947.0
2016-07-15 10:00:00	MSFT	Stock	53.69	53.71	53.43	53.49	3278333.0
2016-07-15 11:00:00	MSFT	Stock	53.5	53.52	53.34	53.395	2586503.0
2016-07-15 12:00:00	MSFT	Stock	53.39	53.4	53.21	53.33	3585259.0
2016-07-15 13:00:00	MSFT	Stock	53.322	53.55	53.32	53.45	2103986.0
2016-07-15 14:00:00	MSFT	Stock	53.45	53.56	53.42	53.54	2572236.0
2016-07-15 15:00:00	MSFT	Stock	53.535	53.71	53.535	53.69	5594183.0
2016-07-15 16:00:00	MSFT	Stock	53.7	53.7	53.5	53.5	3721525.0
2016-07-15 17:00:00	MSFT	Stock	53.45	53.52	53.41	53.46	3800.0
2016-07-15 18:00:00	MSFT	Stock	53.47	53.47	53.47	53.47	600.0
2016-07-15 19:00:00	MSFT	Stock	53.47	53.55	53.45	53.45	10687.0
2016-07-15 04:00:00	NVDA	Stock	1.318	1.318	1.31	1.31	104000.0
2016-07-15 06:00:00	NVDA	Stock	1.3125	1.3125	1.312	1.3123	71960.0
2016-07-15 07:00:00	NVDA	Stock	1.31	1.3125	1.3083	1.3125	310760.0
2016-07-15 08:00:00	NVDA	Stock	1.3083	1.317	1.3052	1.3138	1152000.0
2016-07-15 09:00:00	NVDA	Stock	1.3128	1.3188	1.296	1.3056	83982400.0
2016-07-15 10:00:00	NVDA	Stock	1.3055	1.3195	1.305	1.3188	107787080.0
2016-07-15 11:00:00	NVDA	Stock	1.3185	1.322	1.316	1.322	36683960.0
2016-07-15 12:00:00	NVDA	Stock	1.322	1.3234	1.3168	1.319	24069400.0
2016-07-15 13:00:00	NVDA	Stock	1.3193	1.3228	1.3182	1.3194	23007680.0
2016-07-15 14:00:00	NVDA	Stock	1.3195	1.32	1.3158	1.3178	34661240.0
2016-07-15 15:00:00	NVDA	Stock	1.3178	1.3185	1.3155	1.3172	67426600.0
2016-07-15 16:00:00	NVDA	Stock	1.3175	1.3175	1.31	1.31	16832560.0
2016-07-15 17:00:00	NVDA	Stock	1.31	1.312	1.3098	1.312	158400.0
2016-07-15 18:00:00	NVDA	Stock	1.3125	1.3132	1.3125	1.3125	84000.0
2016-07-15 19:00:00	NVDA	Stock	1.3105	1.3105	1.3	1.3	103360.0
2016-07-15 08:00:00	AMZN	Stock	37.06	37.15	37.06	37.1495	69520.0
2016-07-15 09:00:00	AMZN	Stock	37.1375	37.3275	36.9435	36.9805	13669600.0
2016-07-15 10:00:00	AMZN	Stock	36.9845	36.986	36.758	36.9065	14629420.0
2016-07-15 11:00:00	AMZN	Stock	36.909	36.9295	36.77	36.8005	5170320.0
2016-07-15 12:00:00	AMZN	Stock	36.804	36.8255	36.7148	36.7345	3460080.0

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

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