PREVIEW / stock_1hour / 2014-02-11

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-11.parquet
  size:    1.0 MB
  rows:    48,584
  symbols: 3,548

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-02-11 04:00:00	AAPL	Stock	18.975	19.0	18.975	18.9843	8400.0
2014-02-11 05:00:00	AAPL	Stock	18.9893	18.9914	18.9821	18.9821	36400.0
2014-02-11 06:00:00	AAPL	Stock	18.9611	18.9611	18.9493	18.9546	45472.0
2014-02-11 07:00:00	AAPL	Stock	18.9607	18.9643	18.9329	18.9393	217980.0
2014-02-11 08:00:00	AAPL	Stock	18.9329	18.9679	18.9214	18.9679	2221520.0
2014-02-11 09:00:00	AAPL	Stock	18.9607	19.0393	18.9107	18.9896	41454532.0
2014-02-11 10:00:00	AAPL	Stock	18.9904	19.1025	18.9614	19.0957	45630088.0
2014-02-11 11:00:00	AAPL	Stock	19.0954	19.1682	19.0946	19.1289	33197584.0
2014-02-11 12:00:00	AAPL	Stock	19.1293	19.1661	19.1118	19.1639	19411756.0
2014-02-11 13:00:00	AAPL	Stock	19.1643	19.1861	19.1425	19.1611	20297872.0
2014-02-11 14:00:00	AAPL	Stock	19.1607	19.1829	19.1511	19.1782	18014164.0
2014-02-11 15:00:00	AAPL	Stock	19.1782	19.2054	19.1193	19.1414	42420924.0
2014-02-11 16:00:00	AAPL	Stock	19.1414	19.1643	19.0951	19.1357	10259872.0
2014-02-11 17:00:00	AAPL	Stock	19.1357	19.1514	19.1357	19.1429	346836.0
2014-02-11 18:00:00	AAPL	Stock	19.1432	19.1554	19.1414	19.1554	174776.0
2014-02-11 19:00:00	AAPL	Stock	19.1536	19.155	19.1436	19.15	174832.0
2014-02-11 04:00:00	MSFT	Stock	36.73	36.76	36.73	36.76	2038.0
2014-02-11 08:00:00	MSFT	Stock	36.96	37.01	36.9	36.92	14289.0
2014-02-11 09:00:00	MSFT	Stock	36.94	37.09	36.86	37.06	3643035.0
2014-02-11 10:00:00	MSFT	Stock	37.06	37.25	37.02	37.077	5502558.0
2014-02-11 11:00:00	MSFT	Stock	37.07	37.25	37.04	37.1	3377534.0
2014-02-11 12:00:00	MSFT	Stock	37.1	37.17	37.06	37.12	1994875.0
2014-02-11 13:00:00	MSFT	Stock	37.125	37.25	37.12	37.225	2092536.0
2014-02-11 14:00:00	MSFT	Stock	37.23	37.25	37.17	37.23	2503141.0
2014-02-11 15:00:00	MSFT	Stock	37.24	37.26	37.1	37.2	7304075.0
2014-02-11 16:00:00	MSFT	Stock	37.19	37.207	37.12	37.16	4678726.0
2014-02-11 17:00:00	MSFT	Stock	37.2	37.2	37.19	37.19	8158.0
2014-02-11 18:00:00	MSFT	Stock	37.15	37.2	37.15	37.2	16999.0
2014-02-11 19:00:00	MSFT	Stock	37.175	37.175	37.15	37.15	6518.0
2014-02-11 09:00:00	NVDA	Stock	0.4003	0.4015	0.3982	0.4011	10499480.0
2014-02-11 10:00:00	NVDA	Stock	0.4013	0.4018	0.4005	0.4008	24382760.0
2014-02-11 11:00:00	NVDA	Stock	0.4009	0.4031	0.4008	0.4028	24089120.0
2014-02-11 12:00:00	NVDA	Stock	0.4029	0.4038	0.4022	0.4034	25813320.0
2014-02-11 13:00:00	NVDA	Stock	0.4034	0.4038	0.4028	0.4035	20150800.0
2014-02-11 14:00:00	NVDA	Stock	0.4032	0.405	0.403	0.405	14445280.0
2014-02-11 15:00:00	NVDA	Stock	0.405	0.4072	0.4048	0.4061	92316560.0
2014-02-11 16:00:00	NVDA	Stock	0.4062	0.4069	0.4053	0.4053	4789960.0
2014-02-11 17:00:00	NVDA	Stock	0.4062	0.4062	0.4053	0.4053	16960.0
2014-02-11 19:00:00	NVDA	Stock	0.4062	0.4062	0.4062	0.4062	106440.0
2014-02-11 05:00:00	AMZN	Stock	18.1125	18.1125	18.1125	18.1125	2000.0
2014-02-11 08:00:00	AMZN	Stock	18.126	18.142	18.0845	18.103	82000.0
2014-02-11 09:00:00	AMZN	Stock	18.094	18.142	17.95	18.0225	8276860.0
2014-02-11 10:00:00	AMZN	Stock	18.0085	18.0225	17.9105	17.938	9133020.0
2014-02-11 11:00:00	AMZN	Stock	17.947	17.9635	17.8125	17.9105	10632260.0
2014-02-11 12:00:00	AMZN	Stock	17.9092	17.9995	17.868	17.994	5058640.0
2014-02-11 13:00:00	AMZN	Stock	17.996	18.1125	17.996	18.013	6866840.0
2014-02-11 14:00:00	AMZN	Stock	18.0188	18.1545	18.0075	18.135	5935280.0
2014-02-11 15:00:00	AMZN	Stock	18.1385	18.1805	18.0585	18.0895	10896200.0
2014-02-11 16:00:00	AMZN	Stock	18.0895	18.105	17.9363	18.0835	2549100.0
2014-02-11 17:00:00	AMZN	Stock	18.083	18.0895	18.0125	18.0895	56140.0

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

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