PREVIEW / stock_1hour / 2014-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-15.parquet
  size:    1.0 MB
  rows:    48,131
  symbols: 3,545

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-15 07:00:00	AAPL	Stock	18.6661	18.6786	18.65	18.6607	44632.0
2014-04-15 08:00:00	AAPL	Stock	18.6518	18.6693	18.5932	18.5968	385868.0
2014-04-15 09:00:00	AAPL	Stock	18.5964	18.63	18.5215	18.5846	21989352.0
2014-04-15 10:00:00	AAPL	Stock	18.5839	18.6139	18.3704	18.3811	44869356.0
2014-04-15 11:00:00	AAPL	Stock	18.3771	18.45	18.3571	18.3575	26712616.0
2014-04-15 12:00:00	AAPL	Stock	18.3632	18.3757	18.2975	18.2986	26327700.0
2014-04-15 13:00:00	AAPL	Stock	18.2971	18.4232	18.2618	18.4179	25863544.0
2014-04-15 14:00:00	AAPL	Stock	18.4189	18.5193	18.3975	18.4925	22262912.0
2014-04-15 15:00:00	AAPL	Stock	18.4907	18.5254	18.4471	18.4964	27206984.0
2014-04-15 16:00:00	AAPL	Stock	18.4982	18.55	18.4454	18.5	7534660.0
2014-04-15 17:00:00	AAPL	Stock	18.5089	18.5196	18.4996	18.5	156604.0
2014-04-15 18:00:00	AAPL	Stock	18.4929	18.5071	18.4911	18.4996	406084.0
2014-04-15 19:00:00	AAPL	Stock	18.4936	18.5	18.4914	18.4996	109508.0
2014-04-15 08:00:00	MSFT	Stock	39.2	39.25	39.2	39.23	2000.0
2014-04-15 09:00:00	MSFT	Stock	39.25	39.81	39.19	39.73	4346372.0
2014-04-15 10:00:00	MSFT	Stock	39.72	39.79	39.27	39.33	4895898.0
2014-04-15 11:00:00	MSFT	Stock	39.33	39.49	39.19	39.265	3399984.0
2014-04-15 12:00:00	MSFT	Stock	39.265	39.287	39.075	39.109	2272898.0
2014-04-15 13:00:00	MSFT	Stock	39.1	39.44	39.05	39.41	2836476.0
2014-04-15 14:00:00	MSFT	Stock	39.405	39.895	39.405	39.75	3898915.0
2014-04-15 15:00:00	MSFT	Stock	39.75	39.96	39.67	39.74	8161676.0
2014-04-15 16:00:00	MSFT	Stock	39.75	39.95	39.533	39.95	2830319.0
2014-04-15 17:00:00	MSFT	Stock	40.08	40.08	39.95	39.95	2520.0
2014-04-15 18:00:00	MSFT	Stock	39.81	39.81	39.81	39.81	400.0
2014-04-15 19:00:00	MSFT	Stock	39.97	39.97	39.97	39.97	9800.0
2014-04-15 09:00:00	NVDA	Stock	0.4585	0.4635	0.458	0.4585	16908960.0
2014-04-15 10:00:00	NVDA	Stock	0.4585	0.4605	0.4552	0.4573	45410000.0
2014-04-15 11:00:00	NVDA	Stock	0.4572	0.4588	0.4556	0.4562	43094320.0
2014-04-15 12:00:00	NVDA	Stock	0.4562	0.4582	0.455	0.4552	47594800.0
2014-04-15 13:00:00	NVDA	Stock	0.4552	0.4605	0.454	0.4603	38532720.0
2014-04-15 14:00:00	NVDA	Stock	0.4603	0.4622	0.4581	0.4605	25375640.0
2014-04-15 15:00:00	NVDA	Stock	0.4605	0.4638	0.4593	0.4611	62681720.0
2014-04-15 16:00:00	NVDA	Stock	0.4612	0.4643	0.4612	0.4614	14403480.0
2014-04-15 07:00:00	AMZN	Stock	15.8375	15.8375	15.8375	15.8375	6980.0
2014-04-15 08:00:00	AMZN	Stock	15.85	15.85	15.844	15.844	15000.0
2014-04-15 09:00:00	AMZN	Stock	15.843	15.914	15.6745	15.7635	6721040.0
2014-04-15 10:00:00	AMZN	Stock	15.76	15.862	15.36	15.39	22504920.0
2014-04-15 11:00:00	AMZN	Stock	15.383	15.56	15.275	15.335	15388420.0
2014-04-15 12:00:00	AMZN	Stock	15.324	15.447	15.288	15.3775	9778420.0
2014-04-15 13:00:00	AMZN	Stock	15.371	15.666	15.353	15.652	11551980.0
2014-04-15 14:00:00	AMZN	Stock	15.6545	15.8435	15.5541	15.765	11758320.0
2014-04-15 15:00:00	AMZN	Stock	15.766	15.8635	15.6975	15.8	16485980.0
2014-04-15 16:00:00	AMZN	Stock	15.804	15.907	15.5878	15.8059	2597740.0
2014-04-15 17:00:00	AMZN	Stock	15.8645	15.901	15.8645	15.9	21240.0
2014-04-15 19:00:00	AMZN	Stock	15.9365	15.9365	15.914	15.9195	8400.0
2014-04-15 07:00:00	GOOGL	Stock	27.4	27.45	27.4	27.45	6000.0
2014-04-15 08:00:00	GOOGL	Stock	27.492	27.5545	27.46	27.498	46000.0
2014-04-15 09:00:00	GOOGL	Stock	27.4915	27.6445	27.4369	27.4793	7571760.0
2014-04-15 10:00:00	GOOGL	Stock	27.472	27.5088	26.8635	26.9342	11899100.0
2014-04-15 11:00:00	GOOGL	Stock	26.924	26.9805	26.695	26.728	8501320.0

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

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