PREVIEW / stock_1hour / 2016-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-17.parquet
  size:    1.0 MB
  rows:    48,739
  symbols: 3,340

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-03-17 04:00:00	AAPL	Stock	26.355	26.5625	26.355	26.525	40488.0
2016-03-17 05:00:00	AAPL	Stock	26.535	26.535	26.425	26.425	55496.0
2016-03-17 06:00:00	AAPL	Stock	26.4325	26.4375	26.3	26.3275	33700.0
2016-03-17 07:00:00	AAPL	Stock	26.37	26.39	26.26	26.3175	119340.0
2016-03-17 08:00:00	AAPL	Stock	26.35	26.55	26.275	26.325	1030356.0
2016-03-17 09:00:00	AAPL	Stock	26.3375	26.4	26.24	26.295	21191896.0
2016-03-17 10:00:00	AAPL	Stock	26.295	26.53	26.2525	26.4948	21682812.0
2016-03-17 11:00:00	AAPL	Stock	26.4935	26.56	26.44	26.5338	12662564.0
2016-03-17 12:00:00	AAPL	Stock	26.535	26.6175	26.4875	26.5425	16823528.0
2016-03-17 13:00:00	AAPL	Stock	26.54	26.5748	26.45	26.5075	10377500.0
2016-03-17 14:00:00	AAPL	Stock	26.505	26.545	26.4	26.4012	12268232.0
2016-03-17 15:00:00	AAPL	Stock	26.4	26.5125	26.3925	26.45	17094324.0
2016-03-17 16:00:00	AAPL	Stock	26.4498	26.4825	26.282	26.4825	8982556.0
2016-03-17 17:00:00	AAPL	Stock	26.475	26.475	26.4475	26.455	550220.0
2016-03-17 18:00:00	AAPL	Stock	26.4625	26.495	26.4625	26.49	42420.0
2016-03-17 19:00:00	AAPL	Stock	26.4925	26.5	26.48	26.5	47672.0
2016-03-17 04:00:00	MSFT	Stock	54.55	54.55	54.55	54.55	200.0
2016-03-17 05:00:00	MSFT	Stock	54.34	54.34	54.34	54.34	600.0
2016-03-17 06:00:00	MSFT	Stock	54.02	54.1	54.02	54.1	1000.0
2016-03-17 07:00:00	MSFT	Stock	54.1	54.1	54.1	54.1	100.0
2016-03-17 08:00:00	MSFT	Stock	54.0	54.22	54.0	54.2	2913.0
2016-03-17 09:00:00	MSFT	Stock	54.2	54.46	54.0	54.375	2939244.0
2016-03-17 10:00:00	MSFT	Stock	54.37	54.72	54.24	54.68	3336328.0
2016-03-17 11:00:00	MSFT	Stock	54.68	54.82	54.57	54.81	3485346.0
2016-03-17 12:00:00	MSFT	Stock	54.82	55.0	54.72	54.95	2856304.0
2016-03-17 13:00:00	MSFT	Stock	54.96	54.965	54.55	54.775	2013520.0
2016-03-17 14:00:00	MSFT	Stock	54.77	54.8	54.6	54.615	2542194.0
2016-03-17 15:00:00	MSFT	Stock	54.62	54.92	54.62	54.69	5442684.0
2016-03-17 16:00:00	MSFT	Stock	54.66	54.75	54.66	54.69	2804923.0
2016-03-17 17:00:00	MSFT	Stock	54.68	54.7	54.68	54.7	1100.0
2016-03-17 18:00:00	MSFT	Stock	54.68	54.73	54.68	54.73	2100.0
2016-03-17 19:00:00	MSFT	Stock	54.73	54.74	54.68	54.74	4304.0
2016-03-17 08:00:00	NVDA	Stock	0.822	0.8275	0.816	0.8198	1240000.0
2016-03-17 09:00:00	NVDA	Stock	0.8198	0.8285	0.8115	0.8204	42238600.0
2016-03-17 10:00:00	NVDA	Stock	0.8203	0.8204	0.8094	0.8121	71902440.0
2016-03-17 11:00:00	NVDA	Stock	0.8121	0.8204	0.8121	0.8203	34404160.0
2016-03-17 12:00:00	NVDA	Stock	0.8203	0.825	0.8182	0.8245	28136760.0
2016-03-17 13:00:00	NVDA	Stock	0.8248	0.825	0.8205	0.8226	35908120.0
2016-03-17 14:00:00	NVDA	Stock	0.8225	0.8252	0.8198	0.821	41414720.0
2016-03-17 15:00:00	NVDA	Stock	0.8212	0.8228	0.8195	0.8205	61957360.0
2016-03-17 16:00:00	NVDA	Stock	0.8205	0.8205	0.8205	0.8205	833680.0
2016-03-17 17:00:00	NVDA	Stock	0.8203	0.8203	0.8203	0.8203	12000.0
2016-03-17 18:00:00	NVDA	Stock	0.8203	0.8203	0.8203	0.8203	20000.0
2016-03-17 04:00:00	AMZN	Stock	28.601	28.775	28.601	28.775	22760.0
2016-03-17 05:00:00	AMZN	Stock	28.7	28.7	28.534	28.534	41800.0
2016-03-17 06:00:00	AMZN	Stock	28.478	28.478	28.45	28.45	20640.0
2016-03-17 07:00:00	AMZN	Stock	28.5	28.5	28.415	28.425	78640.0
2016-03-17 08:00:00	AMZN	Stock	28.45	28.5055	28.3725	28.47	183760.0
2016-03-17 09:00:00	AMZN	Stock	28.5	28.57	28.1885	28.2062	17850140.0
2016-03-17 10:00:00	AMZN	Stock	28.209	28.267	28.05	28.05	19726640.0

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

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