PREVIEW / stock_1hour / 2017-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-06.parquet
  size:    1.0 MB
  rows:    48,165
  symbols: 3,106

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-02-06 04:00:00	AAPL	Stock	32.25	32.25	32.215	32.2225	5668.0
2017-02-06 05:00:00	AAPL	Stock	32.2375	32.275	32.2275	32.275	17416.0
2017-02-06 06:00:00	AAPL	Stock	32.295	32.2975	32.225	32.25	28500.0
2017-02-06 07:00:00	AAPL	Stock	32.25	32.2625	32.2125	32.2125	57264.0
2017-02-06 08:00:00	AAPL	Stock	32.225	32.25	32.1775	32.1975	209864.0
2017-02-06 09:00:00	AAPL	Stock	32.2	32.53	32.1675	32.5275	19709200.0
2017-02-06 10:00:00	AAPL	Stock	32.53	32.6175	32.495	32.5288	19252020.0
2017-02-06 11:00:00	AAPL	Stock	32.5275	32.5675	32.4725	32.51	11705072.0
2017-02-06 12:00:00	AAPL	Stock	32.5075	32.61	32.5025	32.605	9569964.0
2017-02-06 13:00:00	AAPL	Stock	32.6062	32.625	32.525	32.545	8856044.0
2017-02-06 14:00:00	AAPL	Stock	32.545	32.5875	32.5125	32.5725	8100332.0
2017-02-06 15:00:00	AAPL	Stock	32.5725	32.5925	32.5225	32.5725	14979404.0
2017-02-06 16:00:00	AAPL	Stock	32.5725	32.585	32.5425	32.5625	5526204.0
2017-02-06 17:00:00	AAPL	Stock	32.5675	32.5725	32.55	32.5725	14552.0
2017-02-06 18:00:00	AAPL	Stock	32.5725	32.5825	32.5675	32.5675	64884.0
2017-02-06 19:00:00	AAPL	Stock	32.5775	32.5825	32.5625	32.5675	46248.0
2017-02-06 04:00:00	MSFT	Stock	63.67	63.67	63.67	63.67	322.0
2017-02-06 05:00:00	MSFT	Stock	63.67	63.8	63.6	63.6	7854.0
2017-02-06 07:00:00	MSFT	Stock	63.44	63.48	63.44	63.48	3955.0
2017-02-06 08:00:00	MSFT	Stock	63.35	63.54	63.35	63.41	4098.0
2017-02-06 09:00:00	MSFT	Stock	63.41	63.55	63.14	63.24	1827002.0
2017-02-06 10:00:00	MSFT	Stock	63.25	63.41	63.21	63.34	1841136.0
2017-02-06 11:00:00	MSFT	Stock	63.34	63.52	63.28	63.464	1743437.0
2017-02-06 12:00:00	MSFT	Stock	63.46	63.49	63.33	63.435	1582001.0
2017-02-06 13:00:00	MSFT	Stock	63.44	63.495	63.38	63.475	1709493.0
2017-02-06 14:00:00	MSFT	Stock	63.47	63.54	63.445	63.496	1805070.0
2017-02-06 15:00:00	MSFT	Stock	63.5	63.65	63.49	63.63	3710420.0
2017-02-06 16:00:00	MSFT	Stock	63.64	63.67	63.522	63.64	2691542.0
2017-02-06 17:00:00	MSFT	Stock	63.63	63.64	63.62	63.64	30570.0
2017-02-06 18:00:00	MSFT	Stock	63.63	63.63	63.6	63.62	2135.0
2017-02-06 19:00:00	MSFT	Stock	63.64	63.64	63.6	63.6	614.0
2017-02-06 04:00:00	NVDA	Stock	2.865	2.865	2.865	2.865	10000.0
2017-02-06 05:00:00	NVDA	Stock	2.847	2.847	2.8435	2.8435	44000.0
2017-02-06 06:00:00	NVDA	Stock	2.8545	2.8545	2.84	2.8438	103520.0
2017-02-06 07:00:00	NVDA	Stock	2.845	2.8488	2.8375	2.845	353640.0
2017-02-06 08:00:00	NVDA	Stock	2.84	2.8538	2.8375	2.8375	1105120.0
2017-02-06 09:00:00	NVDA	Stock	2.8362	2.8975	2.8362	2.8872	81033640.0
2017-02-06 10:00:00	NVDA	Stock	2.8865	2.888	2.865	2.883	75641440.0
2017-02-06 11:00:00	NVDA	Stock	2.8823	2.9283	2.8815	2.9193	97322040.0
2017-02-06 12:00:00	NVDA	Stock	2.9192	2.9313	2.919	2.9213	57059840.0
2017-02-06 13:00:00	NVDA	Stock	2.921	2.9258	2.9145	2.925	35329880.0
2017-02-06 14:00:00	NVDA	Stock	2.925	2.929	2.915	2.9178	37153320.0
2017-02-06 15:00:00	NVDA	Stock	2.918	2.9332	2.9158	2.9328	81921280.0
2017-02-06 16:00:00	NVDA	Stock	2.9328	2.9348	2.9064	2.932	3758920.0
2017-02-06 17:00:00	NVDA	Stock	2.9325	2.9372	2.9325	2.9372	427680.0
2017-02-06 18:00:00	NVDA	Stock	2.9358	2.9388	2.933	2.935	186560.0
2017-02-06 19:00:00	NVDA	Stock	2.9363	2.9375	2.9325	2.9368	176080.0
2017-02-06 04:00:00	AMZN	Stock	40.5475	40.5475	40.5475	40.5475	6080.0
2017-02-06 05:00:00	AMZN	Stock	40.65	40.6585	40.65	40.6585	4000.0
2017-02-06 07:00:00	AMZN	Stock	40.615	40.6195	40.46	40.46	69540.0

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

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