PREVIEW / stock_1hour / 2013-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-20.parquet
  size:    1004 KB
  rows:    46,641
  symbols: 3,507

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-05-20 04:00:00	AAPL	Stock	15.4696	15.4696	15.4696	15.4696	2800.0
2013-05-20 05:00:00	AAPL	Stock	15.4857	15.4857	15.4857	15.4857	2800.0
2013-05-20 06:00:00	AAPL	Stock	15.51	15.5175	15.51	15.5154	8400.0
2013-05-20 07:00:00	AAPL	Stock	15.5154	15.5154	15.4639	15.4639	71176.0
2013-05-20 08:00:00	AAPL	Stock	15.4643	15.5143	15.4286	15.4464	505764.0
2013-05-20 09:00:00	AAPL	Stock	15.45	15.6896	15.3607	15.6767	64951824.0
2013-05-20 10:00:00	AAPL	Stock	15.6789	15.7942	15.6296	15.7682	78635284.0
2013-05-20 11:00:00	AAPL	Stock	15.7668	15.8921	15.7664	15.8468	65499392.0
2013-05-20 12:00:00	AAPL	Stock	15.8471	15.8471	15.7446	15.7986	36064084.0
2013-05-20 13:00:00	AAPL	Stock	15.7964	15.845	15.7321	15.7721	40479880.0
2013-05-20 14:00:00	AAPL	Stock	15.7721	15.8714	15.7454	15.8243	31862880.0
2013-05-20 15:00:00	AAPL	Stock	15.8236	15.9214	15.8054	15.8143	68947788.0
2013-05-20 16:00:00	AAPL	Stock	15.8125	15.8189	15.6672	15.8107	33703180.0
2013-05-20 17:00:00	AAPL	Stock	15.8075	15.8075	15.4736	15.7304	2313668.0
2013-05-20 18:00:00	AAPL	Stock	15.7232	15.7279	15.7086	15.7093	424648.0
2013-05-20 19:00:00	AAPL	Stock	15.7089	15.7139	15.7007	15.7007	427168.0
2013-05-20 06:00:00	MSFT	Stock	34.9	34.9	34.9	34.9	250.0
2013-05-20 07:00:00	MSFT	Stock	34.89	34.89	34.79	34.79	2335.0
2013-05-20 08:00:00	MSFT	Stock	34.7	34.82	34.67	34.68	41904.0
2013-05-20 09:00:00	MSFT	Stock	34.77	34.87	34.68	34.742	5341042.0
2013-05-20 10:00:00	MSFT	Stock	34.74	34.98	34.74	34.89	7255545.0
2013-05-20 11:00:00	MSFT	Stock	34.89	34.97	34.87	34.963	4959181.0
2013-05-20 12:00:00	MSFT	Stock	34.97	34.97	34.89	34.905	4049736.0
2013-05-20 13:00:00	MSFT	Stock	34.905	34.92	34.82	34.89	4800154.0
2013-05-20 14:00:00	MSFT	Stock	34.899	35.03	34.87	35.03	6891973.0
2013-05-20 15:00:00	MSFT	Stock	35.03	35.095	34.87	35.09	12400997.0
2013-05-20 16:00:00	MSFT	Stock	35.09	35.14	34.919	35.07	3433041.0
2013-05-20 17:00:00	MSFT	Stock	34.73	35.08	34.73	35.04	96334.0
2013-05-20 18:00:00	MSFT	Stock	35.07	35.12	35.07	35.1	3840.0
2013-05-20 19:00:00	MSFT	Stock	35.09	35.1	35.06	35.09	1285.0
2013-05-20 09:00:00	NVDA	Stock	0.3715	0.372	0.369	0.3713	29224280.0
2013-05-20 10:00:00	NVDA	Stock	0.371	0.3713	0.3695	0.3703	27674400.0
2013-05-20 11:00:00	NVDA	Stock	0.3703	0.372	0.3698	0.3718	31423000.0
2013-05-20 12:00:00	NVDA	Stock	0.372	0.372	0.37	0.3718	20461200.0
2013-05-20 13:00:00	NVDA	Stock	0.3718	0.3718	0.3698	0.371	32398640.0
2013-05-20 14:00:00	NVDA	Stock	0.3708	0.3724	0.3704	0.3713	37036840.0
2013-05-20 15:00:00	NVDA	Stock	0.3711	0.372	0.3708	0.371	40727320.0
2013-05-20 16:00:00	NVDA	Stock	0.371	0.3715	0.3708	0.3708	1522680.0
2013-05-20 17:00:00	NVDA	Stock	0.3698	0.3725	0.3698	0.3725	17800.0
2013-05-20 08:00:00	AMZN	Stock	13.455	13.47	13.415	13.415	78000.0
2013-05-20 09:00:00	AMZN	Stock	13.46	13.5895	13.3865	13.4255	9682100.0
2013-05-20 10:00:00	AMZN	Stock	13.4275	13.4565	13.363	13.3995	9300240.0
2013-05-20 11:00:00	AMZN	Stock	13.3996	13.48	13.375	13.4785	6380640.0
2013-05-20 12:00:00	AMZN	Stock	13.477	13.4785	13.3855	13.3965	2975980.0
2013-05-20 13:00:00	AMZN	Stock	13.4	13.406	13.336	13.345	3412420.0
2013-05-20 14:00:00	AMZN	Stock	13.3511	13.4335	13.325	13.403	3725000.0
2013-05-20 15:00:00	AMZN	Stock	13.406	13.4525	13.3685	13.382	6144140.0
2013-05-20 16:00:00	AMZN	Stock	13.3825	13.4249	13.373	13.3915	613520.0
2013-05-20 17:00:00	AMZN	Stock	13.3925	13.3925	13.3915	13.3915	10000.0
2013-05-20 19:00:00	AMZN	Stock	13.3955	13.3955	13.3955	13.3955	2000.0

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

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