PREVIEW / stock_1hour / 2016-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-26.parquet
  size:    1.0 MB
  rows:    47,122
  symbols: 3,194

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-10-26 04:00:00	AAPL	Stock	28.5875	28.5875	28.4975	28.56	57100.0
2016-10-26 05:00:00	AAPL	Stock	28.55	28.6775	28.515	28.6775	95528.0
2016-10-26 06:00:00	AAPL	Stock	28.675	28.6875	28.565	28.655	106300.0
2016-10-26 07:00:00	AAPL	Stock	28.6775	28.75	28.5625	28.74	772500.0
2016-10-26 08:00:00	AAPL	Stock	28.7425	28.805	28.58	28.6375	3998476.0
2016-10-26 09:00:00	AAPL	Stock	28.6275	28.6375	28.3275	28.4775	61530752.0
2016-10-26 10:00:00	AAPL	Stock	28.478	28.7415	28.4025	28.725	58241992.0
2016-10-26 11:00:00	AAPL	Stock	28.725	28.8125	28.695	28.7325	28026300.0
2016-10-26 12:00:00	AAPL	Stock	28.73	28.925	28.7175	28.845	19321564.0
2016-10-26 13:00:00	AAPL	Stock	28.845	28.865	28.6525	28.655	18288988.0
2016-10-26 14:00:00	AAPL	Stock	28.66	28.8525	28.6575	28.835	16350652.0
2016-10-26 15:00:00	AAPL	Stock	28.8325	28.9125	28.77	28.8975	24197472.0
2016-10-26 16:00:00	AAPL	Stock	28.8975	28.9125	28.8875	28.8875	15408424.0
2016-10-26 17:00:00	AAPL	Stock	28.8875	28.8975	28.8625	28.875	809984.0
2016-10-26 18:00:00	AAPL	Stock	28.8825	28.915	28.865	28.865	279216.0
2016-10-26 19:00:00	AAPL	Stock	28.865	28.885	28.865	28.885	43444.0
2016-10-26 07:00:00	MSFT	Stock	60.74	60.76	60.74	60.76	1400.0
2016-10-26 08:00:00	MSFT	Stock	60.78	60.88	60.7	60.77	9305.0
2016-10-26 09:00:00	MSFT	Stock	60.77	61.0	60.47	60.585	3800077.0
2016-10-26 10:00:00	MSFT	Stock	60.585	61.12	60.55	61.101	4171909.0
2016-10-26 11:00:00	MSFT	Stock	61.101	61.2	60.9	60.9	2938006.0
2016-10-26 12:00:00	MSFT	Stock	60.9	60.98	60.85	60.87	2068895.0
2016-10-26 13:00:00	MSFT	Stock	60.875	60.92	60.66	60.7	2500082.0
2016-10-26 14:00:00	MSFT	Stock	60.701	60.76	60.6	60.71	2663713.0
2016-10-26 15:00:00	MSFT	Stock	60.71	60.77	60.58	60.63	5354824.0
2016-10-26 16:00:00	MSFT	Stock	60.63	60.71	60.5	60.63	2525377.0
2016-10-26 17:00:00	MSFT	Stock	60.63	60.63	60.6	60.6	1520.0
2016-10-26 18:00:00	MSFT	Stock	60.63	60.63	60.6	60.63	425.0
2016-10-26 19:00:00	MSFT	Stock	60.6	60.6	60.6	60.6	2140.0
2016-10-26 05:00:00	NVDA	Stock	1.787	1.787	1.787	1.787	12000.0
2016-10-26 08:00:00	NVDA	Stock	1.787	1.787	1.782	1.7868	131400.0
2016-10-26 09:00:00	NVDA	Stock	1.7848	1.7988	1.78	1.7868	37782280.0
2016-10-26 10:00:00	NVDA	Stock	1.7869	1.8205	1.7868	1.8145	62179760.0
2016-10-26 11:00:00	NVDA	Stock	1.8138	1.8168	1.807	1.811	35902040.0
2016-10-26 12:00:00	NVDA	Stock	1.811	1.8238	1.8093	1.8222	34450160.0
2016-10-26 13:00:00	NVDA	Stock	1.8222	1.8235	1.8074	1.8101	33938760.0
2016-10-26 14:00:00	NVDA	Stock	1.8102	1.8118	1.802	1.8082	34287480.0
2016-10-26 15:00:00	NVDA	Stock	1.8082	1.8102	1.8036	1.804	57315240.0
2016-10-26 16:00:00	NVDA	Stock	1.804	1.8108	1.804	1.81	6534880.0
2016-10-26 17:00:00	NVDA	Stock	1.8042	1.8042	1.804	1.804	548000.0
2016-10-26 18:00:00	NVDA	Stock	1.8075	1.8108	1.8075	1.8105	49000.0
2016-10-26 19:00:00	NVDA	Stock	1.8108	1.8108	1.8078	1.8093	60000.0
2016-10-26 04:00:00	AMZN	Stock	41.65	41.65	41.6	41.6	6000.0
2016-10-26 06:00:00	AMZN	Stock	41.6245	41.6245	41.6	41.6	11820.0
2016-10-26 07:00:00	AMZN	Stock	41.6285	41.717	41.625	41.717	60420.0
2016-10-26 08:00:00	AMZN	Stock	41.7005	41.724	41.675	41.7095	66060.0
2016-10-26 09:00:00	AMZN	Stock	41.6815	41.6815	41.2265	41.3112	11726240.0
2016-10-26 10:00:00	AMZN	Stock	41.305	41.38	41.2075	41.3679	9140480.0
2016-10-26 11:00:00	AMZN	Stock	41.368	41.4965	41.2778	41.309	7336700.0
2016-10-26 12:00:00	AMZN	Stock	41.3105	41.3159	41.1845	41.2	6997680.0

> showing 50 of 47,122 rows — these rows as CSV

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