PREVIEW / stock_1hour / 2017-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-16.parquet
  size:    1.0 MB
  rows:    48,114
  symbols: 3,030

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-05-16 04:00:00	AAPL	Stock	38.975	38.9875	38.9725	38.9725	7336.0
2017-05-16 05:00:00	AAPL	Stock	38.97	38.97	38.95	38.95	2048.0
2017-05-16 06:00:00	AAPL	Stock	38.975	38.9875	38.975	38.9875	4400.0
2017-05-16 07:00:00	AAPL	Stock	38.9875	39.0475	38.9875	39.0425	26752.0
2017-05-16 08:00:00	AAPL	Stock	39.0375	39.065	38.9875	39.0425	247876.0
2017-05-16 09:00:00	AAPL	Stock	39.025	39.0375	38.8	38.8675	12480856.0
2017-05-16 10:00:00	AAPL	Stock	38.8675	38.9275	38.68	38.7375	14687960.0
2017-05-16 11:00:00	AAPL	Stock	38.74	38.865	38.6975	38.825	8579588.0
2017-05-16 12:00:00	AAPL	Stock	38.8275	38.8625	38.805	38.8225	4785752.0
2017-05-16 13:00:00	AAPL	Stock	38.825	38.83	38.7425	38.7862	6920236.0
2017-05-16 14:00:00	AAPL	Stock	38.785	38.8425	38.7725	38.8362	6010444.0
2017-05-16 15:00:00	AAPL	Stock	38.8362	38.87	38.8002	38.8675	10361560.0
2017-05-16 16:00:00	AAPL	Stock	38.85	38.875	38.84	38.8675	4866468.0
2017-05-16 17:00:00	AAPL	Stock	38.8625	38.8625	38.835	38.8375	49520.0
2017-05-16 18:00:00	AAPL	Stock	38.8275	38.8275	38.7325	38.7325	108592.0
2017-05-16 19:00:00	AAPL	Stock	38.7275	38.7275	38.64	38.665	75596.0
2017-05-16 04:00:00	MSFT	Stock	68.2	68.2	68.15	68.15	448.0
2017-05-16 05:00:00	MSFT	Stock	68.2	68.2	68.2	68.2	2252.0
2017-05-16 06:00:00	MSFT	Stock	68.2	68.2	68.2	68.2	118.0
2017-05-16 07:00:00	MSFT	Stock	68.15	68.15	68.15	68.15	2379.0
2017-05-16 08:00:00	MSFT	Stock	68.15	68.2	68.1	68.1	9468.0
2017-05-16 09:00:00	MSFT	Stock	68.1	68.5	68.1	68.47	2704115.0
2017-05-16 10:00:00	MSFT	Stock	68.475	68.55	68.32	68.5	4446072.0
2017-05-16 11:00:00	MSFT	Stock	68.51	68.87	68.49	68.83	3113787.0
2017-05-16 12:00:00	MSFT	Stock	68.83	69.205	68.81	69.17	2860620.0
2017-05-16 13:00:00	MSFT	Stock	69.17	69.32	69.08	69.215	2215917.0
2017-05-16 14:00:00	MSFT	Stock	69.21	69.22	69.07	69.135	3020095.0
2017-05-16 15:00:00	MSFT	Stock	69.135	69.44	69.09	69.41	9914448.0
2017-05-16 16:00:00	MSFT	Stock	69.41	69.54	69.205	69.41	2470504.0
2017-05-16 17:00:00	MSFT	Stock	69.36	69.41	69.3	69.41	23701.0
2017-05-16 18:00:00	MSFT	Stock	69.35	69.4	69.25	69.25	4382.0
2017-05-16 19:00:00	MSFT	Stock	69.2	69.3	69.15	69.15	4568.0
2017-05-16 04:00:00	NVDA	Stock	3.375	3.375	3.3558	3.3625	156480.0
2017-05-16 05:00:00	NVDA	Stock	3.3625	3.3688	3.36	3.3688	120640.0
2017-05-16 06:00:00	NVDA	Stock	3.3688	3.38	3.365	3.38	239720.0
2017-05-16 07:00:00	NVDA	Stock	3.3825	3.4158	3.3758	3.4038	2516480.0
2017-05-16 08:00:00	NVDA	Stock	3.4088	3.4175	3.3522	3.3905	9282480.0
2017-05-16 09:00:00	NVDA	Stock	3.3908	3.436	3.339	3.3635	270347560.0
2017-05-16 10:00:00	NVDA	Stock	3.3635	3.3798	3.3341	3.372	183877720.0
2017-05-16 11:00:00	NVDA	Stock	3.3715	3.3995	3.365	3.372	149675760.0
2017-05-16 12:00:00	NVDA	Stock	3.3722	3.3835	3.3575	3.3722	74732080.0
2017-05-16 13:00:00	NVDA	Stock	3.3715	3.3932	3.3705	3.3875	59292400.0
2017-05-16 14:00:00	NVDA	Stock	3.3875	3.4268	3.386	3.4109	141905320.0
2017-05-16 15:00:00	NVDA	Stock	3.4111	3.4218	3.3975	3.421	131747560.0
2017-05-16 16:00:00	NVDA	Stock	3.4202	3.4242	3.4138	3.4172	18801840.0
2017-05-16 17:00:00	NVDA	Stock	3.4175	3.418	3.4075	3.4075	846480.0
2017-05-16 18:00:00	NVDA	Stock	3.4075	3.4092	3.4038	3.406	600840.0
2017-05-16 19:00:00	NVDA	Stock	3.4055	3.4062	3.3975	3.3975	655760.0
2017-05-16 04:00:00	AMZN	Stock	48.074	48.074	48.074	48.074	2000.0
2017-05-16 05:00:00	AMZN	Stock	48.0185	48.0185	48.0185	48.0185	2520.0

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

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