PREVIEW / stock_1hour / 2012-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-11.parquet
  size:    927 KB
  rows:    44,036
  symbols: 3,561

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
2012-01-11 04:00:00	AAPL	Stock	15.1071	15.1071	15.1071	15.1071	2800.0
2012-01-11 06:00:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	2800.0
2012-01-11 07:00:00	AAPL	Stock	15.0557	15.1421	15.0557	15.1071	165032.0
2012-01-11 08:00:00	AAPL	Stock	15.1071	15.1086	15.0536	15.0786	1041180.0
2012-01-11 09:00:00	AAPL	Stock	15.0846	15.0979	14.9893	15.0014	44730672.0
2012-01-11 10:00:00	AAPL	Stock	15.002	15.0804	14.9754	15.0409	45936464.0
2012-01-11 11:00:00	AAPL	Stock	15.04	15.05	15.0021	15.0329	22201088.0
2012-01-11 12:00:00	AAPL	Stock	15.0321	15.0429	15.0104	15.0221	15947708.0
2012-01-11 13:00:00	AAPL	Stock	15.0201	15.0643	15.0201	15.0386	16186044.0
2012-01-11 14:00:00	AAPL	Stock	15.0386	15.0668	15.0357	15.0489	15864016.0
2012-01-11 15:00:00	AAPL	Stock	15.0507	15.1018	15.0446	15.0911	41139308.0
2012-01-11 16:00:00	AAPL	Stock	15.0896	15.1071	15.042	15.0986	6914572.0
2012-01-11 17:00:00	AAPL	Stock	15.0986	15.1039	15.0911	15.0939	213136.0
2012-01-11 18:00:00	AAPL	Stock	15.1	15.1071	15.0911	15.105	62048.0
2012-01-11 19:00:00	AAPL	Stock	15.1068	15.1071	15.1	15.1071	78568.0
2012-01-11 05:00:00	MSFT	Stock	27.6	27.62	27.6	27.62	500.0
2012-01-11 06:00:00	MSFT	Stock	27.55	27.56	27.52	27.56	1500.0
2012-01-11 07:00:00	MSFT	Stock	27.56	27.56	27.43	27.54	80164.0
2012-01-11 08:00:00	MSFT	Stock	27.5	27.54	27.38	27.45	318997.0
2012-01-11 09:00:00	MSFT	Stock	27.46	27.72	27.36	27.5	11268847.0
2012-01-11 10:00:00	MSFT	Stock	27.5	27.91	27.47	27.89	11086517.0
2012-01-11 11:00:00	MSFT	Stock	27.89	27.91	27.84	27.86	9566881.0
2012-01-11 12:00:00	MSFT	Stock	27.859	27.876	27.79	27.84	6610065.0
2012-01-11 13:00:00	MSFT	Stock	27.835	27.96	27.83	27.89	8350337.0
2012-01-11 14:00:00	MSFT	Stock	27.883	27.97	27.88	27.942	5227062.0
2012-01-11 15:00:00	MSFT	Stock	27.94	27.955	27.72	27.72	10351744.0
2012-01-11 16:00:00	MSFT	Stock	27.73	27.92	27.62	27.68	1890698.0
2012-01-11 17:00:00	MSFT	Stock	27.68	27.72	27.66	27.69	20638.0
2012-01-11 18:00:00	MSFT	Stock	27.72	27.72	27.72	27.72	7383.0
2012-01-11 19:00:00	MSFT	Stock	27.72	27.75	27.68	27.75	4110.0
2012-01-11 07:00:00	NVDA	Stock	0.3612	0.3612	0.3612	0.3612	4000.0
2012-01-11 08:00:00	NVDA	Stock	0.36	0.3612	0.3595	0.3595	193600.0
2012-01-11 09:00:00	NVDA	Stock	0.3588	0.362	0.3553	0.3558	55065640.0
2012-01-11 10:00:00	NVDA	Stock	0.3558	0.3598	0.3533	0.3565	91719840.0
2012-01-11 11:00:00	NVDA	Stock	0.3565	0.3576	0.3542	0.3543	61438560.0
2012-01-11 12:00:00	NVDA	Stock	0.3545	0.3568	0.3544	0.356	35480360.0
2012-01-11 13:00:00	NVDA	Stock	0.3562	0.3572	0.3545	0.3548	45072080.0
2012-01-11 14:00:00	NVDA	Stock	0.3548	0.356	0.3545	0.355	45704320.0
2012-01-11 15:00:00	NVDA	Stock	0.355	0.3553	0.3533	0.3548	139198720.0
2012-01-11 16:00:00	NVDA	Stock	0.3548	0.3564	0.3542	0.3553	1542160.0
2012-01-11 17:00:00	NVDA	Stock	0.3558	0.3558	0.3553	0.3553	796000.0
2012-01-11 18:00:00	NVDA	Stock	0.3548	0.3568	0.3548	0.3562	354400.0
2012-01-11 19:00:00	NVDA	Stock	0.3555	0.3555	0.3555	0.3555	20000.0
2012-01-11 05:00:00	AMZN	Stock	8.9625	8.9625	8.9625	8.9625	2000.0
2012-01-11 06:00:00	AMZN	Stock	8.9625	8.9625	8.9625	8.9625	2000.0
2012-01-11 07:00:00	AMZN	Stock	8.9465	8.95	8.945	8.95	8000.0
2012-01-11 08:00:00	AMZN	Stock	8.917	8.9435	8.9005	8.9435	28200.0
2012-01-11 09:00:00	AMZN	Stock	8.949	9.0165	8.925	8.9365	10402560.0
2012-01-11 10:00:00	AMZN	Stock	8.9381	9.0385	8.9095	8.9925	12476740.0
2012-01-11 11:00:00	AMZN	Stock	8.9922	9.008	8.941	8.9425	7984900.0

> showing 50 of 44,036 rows — these rows as CSV

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