PREVIEW / stock_1hour / 2006-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-03.parquet
  size:    614 KB
  rows:    29,105
  symbols: 2,178

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-01-03 06:00:00	AAPL	Stock	2.5839	2.5839	2.5839	2.5839	2800.0
2006-01-03 07:00:00	AAPL	Stock	2.5886	2.5964	2.5886	2.5964	86800.0
2006-01-03 08:00:00	AAPL	Stock	2.5932	2.6054	2.5675	2.5907	4357864.0
2006-01-03 09:00:00	AAPL	Stock	2.5914	2.6282	2.5804	2.6275	140336420.0
2006-01-03 10:00:00	AAPL	Stock	2.6279	2.6339	2.5886	2.5996	155678096.0
2006-01-03 11:00:00	AAPL	Stock	2.5999	2.6332	2.5943	2.6186	87241896.0
2006-01-03 12:00:00	AAPL	Stock	2.6186	2.6296	2.6011	2.6132	75765144.0
2006-01-03 13:00:00	AAPL	Stock	2.6136	2.6182	2.5964	2.6046	55086500.0
2006-01-03 14:00:00	AAPL	Stock	2.6046	2.6446	2.6036	2.6425	122815532.0
2006-01-03 15:00:00	AAPL	Stock	2.6425	2.6696	2.6425	2.6689	146989556.0
2006-01-03 16:00:00	AAPL	Stock	2.6696	2.6732	2.6621	2.6661	4030432.0
2006-01-03 17:00:00	AAPL	Stock	2.6686	2.6696	2.6607	2.6639	3519768.0
2006-01-03 18:00:00	AAPL	Stock	2.6625	2.6675	2.6611	2.6671	145404.0
2006-01-03 07:00:00	MSFT	Stock	26.2	26.2	26.2	26.2	100.0
2006-01-03 08:00:00	MSFT	Stock	26.15	26.27	26.14	26.26	227054.0
2006-01-03 09:00:00	MSFT	Stock	26.25	26.28	26.14	26.2	6905678.0
2006-01-03 10:00:00	MSFT	Stock	26.2	26.248	26.1	26.152	8044596.0
2006-01-03 11:00:00	MSFT	Stock	26.15	26.3	26.128	26.3	7074099.0
2006-01-03 12:00:00	MSFT	Stock	26.3	26.4	26.26	26.37	7529794.0
2006-01-03 13:00:00	MSFT	Stock	26.37	26.52	26.34	26.47	9938925.0
2006-01-03 14:00:00	MSFT	Stock	26.46	26.89	26.46	26.82	15246140.0
2006-01-03 15:00:00	MSFT	Stock	26.82	27.001	26.51	26.82	21838201.0
2006-01-03 16:00:00	MSFT	Stock	26.86	26.92	26.46	26.548	584011.0
2006-01-03 17:00:00	MSFT	Stock	26.9	26.9	26.85	26.86	3650.0
2006-01-03 18:00:00	MSFT	Stock	26.86	26.9	26.85	26.9	1365.0
2006-01-03 07:00:00	NVDA	Stock	0.2958	0.2958	0.2958	0.2958	12000.0
2006-01-03 08:00:00	NVDA	Stock	0.3047	0.308	0.3047	0.3053	1069560.0
2006-01-03 09:00:00	NVDA	Stock	0.3053	0.3127	0.3052	0.3111	53798520.0
2006-01-03 10:00:00	NVDA	Stock	0.3111	0.3115	0.3059	0.3092	73985760.0
2006-01-03 11:00:00	NVDA	Stock	0.3092	0.3118	0.3082	0.3117	46092360.0
2006-01-03 12:00:00	NVDA	Stock	0.3117	0.312	0.3096	0.31	27552120.0
2006-01-03 13:00:00	NVDA	Stock	0.31	0.31	0.309	0.3091	30783600.0
2006-01-03 14:00:00	NVDA	Stock	0.3092	0.3156	0.3089	0.3154	71112480.0
2006-01-03 15:00:00	NVDA	Stock	0.3154	0.3208	0.3153	0.3188	133031880.0
2006-01-03 16:00:00	NVDA	Stock	0.3188	0.3192	0.318	0.3192	432000.0
2006-01-03 08:00:00	AMZN	Stock	2.3745	2.3745	2.3575	2.371	133600.0
2006-01-03 09:00:00	AMZN	Stock	2.3575	2.3756	2.3405	2.3445	20297360.0
2006-01-03 10:00:00	AMZN	Stock	2.3445	2.3748	2.3125	2.328	36411420.0
2006-01-03 11:00:00	AMZN	Stock	2.3275	2.3405	2.3145	2.34	15462140.0
2006-01-03 12:00:00	AMZN	Stock	2.34	2.3535	2.34	2.3475	12482760.0
2006-01-03 13:00:00	AMZN	Stock	2.3475	2.3525	2.3325	2.337	7439900.0
2006-01-03 14:00:00	AMZN	Stock	2.3375	2.3735	2.3375	2.369	28239620.0
2006-01-03 15:00:00	AMZN	Stock	2.369	2.3925	2.3685	2.3815	28257600.0
2006-01-03 16:00:00	AMZN	Stock	2.379	2.3845	2.374	2.38	375880.0
2006-01-03 17:00:00	AMZN	Stock	2.3805	2.3805	2.375	2.375	73000.0
2006-01-03 08:00:00	CL	Stock	27.425	27.425	27.425	27.425	19200.0
2006-01-03 09:00:00	CL	Stock	27.49	27.559	27.415	27.475	334000.0
2006-01-03 10:00:00	CL	Stock	27.475	27.55	27.34	27.355	527200.0
2006-01-03 11:00:00	CL	Stock	27.355	27.385	27.285	27.316	308400.0
2006-01-03 12:00:00	CL	Stock	27.315	27.37	27.255	27.36	354800.0

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

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