PREVIEW / stock_1hour / 2009-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-17.parquet
  size:    892 KB
  rows:    42,554
  symbols: 3,421

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
2009-11-17 07:00:00	AAPL	Stock	7.35	7.3571	7.3411	7.3414	39200.0
2009-11-17 08:00:00	AAPL	Stock	7.3546	7.3743	7.3511	7.3664	692272.0
2009-11-17 09:00:00	AAPL	Stock	7.3696	7.4086	7.3589	7.3839	62854288.0
2009-11-17 10:00:00	AAPL	Stock	7.385	7.39	7.35	7.3643	45582124.0
2009-11-17 11:00:00	AAPL	Stock	7.365	7.3679	7.3436	7.3661	36524460.0
2009-11-17 12:00:00	AAPL	Stock	7.3654	7.39	7.3589	7.3786	26295248.0
2009-11-17 13:00:00	AAPL	Stock	7.3786	7.3854	7.3661	7.3789	20900740.0
2009-11-17 14:00:00	AAPL	Stock	7.3782	7.3807	7.3214	7.3518	84605752.0
2009-11-17 15:00:00	AAPL	Stock	7.3518	7.3929	7.3511	7.3929	71701952.0
2009-11-17 16:00:00	AAPL	Stock	7.3925	7.395	7.3678	7.3886	8652308.0
2009-11-17 17:00:00	AAPL	Stock	7.3886	7.3904	7.3879	7.3886	158088.0
2009-11-17 18:00:00	AAPL	Stock	7.3857	7.3929	7.3714	7.3857	305368.0
2009-11-17 19:00:00	AAPL	Stock	7.3864	7.3929	7.3857	7.3893	254576.0
2009-11-17 06:00:00	MSFT	Stock	29.5	29.5	29.5	29.5	110.0
2009-11-17 07:00:00	MSFT	Stock	29.5	29.5	29.45	29.48	3454.0
2009-11-17 08:00:00	MSFT	Stock	29.48	29.56	29.42	29.52	56483.0
2009-11-17 09:00:00	MSFT	Stock	29.52	29.85	29.47	29.76	11389261.0
2009-11-17 10:00:00	MSFT	Stock	29.76	29.83	29.71	29.75	9680757.0
2009-11-17 11:00:00	MSFT	Stock	29.75	29.89	29.74	29.87	6942419.0
2009-11-17 12:00:00	MSFT	Stock	29.864	29.97	29.86	29.88	8118704.0
2009-11-17 13:00:00	MSFT	Stock	29.88	29.95	29.82	29.915	7079173.0
2009-11-17 14:00:00	MSFT	Stock	29.91	30.0	29.89	29.98	8401224.0
2009-11-17 15:00:00	MSFT	Stock	29.97	30.0	29.95	29.99	13891984.0
2009-11-17 16:00:00	MSFT	Stock	29.99	30.08	29.435	29.96	2282651.0
2009-11-17 17:00:00	MSFT	Stock	29.41	30.02	29.41	30.02	166026.0
2009-11-17 18:00:00	MSFT	Stock	30.01	30.04	30.0	30.0	47430.0
2009-11-17 19:00:00	MSFT	Stock	30.0	30.02	29.96	29.98	18056.0
2009-11-17 20:00:00	MSFT	Stock	29.41	29.41	29.41	29.41	122300.0
2009-11-17 09:00:00	NVDA	Stock	0.344	0.344	0.3385	0.3408	52229840.0
2009-11-17 10:00:00	NVDA	Stock	0.3408	0.342	0.3375	0.3382	67537120.0
2009-11-17 11:00:00	NVDA	Stock	0.3382	0.3408	0.3368	0.3405	44990320.0
2009-11-17 12:00:00	NVDA	Stock	0.3405	0.343	0.3395	0.3398	56660640.0
2009-11-17 13:00:00	NVDA	Stock	0.3399	0.3413	0.339	0.3405	38177120.0
2009-11-17 14:00:00	NVDA	Stock	0.3408	0.342	0.3398	0.342	24768520.0
2009-11-17 15:00:00	NVDA	Stock	0.342	0.3435	0.3415	0.3433	57817280.0
2009-11-17 16:00:00	NVDA	Stock	0.3433	0.3433	0.3405	0.3433	6626120.0
2009-11-17 18:00:00	NVDA	Stock	0.3433	0.3433	0.3433	0.3433	8000.0
2009-11-17 19:00:00	NVDA	Stock	0.3422	0.3422	0.3413	0.3413	20000.0
2009-11-17 07:00:00	AMZN	Stock	6.575	6.575	6.575	6.575	10000.0
2009-11-17 08:00:00	AMZN	Stock	6.571	6.578	6.55	6.5665	69120.0
2009-11-17 09:00:00	AMZN	Stock	6.566	6.5925	6.514	6.5198	22727900.0
2009-11-17 10:00:00	AMZN	Stock	6.5205	6.547	6.4775	6.5155	31454420.0
2009-11-17 11:00:00	AMZN	Stock	6.516	6.523	6.466	6.5032	18821980.0
2009-11-17 12:00:00	AMZN	Stock	6.503	6.5255	6.501	6.525	9724640.0
2009-11-17 13:00:00	AMZN	Stock	6.525	6.568	6.51	6.5645	12202200.0
2009-11-17 14:00:00	AMZN	Stock	6.565	6.5654	6.487	6.5095	27706820.0
2009-11-17 15:00:00	AMZN	Stock	6.5095	6.5625	6.5055	6.5625	25462980.0
2009-11-17 16:00:00	AMZN	Stock	6.5625	6.5635	6.5212	6.5575	3009000.0
2009-11-17 17:00:00	AMZN	Stock	6.508	6.5575	6.508	6.5575	64420.0
2009-11-17 18:00:00	AMZN	Stock	6.548	6.5565	6.548	6.556	14000.0

> showing 50 of 42,554 rows — these rows as CSV

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