PREVIEW / stock_1hour / 2016-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-29.parquet
  size:    1.0 MB
  rows:    49,944
  symbols: 3,407

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-01-29 04:00:00	AAPL	Stock	23.5125	23.7075	23.5125	23.7075	31688.0
2016-01-29 05:00:00	AAPL	Stock	23.68	23.695	23.6025	23.665	42420.0
2016-01-29 06:00:00	AAPL	Stock	23.6575	23.6875	23.6125	23.6375	63288.0
2016-01-29 07:00:00	AAPL	Stock	23.6125	23.645	23.5875	23.615	90580.0
2016-01-29 08:00:00	AAPL	Stock	23.615	23.66	23.54	23.625	278688.0
2016-01-29 09:00:00	AAPL	Stock	23.6125	23.94	23.565	23.9	31354236.0
2016-01-29 10:00:00	AAPL	Stock	23.9	24.0125	23.8075	23.895	35156868.0
2016-01-29 11:00:00	AAPL	Stock	23.8962	23.955	23.8438	23.935	23451980.0
2016-01-29 12:00:00	AAPL	Stock	23.9375	24.0875	23.89	24.048	29842288.0
2016-01-29 13:00:00	AAPL	Stock	24.0475	24.1905	24.0075	24.18	22478724.0
2016-01-29 14:00:00	AAPL	Stock	24.1797	24.2275	24.1175	24.1612	20493940.0
2016-01-29 15:00:00	AAPL	Stock	24.1625	24.305	24.1412	24.285	42743120.0
2016-01-29 16:00:00	AAPL	Stock	24.335	24.335	23.9902	24.265	34714364.0
2016-01-29 17:00:00	AAPL	Stock	24.2675	24.335	24.265	24.2925	146080.0
2016-01-29 18:00:00	AAPL	Stock	24.2875	24.3	24.2825	24.3	47100.0
2016-01-29 19:00:00	AAPL	Stock	24.2925	24.3125	24.29	24.2975	48084.0
2016-01-29 04:00:00	MSFT	Stock	54.25	54.25	54.0	54.0	6930.0
2016-01-29 05:00:00	MSFT	Stock	53.95	53.95	53.7	53.7	1448.0
2016-01-29 06:00:00	MSFT	Stock	53.88	54.28	53.76	54.2	60230.0
2016-01-29 07:00:00	MSFT	Stock	54.2	54.75	54.2	54.46	138767.0
2016-01-29 08:00:00	MSFT	Stock	54.41	54.72	53.82	54.27	523933.0
2016-01-29 09:00:00	MSFT	Stock	54.28	54.81	54.0	54.5	15818873.0
2016-01-29 10:00:00	MSFT	Stock	54.495	54.935	54.22	54.315	11312763.0
2016-01-29 11:00:00	MSFT	Stock	54.32	54.73	54.26	54.67	7246456.0
2016-01-29 12:00:00	MSFT	Stock	54.68	55.01	54.57	54.896	6317129.0
2016-01-29 13:00:00	MSFT	Stock	54.893	54.98	54.79	54.89	5706085.0
2016-01-29 14:00:00	MSFT	Stock	54.895	55.005	54.72	54.955	5676979.0
2016-01-29 15:00:00	MSFT	Stock	54.96	55.06	54.74	55.05	15545025.0
2016-01-29 16:00:00	MSFT	Stock	55.04	55.09	54.9	55.0	11530760.0
2016-01-29 17:00:00	MSFT	Stock	55.02	55.02	54.97	55.0	14321.0
2016-01-29 18:00:00	MSFT	Stock	54.99	55.02	54.97	55.02	16639.0
2016-01-29 19:00:00	MSFT	Stock	55.02	55.02	54.98	55.01	5590.0
2016-01-29 08:00:00	NVDA	Stock	0.7015	0.7015	0.7015	0.7015	4000.0
2016-01-29 09:00:00	NVDA	Stock	0.7068	0.7148	0.7045	0.711	17361200.0
2016-01-29 10:00:00	NVDA	Stock	0.7113	0.7221	0.7111	0.7195	42250720.0
2016-01-29 11:00:00	NVDA	Stock	0.7193	0.7218	0.7173	0.72	26509760.0
2016-01-29 12:00:00	NVDA	Stock	0.7198	0.728	0.7195	0.7268	28869840.0
2016-01-29 13:00:00	NVDA	Stock	0.7268	0.7275	0.7235	0.7263	25787320.0
2016-01-29 14:00:00	NVDA	Stock	0.726	0.7275	0.7238	0.7259	18308680.0
2016-01-29 15:00:00	NVDA	Stock	0.726	0.7336	0.7254	0.7323	94961720.0
2016-01-29 16:00:00	NVDA	Stock	0.7323	0.7332	0.7303	0.7323	45179240.0
2016-01-29 17:00:00	NVDA	Stock	0.7343	0.7343	0.7298	0.7325	52000.0
2016-01-29 18:00:00	NVDA	Stock	0.7368	0.7368	0.7368	0.7368	16000.0
2016-01-29 19:00:00	NVDA	Stock	0.7325	0.7325	0.7325	0.7325	34000.0
2016-01-29 04:00:00	AMZN	Stock	27.825	28.3	27.825	28.25	61720.0
2016-01-29 05:00:00	AMZN	Stock	28.325	28.55	28.255	28.55	149840.0
2016-01-29 06:00:00	AMZN	Stock	28.4	28.426	28.2475	28.342	175240.0
2016-01-29 07:00:00	AMZN	Stock	28.4225	28.965	28.2	28.45	2509520.0
2016-01-29 08:00:00	AMZN	Stock	28.4075	28.6	28.1655	28.55	5340700.0
2016-01-29 09:00:00	AMZN	Stock	28.549	29.65	28.5	28.897	88808880.0

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

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