PREVIEW / stock_1hour / 2010-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-31.parquet
  size:    908 KB
  rows:    43,636
  symbols: 3,459

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
2010-08-31 04:00:00	AAPL	Stock	8.6786	8.6786	8.6786	8.6786	2800.0
2010-08-31 06:00:00	AAPL	Stock	8.6725	8.6786	8.6607	8.6607	17752.0
2010-08-31 07:00:00	AAPL	Stock	8.6479	8.6568	8.615	8.6493	174664.0
2010-08-31 08:00:00	AAPL	Stock	8.6396	8.6536	8.5893	8.6161	1737512.0
2010-08-31 09:00:00	AAPL	Stock	8.6161	8.6936	8.5839	8.6704	64385328.0
2010-08-31 10:00:00	AAPL	Stock	8.6718	8.7343	8.6532	8.675	79871204.0
2010-08-31 11:00:00	AAPL	Stock	8.675	8.6993	8.6443	8.6893	40502056.0
2010-08-31 12:00:00	AAPL	Stock	8.6896	8.7128	8.6768	8.6768	27671924.0
2010-08-31 13:00:00	AAPL	Stock	8.6764	8.7225	8.6668	8.7093	32701676.0
2010-08-31 14:00:00	AAPL	Stock	8.7093	8.7343	8.6354	8.6589	66552360.0
2010-08-31 15:00:00	AAPL	Stock	8.6568	8.7054	8.6379	8.6918	73132024.0
2010-08-31 16:00:00	AAPL	Stock	8.6918	8.7132	8.6332	8.7125	22393140.0
2010-08-31 17:00:00	AAPL	Stock	8.6918	8.7214	8.6879	8.7196	1641332.0
2010-08-31 18:00:00	AAPL	Stock	8.7196	8.7286	8.7154	8.7261	443772.0
2010-08-31 19:00:00	AAPL	Stock	8.725	8.7293	8.7193	8.7264	178976.0
2010-08-31 08:00:00	MSFT	Stock	23.63	23.63	23.55	23.56	6950.0
2010-08-31 09:00:00	MSFT	Stock	23.56	23.67	23.53	23.59	7659217.0
2010-08-31 10:00:00	MSFT	Stock	23.58	23.69	23.54	23.56	7913123.0
2010-08-31 11:00:00	MSFT	Stock	23.555	23.73	23.52	23.687	8729271.0
2010-08-31 12:00:00	MSFT	Stock	23.68	23.71	23.54	23.56	3498116.0
2010-08-31 13:00:00	MSFT	Stock	23.551	23.62	23.55	23.57	3263076.0
2010-08-31 14:00:00	MSFT	Stock	23.57	23.59	23.39	23.4	10172455.0
2010-08-31 15:00:00	MSFT	Stock	23.4	23.57	23.32	23.48	16059471.0
2010-08-31 16:00:00	MSFT	Stock	23.48	23.744	23.45	23.47	7579899.0
2010-08-31 17:00:00	MSFT	Stock	23.48	23.55	23.469	23.55	530740.0
2010-08-31 18:00:00	MSFT	Stock	23.565	23.565	23.54	23.55	6539.0
2010-08-31 19:00:00	MSFT	Stock	23.57	23.6	23.57	23.58	4900.0
2010-08-31 08:00:00	NVDA	Stock	0.2358	0.2422	0.2355	0.2362	568360.0
2010-08-31 09:00:00	NVDA	Stock	0.2372	0.2405	0.2355	0.2388	96435760.0
2010-08-31 10:00:00	NVDA	Stock	0.239	0.245	0.2388	0.2415	163679600.0
2010-08-31 11:00:00	NVDA	Stock	0.2415	0.2418	0.2388	0.2398	83712000.0
2010-08-31 12:00:00	NVDA	Stock	0.2398	0.24	0.2368	0.237	78211120.0
2010-08-31 13:00:00	NVDA	Stock	0.2368	0.2378	0.2358	0.236	74088720.0
2010-08-31 14:00:00	NVDA	Stock	0.2362	0.237	0.2325	0.234	119166600.0
2010-08-31 15:00:00	NVDA	Stock	0.2339	0.2345	0.2325	0.2332	260424720.0
2010-08-31 16:00:00	NVDA	Stock	0.2335	0.2374	0.233	0.2332	14649560.0
2010-08-31 17:00:00	NVDA	Stock	0.2332	0.2338	0.2332	0.2332	4130200.0
2010-08-31 18:00:00	NVDA	Stock	0.2335	0.2335	0.2332	0.2335	266000.0
2010-08-31 19:00:00	NVDA	Stock	0.2335	0.2345	0.2335	0.2342	168000.0
2010-08-31 08:00:00	AMZN	Stock	6.168	6.17	6.1615	6.1615	25000.0
2010-08-31 09:00:00	AMZN	Stock	6.171	6.2495	6.125	6.219	11620040.0
2010-08-31 10:00:00	AMZN	Stock	6.2205	6.2775	6.2125	6.23	13252320.0
2010-08-31 11:00:00	AMZN	Stock	6.23	6.2665	6.198	6.2505	7955180.0
2010-08-31 12:00:00	AMZN	Stock	6.2525	6.2715	6.2327	6.2388	6583900.0
2010-08-31 13:00:00	AMZN	Stock	6.2385	6.295	6.234	6.267	7891480.0
2010-08-31 14:00:00	AMZN	Stock	6.266	6.274	6.182	6.205	11709140.0
2010-08-31 15:00:00	AMZN	Stock	6.206	6.2648	6.2005	6.242	17509900.0
2010-08-31 16:00:00	AMZN	Stock	6.2415	6.275	6.2328	6.2443	7493160.0
2010-08-31 17:00:00	AMZN	Stock	6.2415	6.2415	6.2403	6.2415	386200.0
2010-08-31 18:00:00	AMZN	Stock	6.269	6.274	6.269	6.274	10000.0

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

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