PREVIEW / stock_1hour / 2010-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-16.parquet
  size:    900 KB
  rows:    44,416
  symbols: 3,482

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-16 06:00:00	AAPL	Stock	8.8964	8.9107	8.8964	8.9107	5600.0
2010-08-16 07:00:00	AAPL	Stock	8.9107	8.9107	8.8486	8.8486	92736.0
2010-08-16 08:00:00	AAPL	Stock	8.8396	8.8743	8.8393	8.8643	906360.0
2010-08-16 09:00:00	AAPL	Stock	8.8639	8.9232	8.8214	8.8868	59168900.0
2010-08-16 10:00:00	AAPL	Stock	8.8864	8.9196	8.8607	8.9193	63655200.0
2010-08-16 11:00:00	AAPL	Stock	8.9193	8.9196	8.8792	8.9032	24861620.0
2010-08-16 12:00:00	AAPL	Stock	8.9032	8.9289	8.8982	8.905	26807956.0
2010-08-16 13:00:00	AAPL	Stock	8.905	8.9101	8.8757	8.8804	20720196.0
2010-08-16 14:00:00	AAPL	Stock	8.8804	8.8929	8.8354	8.8371	35338800.0
2010-08-16 15:00:00	AAPL	Stock	8.8371	8.8564	8.8079	8.8454	76785912.0
2010-08-16 16:00:00	AAPL	Stock	8.8443	8.8702	8.8266	8.85	8998080.0
2010-08-16 17:00:00	AAPL	Stock	8.9052	8.9052	8.8514	8.8568	129024.0
2010-08-16 18:00:00	AAPL	Stock	8.8568	8.8629	8.8443	8.8625	404124.0
2010-08-16 19:00:00	AAPL	Stock	8.8629	8.8629	8.8496	8.85	303884.0
2010-08-16 07:00:00	MSFT	Stock	24.4	24.4	24.4	24.4	100.0
2010-08-16 08:00:00	MSFT	Stock	24.35	24.47	24.35	24.45	5100.0
2010-08-16 09:00:00	MSFT	Stock	24.45	24.53	24.3	24.38	4977789.0
2010-08-16 10:00:00	MSFT	Stock	24.37	24.55	24.37	24.46	5442197.0
2010-08-16 11:00:00	MSFT	Stock	24.46	24.56	24.38	24.55	4224906.0
2010-08-16 12:00:00	MSFT	Stock	24.55	24.61	24.52	24.57	3220181.0
2010-08-16 13:00:00	MSFT	Stock	24.565	24.61	24.55	24.57	2842120.0
2010-08-16 14:00:00	MSFT	Stock	24.57	24.6	24.46	24.48	5094642.0
2010-08-16 15:00:00	MSFT	Stock	24.48	24.58	24.43	24.5	6313327.0
2010-08-16 16:00:00	MSFT	Stock	24.5	24.584	24.44	24.504	8623447.0
2010-08-16 17:00:00	MSFT	Stock	24.57	24.58	24.51	24.53	34674.0
2010-08-16 18:00:00	MSFT	Stock	24.54	24.55	24.5	24.5	16980.0
2010-08-16 19:00:00	MSFT	Stock	24.57	24.57	24.53	24.53	18450.0
2010-08-16 08:00:00	NVDA	Stock	0.2358	0.2358	0.234	0.234	616000.0
2010-08-16 09:00:00	NVDA	Stock	0.234	0.2362	0.2298	0.234	112393800.0
2010-08-16 10:00:00	NVDA	Stock	0.234	0.2355	0.2332	0.2342	139514000.0
2010-08-16 11:00:00	NVDA	Stock	0.234	0.2342	0.2308	0.2308	53847040.0
2010-08-16 12:00:00	NVDA	Stock	0.2308	0.231	0.2292	0.2292	102872600.0
2010-08-16 13:00:00	NVDA	Stock	0.2295	0.2298	0.2292	0.2295	35151640.0
2010-08-16 14:00:00	NVDA	Stock	0.2295	0.2298	0.2258	0.2265	118170520.0
2010-08-16 15:00:00	NVDA	Stock	0.2263	0.2292	0.226	0.2288	212992160.0
2010-08-16 16:00:00	NVDA	Stock	0.2288	0.2335	0.2273	0.2285	29773160.0
2010-08-16 17:00:00	NVDA	Stock	0.2285	0.2288	0.2278	0.2285	308080.0
2010-08-16 18:00:00	NVDA	Stock	0.2285	0.2292	0.2285	0.2292	160000.0
2010-08-16 19:00:00	NVDA	Stock	0.229	0.229	0.229	0.229	72000.0
2010-08-16 08:00:00	AMZN	Stock	6.215	6.2295	6.215	6.2295	23700.0
2010-08-16 09:00:00	AMZN	Stock	6.225	6.265	6.152	6.265	11287620.0
2010-08-16 10:00:00	AMZN	Stock	6.258	6.323	6.242	6.315	15801480.0
2010-08-16 11:00:00	AMZN	Stock	6.3155	6.35	6.298	6.335	12300260.0
2010-08-16 12:00:00	AMZN	Stock	6.334	6.3685	6.332	6.3465	8034560.0
2010-08-16 13:00:00	AMZN	Stock	6.346	6.355	6.314	6.324	5583960.0
2010-08-16 14:00:00	AMZN	Stock	6.324	6.331	6.2805	6.2805	7546720.0
2010-08-16 15:00:00	AMZN	Stock	6.2805	6.3145	6.2605	6.305	17912380.0
2010-08-16 16:00:00	AMZN	Stock	6.301	6.3055	6.2545	6.278	514260.0
2010-08-16 17:00:00	AMZN	Stock	6.3005	6.3005	6.3	6.3	11000.0
2010-08-16 18:00:00	AMZN	Stock	6.3035	6.3035	6.3035	6.3035	55420.0

> showing 50 of 44,416 rows — these rows as CSV

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