PREVIEW / stock_1hour / 2013-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-17.parquet
  size:    995 KB
  rows:    46,011
  symbols: 3,513

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
2013-05-17 05:00:00	AAPL	Stock	15.5357	15.5357	15.5354	15.5357	8400.0
2013-05-17 06:00:00	AAPL	Stock	15.5357	15.5861	15.5343	15.5861	54684.0
2013-05-17 07:00:00	AAPL	Stock	15.5929	15.7679	15.5886	15.725	1902460.0
2013-05-17 08:00:00	AAPL	Stock	15.7161	15.75	15.6143	15.6693	1669864.0
2013-05-17 09:00:00	AAPL	Stock	15.6743	15.7175	15.5189	15.6246	89752740.0
2013-05-17 10:00:00	AAPL	Stock	15.625	15.6943	15.4679	15.4971	92161720.0
2013-05-17 11:00:00	AAPL	Stock	15.4964	15.5	15.3932	15.4382	61107004.0
2013-05-17 12:00:00	AAPL	Stock	15.4379	15.4889	15.395	15.4854	32656932.0
2013-05-17 13:00:00	AAPL	Stock	15.4836	15.5211	15.4204	15.4525	40105380.0
2013-05-17 14:00:00	AAPL	Stock	15.4561	15.5035	15.4286	15.4943	33853848.0
2013-05-17 15:00:00	AAPL	Stock	15.4943	15.5014	15.4361	15.4732	48877024.0
2013-05-17 16:00:00	AAPL	Stock	15.4732	15.5374	15.4651	15.4736	21719852.0
2013-05-17 17:00:00	AAPL	Stock	15.4954	15.5	15.4857	15.4911	102816.0
2013-05-17 18:00:00	AAPL	Stock	15.4911	15.5054	15.4911	15.4964	56476.0
2013-05-17 19:00:00	AAPL	Stock	15.4911	15.5	15.4821	15.5	130116.0
2013-05-17 04:00:00	MSFT	Stock	34.03	34.03	33.98	33.98	200.0
2013-05-17 05:00:00	MSFT	Stock	34.03	34.03	34.03	34.03	100.0
2013-05-17 06:00:00	MSFT	Stock	34.03	34.03	34.03	34.03	200.0
2013-05-17 07:00:00	MSFT	Stock	34.09	34.1	34.08	34.09	1043.0
2013-05-17 08:00:00	MSFT	Stock	34.05	34.1	33.9	34.06	17071.0
2013-05-17 09:00:00	MSFT	Stock	34.08	34.3	34.06	34.178	11043612.0
2013-05-17 10:00:00	MSFT	Stock	34.18	34.37	34.17	34.36	7008951.0
2013-05-17 11:00:00	MSFT	Stock	34.35	34.39	34.25	34.34	4621645.0
2013-05-17 12:00:00	MSFT	Stock	34.343	34.375	34.32	34.345	2830458.0
2013-05-17 13:00:00	MSFT	Stock	34.35	34.37	34.28	34.365	6132053.0
2013-05-17 14:00:00	MSFT	Stock	34.37	34.54	34.35	34.54	7214729.0
2013-05-17 15:00:00	MSFT	Stock	34.54	34.87	34.53	34.87	15057336.0
2013-05-17 16:00:00	MSFT	Stock	34.87	34.88	34.32	34.78	4290191.0
2013-05-17 17:00:00	MSFT	Stock	34.78	34.82	34.78	34.82	3081.0
2013-05-17 18:00:00	MSFT	Stock	34.79	34.87	34.79	34.85	5200.0
2013-05-17 19:00:00	MSFT	Stock	34.85	34.86	34.8	34.8	2600.0
2013-05-17 07:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	4000.0
2013-05-17 08:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	60000.0
2013-05-17 09:00:00	NVDA	Stock	0.3675	0.37	0.3648	0.3686	51753560.0
2013-05-17 10:00:00	NVDA	Stock	0.3688	0.3713	0.3668	0.3708	45385000.0
2013-05-17 11:00:00	NVDA	Stock	0.3709	0.3728	0.3703	0.3728	47740960.0
2013-05-17 12:00:00	NVDA	Stock	0.3728	0.3743	0.3725	0.3728	40454920.0
2013-05-17 13:00:00	NVDA	Stock	0.3729	0.373	0.3705	0.3709	26340760.0
2013-05-17 14:00:00	NVDA	Stock	0.371	0.3719	0.3705	0.3713	22528400.0
2013-05-17 15:00:00	NVDA	Stock	0.3714	0.3725	0.371	0.3718	63759400.0
2013-05-17 16:00:00	NVDA	Stock	0.3715	0.3718	0.37	0.3718	3711840.0
2013-05-17 19:00:00	NVDA	Stock	0.3695	0.3695	0.3695	0.3695	38000.0
2013-05-17 07:00:00	AMZN	Stock	13.215	13.2175	13.215	13.2175	12000.0
2013-05-17 08:00:00	AMZN	Stock	13.24	13.2625	13.206	13.22	169740.0
2013-05-17 09:00:00	AMZN	Stock	13.2345	13.39	13.206	13.3788	13181720.0
2013-05-17 10:00:00	AMZN	Stock	13.382	13.4	13.31	13.3502	5611420.0
2013-05-17 11:00:00	AMZN	Stock	13.3447	13.3875	13.301	13.3705	5019400.0
2013-05-17 12:00:00	AMZN	Stock	13.3665	13.3715	13.3302	13.3595	2084320.0
2013-05-17 13:00:00	AMZN	Stock	13.356	13.3675	13.311	13.3675	4293580.0
2013-05-17 14:00:00	AMZN	Stock	13.3635	13.4475	13.361	13.4405	5525640.0

> showing 50 of 46,011 rows — these rows as CSV

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