PREVIEW / stock_1hour / 2014-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-11.parquet
  size:    1.0 MB
  rows:    48,582
  symbols: 3,575

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-08-11 04:00:00	AAPL	Stock	23.8875	23.8875	23.7775	23.7975	28420.0
2014-08-11 05:00:00	AAPL	Stock	23.7975	23.8125	23.79	23.8	8264.0
2014-08-11 06:00:00	AAPL	Stock	23.795	23.8625	23.79	23.8625	30620.0
2014-08-11 07:00:00	AAPL	Stock	23.8525	23.8625	23.8125	23.825	176960.0
2014-08-11 08:00:00	AAPL	Stock	23.84	23.8625	23.7825	23.825	680252.0
2014-08-11 09:00:00	AAPL	Stock	23.83	23.8675	23.709	23.855	22639864.0
2014-08-11 10:00:00	AAPL	Stock	23.8575	24.02	23.855	23.975	29751708.0
2014-08-11 11:00:00	AAPL	Stock	23.975	24.0	23.9425	23.96	16796448.0
2014-08-11 12:00:00	AAPL	Stock	23.9587	23.9975	23.915	23.9625	11815796.0
2014-08-11 13:00:00	AAPL	Stock	23.9625	23.9925	23.93	23.9525	8727652.0
2014-08-11 14:00:00	AAPL	Stock	23.9525	23.9725	23.9	23.9625	12061168.0
2014-08-11 15:00:00	AAPL	Stock	23.9638	24.0125	23.9525	23.995	22888200.0
2014-08-11 16:00:00	AAPL	Stock	23.9975	24.015	23.9382	24.015	10488876.0
2014-08-11 17:00:00	AAPL	Stock	24.0125	24.0175	23.9975	24.005	131840.0
2014-08-11 18:00:00	AAPL	Stock	24.01	24.0375	23.9975	24.0375	213016.0
2014-08-11 19:00:00	AAPL	Stock	24.0425	24.0575	23.9975	24.0525	179064.0
2014-08-11 05:00:00	MSFT	Stock	43.36	43.36	43.36	43.36	100.0
2014-08-11 06:00:00	MSFT	Stock	43.36	43.42	43.36	43.42	400.0
2014-08-11 07:00:00	MSFT	Stock	43.38	43.45	43.38	43.45	249.0
2014-08-11 08:00:00	MSFT	Stock	43.4	43.49	43.4	43.43	6196.0
2014-08-11 09:00:00	MSFT	Stock	43.45	43.45	43.03	43.12	2613790.0
2014-08-11 10:00:00	MSFT	Stock	43.12	43.17	43.02	43.08	2741100.0
2014-08-11 11:00:00	MSFT	Stock	43.07	43.435	43.04	43.366	2954927.0
2014-08-11 12:00:00	MSFT	Stock	43.36	43.45	43.27	43.28	1613418.0
2014-08-11 13:00:00	MSFT	Stock	43.28	43.29	43.1	43.1	1426435.0
2014-08-11 14:00:00	MSFT	Stock	43.1	43.21	43.06	43.16	2130030.0
2014-08-11 15:00:00	MSFT	Stock	43.155	43.22	43.12	43.19	4124472.0
2014-08-11 16:00:00	MSFT	Stock	43.2	43.299	43.17	43.299	1446934.0
2014-08-11 17:00:00	MSFT	Stock	43.2	43.2	43.2	43.2	4945.0
2014-08-11 18:00:00	MSFT	Stock	43.2	43.2	43.2	43.2	516496.0
2014-08-11 19:00:00	MSFT	Stock	43.2	43.2	43.2	43.2	975.0
2014-08-11 08:00:00	NVDA	Stock	0.4782	0.48	0.4782	0.48	153200.0
2014-08-11 09:00:00	NVDA	Stock	0.479	0.479	0.4745	0.4757	55262720.0
2014-08-11 10:00:00	NVDA	Stock	0.476	0.4765	0.4751	0.4763	44739400.0
2014-08-11 11:00:00	NVDA	Stock	0.476	0.4772	0.475	0.4754	51854680.0
2014-08-11 12:00:00	NVDA	Stock	0.4753	0.4755	0.4732	0.4742	40161920.0
2014-08-11 13:00:00	NVDA	Stock	0.4744	0.4758	0.4714	0.4723	27599880.0
2014-08-11 14:00:00	NVDA	Stock	0.4725	0.4735	0.4713	0.4728	42715240.0
2014-08-11 15:00:00	NVDA	Stock	0.4728	0.4738	0.4723	0.4726	65493840.0
2014-08-11 16:00:00	NVDA	Stock	0.4725	0.4744	0.4725	0.4725	1024240.0
2014-08-11 05:00:00	AMZN	Stock	15.8905	15.8905	15.89	15.89	22000.0
2014-08-11 06:00:00	AMZN	Stock	15.92	15.92	15.92	15.92	2000.0
2014-08-11 08:00:00	AMZN	Stock	15.9095	15.9305	15.904	15.928	74900.0
2014-08-11 09:00:00	AMZN	Stock	15.922	16.014	15.8975	16.01	8750580.0
2014-08-11 10:00:00	AMZN	Stock	16.01	16.019	15.853	15.8635	9093740.0
2014-08-11 11:00:00	AMZN	Stock	15.8635	15.93	15.844	15.9118	5621540.0
2014-08-11 12:00:00	AMZN	Stock	15.914	15.952	15.906	15.93	3204820.0
2014-08-11 13:00:00	AMZN	Stock	15.9355	15.9525	15.9015	15.9212	3365920.0
2014-08-11 14:00:00	AMZN	Stock	15.9236	15.9525	15.8925	15.9335	5077920.0
2014-08-11 15:00:00	AMZN	Stock	15.932	15.9555	15.897	15.916	7400160.0

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

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