PREVIEW / stock_1hour / 2016-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-29.parquet
  size:    1.0 MB
  rows:    48,017
  symbols: 3,152

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-12-29 04:00:00	AAPL	Stock	29.1775	29.1775	29.1775	29.1775	1584.0
2016-12-29 05:00:00	AAPL	Stock	29.175	29.175	29.175	29.175	400.0
2016-12-29 06:00:00	AAPL	Stock	29.15	29.15	29.15	29.15	400.0
2016-12-29 07:00:00	AAPL	Stock	29.16	29.16	29.16	29.16	960.0
2016-12-29 08:00:00	AAPL	Stock	29.165	29.185	29.15	29.1675	92464.0
2016-12-29 09:00:00	AAPL	Stock	29.1625	29.2775	29.1025	29.2075	9469280.0
2016-12-29 10:00:00	AAPL	Stock	29.2062	29.275	29.15	29.1772	9853460.0
2016-12-29 11:00:00	AAPL	Stock	29.1775	29.1788	29.1	29.1262	6727560.0
2016-12-29 12:00:00	AAPL	Stock	29.1262	29.1925	29.1225	29.1575	4913788.0
2016-12-29 13:00:00	AAPL	Stock	29.155	29.185	29.12	29.1512	4629744.0
2016-12-29 14:00:00	AAPL	Stock	29.1512	29.1738	29.13	29.1475	4700920.0
2016-12-29 15:00:00	AAPL	Stock	29.15	29.185	29.145	29.1825	9402176.0
2016-12-29 16:00:00	AAPL	Stock	29.1825	29.1825	29.1525	29.18	4092140.0
2016-12-29 17:00:00	AAPL	Stock	29.1775	29.195	29.175	29.18	44980.0
2016-12-29 18:00:00	AAPL	Stock	29.18	29.1925	29.18	29.1925	21780.0
2016-12-29 19:00:00	AAPL	Stock	29.1775	29.205	29.1775	29.205	13884.0
2016-12-29 08:00:00	MSFT	Stock	63.1	63.1	63.07	63.1	950.0
2016-12-29 09:00:00	MSFT	Stock	63.0	63.2	62.75	62.835	1335234.0
2016-12-29 10:00:00	MSFT	Stock	62.836	62.975	62.79	62.826	1526181.0
2016-12-29 11:00:00	MSFT	Stock	62.82	62.875	62.73	62.784	992740.0
2016-12-29 12:00:00	MSFT	Stock	62.79	62.95	62.775	62.91	754489.0
2016-12-29 13:00:00	MSFT	Stock	62.91	62.925	62.78	62.835	831557.0
2016-12-29 14:00:00	MSFT	Stock	62.84	62.908	62.81	62.832	1085155.0
2016-12-29 15:00:00	MSFT	Stock	62.83	62.925	62.815	62.9	1922928.0
2016-12-29 16:00:00	MSFT	Stock	62.9	62.9	62.87	62.9	1119072.0
2016-12-29 17:00:00	MSFT	Stock	62.9	62.9	62.9	62.9	250.0
2016-12-29 18:00:00	MSFT	Stock	62.9	62.9	62.9	62.9	1119.0
2016-12-29 19:00:00	MSFT	Stock	62.9	62.9	62.9	62.9	200.0
2016-12-29 04:00:00	NVDA	Stock	2.6128	2.6425	2.6128	2.6325	685320.0
2016-12-29 05:00:00	NVDA	Stock	2.6325	2.66	2.6288	2.6562	751600.0
2016-12-29 06:00:00	NVDA	Stock	2.6538	2.66	2.6498	2.65	348280.0
2016-12-29 07:00:00	NVDA	Stock	2.6503	2.6925	2.6503	2.6848	3806680.0
2016-12-29 08:00:00	NVDA	Stock	2.6832	2.7	2.6498	2.6578	15379920.0
2016-12-29 09:00:00	NVDA	Stock	2.6588	2.6775	2.57	2.597	492222960.0
2016-12-29 10:00:00	NVDA	Stock	2.5962	2.6475	2.5962	2.6262	287970840.0
2016-12-29 11:00:00	NVDA	Stock	2.626	2.6372	2.6088	2.6285	154160280.0
2016-12-29 12:00:00	NVDA	Stock	2.6282	2.7312	2.6264	2.7165	316432080.0
2016-12-29 13:00:00	NVDA	Stock	2.717	2.7255	2.6795	2.6827	185633480.0
2016-12-29 14:00:00	NVDA	Stock	2.683	2.761	2.6808	2.752	278456240.0
2016-12-29 15:00:00	NVDA	Stock	2.7528	2.7873	2.7323	2.7852	316317240.0
2016-12-29 16:00:00	NVDA	Stock	2.7795	2.8235	2.7785	2.8175	11664880.0
2016-12-29 17:00:00	NVDA	Stock	2.8188	2.8223	2.8162	2.8205	2174000.0
2016-12-29 18:00:00	NVDA	Stock	2.8205	2.8343	2.7858	2.8275	7297960.0
2016-12-29 19:00:00	NVDA	Stock	2.8275	2.8328	2.825	2.8325	1642960.0
2016-12-29 08:00:00	AMZN	Stock	38.7295	38.7295	38.5995	38.5995	47720.0
2016-12-29 09:00:00	AMZN	Stock	38.594	38.67	38.3715	38.4125	6924260.0
2016-12-29 10:00:00	AMZN	Stock	38.4106	38.4555	38.2005	38.2335	9669560.0
2016-12-29 11:00:00	AMZN	Stock	38.235	38.297	38.079	38.1035	7516360.0
2016-12-29 12:00:00	AMZN	Stock	38.1087	38.211	38.0425	38.141	6443820.0
2016-12-29 13:00:00	AMZN	Stock	38.14	38.1575	38.0685	38.1145	4386820.0

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

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