PREVIEW / stock_1hour / 2017-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-06.parquet
  size:    1.1 MB
  rows:    48,584
  symbols: 2,956

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-11-06 04:00:00	AAPL	Stock	43.25	43.275	43.225	43.235	75308.0
2017-11-06 05:00:00	AAPL	Stock	43.2325	43.2325	43.175	43.175	33828.0
2017-11-06 06:00:00	AAPL	Stock	43.175	43.25	43.1725	43.1975	99508.0
2017-11-06 07:00:00	AAPL	Stock	43.1975	43.2375	43.175	43.2075	145252.0
2017-11-06 08:00:00	AAPL	Stock	43.2	43.2725	43.125	43.2025	597748.0
2017-11-06 09:00:00	AAPL	Stock	43.225	43.2375	42.93	43.07	19689352.0
2017-11-06 10:00:00	AAPL	Stock	43.075	43.6925	43.0525	43.68	27438848.0
2017-11-06 11:00:00	AAPL	Stock	43.6763	43.7275	43.5275	43.6428	18248340.0
2017-11-06 12:00:00	AAPL	Stock	43.6425	43.7125	43.6	43.6425	10635108.0
2017-11-06 13:00:00	AAPL	Stock	43.6438	43.725	43.605	43.7225	9129152.0
2017-11-06 14:00:00	AAPL	Stock	43.7175	43.745	43.6175	43.7062	9417660.0
2017-11-06 15:00:00	AAPL	Stock	43.7075	43.7475	43.5675	43.58	16808692.0
2017-11-06 16:00:00	AAPL	Stock	43.5625	43.57	43.52	43.5425	14308432.0
2017-11-06 17:00:00	AAPL	Stock	43.5325	43.5625	43.525	43.5425	918256.0
2017-11-06 18:00:00	AAPL	Stock	43.55	43.55	43.5275	43.5275	70088.0
2017-11-06 19:00:00	AAPL	Stock	43.5375	43.55	43.5375	43.55	46812.0
2017-11-06 04:00:00	MSFT	Stock	84.06	84.06	84.06	84.06	800.0
2017-11-06 07:00:00	MSFT	Stock	84.1	84.13	84.1	84.13	844.0
2017-11-06 08:00:00	MSFT	Stock	84.13	84.13	84.0	84.0	3836.0
2017-11-06 09:00:00	MSFT	Stock	84.0	84.54	84.0	84.51	2173208.0
2017-11-06 10:00:00	MSFT	Stock	84.51	84.7	84.319	84.366	2419548.0
2017-11-06 11:00:00	MSFT	Stock	84.36	84.44	84.082	84.214	1943205.0
2017-11-06 12:00:00	MSFT	Stock	84.22	84.52	84.2	84.5	1225157.0
2017-11-06 13:00:00	MSFT	Stock	84.51	84.59	84.31	84.36	1459965.0
2017-11-06 14:00:00	MSFT	Stock	84.366	84.39	84.21	84.255	1407490.0
2017-11-06 15:00:00	MSFT	Stock	84.26	84.58	84.25	84.48	3412703.0
2017-11-06 16:00:00	MSFT	Stock	84.51	84.55	84.35	84.49	3839975.0
2017-11-06 17:00:00	MSFT	Stock	84.48	84.48	84.4	84.41	1072.0
2017-11-06 18:00:00	MSFT	Stock	84.48	84.5	84.48	84.48	2163.0
2017-11-06 19:00:00	MSFT	Stock	84.5	84.55	84.5	84.52	956.0
2017-11-06 05:00:00	NVDA	Stock	5.2175	5.2175	5.2172	5.2172	32440.0
2017-11-06 06:00:00	NVDA	Stock	5.2213	5.229	5.09	5.1425	1046640.0
2017-11-06 07:00:00	NVDA	Stock	5.1462	5.1775	5.1462	5.175	1325840.0
2017-11-06 08:00:00	NVDA	Stock	5.175	5.2288	5.1062	5.1562	4463720.0
2017-11-06 09:00:00	NVDA	Stock	5.155	5.2115	5.15	5.1945	73492440.0
2017-11-06 10:00:00	NVDA	Stock	5.196	5.2398	5.1932	5.2313	73932120.0
2017-11-06 11:00:00	NVDA	Stock	5.2305	5.2331	5.2013	5.2046	35975560.0
2017-11-06 12:00:00	NVDA	Stock	5.2055	5.2312	5.1923	5.228	33876440.0
2017-11-06 13:00:00	NVDA	Stock	5.2295	5.2425	5.2262	5.2387	26406800.0
2017-11-06 14:00:00	NVDA	Stock	5.24	5.2495	5.234	5.2388	31157920.0
2017-11-06 15:00:00	NVDA	Stock	5.2395	5.2413	5.2255	5.2405	49122560.0
2017-11-06 16:00:00	NVDA	Stock	5.2405	5.245	5.23	5.245	10530200.0
2017-11-06 17:00:00	NVDA	Stock	5.245	5.2495	5.2375	5.2495	860440.0
2017-11-06 18:00:00	NVDA	Stock	5.2453	5.2472	5.2453	5.2462	221680.0
2017-11-06 19:00:00	NVDA	Stock	5.2472	5.2495	5.2448	5.2488	209720.0
2017-11-06 04:00:00	AMZN	Stock	55.5735	55.5745	55.55	55.55	23040.0
2017-11-06 06:00:00	AMZN	Stock	55.5345	55.55	55.5345	55.55	28320.0
2017-11-06 07:00:00	AMZN	Stock	55.4	55.4945	55.4	55.4525	100660.0
2017-11-06 08:00:00	AMZN	Stock	55.475	55.5	55.4	55.45	133000.0
2017-11-06 09:00:00	AMZN	Stock	55.4785	56.074	55.41	55.94	13301660.0

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

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