PREVIEW / stock_1hour / 2016-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-18.parquet
  size:    1.1 MB
  rows:    49,093
  symbols: 3,350

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-18 04:00:00	AAPL	Stock	26.48	26.48	26.48	26.48	440.0
2016-03-18 05:00:00	AAPL	Stock	26.48	26.48	26.48	26.48	2840.0
2016-03-18 06:00:00	AAPL	Stock	26.48	26.48	26.48	26.48	6148.0
2016-03-18 07:00:00	AAPL	Stock	26.48	26.6125	26.48	26.5625	77556.0
2016-03-18 08:00:00	AAPL	Stock	26.55	26.6	26.5	26.5675	223520.0
2016-03-18 09:00:00	AAPL	Stock	26.5625	26.6625	26.3528	26.3775	51730932.0
2016-03-18 10:00:00	AAPL	Stock	26.3752	26.495	26.37	26.4725	15584504.0
2016-03-18 11:00:00	AAPL	Stock	26.4725	26.533	26.425	26.4425	12635800.0
2016-03-18 12:00:00	AAPL	Stock	26.445	26.475	26.415	26.465	9791128.0
2016-03-18 13:00:00	AAPL	Stock	26.467	26.4675	26.2975	26.4235	14329304.0
2016-03-18 14:00:00	AAPL	Stock	26.4225	26.4725	26.4025	26.4275	9661656.0
2016-03-18 15:00:00	AAPL	Stock	26.43	26.5	26.4288	26.4775	22757088.0
2016-03-18 16:00:00	AAPL	Stock	26.48	26.4975	26.375	26.425	23055968.0
2016-03-18 17:00:00	AAPL	Stock	26.4325	26.48	26.4125	26.4375	2388368.0
2016-03-18 18:00:00	AAPL	Stock	26.4425	26.4625	26.4375	26.4425	29476.0
2016-03-18 19:00:00	AAPL	Stock	26.4425	26.46	26.4375	26.4425	50212.0
2016-03-18 07:00:00	MSFT	Stock	54.95	54.96	54.95	54.96	1498.0
2016-03-18 08:00:00	MSFT	Stock	54.75	54.93	54.7	54.93	2050.0
2016-03-18 09:00:00	MSFT	Stock	54.8	54.99	53.8	54.029	17679724.0
2016-03-18 10:00:00	MSFT	Stock	54.02	54.22	53.81	54.015	5649226.0
2016-03-18 11:00:00	MSFT	Stock	54.01	54.35	54.0	54.15	4032804.0
2016-03-18 12:00:00	MSFT	Stock	54.15	54.165	53.855	54.06	3277190.0
2016-03-18 13:00:00	MSFT	Stock	54.055	54.06	53.465	53.575	4187975.0
2016-03-18 14:00:00	MSFT	Stock	53.58	53.69	53.445	53.615	3289998.0
2016-03-18 15:00:00	MSFT	Stock	53.62	53.898	53.48	53.49	8475432.0
2016-03-18 16:00:00	MSFT	Stock	53.49	54.001	53.36	53.41	17227384.0
2016-03-18 17:00:00	MSFT	Stock	53.49	53.49	53.45	53.45	94110.0
2016-03-18 18:00:00	MSFT	Stock	53.47	53.48	53.4	53.4	4726.0
2016-03-18 19:00:00	MSFT	Stock	53.49	53.49	53.49	53.49	604.0
2016-03-18 08:00:00	NVDA	Stock	0.825	0.825	0.8248	0.825	244160.0
2016-03-18 09:00:00	NVDA	Stock	0.8222	0.8415	0.8222	0.8412	85680240.0
2016-03-18 10:00:00	NVDA	Stock	0.8412	0.8518	0.841	0.8492	90767240.0
2016-03-18 11:00:00	NVDA	Stock	0.849	0.8558	0.849	0.8524	74813000.0
2016-03-18 12:00:00	NVDA	Stock	0.8525	0.8562	0.8508	0.8525	49906160.0
2016-03-18 13:00:00	NVDA	Stock	0.8525	0.8525	0.847	0.8502	33268440.0
2016-03-18 14:00:00	NVDA	Stock	0.8504	0.852	0.847	0.8482	42160000.0
2016-03-18 15:00:00	NVDA	Stock	0.8482	0.8495	0.8446	0.8455	99224360.0
2016-03-18 16:00:00	NVDA	Stock	0.8452	0.8454	0.8425	0.8425	43038360.0
2016-03-18 17:00:00	NVDA	Stock	0.8425	0.8452	0.8425	0.8452	82000.0
2016-03-18 06:00:00	AMZN	Stock	28.0705	28.0705	28.07	28.07	13000.0
2016-03-18 07:00:00	AMZN	Stock	28.092	28.0975	28.092	28.0975	14000.0
2016-03-18 08:00:00	AMZN	Stock	28.05	28.1	28.029	28.0505	126500.0
2016-03-18 09:00:00	AMZN	Stock	28.0545	28.1225	27.416	27.5125	31337700.0
2016-03-18 10:00:00	AMZN	Stock	27.5165	27.562	27.3045	27.49	18681520.0
2016-03-18 11:00:00	AMZN	Stock	27.4875	27.7985	27.4845	27.632	15545040.0
2016-03-18 12:00:00	AMZN	Stock	27.649	27.7625	27.597	27.7512	7001380.0
2016-03-18 13:00:00	AMZN	Stock	27.7535	27.7689	27.368	27.429	11045880.0
2016-03-18 14:00:00	AMZN	Stock	27.425	27.52	27.3935	27.5015	7898600.0
2016-03-18 15:00:00	AMZN	Stock	27.5	27.678	27.4895	27.6055	19107820.0
2016-03-18 16:00:00	AMZN	Stock	27.604	27.675	27.4873	27.635	20547620.0

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

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