PREVIEW / stock_1hour / 2013-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-09.parquet
  size:    1011 KB
  rows:    46,803
  symbols: 3,539

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-10-09 04:00:00	AAPL	Stock	17.2857	17.3036	17.2536	17.2721	47600.0
2013-10-09 05:00:00	AAPL	Stock	17.2857	17.3346	17.2857	17.3346	37912.0
2013-10-09 06:00:00	AAPL	Stock	17.34	17.3629	17.3393	17.3393	49700.0
2013-10-09 07:00:00	AAPL	Stock	17.3461	17.3543	17.3071	17.3157	280728.0
2013-10-09 08:00:00	AAPL	Stock	17.3114	17.3571	17.1786	17.3046	1789508.0
2013-10-09 09:00:00	AAPL	Stock	17.2982	17.3189	17.1796	17.2696	42042504.0
2013-10-09 10:00:00	AAPL	Stock	17.2661	17.2975	17.1893	17.1956	50510992.0
2013-10-09 11:00:00	AAPL	Stock	17.1921	17.2104	17.0814	17.1611	40969432.0
2013-10-09 12:00:00	AAPL	Stock	17.1614	17.2539	17.1466	17.2096	22349432.0
2013-10-09 13:00:00	AAPL	Stock	17.2079	17.2943	17.2079	17.265	25122076.0
2013-10-09 14:00:00	AAPL	Stock	17.265	17.4211	17.2446	17.4121	43012900.0
2013-10-09 15:00:00	AAPL	Stock	17.4139	17.4179	17.3125	17.3682	44522772.0
2013-10-09 16:00:00	AAPL	Stock	17.3679	17.3796	17.1771	17.3732	14070392.0
2013-10-09 17:00:00	AAPL	Stock	17.3679	17.3679	17.3568	17.3614	175868.0
2013-10-09 18:00:00	AAPL	Stock	17.3679	17.3893	17.3643	17.3875	255052.0
2013-10-09 19:00:00	AAPL	Stock	17.3893	17.4129	17.3893	17.4129	223860.0
2013-10-09 08:00:00	MSFT	Stock	33.05	33.08	33.01	33.05	8011.0
2013-10-09 09:00:00	MSFT	Stock	33.05	33.35	33.01	33.29	3751465.0
2013-10-09 10:00:00	MSFT	Stock	33.29	33.33	33.01	33.02	5538935.0
2013-10-09 11:00:00	MSFT	Stock	33.02	33.3	32.96	33.16	6693864.0
2013-10-09 12:00:00	MSFT	Stock	33.16	33.2	32.98	33.01	3371305.0
2013-10-09 13:00:00	MSFT	Stock	33.013	33.325	33.01	33.18	3386359.0
2013-10-09 14:00:00	MSFT	Stock	33.18	33.23	33.1	33.164	3241554.0
2013-10-09 15:00:00	MSFT	Stock	33.16	33.27	33.05	33.08	7480806.0
2013-10-09 16:00:00	MSFT	Stock	33.08	33.23	32.9	33.07	1660494.0
2013-10-09 17:00:00	MSFT	Stock	33.08	33.174	33.04	33.04	6370.0
2013-10-09 18:00:00	MSFT	Stock	33.04	33.1	33.04	33.1	34311.0
2013-10-09 19:00:00	MSFT	Stock	33.13	33.15	33.12	33.12	1081.0
2013-10-09 09:00:00	NVDA	Stock	0.389	0.3893	0.3838	0.386	35908400.0
2013-10-09 10:00:00	NVDA	Stock	0.386	0.3862	0.383	0.383	39199280.0
2013-10-09 11:00:00	NVDA	Stock	0.383	0.383	0.3785	0.38	40366640.0
2013-10-09 12:00:00	NVDA	Stock	0.38	0.3815	0.3795	0.3795	26835360.0
2013-10-09 13:00:00	NVDA	Stock	0.3798	0.3838	0.3795	0.3838	19949720.0
2013-10-09 14:00:00	NVDA	Stock	0.3838	0.3845	0.382	0.3828	22490840.0
2013-10-09 15:00:00	NVDA	Stock	0.3829	0.3833	0.3798	0.3806	78814520.0
2013-10-09 16:00:00	NVDA	Stock	0.3805	0.3809	0.3805	0.3805	2221560.0
2013-10-09 07:00:00	AMZN	Stock	15.315	15.33	15.315	15.33	16140.0
2013-10-09 08:00:00	AMZN	Stock	15.275	15.275	15.171	15.2085	70660.0
2013-10-09 09:00:00	AMZN	Stock	15.164	15.1895	14.8655	14.944	11118540.0
2013-10-09 10:00:00	AMZN	Stock	14.9468	15.049	14.8251	14.988	14225780.0
2013-10-09 11:00:00	AMZN	Stock	14.979	15.0175	14.8375	14.8865	7674660.0
2013-10-09 12:00:00	AMZN	Stock	14.8868	14.9955	14.872	14.9015	3670280.0
2013-10-09 13:00:00	AMZN	Stock	14.901	15.015	14.9	14.975	7363440.0
2013-10-09 14:00:00	AMZN	Stock	14.975	14.9975	14.91	14.989	7228180.0
2013-10-09 15:00:00	AMZN	Stock	14.989	14.995	14.8875	14.9075	11542780.0
2013-10-09 16:00:00	AMZN	Stock	14.9115	14.9848	14.9085	14.922	501660.0
2013-10-09 17:00:00	AMZN	Stock	14.9175	14.93	14.9175	14.93	8000.0
2013-10-09 18:00:00	AMZN	Stock	14.9115	14.951	14.9115	14.945	84620.0
2013-10-09 19:00:00	AMZN	Stock	14.962	14.962	14.9385	14.949	19820.0
2013-10-09 04:00:00	META	Stock	47.26	47.4	47.2	47.4	19088.0

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

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