PREVIEW / stock_1hour / 2006-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-08.parquet
  size:    604 KB
  rows:    29,053
  symbols: 2,336

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
2006-09-08 04:00:00	AAPL	Stock	2.6018	2.6071	2.6018	2.6071	5600.0
2006-09-08 06:00:00	AAPL	Stock	2.6125	2.6175	2.6089	2.6175	176680.0
2006-09-08 07:00:00	AAPL	Stock	2.6246	2.625	2.6168	2.6168	316260.0
2006-09-08 08:00:00	AAPL	Stock	2.6211	2.6318	2.6161	2.6232	6486368.0
2006-09-08 09:00:00	AAPL	Stock	2.625	2.6293	2.5911	2.5986	205748536.0
2006-09-08 10:00:00	AAPL	Stock	2.5986	2.6036	2.5764	2.6007	199500364.0
2006-09-08 11:00:00	AAPL	Stock	2.6007	2.6014	2.5732	2.5764	127562456.0
2006-09-08 12:00:00	AAPL	Stock	2.5768	2.595	2.5682	2.5889	89620328.0
2006-09-08 13:00:00	AAPL	Stock	2.5889	2.5961	2.5789	2.5946	68123972.0
2006-09-08 14:00:00	AAPL	Stock	2.5946	2.5996	2.5889	2.5975	71175944.0
2006-09-08 15:00:00	AAPL	Stock	2.5971	2.5979	2.5854	2.5904	116684876.0
2006-09-08 16:00:00	AAPL	Stock	2.5914	2.5936	2.5889	2.5904	2147180.0
2006-09-08 17:00:00	AAPL	Stock	2.5911	2.5936	2.59	2.59	402052.0
2006-09-08 18:00:00	AAPL	Stock	2.5921	2.5925	2.59	2.5911	99540.0
2006-09-08 08:00:00	MSFT	Stock	25.5	25.5	25.45	25.49	18970.0
2006-09-08 09:00:00	MSFT	Stock	25.49	25.55	25.46	25.5	3883099.0
2006-09-08 10:00:00	MSFT	Stock	25.5	25.65	25.47	25.65	5817250.0
2006-09-08 11:00:00	MSFT	Stock	25.65	25.68	25.54	25.58	5304590.0
2006-09-08 12:00:00	MSFT	Stock	25.57	25.65	25.57	25.63	3119717.0
2006-09-08 13:00:00	MSFT	Stock	25.63	25.79	25.62	25.72	5493630.0
2006-09-08 14:00:00	MSFT	Stock	25.72	25.74	25.59	25.648	3842689.0
2006-09-08 15:00:00	MSFT	Stock	25.64	25.66	25.58	25.62	7129760.0
2006-09-08 16:00:00	MSFT	Stock	25.6	25.64	25.25	25.58	107157.0
2006-09-08 17:00:00	MSFT	Stock	25.59	25.63	25.58	25.58	3720.0
2006-09-08 08:00:00	NVDA	Stock	0.4607	0.4683	0.4607	0.4683	934800.0
2006-09-08 09:00:00	NVDA	Stock	0.4667	0.47	0.4608	0.469	57919080.0
2006-09-08 10:00:00	NVDA	Stock	0.4692	0.4695	0.4563	0.46	102969000.0
2006-09-08 11:00:00	NVDA	Stock	0.46	0.4615	0.4535	0.4572	67457220.0
2006-09-08 12:00:00	NVDA	Stock	0.4568	0.4575	0.4515	0.4573	50498700.0
2006-09-08 13:00:00	NVDA	Stock	0.4573	0.4628	0.4555	0.4627	40306980.0
2006-09-08 14:00:00	NVDA	Stock	0.4627	0.464	0.4603	0.4608	46900020.0
2006-09-08 15:00:00	NVDA	Stock	0.461	0.4632	0.4595	0.4617	71437260.0
2006-09-08 16:00:00	NVDA	Stock	0.4617	0.462	0.461	0.4613	440040.0
2006-09-08 17:00:00	NVDA	Stock	0.462	0.462	0.462	0.462	6000.0
2006-09-08 18:00:00	NVDA	Stock	0.462	0.462	0.462	0.462	90000.0
2006-09-08 08:00:00	AMZN	Stock	1.501	1.5225	1.501	1.518	646000.0
2006-09-08 09:00:00	AMZN	Stock	1.5135	1.525	1.497	1.51	22515300.0
2006-09-08 10:00:00	AMZN	Stock	1.5115	1.515	1.505	1.511	15173200.0
2006-09-08 11:00:00	AMZN	Stock	1.511	1.5135	1.5065	1.511	9826840.0
2006-09-08 12:00:00	AMZN	Stock	1.511	1.513	1.5065	1.511	5311460.0
2006-09-08 13:00:00	AMZN	Stock	1.511	1.5225	1.511	1.5225	9702100.0
2006-09-08 14:00:00	AMZN	Stock	1.5225	1.5245	1.5165	1.5245	10490260.0
2006-09-08 15:00:00	AMZN	Stock	1.5245	1.533	1.521	1.525	25551700.0
2006-09-08 16:00:00	AMZN	Stock	1.525	1.5295	1.5097	1.528	354920.0
2006-09-08 09:00:00	CL	Stock	30.43	30.565	30.41	30.535	146400.0
2006-09-08 10:00:00	CL	Stock	30.54	30.6	30.45	30.5915	303800.0
2006-09-08 11:00:00	CL	Stock	30.6	30.61	30.505	30.51	231400.0
2006-09-08 12:00:00	CL	Stock	30.515	30.52	30.395	30.395	405200.0
2006-09-08 13:00:00	CL	Stock	30.39	30.395	30.28	30.355	554800.0
2006-09-08 14:00:00	CL	Stock	30.355	30.405	30.32	30.375	300400.0

> showing 50 of 29,053 rows — these rows as CSV

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