PREVIEW / stock_1hour / 2014-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-09.parquet
  size:    1.0 MB
  rows:    48,871
  symbols: 3,531

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-04-09 04:00:00	AAPL	Stock	18.7493	18.7493	18.7493	18.7493	2800.0
2014-04-09 07:00:00	AAPL	Stock	18.7736	18.7736	18.7736	18.7736	3836.0
2014-04-09 08:00:00	AAPL	Stock	18.7661	18.7675	18.7139	18.715	579152.0
2014-04-09 09:00:00	AAPL	Stock	18.7196	18.8111	18.6436	18.7507	34751892.0
2014-04-09 10:00:00	AAPL	Stock	18.7539	18.835	18.6993	18.8208	30446220.0
2014-04-09 11:00:00	AAPL	Stock	18.8214	18.8579	18.8018	18.8139	17473344.0
2014-04-09 12:00:00	AAPL	Stock	18.8146	18.8336	18.7929	18.8232	10820936.0
2014-04-09 13:00:00	AAPL	Stock	18.8264	18.8318	18.785	18.7875	8353772.0
2014-04-09 14:00:00	AAPL	Stock	18.7868	18.8807	18.7868	18.8671	20443696.0
2014-04-09 15:00:00	AAPL	Stock	18.8654	18.9461	18.8621	18.9395	32399584.0
2014-04-09 16:00:00	AAPL	Stock	18.9393	18.9443	18.7857	18.9431	7300328.0
2014-04-09 17:00:00	AAPL	Stock	18.9393	18.9393	18.915	18.9286	533064.0
2014-04-09 18:00:00	AAPL	Stock	18.9286	18.9393	18.9286	18.9357	537180.0
2014-04-09 19:00:00	AAPL	Stock	18.9375	18.9554	18.9286	18.9554	102144.0
2014-04-09 08:00:00	MSFT	Stock	39.95	40.07	39.95	40.03	5998.0
2014-04-09 09:00:00	MSFT	Stock	40.05	40.345	39.88	40.146	4383028.0
2014-04-09 10:00:00	MSFT	Stock	40.14	40.37	39.99	40.06	3384117.0
2014-04-09 11:00:00	MSFT	Stock	40.06	40.09	39.9	39.98	2504485.0
2014-04-09 12:00:00	MSFT	Stock	39.98	40.18	39.91	40.15	1902213.0
2014-04-09 13:00:00	MSFT	Stock	40.15	40.21	40.09	40.2	1507940.0
2014-04-09 14:00:00	MSFT	Stock	40.195	40.48	40.19	40.33	3725510.0
2014-04-09 15:00:00	MSFT	Stock	40.32	40.55	40.3	40.47	5406465.0
2014-04-09 16:00:00	MSFT	Stock	40.47	40.53	40.13	40.478	2341460.0
2014-04-09 17:00:00	MSFT	Stock	40.47	40.51	40.359	40.359	61271.0
2014-04-09 18:00:00	MSFT	Stock	40.51	40.53	40.47	40.53	59870.0
2014-04-09 19:00:00	MSFT	Stock	40.53	40.53	40.49	40.49	6761.0
2014-04-09 07:00:00	NVDA	Stock	0.4828	0.4828	0.4828	0.4828	4000.0
2014-04-09 08:00:00	NVDA	Stock	0.475	0.4793	0.4742	0.4788	656200.0
2014-04-09 09:00:00	NVDA	Stock	0.4788	0.4788	0.4698	0.47	46067760.0
2014-04-09 10:00:00	NVDA	Stock	0.47	0.4723	0.4673	0.4695	60787640.0
2014-04-09 11:00:00	NVDA	Stock	0.4692	0.473	0.4683	0.4719	37696080.0
2014-04-09 12:00:00	NVDA	Stock	0.4718	0.4778	0.4718	0.4761	100258040.0
2014-04-09 13:00:00	NVDA	Stock	0.476	0.477	0.4718	0.4718	36210000.0
2014-04-09 14:00:00	NVDA	Stock	0.472	0.4753	0.4696	0.4702	46929200.0
2014-04-09 15:00:00	NVDA	Stock	0.4704	0.472	0.47	0.471	77113440.0
2014-04-09 16:00:00	NVDA	Stock	0.471	0.4711	0.4708	0.4711	9134720.0
2014-04-09 17:00:00	NVDA	Stock	0.471	0.4728	0.471	0.4715	285400.0
2014-04-09 04:00:00	AMZN	Stock	16.35	16.35	16.35	16.35	4000.0
2014-04-09 07:00:00	AMZN	Stock	16.4	16.45	16.4	16.45	54000.0
2014-04-09 08:00:00	AMZN	Stock	16.403	16.473	16.4	16.45	137020.0
2014-04-09 09:00:00	AMZN	Stock	16.4555	16.4555	16.125	16.2685	22771580.0
2014-04-09 10:00:00	AMZN	Stock	16.2685	16.4	16.1425	16.273	13927560.0
2014-04-09 11:00:00	AMZN	Stock	16.28	16.2905	16.1968	16.2665	5744460.0
2014-04-09 12:00:00	AMZN	Stock	16.2645	16.4185	16.263	16.318	9343680.0
2014-04-09 13:00:00	AMZN	Stock	16.3192	16.3495	16.3075	16.31	5204320.0
2014-04-09 14:00:00	AMZN	Stock	16.314	16.55	16.2945	16.4885	14625500.0
2014-04-09 15:00:00	AMZN	Stock	16.4885	16.609	16.486	16.5904	17560460.0
2014-04-09 16:00:00	AMZN	Stock	16.5835	16.6015	16.362	16.5868	182760.0
2014-04-09 17:00:00	AMZN	Stock	16.5835	16.5835	16.56	16.56	146380.0
2014-04-09 18:00:00	AMZN	Stock	16.575	16.5895	16.575	16.5895	19140.0

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

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