PREVIEW / stock_1hour / 2011-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-15.parquet
  size:    914 KB
  rows:    43,597
  symbols: 3,523

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
2011-11-15 04:00:00	AAPL	Stock	13.525	13.525	13.525	13.525	2800.0
2011-11-15 05:00:00	AAPL	Stock	13.5	13.5	13.4911	13.5	78400.0
2011-11-15 06:00:00	AAPL	Stock	13.4918	13.4918	13.4286	13.4643	32200.0
2011-11-15 07:00:00	AAPL	Stock	13.4693	13.5457	13.4554	13.5268	599284.0
2011-11-15 08:00:00	AAPL	Stock	13.5271	13.6364	13.5179	13.5843	2654008.0
2011-11-15 09:00:00	AAPL	Stock	13.5964	13.7296	13.545	13.7118	87055892.0
2011-11-15 10:00:00	AAPL	Stock	13.7117	13.75	13.6757	13.6986	68995640.0
2011-11-15 11:00:00	AAPL	Stock	13.6969	13.7496	13.6921	13.7472	39149992.0
2011-11-15 12:00:00	AAPL	Stock	13.7479	13.8621	13.7454	13.8525	69761244.0
2011-11-15 13:00:00	AAPL	Stock	13.8534	13.8732	13.8307	13.8404	37647848.0
2011-11-15 14:00:00	AAPL	Stock	13.8389	13.8925	13.8301	13.8821	39271008.0
2011-11-15 15:00:00	AAPL	Stock	13.8807	13.9107	13.8732	13.8864	64685096.0
2011-11-15 16:00:00	AAPL	Stock	13.8868	13.9012	13.5406	13.8964	11826528.0
2011-11-15 17:00:00	AAPL	Stock	13.8932	13.9018	13.8893	13.8982	469560.0
2011-11-15 18:00:00	AAPL	Stock	13.8971	13.8986	13.8857	13.8857	188608.0
2011-11-15 19:00:00	AAPL	Stock	13.88	13.8857	13.8686	13.875	92344.0
2011-11-15 04:00:00	MSFT	Stock	26.29	26.29	26.23	26.23	863.0
2011-11-15 06:00:00	MSFT	Stock	26.43	26.43	26.43	26.43	100.0
2011-11-15 07:00:00	MSFT	Stock	26.4	26.53	26.39	26.42	13901.0
2011-11-15 08:00:00	MSFT	Stock	26.44	26.58	26.44	26.48	36258.0
2011-11-15 09:00:00	MSFT	Stock	26.48	26.76	26.48	26.64	7774862.0
2011-11-15 10:00:00	MSFT	Stock	26.63	26.66	26.5	26.5	4847160.0
2011-11-15 11:00:00	MSFT	Stock	26.51	26.545	26.4	26.46	4702950.0
2011-11-15 12:00:00	MSFT	Stock	26.46	26.82	26.452	26.79	5588953.0
2011-11-15 13:00:00	MSFT	Stock	26.79	26.9	26.7	26.8	4740961.0
2011-11-15 14:00:00	MSFT	Stock	26.8	26.88	26.77	26.84	3422322.0
2011-11-15 15:00:00	MSFT	Stock	26.85	26.94	26.68	26.73	9638415.0
2011-11-15 16:00:00	MSFT	Stock	26.74	26.895	26.647	26.73	2252931.0
2011-11-15 17:00:00	MSFT	Stock	26.73	26.74	26.69	26.74	3975.0
2011-11-15 18:00:00	MSFT	Stock	26.74	26.75	26.74	26.75	8519.0
2011-11-15 19:00:00	MSFT	Stock	26.69	26.69	26.68	26.68	1890.0
2011-11-15 08:00:00	NVDA	Stock	0.3635	0.365	0.3635	0.365	133760.0
2011-11-15 09:00:00	NVDA	Stock	0.3658	0.3713	0.3632	0.3688	67157520.0
2011-11-15 10:00:00	NVDA	Stock	0.3688	0.37	0.3628	0.3658	77658960.0
2011-11-15 11:00:00	NVDA	Stock	0.3655	0.3695	0.365	0.369	71181760.0
2011-11-15 12:00:00	NVDA	Stock	0.3688	0.373	0.3688	0.3718	66439000.0
2011-11-15 13:00:00	NVDA	Stock	0.372	0.3735	0.3703	0.3719	62263000.0
2011-11-15 14:00:00	NVDA	Stock	0.372	0.3745	0.3713	0.3743	48824240.0
2011-11-15 15:00:00	NVDA	Stock	0.3743	0.3746	0.371	0.3718	96593640.0
2011-11-15 16:00:00	NVDA	Stock	0.3718	0.374	0.3692	0.374	14471800.0
2011-11-15 17:00:00	NVDA	Stock	0.3718	0.3718	0.371	0.371	30000.0
2011-11-15 18:00:00	NVDA	Stock	0.3705	0.3723	0.3705	0.3723	70400.0
2011-11-15 19:00:00	NVDA	Stock	0.3723	0.3723	0.3692	0.3723	90400.0
2011-11-15 06:00:00	AMZN	Stock	10.9125	10.9225	10.75	10.8445	50600.0
2011-11-15 07:00:00	AMZN	Stock	10.85	10.85	10.84	10.84	22200.0
2011-11-15 08:00:00	AMZN	Stock	10.8435	10.9235	10.8425	10.905	236520.0
2011-11-15 09:00:00	AMZN	Stock	10.9165	11.0164	10.8965	10.9	17443620.0
2011-11-15 10:00:00	AMZN	Stock	10.904	10.927	10.8125	10.844	19597640.0
2011-11-15 11:00:00	AMZN	Stock	10.8425	10.8705	10.713	10.7575	22370040.0
2011-11-15 12:00:00	AMZN	Stock	10.7608	10.85	10.7535	10.8433	14902480.0

> showing 50 of 43,597 rows — these rows as CSV

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