PREVIEW / stock_1hour / 2010-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-19.parquet
  size:    910 KB
  rows:    44,679
  symbols: 3,476

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-19 06:00:00	AAPL	Stock	9.065	9.0661	9.065	9.0661	9800.0
2010-08-19 07:00:00	AAPL	Stock	9.0643	9.0643	9.0518	9.0518	94920.0
2010-08-19 08:00:00	AAPL	Stock	9.0589	9.0857	8.9968	9.0268	4063024.0
2010-08-19 09:00:00	AAPL	Stock	9.0236	9.0529	8.9982	9.0125	49061740.0
2010-08-19 10:00:00	AAPL	Stock	9.0125	9.0129	8.9375	8.9525	86396688.0
2010-08-19 11:00:00	AAPL	Stock	8.9511	8.9532	8.8814	8.9093	76660864.0
2010-08-19 12:00:00	AAPL	Stock	8.9096	8.9332	8.8857	8.9264	50716596.0
2010-08-19 13:00:00	AAPL	Stock	8.9261	8.9375	8.9114	8.9146	28697172.0
2010-08-19 14:00:00	AAPL	Stock	8.9142	8.9486	8.9039	8.9325	44627688.0
2010-08-19 15:00:00	AAPL	Stock	8.9329	8.9571	8.9225	8.9225	70932260.0
2010-08-19 16:00:00	AAPL	Stock	8.9261	8.9525	8.9193	8.9275	14649096.0
2010-08-19 17:00:00	AAPL	Stock	8.9275	8.9275	8.9196	8.9196	128632.0
2010-08-19 18:00:00	AAPL	Stock	8.9196	8.9257	8.9179	8.9243	187880.0
2010-08-19 19:00:00	AAPL	Stock	8.9175	8.9261	8.9175	8.9236	159628.0
2010-08-19 05:00:00	MSFT	Stock	24.91	24.93	24.91	24.93	400.0
2010-08-19 06:00:00	MSFT	Stock	25.0	25.0	25.0	25.0	500.0
2010-08-19 07:00:00	MSFT	Stock	24.93	24.93	24.85	24.85	4300.0
2010-08-19 08:00:00	MSFT	Stock	24.85	24.85	24.6	24.65	46062.0
2010-08-19 09:00:00	MSFT	Stock	24.66	24.74	24.56	24.59	8115482.0
2010-08-19 10:00:00	MSFT	Stock	24.58	24.58	24.41	24.45	12357838.0
2010-08-19 11:00:00	MSFT	Stock	24.45	24.474	24.21	24.305	8306609.0
2010-08-19 12:00:00	MSFT	Stock	24.3	24.47	24.28	24.398	4535537.0
2010-08-19 13:00:00	MSFT	Stock	24.4	24.5	24.35	24.371	2998977.0
2010-08-19 14:00:00	MSFT	Stock	24.375	24.47	24.312	24.4	4534080.0
2010-08-19 15:00:00	MSFT	Stock	24.409	24.53	24.375	24.44	8769631.0
2010-08-19 16:00:00	MSFT	Stock	24.44	24.56	24.4	24.43	960681.0
2010-08-19 17:00:00	MSFT	Stock	24.45	24.58	24.45	24.46	52862.0
2010-08-19 18:00:00	MSFT	Stock	24.44	24.5	24.44	24.47	24396.0
2010-08-19 19:00:00	MSFT	Stock	24.47	24.5	24.47	24.5	4325.0
2010-08-19 07:00:00	NVDA	Stock	0.2362	0.2362	0.2362	0.2362	8000.0
2010-08-19 08:00:00	NVDA	Stock	0.2362	0.2368	0.2332	0.236	2585320.0
2010-08-19 09:00:00	NVDA	Stock	0.2358	0.241	0.2342	0.239	162760760.0
2010-08-19 10:00:00	NVDA	Stock	0.2388	0.2389	0.2362	0.2382	151298360.0
2010-08-19 11:00:00	NVDA	Stock	0.2382	0.239	0.2345	0.2348	122276200.0
2010-08-19 12:00:00	NVDA	Stock	0.2348	0.2375	0.2342	0.2365	85674400.0
2010-08-19 13:00:00	NVDA	Stock	0.2365	0.241	0.2362	0.2409	121250280.0
2010-08-19 14:00:00	NVDA	Stock	0.2408	0.2442	0.24	0.2435	264981120.0
2010-08-19 15:00:00	NVDA	Stock	0.2433	0.2478	0.2425	0.2473	583176800.0
2010-08-19 16:00:00	NVDA	Stock	0.247	0.2485	0.2414	0.2468	26009760.0
2010-08-19 17:00:00	NVDA	Stock	0.2468	0.247	0.246	0.247	485280.0
2010-08-19 18:00:00	NVDA	Stock	0.2465	0.2482	0.2465	0.248	577520.0
2010-08-19 19:00:00	NVDA	Stock	0.248	0.248	0.2475	0.2475	539000.0
2010-08-19 08:00:00	AMZN	Stock	6.483	6.483	6.376	6.428	296080.0
2010-08-19 09:00:00	AMZN	Stock	6.435	6.501	6.435	6.4965	20689420.0
2010-08-19 10:00:00	AMZN	Stock	6.4965	6.4965	6.3875	6.4001	22167520.0
2010-08-19 11:00:00	AMZN	Stock	6.4	6.4045	6.35	6.359	12546200.0
2010-08-19 12:00:00	AMZN	Stock	6.3585	6.4165	6.341	6.414	13663860.0
2010-08-19 13:00:00	AMZN	Stock	6.4155	6.418	6.3695	6.3705	9703000.0
2010-08-19 14:00:00	AMZN	Stock	6.3705	6.4015	6.345	6.382	11314200.0
2010-08-19 15:00:00	AMZN	Stock	6.382	6.4185	6.372	6.3785	17139660.0

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

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