PREVIEW / stock_1hour / 2016-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-13.parquet
  size:    1.0 MB
  rows:    47,865
  symbols: 3,280

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-05-13 04:00:00	AAPL	Stock	22.4675	22.5	22.25	22.48	22480.0
2016-05-13 05:00:00	AAPL	Stock	22.48	22.48	22.425	22.46	9000.0
2016-05-13 06:00:00	AAPL	Stock	22.48	22.535	22.465	22.5025	26236.0
2016-05-13 07:00:00	AAPL	Stock	22.5025	22.54	22.4775	22.5025	71696.0
2016-05-13 08:00:00	AAPL	Stock	22.5125	22.56	22.47	22.515	568096.0
2016-05-13 09:00:00	AAPL	Stock	22.515	22.83	22.4775	22.6625	35992036.0
2016-05-13 10:00:00	AAPL	Stock	22.6625	22.8325	22.6525	22.785	27458672.0
2016-05-13 11:00:00	AAPL	Stock	22.7842	22.9175	22.7842	22.8325	22057600.0
2016-05-13 12:00:00	AAPL	Stock	22.8325	22.85	22.6925	22.7042	13641032.0
2016-05-13 13:00:00	AAPL	Stock	22.705	22.7375	22.55	22.58	16869240.0
2016-05-13 14:00:00	AAPL	Stock	22.58	22.6425	22.54	22.564	14719088.0
2016-05-13 15:00:00	AAPL	Stock	22.565	22.6725	22.5425	22.63	25171652.0
2016-05-13 16:00:00	AAPL	Stock	22.63	22.66	22.625	22.6325	7336960.0
2016-05-13 17:00:00	AAPL	Stock	22.6375	22.6375	22.585	22.585	82376.0
2016-05-13 18:00:00	AAPL	Stock	22.585	22.61	22.5525	22.575	60052.0
2016-05-13 19:00:00	AAPL	Stock	22.5775	22.5975	22.575	22.595	60704.0
2016-05-13 08:00:00	MSFT	Stock	51.3	51.44	51.3	51.4	1418.0
2016-05-13 09:00:00	MSFT	Stock	51.44	51.86	51.23	51.76	2211864.0
2016-05-13 10:00:00	MSFT	Stock	51.76	51.895	51.6	51.66	2543657.0
2016-05-13 11:00:00	MSFT	Stock	51.66	51.81	51.565	51.57	2459205.0
2016-05-13 12:00:00	MSFT	Stock	51.58	51.735	51.54	51.57	1907122.0
2016-05-13 13:00:00	MSFT	Stock	51.57	51.68	51.32	51.35	2408279.0
2016-05-13 14:00:00	MSFT	Stock	51.34	51.37	51.04	51.15	2701118.0
2016-05-13 15:00:00	MSFT	Stock	51.15	51.26	51.06	51.08	4358091.0
2016-05-13 16:00:00	MSFT	Stock	51.09	51.15	51.03	51.15	2538660.0
2016-05-13 17:00:00	MSFT	Stock	51.05	51.05	51.03	51.03	1481.0
2016-05-13 18:00:00	MSFT	Stock	51.03	51.04	51.03	51.04	300.0
2016-05-13 19:00:00	MSFT	Stock	51.15	51.15	51.03	51.03	1082.0
2016-05-13 04:00:00	NVDA	Stock	0.9468	0.948	0.9468	0.948	16000.0
2016-05-13 05:00:00	NVDA	Stock	0.95	0.9535	0.95	0.9535	56000.0
2016-05-13 06:00:00	NVDA	Stock	0.9508	0.9508	0.9508	0.9508	63200.0
2016-05-13 07:00:00	NVDA	Stock	0.9575	0.967	0.9575	0.959	1258240.0
2016-05-13 08:00:00	NVDA	Stock	0.96	0.9845	0.9555	0.9815	76951920.0
2016-05-13 09:00:00	NVDA	Stock	0.982	1.0065	0.9725	1.0024	458491040.0
2016-05-13 10:00:00	NVDA	Stock	1.0025	1.0075	0.9858	0.9988	488757960.0
2016-05-13 11:00:00	NVDA	Stock	0.9988	1.0136	0.9982	1.0132	277236280.0
2016-05-13 12:00:00	NVDA	Stock	1.0132	1.017	1.0072	1.0091	165323120.0
2016-05-13 13:00:00	NVDA	Stock	1.0092	1.0115	1.0035	1.009	127444520.0
2016-05-13 14:00:00	NVDA	Stock	1.009	1.0215	1.0078	1.0172	146976640.0
2016-05-13 15:00:00	NVDA	Stock	1.017	1.025	1.0145	1.0243	291492840.0
2016-05-13 16:00:00	NVDA	Stock	1.0245	1.025	1.0225	1.0238	22226680.0
2016-05-13 17:00:00	NVDA	Stock	1.0238	1.0245	1.0235	1.0235	305720.0
2016-05-13 18:00:00	NVDA	Stock	1.024	1.024	1.0238	1.0238	49080.0
2016-05-13 19:00:00	NVDA	Stock	1.0235	1.024	1.022	1.022	151560.0
2016-05-13 04:00:00	AMZN	Stock	35.725	35.725	35.7	35.7	4000.0
2016-05-13 05:00:00	AMZN	Stock	35.7	35.7125	35.7	35.7125	14000.0
2016-05-13 06:00:00	AMZN	Stock	35.75	35.775	35.75	35.775	6920.0
2016-05-13 07:00:00	AMZN	Stock	35.725	35.7995	35.725	35.75	38760.0
2016-05-13 08:00:00	AMZN	Stock	35.8125	35.8865	35.655	35.8505	592320.0
2016-05-13 09:00:00	AMZN	Stock	35.8525	35.9625	35.655	35.7508	18159680.0

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

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