PREVIEW / stock_1hour / 2011-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-09.parquet
  size:    920 KB
  rows:    43,982
  symbols: 3,537

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-12-09 04:00:00	AAPL	Stock	14.0	14.0179	14.0	14.0179	8400.0
2011-12-09 05:00:00	AAPL	Stock	14.0339	14.0357	14.0321	14.0357	44072.0
2011-12-09 06:00:00	AAPL	Stock	14.0621	14.0636	14.0475	14.0636	44520.0
2011-12-09 07:00:00	AAPL	Stock	14.0579	14.0925	14.0464	14.0536	671664.0
2011-12-09 08:00:00	AAPL	Stock	14.0539	14.0625	14.01	14.02	1845312.0
2011-12-09 09:00:00	AAPL	Stock	14.0218	14.0657	13.9743	14.0086	50477756.0
2011-12-09 10:00:00	AAPL	Stock	14.0125	14.0457	13.9654	14.0342	59387468.0
2011-12-09 11:00:00	AAPL	Stock	14.0314	14.0454	14.0114	14.0332	34497736.0
2011-12-09 12:00:00	AAPL	Stock	14.0343	14.0532	14.0179	14.0407	23683660.0
2011-12-09 13:00:00	AAPL	Stock	14.0414	14.0571	14.0229	14.0321	22092728.0
2011-12-09 14:00:00	AAPL	Stock	14.0329	14.0482	14.0286	14.0386	26689992.0
2011-12-09 15:00:00	AAPL	Stock	14.0393	14.0729	14.0304	14.0589	67107320.0
2011-12-09 16:00:00	AAPL	Stock	14.058	14.0711	14.0081	14.0711	8296736.0
2011-12-09 17:00:00	AAPL	Stock	14.0664	14.0711	14.0629	14.0679	186256.0
2011-12-09 18:00:00	AAPL	Stock	14.0693	14.0821	14.0579	14.0786	233240.0
2011-12-09 19:00:00	AAPL	Stock	14.0804	14.0871	14.0754	14.0757	103908.0
2011-12-09 06:00:00	MSFT	Stock	25.63	25.7	25.63	25.7	1800.0
2011-12-09 07:00:00	MSFT	Stock	25.69	25.7	25.58	25.6	11700.0
2011-12-09 08:00:00	MSFT	Stock	25.61	25.63	25.46	25.48	540309.0
2011-12-09 09:00:00	MSFT	Stock	25.5	25.765	25.47	25.68	7013756.0
2011-12-09 10:00:00	MSFT	Stock	25.685	25.845	25.67	25.82	8585814.0
2011-12-09 11:00:00	MSFT	Stock	25.821	25.85	25.76	25.78	5841590.0
2011-12-09 12:00:00	MSFT	Stock	25.78	25.84	25.74	25.8	4567324.0
2011-12-09 13:00:00	MSFT	Stock	25.805	25.85	25.76	25.832	3542650.0
2011-12-09 14:00:00	MSFT	Stock	25.83	25.87	25.75	25.822	6307471.0
2011-12-09 15:00:00	MSFT	Stock	25.827	25.83	25.7	25.7	13769487.0
2011-12-09 16:00:00	MSFT	Stock	25.7	25.851	25.535	25.74	2287287.0
2011-12-09 17:00:00	MSFT	Stock	25.699	25.74	25.699	25.74	165480.0
2011-12-09 18:00:00	MSFT	Stock	25.7	25.71	25.7	25.71	6170.0
2011-12-09 19:00:00	MSFT	Stock	25.71	25.73	25.7	25.71	1928.0
2011-12-09 06:00:00	NVDA	Stock	0.3672	0.3672	0.3672	0.3672	56000.0
2011-12-09 07:00:00	NVDA	Stock	0.3672	0.3672	0.3672	0.3672	104000.0
2011-12-09 08:00:00	NVDA	Stock	0.3672	0.3672	0.3632	0.3648	978000.0
2011-12-09 09:00:00	NVDA	Stock	0.3645	0.368	0.3594	0.368	74950920.0
2011-12-09 10:00:00	NVDA	Stock	0.368	0.3715	0.3652	0.368	69129840.0
2011-12-09 11:00:00	NVDA	Stock	0.368	0.3698	0.3672	0.3678	48028240.0
2011-12-09 12:00:00	NVDA	Stock	0.3678	0.3692	0.3665	0.3668	45743640.0
2011-12-09 13:00:00	NVDA	Stock	0.367	0.3689	0.3652	0.3682	59674760.0
2011-12-09 14:00:00	NVDA	Stock	0.3682	0.3718	0.3682	0.3709	64514840.0
2011-12-09 15:00:00	NVDA	Stock	0.371	0.3755	0.369	0.3728	176158000.0
2011-12-09 16:00:00	NVDA	Stock	0.3738	0.3738	0.3687	0.3725	4028760.0
2011-12-09 17:00:00	NVDA	Stock	0.3665	0.3665	0.3665	0.3665	1008000.0
2011-12-09 19:00:00	NVDA	Stock	0.3745	0.3745	0.374	0.374	20000.0
2011-12-09 05:00:00	AMZN	Stock	9.6	9.6	9.6	9.6	2000.0
2011-12-09 06:00:00	AMZN	Stock	9.6	9.6	9.6	9.6	16000.0
2011-12-09 07:00:00	AMZN	Stock	9.6325	9.649	9.6125	9.6125	22000.0
2011-12-09 08:00:00	AMZN	Stock	9.606	9.6125	9.568	9.574	426280.0
2011-12-09 09:00:00	AMZN	Stock	9.574	9.615	9.42	9.4582	22252040.0
2011-12-09 10:00:00	AMZN	Stock	9.458	9.5585	9.445	9.523	17517840.0
2011-12-09 11:00:00	AMZN	Stock	9.5227	9.6365	9.522	9.5895	13818040.0

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

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