PREVIEW / stock_1hour / 2006-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-13.parquet
  size:    588 KB
  rows:    27,798
  symbols: 2,164

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-13 07:00:00	AAPL	Stock	3.0036	3.0264	3.0036	3.0107	382704.0
2006-01-13 08:00:00	AAPL	Stock	3.0204	3.0393	3.0129	3.0246	4858588.0
2006-01-13 09:00:00	AAPL	Stock	3.0236	3.0679	3.0232	3.0329	157633112.0
2006-01-13 10:00:00	AAPL	Stock	3.0325	3.0539	3.0214	3.0464	179538772.0
2006-01-13 11:00:00	AAPL	Stock	3.0465	3.0625	3.0368	3.0464	105292824.0
2006-01-13 12:00:00	AAPL	Stock	3.0464	3.0489	3.0286	3.0354	80697176.0
2006-01-13 13:00:00	AAPL	Stock	3.0357	3.0414	3.0304	3.0371	52060036.0
2006-01-13 14:00:00	AAPL	Stock	3.0368	3.0464	3.0304	3.0464	70611352.0
2006-01-13 15:00:00	AAPL	Stock	3.0464	3.0718	3.0357	3.0568	105404488.0
2006-01-13 16:00:00	AAPL	Stock	3.0575	3.0625	3.046	3.0621	6725656.0
2006-01-13 17:00:00	AAPL	Stock	3.0589	3.0668	3.0579	3.0661	1063272.0
2006-01-13 18:00:00	AAPL	Stock	3.0661	3.0671	3.0632	3.0643	195860.0
2006-01-13 06:00:00	MSFT	Stock	27.21	27.21	27.14	27.14	2773.0
2006-01-13 07:00:00	MSFT	Stock	27.1	27.1	27.08	27.08	2496.0
2006-01-13 08:00:00	MSFT	Stock	27.05	27.08	27.05	27.07	8137.0
2006-01-13 09:00:00	MSFT	Stock	27.07	27.25	27.02	27.22	5192984.0
2006-01-13 10:00:00	MSFT	Stock	27.21	27.25	27.01	27.142	8533269.0
2006-01-13 11:00:00	MSFT	Stock	27.15	27.24	27.14	27.14	4613722.0
2006-01-13 12:00:00	MSFT	Stock	27.14	27.16	27.05	27.09	4183591.0
2006-01-13 13:00:00	MSFT	Stock	27.09	27.13	27.04	27.08	3731456.0
2006-01-13 14:00:00	MSFT	Stock	27.08	27.15	27.01	27.1	5869635.0
2006-01-13 15:00:00	MSFT	Stock	27.101	27.21	27.05	27.18	7342057.0
2006-01-13 16:00:00	MSFT	Stock	27.19	27.19	27.11	27.15	404922.0
2006-01-13 08:00:00	NVDA	Stock	0.3572	0.3572	0.3572	0.3572	36000.0
2006-01-13 09:00:00	NVDA	Stock	0.3564	0.3595	0.3525	0.3572	55007160.0
2006-01-13 10:00:00	NVDA	Stock	0.3577	0.3577	0.3492	0.3514	77781600.0
2006-01-13 11:00:00	NVDA	Stock	0.3512	0.3572	0.3503	0.3557	78531240.0
2006-01-13 12:00:00	NVDA	Stock	0.3557	0.3572	0.3547	0.3565	30947520.0
2006-01-13 13:00:00	NVDA	Stock	0.3565	0.3566	0.354	0.3548	30211560.0
2006-01-13 14:00:00	NVDA	Stock	0.3547	0.3555	0.3529	0.3535	48980160.0
2006-01-13 15:00:00	NVDA	Stock	0.3535	0.3553	0.352	0.3542	85968240.0
2006-01-13 16:00:00	NVDA	Stock	0.3542	0.3542	0.3535	0.3542	6750120.0
2006-01-13 17:00:00	NVDA	Stock	0.3537	0.3542	0.3537	0.3542	24000.0
2006-01-13 08:00:00	AMZN	Stock	2.218	2.218	2.218	2.218	4000.0
2006-01-13 09:00:00	AMZN	Stock	2.218	2.2425	2.212	2.215	15943040.0
2006-01-13 10:00:00	AMZN	Stock	2.2145	2.2285	2.2	2.224	20591720.0
2006-01-13 11:00:00	AMZN	Stock	2.224	2.2275	2.211	2.2185	7922960.0
2006-01-13 12:00:00	AMZN	Stock	2.218	2.2231	2.204	2.2095	8102440.0
2006-01-13 13:00:00	AMZN	Stock	2.209	2.2145	2.206	2.2125	5430060.0
2006-01-13 14:00:00	AMZN	Stock	2.212	2.22	2.2	2.217	8228440.0
2006-01-13 15:00:00	AMZN	Stock	2.217	2.2205	2.207	2.219	18669480.0
2006-01-13 16:00:00	AMZN	Stock	2.22	2.221	2.2125	2.22	1601180.0
2006-01-13 08:00:00	CL	Stock	27.125	27.125	27.125	27.125	800.0
2006-01-13 09:00:00	CL	Stock	27.19	27.355	27.165	27.3	269200.0
2006-01-13 10:00:00	CL	Stock	27.315	27.445	27.27	27.4	372200.0
2006-01-13 11:00:00	CL	Stock	27.38	27.45	27.38	27.42	334000.0
2006-01-13 12:00:00	CL	Stock	27.415	27.5	27.4	27.445	443600.0
2006-01-13 13:00:00	CL	Stock	27.44	27.475	27.39	27.435	329600.0
2006-01-13 14:00:00	CL	Stock	27.435	27.44	27.345	27.365	327200.0
2006-01-13 15:00:00	CL	Stock	27.365	27.385	27.32	27.37	479400.0

> showing 50 of 27,798 rows — these rows as CSV

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