PREVIEW / stock_1hour / 2011-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-10.parquet
  size:    911 KB
  rows:    43,544
  symbols: 3,489

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-10 04:00:00	AAPL	Stock	14.1429	14.1971	14.1429	14.1971	64120.0
2011-11-10 05:00:00	AAPL	Stock	14.1875	14.1875	14.1875	14.1875	2800.0
2011-11-10 07:00:00	AAPL	Stock	14.1875	14.2861	14.1871	14.2214	1732920.0
2011-11-10 08:00:00	AAPL	Stock	14.2168	14.25	14.1964	14.2307	2726724.0
2011-11-10 09:00:00	AAPL	Stock	14.2286	14.2314	13.8254	13.8571	132933024.0
2011-11-10 10:00:00	AAPL	Stock	13.8571	13.8639	13.6625	13.7352	215752516.0
2011-11-10 11:00:00	AAPL	Stock	13.7386	13.8393	13.7339	13.7936	84547540.0
2011-11-10 12:00:00	AAPL	Stock	13.7936	13.8029	13.6482	13.7334	92017240.0
2011-11-10 13:00:00	AAPL	Stock	13.7332	13.8214	13.7143	13.7991	61551000.0
2011-11-10 14:00:00	AAPL	Stock	13.7984	13.8	13.6968	13.7018	50464372.0
2011-11-10 15:00:00	AAPL	Stock	13.7036	13.7675	13.6982	13.7575	88194120.0
2011-11-10 16:00:00	AAPL	Stock	13.7575	13.8147	13.7232	13.7579	10387888.0
2011-11-10 17:00:00	AAPL	Stock	13.7539	13.7579	13.7382	13.7425	392980.0
2011-11-10 18:00:00	AAPL	Stock	13.7461	13.7579	13.7321	13.7411	192696.0
2011-11-10 19:00:00	AAPL	Stock	13.7482	13.7571	13.7425	13.7571	185136.0
2011-11-10 04:00:00	MSFT	Stock	26.36	26.44	26.36	26.44	900.0
2011-11-10 05:00:00	MSFT	Stock	26.45	26.5	26.45	26.5	2700.0
2011-11-10 06:00:00	MSFT	Stock	26.4	26.4	26.4	26.4	2100.0
2011-11-10 07:00:00	MSFT	Stock	26.43	26.51	26.43	26.48	4576.0
2011-11-10 08:00:00	MSFT	Stock	26.47	26.49	26.38	26.42	19589.0
2011-11-10 09:00:00	MSFT	Stock	26.42	26.53	26.28	26.33	3157762.0
2011-11-10 10:00:00	MSFT	Stock	26.315	26.42	26.12	26.19	6123800.0
2011-11-10 11:00:00	MSFT	Stock	26.2	26.34	26.18	26.3	4534980.0
2011-11-10 12:00:00	MSFT	Stock	26.3	26.32	26.17	26.29	3062870.0
2011-11-10 13:00:00	MSFT	Stock	26.29	26.44	26.275	26.43	3428811.0
2011-11-10 14:00:00	MSFT	Stock	26.428	26.44	26.23	26.233	3235070.0
2011-11-10 15:00:00	MSFT	Stock	26.24	26.38	26.2	26.28	7111447.0
2011-11-10 16:00:00	MSFT	Stock	26.28	26.35	26.27	26.28	1104489.0
2011-11-10 17:00:00	MSFT	Stock	26.3	26.34	26.27	26.32	2900.0
2011-11-10 18:00:00	MSFT	Stock	26.3	26.3	26.28	26.3	4500.0
2011-11-10 19:00:00	MSFT	Stock	26.3	26.3	26.3	26.3	500.0
2011-11-10 04:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	10000.0
2011-11-10 08:00:00	NVDA	Stock	0.367	0.3715	0.3652	0.3715	1130840.0
2011-11-10 09:00:00	NVDA	Stock	0.372	0.372	0.3615	0.362	95428040.0
2011-11-10 10:00:00	NVDA	Stock	0.362	0.3625	0.3528	0.357	167250160.0
2011-11-10 11:00:00	NVDA	Stock	0.357	0.3605	0.3561	0.3591	146960760.0
2011-11-10 12:00:00	NVDA	Stock	0.3592	0.3599	0.3565	0.3595	73224800.0
2011-11-10 13:00:00	NVDA	Stock	0.3595	0.3648	0.358	0.362	100150920.0
2011-11-10 14:00:00	NVDA	Stock	0.362	0.3642	0.359	0.3603	102083240.0
2011-11-10 15:00:00	NVDA	Stock	0.3602	0.3665	0.3602	0.3618	200622040.0
2011-11-10 16:00:00	NVDA	Stock	0.3625	0.3862	0.3562	0.3788	54802000.0
2011-11-10 17:00:00	NVDA	Stock	0.3788	0.38	0.3692	0.3698	12125800.0
2011-11-10 18:00:00	NVDA	Stock	0.3695	0.3733	0.3682	0.3733	1977160.0
2011-11-10 19:00:00	NVDA	Stock	0.3738	0.3788	0.373	0.3765	2886760.0
2011-11-10 04:00:00	AMZN	Stock	10.6185	10.6185	10.6185	10.6185	2000.0
2011-11-10 06:00:00	AMZN	Stock	10.6395	10.6395	10.6025	10.6025	4000.0
2011-11-10 07:00:00	AMZN	Stock	10.628	10.6925	10.6275	10.664	62000.0
2011-11-10 08:00:00	AMZN	Stock	10.6625	10.6925	10.641	10.6725	421020.0
2011-11-10 09:00:00	AMZN	Stock	10.675	10.703	10.6035	10.6335	15205860.0
2011-11-10 10:00:00	AMZN	Stock	10.634	10.6525	10.405	10.484	27031960.0

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

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