PREVIEW / stock_1hour / 2012-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-26.parquet
  size:    951 KB
  rows:    45,566
  symbols: 3,520

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-26 04:00:00	AAPL	Stock	15.9754	16.0489	15.9729	16.0382	140000.0
2012-01-26 05:00:00	AAPL	Stock	16.0304	16.0461	16.0179	16.0179	75600.0
2012-01-26 06:00:00	AAPL	Stock	16.0321	16.0379	16.0179	16.0179	61600.0
2012-01-26 07:00:00	AAPL	Stock	16.0179	16.0357	16.0043	16.0214	1009848.0
2012-01-26 08:00:00	AAPL	Stock	16.025	16.035	15.9514	15.9929	1383536.0
2012-01-26 09:00:00	AAPL	Stock	15.9929	16.0425	15.9243	16.0036	64223992.0
2012-01-26 10:00:00	AAPL	Stock	16.0036	16.0036	15.8611	15.8664	68720176.0
2012-01-26 11:00:00	AAPL	Stock	15.8668	15.9164	15.8514	15.9054	40833996.0
2012-01-26 12:00:00	AAPL	Stock	15.9043	15.9057	15.8625	15.8796	27358884.0
2012-01-26 13:00:00	AAPL	Stock	15.8782	15.8804	15.8489	15.8779	27838216.0
2012-01-26 14:00:00	AAPL	Stock	15.8779	15.8846	15.85	15.8671	23958088.0
2012-01-26 15:00:00	AAPL	Stock	15.8668	15.8811	15.8264	15.8771	55463912.0
2012-01-26 16:00:00	AAPL	Stock	15.8796	15.9201	15.8306	15.8754	1508080.0
2012-01-26 17:00:00	AAPL	Stock	15.9521	15.9521	15.8621	15.8932	488628.0
2012-01-26 18:00:00	AAPL	Stock	15.8921	15.8929	15.8818	15.8893	51184.0
2012-01-26 19:00:00	AAPL	Stock	15.8893	15.8893	15.8625	15.8625	232288.0
2012-01-26 05:00:00	MSFT	Stock	29.63	29.63	29.63	29.63	1000.0
2012-01-26 06:00:00	MSFT	Stock	29.56	29.56	29.55	29.55	1100.0
2012-01-26 07:00:00	MSFT	Stock	29.55	29.65	29.55	29.65	2000.0
2012-01-26 08:00:00	MSFT	Stock	29.64	29.7	29.59	29.65	20463.0
2012-01-26 09:00:00	MSFT	Stock	29.65	29.69	29.49	29.61	4934489.0
2012-01-26 10:00:00	MSFT	Stock	29.61	29.7	29.51	29.53	9118698.0
2012-01-26 11:00:00	MSFT	Stock	29.53	29.675	29.52	29.622	7292188.0
2012-01-26 12:00:00	MSFT	Stock	29.628	29.636	29.52	29.59	5005399.0
2012-01-26 13:00:00	MSFT	Stock	29.585	29.6	29.48	29.58	3610531.0
2012-01-26 14:00:00	MSFT	Stock	29.572	29.58	29.4	29.51	6502232.0
2012-01-26 15:00:00	MSFT	Stock	29.51	29.54	29.43	29.51	9517168.0
2012-01-26 16:00:00	MSFT	Stock	29.51	29.564	29.45	29.5	2312047.0
2012-01-26 17:00:00	MSFT	Stock	29.45	29.5	29.45	29.45	1700.0
2012-01-26 18:00:00	MSFT	Stock	29.45	29.5	29.45	29.5	660.0
2012-01-26 19:00:00	MSFT	Stock	29.5	29.5	29.45	29.45	4100.0
2012-01-26 06:00:00	NVDA	Stock	0.3743	0.3743	0.3733	0.3733	140000.0
2012-01-26 07:00:00	NVDA	Stock	0.375	0.375	0.375	0.375	146000.0
2012-01-26 08:00:00	NVDA	Stock	0.375	0.3763	0.3738	0.3763	606560.0
2012-01-26 09:00:00	NVDA	Stock	0.3763	0.381	0.3715	0.3738	137784000.0
2012-01-26 10:00:00	NVDA	Stock	0.374	0.375	0.369	0.3698	148727400.0
2012-01-26 11:00:00	NVDA	Stock	0.3695	0.3733	0.3682	0.372	102106040.0
2012-01-26 12:00:00	NVDA	Stock	0.372	0.3733	0.3698	0.3705	55566520.0
2012-01-26 13:00:00	NVDA	Stock	0.3704	0.3738	0.3698	0.3718	58618920.0
2012-01-26 14:00:00	NVDA	Stock	0.3715	0.3733	0.371	0.372	101839600.0
2012-01-26 15:00:00	NVDA	Stock	0.3723	0.3723	0.3658	0.368	169207920.0
2012-01-26 16:00:00	NVDA	Stock	0.368	0.375	0.3672	0.3672	7234840.0
2012-01-26 17:00:00	NVDA	Stock	0.3713	0.3713	0.3665	0.3665	1082000.0
2012-01-26 18:00:00	NVDA	Stock	0.366	0.3665	0.366	0.3665	24000.0
2012-01-26 19:00:00	NVDA	Stock	0.3665	0.3665	0.3662	0.3662	136000.0
2012-01-26 07:00:00	AMZN	Stock	9.425	9.425	9.425	9.425	3920.0
2012-01-26 08:00:00	AMZN	Stock	9.425	9.44	9.4025	9.4125	262580.0
2012-01-26 09:00:00	AMZN	Stock	9.4125	9.694	9.385	9.687	24275920.0
2012-01-26 10:00:00	AMZN	Stock	9.6845	9.7425	9.6005	9.645	23844320.0
2012-01-26 11:00:00	AMZN	Stock	9.6463	9.6893	9.6106	9.658	11620860.0

> showing 50 of 45,566 rows — these rows as CSV

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