PREVIEW / stock_1hour / 2014-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-23.parquet
  size:    1.1 MB
  rows:    51,792
  symbols: 3,578

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-09-23 04:00:00	AAPL	Stock	25.265	25.265	25.14	25.185	27692.0
2014-09-23 05:00:00	AAPL	Stock	25.17	25.17	25.07	25.0875	19676.0
2014-09-23 06:00:00	AAPL	Stock	25.1475	25.1475	25.1025	25.1475	31560.0
2014-09-23 07:00:00	AAPL	Stock	25.1625	25.1675	25.105	25.155	113172.0
2014-09-23 08:00:00	AAPL	Stock	25.1425	25.1925	25.14	25.1925	486260.0
2014-09-23 09:00:00	AAPL	Stock	25.185	25.5	25.135	25.47	32239900.0
2014-09-23 10:00:00	AAPL	Stock	25.47	25.535	25.4	25.486	36267100.0
2014-09-23 11:00:00	AAPL	Stock	25.4875	25.5975	25.435	25.5612	28791304.0
2014-09-23 12:00:00	AAPL	Stock	25.5612	25.69	25.5525	25.6625	31687380.0
2014-09-23 13:00:00	AAPL	Stock	25.6625	25.695	25.595	25.6175	26176768.0
2014-09-23 14:00:00	AAPL	Stock	25.6175	25.65	25.5375	25.6275	24292928.0
2014-09-23 15:00:00	AAPL	Stock	25.6275	25.735	25.6075	25.66	48160756.0
2014-09-23 16:00:00	AAPL	Stock	25.66	25.6875	25.489	25.624	8583664.0
2014-09-23 17:00:00	AAPL	Stock	25.59	25.66	25.5525	25.5925	407180.0
2014-09-23 18:00:00	AAPL	Stock	25.6	25.66	25.5975	25.62	326520.0
2014-09-23 19:00:00	AAPL	Stock	25.615	25.6425	25.595	25.6375	166352.0
2014-09-23 04:00:00	MSFT	Stock	46.83	46.83	46.83	46.83	200.0
2014-09-23 05:00:00	MSFT	Stock	46.83	46.83	46.83	46.83	100.0
2014-09-23 07:00:00	MSFT	Stock	46.87	46.87	46.87	46.87	500.0
2014-09-23 08:00:00	MSFT	Stock	46.86	46.98	46.85	46.93	2052.0
2014-09-23 09:00:00	MSFT	Stock	47.02	47.02	46.74	46.9	4149984.0
2014-09-23 10:00:00	MSFT	Stock	46.9	46.98	46.77	46.875	4162640.0
2014-09-23 11:00:00	MSFT	Stock	46.876	46.89	46.8	46.86	2295589.0
2014-09-23 12:00:00	MSFT	Stock	46.86	46.88	46.67	46.685	4131270.0
2014-09-23 13:00:00	MSFT	Stock	46.68	46.77	46.66	46.725	4932677.0
2014-09-23 14:00:00	MSFT	Stock	46.725	46.78	46.55	46.61	4486932.0
2014-09-23 15:00:00	MSFT	Stock	46.61	46.685	46.47	46.55	6233518.0
2014-09-23 16:00:00	MSFT	Stock	46.56	46.768	46.41	46.768	1961609.0
2014-09-23 17:00:00	MSFT	Stock	46.56	46.56	46.54	46.54	20265.0
2014-09-23 18:00:00	MSFT	Stock	46.56	46.56	46.46	46.56	29101.0
2014-09-23 19:00:00	MSFT	Stock	46.51	46.51	46.51	46.51	700.0
2014-09-23 04:00:00	NVDA	Stock	0.4718	0.4718	0.4718	0.4718	12000.0
2014-09-23 09:00:00	NVDA	Stock	0.472	0.4732	0.468	0.4719	25630360.0
2014-09-23 10:00:00	NVDA	Stock	0.472	0.4755	0.472	0.4735	36818240.0
2014-09-23 11:00:00	NVDA	Stock	0.4738	0.4753	0.473	0.4736	20942200.0
2014-09-23 12:00:00	NVDA	Stock	0.4737	0.4742	0.4728	0.4735	16175160.0
2014-09-23 13:00:00	NVDA	Stock	0.4735	0.4738	0.4713	0.472	19064280.0
2014-09-23 14:00:00	NVDA	Stock	0.472	0.4728	0.4709	0.4713	18453080.0
2014-09-23 15:00:00	NVDA	Stock	0.4715	0.4728	0.4698	0.4701	42865080.0
2014-09-23 16:00:00	NVDA	Stock	0.4702	0.4716	0.4702	0.4702	1328960.0
2014-09-23 17:00:00	NVDA	Stock	0.4702	0.4702	0.4702	0.4702	50480.0
2014-09-23 07:00:00	AMZN	Stock	16.103	16.103	16.088	16.103	22400.0
2014-09-23 08:00:00	AMZN	Stock	16.137	16.1505	16.105	16.13	196500.0
2014-09-23 09:00:00	AMZN	Stock	16.1425	16.38	16.0625	16.3405	11178860.0
2014-09-23 10:00:00	AMZN	Stock	16.3355	16.3405	16.1375	16.2034	9454820.0
2014-09-23 11:00:00	AMZN	Stock	16.208	16.277	16.1475	16.232	4963740.0
2014-09-23 12:00:00	AMZN	Stock	16.2365	16.2894	16.227	16.2323	2527620.0
2014-09-23 13:00:00	AMZN	Stock	16.229	16.248	16.1665	16.1789	2970960.0
2014-09-23 14:00:00	AMZN	Stock	16.172	16.206	16.1575	16.1835	3370080.0
2014-09-23 15:00:00	AMZN	Stock	16.191	16.2465	16.177	16.1815	6104820.0

> showing 50 of 51,792 rows — these rows as CSV

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