PREVIEW / stock_1hour / 2014-12-30

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-30.parquet
  size:    1.0 MB
  rows:    49,074
  symbols: 3,523

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
2014-12-30 04:00:00	AAPL	Stock	28.36	28.375	28.34	28.3625	51252.0
2014-12-30 05:00:00	AAPL	Stock	28.3625	28.41	28.3625	28.4	18000.0
2014-12-30 06:00:00	AAPL	Stock	28.395	28.4075	28.395	28.4075	16996.0
2014-12-30 07:00:00	AAPL	Stock	28.4075	28.435	28.395	28.42	87652.0
2014-12-30 08:00:00	AAPL	Stock	28.4	28.4475	28.4	28.415	347892.0
2014-12-30 09:00:00	AAPL	Stock	28.425	28.48	28.2775	28.335	13613284.0
2014-12-30 10:00:00	AAPL	Stock	28.3375	28.3875	28.225	28.3725	18933336.0
2014-12-30 11:00:00	AAPL	Stock	28.3725	28.3725	28.265	28.31	9214800.0
2014-12-30 12:00:00	AAPL	Stock	28.31	28.3125	28.1275	28.19	14247324.0
2014-12-30 13:00:00	AAPL	Stock	28.1875	28.2425	28.065	28.08	15102508.0
2014-12-30 14:00:00	AAPL	Stock	28.0775	28.16	28.0275	28.1545	14940348.0
2014-12-30 15:00:00	AAPL	Stock	28.1525	28.1875	28.0675	28.145	15557616.0
2014-12-30 16:00:00	AAPL	Stock	28.13	28.3792	28.1075	28.1075	6920708.0
2014-12-30 17:00:00	AAPL	Stock	28.1125	28.4975	28.1	28.4975	1450156.0
2014-12-30 18:00:00	AAPL	Stock	28.13	28.4975	28.1	28.115	187620.0
2014-12-30 19:00:00	AAPL	Stock	28.1325	28.14	28.125	28.1375	38736.0
2014-12-30 06:00:00	MSFT	Stock	47.38	47.38	47.38	47.38	500.0
2014-12-30 07:00:00	MSFT	Stock	47.38	47.49	47.38	47.4	1700.0
2014-12-30 08:00:00	MSFT	Stock	47.4	47.55	47.35	47.35	3896.0
2014-12-30 09:00:00	MSFT	Stock	47.48	47.62	47.32	47.46	1566659.0
2014-12-30 10:00:00	MSFT	Stock	47.46	47.48	47.26	47.309	1720468.0
2014-12-30 11:00:00	MSFT	Stock	47.31	47.37	47.235	47.3	1489468.0
2014-12-30 12:00:00	MSFT	Stock	47.295	47.32	47.11	47.13	1653181.0
2014-12-30 13:00:00	MSFT	Stock	47.13	47.13	46.84	46.936	2396833.0
2014-12-30 14:00:00	MSFT	Stock	46.93	47.05	46.885	46.995	1286265.0
2014-12-30 15:00:00	MSFT	Stock	46.99	47.12	46.98	47.02	3002074.0
2014-12-30 16:00:00	MSFT	Stock	47.02	47.365	47.012	47.038	1914465.0
2014-12-30 17:00:00	MSFT	Stock	47.07	47.07	46.99	46.99	469600.0
2014-12-30 18:00:00	MSFT	Stock	47.0	47.0	47.0	47.0	100.0
2014-12-30 19:00:00	MSFT	Stock	47.05	47.05	47.05	47.05	400.0
2014-12-30 08:00:00	NVDA	Stock	0.514	0.514	0.514	0.514	3224000.0
2014-12-30 09:00:00	NVDA	Stock	0.514	0.514	0.5088	0.51	11057720.0
2014-12-30 10:00:00	NVDA	Stock	0.51	0.5129	0.5095	0.5128	23346360.0
2014-12-30 11:00:00	NVDA	Stock	0.5128	0.513	0.5108	0.5118	9266520.0
2014-12-30 12:00:00	NVDA	Stock	0.512	0.512	0.5098	0.511	6054560.0
2014-12-30 13:00:00	NVDA	Stock	0.5108	0.5115	0.5095	0.5098	7962240.0
2014-12-30 14:00:00	NVDA	Stock	0.5098	0.51	0.5088	0.5093	6986400.0
2014-12-30 15:00:00	NVDA	Stock	0.5093	0.5098	0.5085	0.509	20200720.0
2014-12-30 16:00:00	NVDA	Stock	0.5093	0.5098	0.5093	0.5093	1059760.0
2014-12-30 17:00:00	NVDA	Stock	0.5093	0.5093	0.5093	0.5093	1164000.0
2014-12-30 19:00:00	NVDA	Stock	0.5093	0.5093	0.5093	0.5093	8000.0
2014-12-30 08:00:00	AMZN	Stock	15.5575	15.5575	15.535	15.535	4000.0
2014-12-30 09:00:00	AMZN	Stock	15.55	15.697	15.485	15.6225	5262700.0
2014-12-30 10:00:00	AMZN	Stock	15.603	15.652	15.487	15.539	7803780.0
2014-12-30 11:00:00	AMZN	Stock	15.5365	15.574	15.507	15.5265	4427540.0
2014-12-30 12:00:00	AMZN	Stock	15.527	15.5525	15.4985	15.5185	3115980.0
2014-12-30 13:00:00	AMZN	Stock	15.518	15.5265	15.4875	15.5035	3433000.0
2014-12-30 14:00:00	AMZN	Stock	15.5	15.5452	15.467	15.5338	3530000.0
2014-12-30 15:00:00	AMZN	Stock	15.536	15.5584	15.5125	15.517	6598620.0
2014-12-30 16:00:00	AMZN	Stock	15.515	15.5428	15.5045	15.5045	423780.0

> showing 50 of 49,074 rows — these rows as CSV

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