PREVIEW / stock_1hour / 2016-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-11.parquet
  size:    1.0 MB
  rows:    48,221
  symbols: 3,263

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-08-11 06:00:00	AAPL	Stock	27.055	27.0725	27.035	27.035	25392.0
2016-08-11 07:00:00	AAPL	Stock	27.05	27.0975	27.0275	27.0975	117624.0
2016-08-11 08:00:00	AAPL	Stock	27.0725	27.1	27.05	27.095	239524.0
2016-08-11 09:00:00	AAPL	Stock	27.0875	27.2325	27.075	27.14	16585880.0
2016-08-11 10:00:00	AAPL	Stock	27.14	27.16	27.0275	27.0938	16532468.0
2016-08-11 11:00:00	AAPL	Stock	27.095	27.1762	27.0775	27.1588	8594152.0
2016-08-11 12:00:00	AAPL	Stock	27.1588	27.1625	27.1075	27.1288	5710020.0
2016-08-11 13:00:00	AAPL	Stock	27.13	27.1375	27.0925	27.095	5504760.0
2016-08-11 14:00:00	AAPL	Stock	27.095	27.1475	27.0325	27.0412	8404496.0
2016-08-11 15:00:00	AAPL	Stock	27.04	27.09	26.9625	26.9825	15956640.0
2016-08-11 16:00:00	AAPL	Stock	26.9825	27.0125	26.98	27.0075	10720552.0
2016-08-11 17:00:00	AAPL	Stock	27.01	27.03	26.99	27.01	16024.0
2016-08-11 18:00:00	AAPL	Stock	27.0125	27.03	27.005	27.0225	30932.0
2016-08-11 19:00:00	AAPL	Stock	27.0125	27.0225	27.005	27.0075	32984.0
2016-08-11 06:00:00	MSFT	Stock	58.08	58.09	58.08	58.09	3596.0
2016-08-11 07:00:00	MSFT	Stock	58.08	58.08	58.08	58.08	200.0
2016-08-11 08:00:00	MSFT	Stock	58.1	58.15	57.96	58.15	25781.0
2016-08-11 09:00:00	MSFT	Stock	58.27	58.45	58.03	58.37	2293385.0
2016-08-11 10:00:00	MSFT	Stock	58.37	58.41	58.18	58.21	2339899.0
2016-08-11 11:00:00	MSFT	Stock	58.21	58.34	58.14	58.28	1328681.0
2016-08-11 12:00:00	MSFT	Stock	58.29	58.29	58.16	58.229	1682734.0
2016-08-11 13:00:00	MSFT	Stock	58.23	58.28	58.17	58.26	1413874.0
2016-08-11 14:00:00	MSFT	Stock	58.26	58.305	58.2	58.226	1737877.0
2016-08-11 15:00:00	MSFT	Stock	58.22	58.36	58.21	58.3	3176770.0
2016-08-11 16:00:00	MSFT	Stock	58.3	58.32	58.3	58.32	2389888.0
2016-08-11 17:00:00	MSFT	Stock	58.3	58.3	58.3	58.3	100.0
2016-08-11 19:00:00	MSFT	Stock	58.3	58.3	58.25	58.25	999.0
2016-08-11 06:00:00	NVDA	Stock	1.4628	1.4688	1.4628	1.4688	12000.0
2016-08-11 07:00:00	NVDA	Stock	1.4722	1.4725	1.4688	1.4713	104520.0
2016-08-11 08:00:00	NVDA	Stock	1.4722	1.4725	1.4675	1.47	941320.0
2016-08-11 09:00:00	NVDA	Stock	1.47	1.4838	1.4675	1.4763	55601400.0
2016-08-11 10:00:00	NVDA	Stock	1.4762	1.478	1.4678	1.4748	76067960.0
2016-08-11 11:00:00	NVDA	Stock	1.4752	1.4788	1.4733	1.4749	58770440.0
2016-08-11 12:00:00	NVDA	Stock	1.475	1.484	1.4745	1.4822	50457760.0
2016-08-11 13:00:00	NVDA	Stock	1.4822	1.4849	1.4794	1.4815	49005200.0
2016-08-11 14:00:00	NVDA	Stock	1.4814	1.4895	1.4814	1.4858	55345440.0
2016-08-11 15:00:00	NVDA	Stock	1.4859	1.4988	1.485	1.4932	166385520.0
2016-08-11 16:00:00	NVDA	Stock	1.4925	1.5812	1.484	1.5312	72420600.0
2016-08-11 17:00:00	NVDA	Stock	1.5312	1.55	1.5258	1.5425	14247880.0
2016-08-11 18:00:00	NVDA	Stock	1.5425	1.5425	1.5315	1.5315	3337880.0
2016-08-11 19:00:00	NVDA	Stock	1.5315	1.5325	1.5273	1.528	4820400.0
2016-08-11 04:00:00	AMZN	Stock	38.4605	38.4605	38.4605	38.4605	4000.0
2016-08-11 07:00:00	AMZN	Stock	38.51	38.5745	38.51	38.55	24200.0
2016-08-11 08:00:00	AMZN	Stock	38.53	38.55	38.4945	38.525	72180.0
2016-08-11 09:00:00	AMZN	Stock	38.5375	38.6875	38.475	38.567	8580400.0
2016-08-11 10:00:00	AMZN	Stock	38.5695	38.6085	38.4765	38.5215	6208620.0
2016-08-11 11:00:00	AMZN	Stock	38.527	38.5595	38.456	38.5025	4128840.0
2016-08-11 12:00:00	AMZN	Stock	38.5105	38.535	38.4805	38.5128	2525900.0
2016-08-11 13:00:00	AMZN	Stock	38.5138	38.549	38.492	38.542	2834820.0
2016-08-11 14:00:00	AMZN	Stock	38.5465	38.621	38.5325	38.553	2967760.0

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

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