PREVIEW / stock_1hour / 2011-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-11.parquet
  size:    894 KB
  rows:    43,181
  symbols: 3,491

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-10-11 04:00:00	AAPL	Stock	13.8854	13.9111	13.8611	13.8836	102760.0
2011-10-11 05:00:00	AAPL	Stock	13.8929	13.8929	13.8914	13.8914	5600.0
2011-10-11 06:00:00	AAPL	Stock	13.9082	13.9107	13.8839	13.8839	15400.0
2011-10-11 07:00:00	AAPL	Stock	13.8668	13.9443	13.8668	13.9036	448756.0
2011-10-11 08:00:00	AAPL	Stock	13.9207	14.0468	13.9111	13.9854	6011516.0
2011-10-11 09:00:00	AAPL	Stock	13.985	14.225	13.9632	14.1864	127574412.0
2011-10-11 10:00:00	AAPL	Stock	14.1864	14.3321	14.1454	14.2534	127060080.0
2011-10-11 11:00:00	AAPL	Stock	14.2532	14.3011	14.2179	14.2793	58065952.0
2011-10-11 12:00:00	AAPL	Stock	14.2796	14.3079	14.1929	14.2321	45311476.0
2011-10-11 13:00:00	AAPL	Stock	14.2309	14.2971	14.1886	14.2971	38732736.0
2011-10-11 14:00:00	AAPL	Stock	14.2982	14.3429	14.2536	14.3421	54673276.0
2011-10-11 15:00:00	AAPL	Stock	14.3436	14.3993	14.2504	14.2954	132278748.0
2011-10-11 16:00:00	AAPL	Stock	14.295	14.3007	14.1556	14.2289	7106456.0
2011-10-11 17:00:00	AAPL	Stock	14.2411	14.2571	14.2321	14.25	291200.0
2011-10-11 18:00:00	AAPL	Stock	14.2504	14.2961	14.2361	14.2414	443996.0
2011-10-11 19:00:00	AAPL	Stock	14.2375	14.2561	14.2321	14.2479	358568.0
2011-10-11 07:00:00	MSFT	Stock	26.76	26.92	26.75	26.88	2800.0
2011-10-11 08:00:00	MSFT	Stock	26.88	26.94	26.8	26.8	18122.0
2011-10-11 09:00:00	MSFT	Stock	26.8	26.93	26.72	26.882	3769682.0
2011-10-11 10:00:00	MSFT	Stock	26.87	27.0	26.74	27.0	6540433.0
2011-10-11 11:00:00	MSFT	Stock	26.995	27.0	26.91	26.97	4394131.0
2011-10-11 12:00:00	MSFT	Stock	26.97	26.98	26.92	26.96	3094861.0
2011-10-11 13:00:00	MSFT	Stock	26.96	27.035	26.9	27.03	5306161.0
2011-10-11 14:00:00	MSFT	Stock	27.04	27.05	26.9	26.96	4062887.0
2011-10-11 15:00:00	MSFT	Stock	26.955	27.07	26.94	26.99	9225690.0
2011-10-11 16:00:00	MSFT	Stock	26.99	27.01	26.8	26.84	1785457.0
2011-10-11 17:00:00	MSFT	Stock	26.94	26.977	26.9	26.9	12496.0
2011-10-11 18:00:00	MSFT	Stock	27.0	27.0	26.9	26.9	16662.0
2011-10-11 19:00:00	MSFT	Stock	26.9	26.94	26.9	26.92	550.0
2011-10-11 08:00:00	NVDA	Stock	0.3682	0.3682	0.3632	0.3648	66800.0
2011-10-11 09:00:00	NVDA	Stock	0.365	0.3692	0.365	0.3675	63125400.0
2011-10-11 10:00:00	NVDA	Stock	0.3675	0.3725	0.3662	0.3713	135101120.0
2011-10-11 11:00:00	NVDA	Stock	0.3713	0.3723	0.3678	0.3695	143804600.0
2011-10-11 12:00:00	NVDA	Stock	0.3695	0.3698	0.3652	0.3675	78792560.0
2011-10-11 13:00:00	NVDA	Stock	0.3672	0.3688	0.3652	0.3688	73804960.0
2011-10-11 14:00:00	NVDA	Stock	0.3689	0.369	0.3648	0.3664	79908320.0
2011-10-11 15:00:00	NVDA	Stock	0.3665	0.3672	0.3642	0.3655	221001520.0
2011-10-11 16:00:00	NVDA	Stock	0.3655	0.3678	0.363	0.3632	19120160.0
2011-10-11 17:00:00	NVDA	Stock	0.3695	0.3695	0.363	0.3655	256960.0
2011-10-11 18:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	120000.0
2011-10-11 19:00:00	NVDA	Stock	0.3642	0.3642	0.3618	0.3618	248400.0
2011-10-11 04:00:00	AMZN	Stock	11.487	11.487	11.4565	11.4565	10000.0
2011-10-11 05:00:00	AMZN	Stock	11.469	11.469	11.435	11.463	8000.0
2011-10-11 06:00:00	AMZN	Stock	11.452	11.452	11.452	11.452	2000.0
2011-10-11 07:00:00	AMZN	Stock	11.465	11.5275	11.465	11.505	28420.0
2011-10-11 08:00:00	AMZN	Stock	11.4875	11.5275	11.48	11.4825	131380.0
2011-10-11 09:00:00	AMZN	Stock	11.4825	11.6668	11.45	11.6234	16721560.0
2011-10-11 10:00:00	AMZN	Stock	11.619	11.803	11.553	11.7475	20346720.0
2011-10-11 11:00:00	AMZN	Stock	11.7555	11.7995	11.68	11.776	13057460.0
2011-10-11 12:00:00	AMZN	Stock	11.77	11.8375	11.6865	11.701	9474080.0

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

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