PREVIEW / stock_1hour / 2008-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-01.parquet
  size:    853 KB
  rows:    40,980
  symbols: 3,342

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
2008-07-01 04:00:00	AAPL	Stock	5.9286	5.9286	5.9286	5.9286	2800.0
2008-07-01 05:00:00	AAPL	Stock	5.9175	5.9175	5.9175	5.9175	8400.0
2008-07-01 07:00:00	AAPL	Stock	5.9107	5.9436	5.8929	5.8929	158172.0
2008-07-01 08:00:00	AAPL	Stock	5.98	5.98	5.8836	5.8857	3613736.0
2008-07-01 09:00:00	AAPL	Stock	5.8871	6.1607	5.8571	6.045	161862036.0
2008-07-01 10:00:00	AAPL	Stock	6.045	6.1586	6.0396	6.1568	213362380.0
2008-07-01 11:00:00	AAPL	Stock	6.1571	6.225	6.1186	6.1264	153305124.0
2008-07-01 12:00:00	AAPL	Stock	6.1264	6.1354	6.0329	6.1136	147059136.0
2008-07-01 13:00:00	AAPL	Stock	6.1136	6.1704	6.0964	6.1546	88973024.0
2008-07-01 14:00:00	AAPL	Stock	6.1554	6.2375	6.1439	6.2069	151853100.0
2008-07-01 15:00:00	AAPL	Stock	6.2071	6.24	6.1871	6.2386	160656944.0
2008-07-01 16:00:00	AAPL	Stock	6.2368	6.2386	6.1201	6.2321	18617424.0
2008-07-01 17:00:00	AAPL	Stock	6.2354	6.2411	5.98	6.2411	816312.0
2008-07-01 18:00:00	AAPL	Stock	6.2407	6.2471	6.2396	6.2446	203812.0
2008-07-01 19:00:00	AAPL	Stock	6.2432	6.2436	6.2286	6.2304	300076.0
2008-07-01 06:00:00	MSFT	Stock	27.38	27.38	27.38	27.38	100.0
2008-07-01 07:00:00	MSFT	Stock	27.38	27.38	27.33	27.33	22950.0
2008-07-01 08:00:00	MSFT	Stock	27.33	27.51	27.28	27.32	189363.0
2008-07-01 09:00:00	MSFT	Stock	27.31	27.51	27.1	27.15	7195434.0
2008-07-01 10:00:00	MSFT	Stock	27.15	27.38	26.99	27.22	13885538.0
2008-07-01 11:00:00	MSFT	Stock	27.22	27.28	26.74	26.785	10112313.0
2008-07-01 12:00:00	MSFT	Stock	26.785	26.82	26.44	26.62	15094929.0
2008-07-01 13:00:00	MSFT	Stock	26.62	26.82	26.52	26.73	9343794.0
2008-07-01 14:00:00	MSFT	Stock	26.72	27.14	26.705	26.96	14503224.0
2008-07-01 15:00:00	MSFT	Stock	26.96	27.33	26.8	26.91	17133466.0
2008-07-01 16:00:00	MSFT	Stock	26.9	26.92	26.82	26.87	10664138.0
2008-07-01 17:00:00	MSFT	Stock	26.85	27.15	26.85	26.9	227116.0
2008-07-01 18:00:00	MSFT	Stock	26.9	26.97	26.9	26.97	4000.0
2008-07-01 19:00:00	MSFT	Stock	26.96	26.96	26.88	26.94	2650.0
2008-07-01 20:00:00	MSFT	Stock	27.51	27.51	27.51	27.51	153900.0
2008-07-01 08:00:00	NVDA	Stock	0.4675	0.4702	0.4625	0.4625	1538440.0
2008-07-01 09:00:00	NVDA	Stock	0.4625	0.4655	0.4593	0.4615	79414400.0
2008-07-01 10:00:00	NVDA	Stock	0.4612	0.4683	0.461	0.467	136670200.0
2008-07-01 11:00:00	NVDA	Stock	0.4673	0.4688	0.4593	0.4595	98224120.0
2008-07-01 12:00:00	NVDA	Stock	0.4595	0.46	0.454	0.4578	119760080.0
2008-07-01 13:00:00	NVDA	Stock	0.4578	0.462	0.4545	0.4605	106654360.0
2008-07-01 14:00:00	NVDA	Stock	0.4605	0.4692	0.46	0.4652	143161720.0
2008-07-01 15:00:00	NVDA	Stock	0.4655	0.4688	0.4618	0.4683	173225880.0
2008-07-01 16:00:00	NVDA	Stock	0.4683	0.4688	0.4623	0.4688	10606200.0
2008-07-01 17:00:00	NVDA	Stock	0.4695	0.4695	0.469	0.469	72600.0
2008-07-01 18:00:00	NVDA	Stock	0.469	0.469	0.469	0.469	16000.0
2008-07-01 19:00:00	NVDA	Stock	0.4695	0.4695	0.4695	0.4695	8000.0
2008-07-01 08:00:00	AMZN	Stock	3.6395	3.6395	3.6065	3.6065	46500.0
2008-07-01 09:00:00	AMZN	Stock	3.61	3.6665	3.5445	3.605	19671140.0
2008-07-01 10:00:00	AMZN	Stock	3.605	3.6365	3.5615	3.6165	32642900.0
2008-07-01 11:00:00	AMZN	Stock	3.6165	3.6365	3.5725	3.579	17725100.0
2008-07-01 12:00:00	AMZN	Stock	3.5788	3.579	3.526	3.565	21544160.0
2008-07-01 13:00:00	AMZN	Stock	3.5645	3.6035	3.5475	3.5965	14208840.0
2008-07-01 14:00:00	AMZN	Stock	3.5975	3.693	3.5905	3.683	38100400.0
2008-07-01 15:00:00	AMZN	Stock	3.683	3.7115	3.666	3.6818	55113620.0

> showing 50 of 40,980 rows — these rows as CSV

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