PREVIEW / stock_1hour / 2006-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-22.parquet
  size:    582 KB
  rows:    28,252
  symbols: 2,339

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-08-22 08:00:00	AAPL	Stock	2.3732	2.3843	2.3661	2.3829	678608.0
2006-08-22 09:00:00	AAPL	Stock	2.3839	2.4061	2.375	2.3996	74286352.0
2006-08-22 10:00:00	AAPL	Stock	2.3996	2.4254	2.3971	2.4207	120942948.0
2006-08-22 11:00:00	AAPL	Stock	2.4207	2.44	2.4143	2.4361	82051536.0
2006-08-22 12:00:00	AAPL	Stock	2.4361	2.4368	2.4225	2.4329	54071528.0
2006-08-22 13:00:00	AAPL	Stock	2.4332	2.4339	2.4046	2.4082	86392992.0
2006-08-22 14:00:00	AAPL	Stock	2.4089	2.4175	2.4014	2.4168	60847024.0
2006-08-22 15:00:00	AAPL	Stock	2.4168	2.4229	2.4114	2.4146	72633120.0
2006-08-22 16:00:00	AAPL	Stock	2.4136	2.4171	2.41	2.4136	14739144.0
2006-08-22 17:00:00	AAPL	Stock	2.4132	2.4143	2.4132	2.4143	90160.0
2006-08-22 18:00:00	AAPL	Stock	2.4146	2.4161	2.4146	2.4161	244580.0
2006-08-22 07:00:00	MSFT	Stock	26.08	26.1	26.04	26.04	1150.0
2006-08-22 08:00:00	MSFT	Stock	26.03	26.09	26.0	26.01	109038.0
2006-08-22 09:00:00	MSFT	Stock	26.03	26.25	25.99	26.21	10048170.0
2006-08-22 10:00:00	MSFT	Stock	26.21	26.25	26.15	26.19	9965895.0
2006-08-22 11:00:00	MSFT	Stock	26.18	26.2	26.01	26.03	11449887.0
2006-08-22 12:00:00	MSFT	Stock	26.03	26.03	25.84	25.929	9691145.0
2006-08-22 13:00:00	MSFT	Stock	25.93	25.94	25.71	25.77	11041166.0
2006-08-22 14:00:00	MSFT	Stock	25.76	25.78	25.66	25.76	7717581.0
2006-08-22 15:00:00	MSFT	Stock	25.77	25.971	25.62	25.66	19314831.0
2006-08-22 16:00:00	MSFT	Stock	25.66	26.016	25.5	25.5	1471391.0
2006-08-22 17:00:00	MSFT	Stock	25.5	25.62	25.5	25.57	39200.0
2006-08-22 18:00:00	MSFT	Stock	25.56	25.57	25.52	25.57	17523.0
2006-08-22 08:00:00	NVDA	Stock	0.4383	0.4383	0.4383	0.4383	18000.0
2006-08-22 09:00:00	NVDA	Stock	0.4392	0.4488	0.4365	0.4463	78005100.0
2006-08-22 10:00:00	NVDA	Stock	0.4465	0.4488	0.4438	0.446	58123380.0
2006-08-22 11:00:00	NVDA	Stock	0.4458	0.4507	0.4433	0.4476	65035320.0
2006-08-22 12:00:00	NVDA	Stock	0.4477	0.4482	0.4442	0.4463	54042720.0
2006-08-22 13:00:00	NVDA	Stock	0.4463	0.4463	0.4378	0.4423	76191000.0
2006-08-22 14:00:00	NVDA	Stock	0.4422	0.4427	0.4375	0.4403	52189800.0
2006-08-22 15:00:00	NVDA	Stock	0.4403	0.4435	0.4385	0.4388	77851200.0
2006-08-22 16:00:00	NVDA	Stock	0.4387	0.4443	0.4382	0.4382	1059480.0
2006-08-22 17:00:00	NVDA	Stock	0.4375	0.4375	0.4375	0.4375	70800.0
2006-08-22 08:00:00	AMZN	Stock	1.4	1.4	1.3975	1.3975	16660.0
2006-08-22 09:00:00	AMZN	Stock	1.4055	1.431	1.4025	1.4245	10303040.0
2006-08-22 10:00:00	AMZN	Stock	1.424	1.44	1.4195	1.4385	17935060.0
2006-08-22 11:00:00	AMZN	Stock	1.4382	1.4445	1.4345	1.437	11553580.0
2006-08-22 12:00:00	AMZN	Stock	1.4365	1.437	1.4218	1.429	13741220.0
2006-08-22 13:00:00	AMZN	Stock	1.4285	1.4285	1.4055	1.4155	13375600.0
2006-08-22 14:00:00	AMZN	Stock	1.415	1.42	1.406	1.4195	8462640.0
2006-08-22 15:00:00	AMZN	Stock	1.4195	1.4265	1.415	1.419	14180880.0
2006-08-22 16:00:00	AMZN	Stock	1.419	1.422	1.416	1.4185	290540.0
2006-08-22 18:00:00	AMZN	Stock	1.4195	1.4195	1.4195	1.4195	4000.0
2006-08-22 09:00:00	CL	Stock	29.7	29.77	29.625	29.635	199400.0
2006-08-22 10:00:00	CL	Stock	29.625	29.6425	29.515	29.52	478600.0
2006-08-22 11:00:00	CL	Stock	29.52	29.6	29.5	29.545	226400.0
2006-08-22 12:00:00	CL	Stock	29.55	29.55	29.5	29.515	195400.0
2006-08-22 13:00:00	CL	Stock	29.51	29.525	29.42	29.43	655200.0
2006-08-22 14:00:00	CL	Stock	29.42	29.47	29.37	29.405	510400.0
2006-08-22 15:00:00	CL	Stock	29.4	29.46	29.4	29.44	556800.0

> showing 50 of 28,252 rows — these rows as CSV

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