PREVIEW / stock_1hour / 2014-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-15.parquet
  size:    1.0 MB
  rows:    49,274
  symbols: 3,537

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-05-15 05:00:00	AAPL	Stock	21.1804	21.1804	21.1804	21.1804	2800.0
2014-05-15 07:00:00	AAPL	Stock	21.1964	21.2139	21.1804	21.1804	83888.0
2014-05-15 08:00:00	AAPL	Stock	21.1829	21.2482	21.1768	21.2143	489020.0
2014-05-15 09:00:00	AAPL	Stock	21.2143	21.3071	21.1875	21.2421	33522496.0
2014-05-15 10:00:00	AAPL	Stock	21.2354	21.2436	21.1036	21.1554	34261220.0
2014-05-15 11:00:00	AAPL	Stock	21.1579	21.1607	21.0207	21.0421	29569848.0
2014-05-15 12:00:00	AAPL	Stock	21.0446	21.095	21.0268	21.0689	17370500.0
2014-05-15 13:00:00	AAPL	Stock	21.0723	21.0889	21.0268	21.0293	15032388.0
2014-05-15 14:00:00	AAPL	Stock	21.03	21.105	21.0014	21.0968	23940504.0
2014-05-15 15:00:00	AAPL	Stock	21.1021	21.1086	21.0286	21.0293	23444764.0
2014-05-15 16:00:00	AAPL	Stock	21.0293	21.0714	20.9993	21.0179	11744656.0
2014-05-15 17:00:00	AAPL	Stock	21.0143	21.0293	21.0057	21.0089	571200.0
2014-05-15 18:00:00	AAPL	Stock	21.0168	21.0293	21.0125	21.0143	569240.0
2014-05-15 19:00:00	AAPL	Stock	21.0179	21.0282	21.0143	21.0282	220640.0
2014-05-15 08:00:00	MSFT	Stock	40.19	40.21	40.19	40.21	1000.0
2014-05-15 09:00:00	MSFT	Stock	40.19	40.4	39.76	39.85	3300439.0
2014-05-15 10:00:00	MSFT	Stock	39.85	39.86	39.54	39.66	6149054.0
2014-05-15 11:00:00	MSFT	Stock	39.67	39.72	39.56	39.62	3941106.0
2014-05-15 12:00:00	MSFT	Stock	39.61	39.68	39.51	39.62	2462634.0
2014-05-15 13:00:00	MSFT	Stock	39.62	39.7	39.53	39.6	9382521.0
2014-05-15 14:00:00	MSFT	Stock	39.6	39.78	39.51	39.695	3169389.0
2014-05-15 15:00:00	MSFT	Stock	39.7	39.735	39.56	39.61	6249996.0
2014-05-15 16:00:00	MSFT	Stock	39.6	39.68	39.592	39.61	1648133.0
2014-05-15 17:00:00	MSFT	Stock	39.6	39.61	39.6	39.6	134910.0
2014-05-15 18:00:00	MSFT	Stock	39.6	39.61	39.6	39.61	15603.0
2014-05-15 19:00:00	MSFT	Stock	39.58	39.58	39.58	39.58	200.0
2014-05-15 08:00:00	NVDA	Stock	0.4518	0.4518	0.4518	0.4518	4000.0
2014-05-15 09:00:00	NVDA	Stock	0.4518	0.453	0.4495	0.4512	42444840.0
2014-05-15 10:00:00	NVDA	Stock	0.4512	0.454	0.4455	0.453	77593360.0
2014-05-15 11:00:00	NVDA	Stock	0.4532	0.4535	0.447	0.4472	63948680.0
2014-05-15 12:00:00	NVDA	Stock	0.4472	0.4508	0.447	0.4495	23552720.0
2014-05-15 13:00:00	NVDA	Stock	0.4495	0.451	0.449	0.4506	18811920.0
2014-05-15 14:00:00	NVDA	Stock	0.4508	0.4525	0.4502	0.452	32908400.0
2014-05-15 15:00:00	NVDA	Stock	0.452	0.4522	0.4498	0.45	43935320.0
2014-05-15 16:00:00	NVDA	Stock	0.45	0.45	0.4458	0.45	11770320.0
2014-05-15 17:00:00	NVDA	Stock	0.45	0.45	0.45	0.45	372640.0
2014-05-15 18:00:00	NVDA	Stock	0.4492	0.4492	0.4492	0.4492	20000.0
2014-05-15 04:00:00	AMZN	Stock	14.886	14.8935	14.886	14.8935	4000.0
2014-05-15 07:00:00	AMZN	Stock	14.8875	14.8875	14.82	14.8525	26900.0
2014-05-15 08:00:00	AMZN	Stock	14.895	14.9255	14.868	14.89	75500.0
2014-05-15 09:00:00	AMZN	Stock	14.8965	14.96	14.6912	14.7685	15343780.0
2014-05-15 10:00:00	AMZN	Stock	14.77	14.7704	14.586	14.652	16662560.0
2014-05-15 11:00:00	AMZN	Stock	14.6565	14.6945	14.5195	14.54	10328520.0
2014-05-15 12:00:00	AMZN	Stock	14.5358	14.6845	14.519	14.658	8297100.0
2014-05-15 13:00:00	AMZN	Stock	14.654	14.689	14.6045	14.6575	4581580.0
2014-05-15 14:00:00	AMZN	Stock	14.6495	14.806	14.646	14.7925	7499100.0
2014-05-15 15:00:00	AMZN	Stock	14.791	14.81	14.706	14.7605	11682900.0
2014-05-15 16:00:00	AMZN	Stock	14.7595	14.8	14.6509	14.8	246260.0
2014-05-15 17:00:00	AMZN	Stock	14.7595	14.7595	14.7595	14.7595	138700.0
2014-05-15 18:00:00	AMZN	Stock	14.7595	14.78	14.755	14.755	55400.0

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

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