PREVIEW / stock_1hour / 2017-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-11.parquet
  size:    1.0 MB
  rows:    48,319
  symbols: 3,066

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
2017-04-11 05:00:00	AAPL	Stock	35.725	35.725	35.7025	35.725	10940.0
2017-04-11 06:00:00	AAPL	Stock	35.75	35.775	35.75	35.7525	5248.0
2017-04-11 07:00:00	AAPL	Stock	35.775	35.775	35.755	35.775	23684.0
2017-04-11 08:00:00	AAPL	Stock	35.775	35.81	35.75	35.795	123892.0
2017-04-11 09:00:00	AAPL	Stock	35.775	35.8375	35.4182	35.505	15051188.0
2017-04-11 10:00:00	AAPL	Stock	35.5062	35.525	35.015	35.2722	32166332.0
2017-04-11 11:00:00	AAPL	Stock	35.2725	35.325	35.16	35.2075	13047592.0
2017-04-11 12:00:00	AAPL	Stock	35.2075	35.4825	35.1825	35.4475	10469760.0
2017-04-11 13:00:00	AAPL	Stock	35.445	35.5375	35.39	35.4288	8732188.0
2017-04-11 14:00:00	AAPL	Stock	35.43	35.49	35.375	35.465	7503544.0
2017-04-11 15:00:00	AAPL	Stock	35.465	35.47	35.25	35.405	18329104.0
2017-04-11 16:00:00	AAPL	Stock	35.4075	35.427	35.35	35.35	4874000.0
2017-04-11 17:00:00	AAPL	Stock	35.365	35.375	35.34	35.34	30476.0
2017-04-11 18:00:00	AAPL	Stock	35.34	35.375	35.34	35.35	51668.0
2017-04-11 19:00:00	AAPL	Stock	35.3525	35.3725	35.3275	35.3725	46848.0
2017-04-11 04:00:00	MSFT	Stock	65.55	65.55	65.55	65.55	100.0
2017-04-11 06:00:00	MSFT	Stock	65.77	65.77	65.77	65.77	127.0
2017-04-11 08:00:00	MSFT	Stock	65.55	65.55	65.55	65.55	2573.0
2017-04-11 09:00:00	MSFT	Stock	65.6	65.61	65.1	65.23	2155741.0
2017-04-11 10:00:00	MSFT	Stock	65.24	65.42	64.85	64.99	3878319.0
2017-04-11 11:00:00	MSFT	Stock	64.99	65.28	64.95	65.18	2427534.0
2017-04-11 12:00:00	MSFT	Stock	65.18	65.51	65.13	65.48	1803463.0
2017-04-11 13:00:00	MSFT	Stock	65.48	65.61	65.34	65.39	1419066.0
2017-04-11 14:00:00	MSFT	Stock	65.39	65.49	65.31	65.4	1317130.0
2017-04-11 15:00:00	MSFT	Stock	65.4	65.5	65.2	65.5	2959421.0
2017-04-11 16:00:00	MSFT	Stock	65.48	65.48	65.332	65.48	1333186.0
2017-04-11 17:00:00	MSFT	Stock	65.48	65.55	65.48	65.48	5202.0
2017-04-11 18:00:00	MSFT	Stock	65.42	65.42	65.42	65.42	245.0
2017-04-11 19:00:00	MSFT	Stock	65.46	65.46	65.46	65.46	100.0
2017-04-11 06:00:00	NVDA	Stock	2.4412	2.4412	2.4412	2.4412	40000.0
2017-04-11 07:00:00	NVDA	Stock	2.435	2.4363	2.4338	2.4363	68320.0
2017-04-11 08:00:00	NVDA	Stock	2.44	2.441	2.425	2.4288	2121480.0
2017-04-11 09:00:00	NVDA	Stock	2.4298	2.4548	2.4088	2.4538	128206720.0
2017-04-11 10:00:00	NVDA	Stock	2.454	2.4572	2.421	2.4308	117398680.0
2017-04-11 11:00:00	NVDA	Stock	2.4305	2.4572	2.423	2.4541	71498840.0
2017-04-11 12:00:00	NVDA	Stock	2.454	2.4725	2.4518	2.462	70773680.0
2017-04-11 13:00:00	NVDA	Stock	2.4625	2.471	2.4542	2.4565	44189680.0
2017-04-11 14:00:00	NVDA	Stock	2.4565	2.4578	2.4458	2.4503	38273040.0
2017-04-11 15:00:00	NVDA	Stock	2.4505	2.4532	2.4382	2.453	73699800.0
2017-04-11 16:00:00	NVDA	Stock	2.453	2.4688	2.4293	2.453	18617000.0
2017-04-11 17:00:00	NVDA	Stock	2.4625	2.4685	2.4552	2.462	206000.0
2017-04-11 18:00:00	NVDA	Stock	2.46	2.4612	2.4595	2.4595	99720.0
2017-04-11 19:00:00	NVDA	Stock	2.4595	2.4595	2.453	2.4575	190160.0
2017-04-11 07:00:00	AMZN	Stock	45.47	45.4755	45.435	45.435	85740.0
2017-04-11 08:00:00	AMZN	Stock	45.43	45.46	45.25	45.4565	193400.0
2017-04-11 09:00:00	AMZN	Stock	45.4585	45.562	45.0175	45.15	11834440.0
2017-04-11 10:00:00	AMZN	Stock	45.1535	45.25	44.899	45.0	11741760.0
2017-04-11 11:00:00	AMZN	Stock	44.9865	45.046	44.875	45.011	6617900.0
2017-04-11 12:00:00	AMZN	Stock	44.998	45.1995	44.99	45.138	5511100.0
2017-04-11 13:00:00	AMZN	Stock	45.1375	45.1925	45.0891	45.1144	2996180.0

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

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