PREVIEW / stock_1hour / 2005-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-23.parquet
  size:    562 KB
  rows:    26,686
  symbols: 1,988

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
2005-06-23 07:00:00	AAPL	Stock	1.3786	1.3857	1.3786	1.3857	67200.0
2005-06-23 08:00:00	AAPL	Stock	1.3839	1.3946	1.3821	1.3893	1749412.0
2005-06-23 09:00:00	AAPL	Stock	1.3893	1.4025	1.3829	1.3996	96189464.0
2005-06-23 10:00:00	AAPL	Stock	1.3993	1.4011	1.3871	1.3939	85406804.0
2005-06-23 11:00:00	AAPL	Stock	1.3936	1.4207	1.3929	1.4132	106741180.0
2005-06-23 12:00:00	AAPL	Stock	1.4132	1.4196	1.4089	1.4118	93934176.0
2005-06-23 13:00:00	AAPL	Stock	1.4121	1.4121	1.39	1.3939	93151352.0
2005-06-23 14:00:00	AAPL	Stock	1.3939	1.3989	1.3893	1.3918	80372936.0
2005-06-23 15:00:00	AAPL	Stock	1.3918	1.3943	1.3804	1.3879	108256680.0
2005-06-23 16:00:00	AAPL	Stock	1.3886	1.3893	1.35	1.3857	3176964.0
2005-06-23 17:00:00	AAPL	Stock	1.3875	1.3918	1.3857	1.3896	420476.0
2005-06-23 18:00:00	AAPL	Stock	1.3918	1.3921	1.3918	1.3918	45220.0
2005-06-23 06:00:00	MSFT	Stock	25.29	25.29	25.29	25.29	200.0
2005-06-23 07:00:00	MSFT	Stock	25.23	25.23	25.17	25.18	14516.0
2005-06-23 08:00:00	MSFT	Stock	25.18	25.23	25.17	25.2	319945.0
2005-06-23 09:00:00	MSFT	Stock	25.2	25.4	25.15	25.34	13780895.0
2005-06-23 10:00:00	MSFT	Stock	25.33	25.39	25.29	25.341	15842450.0
2005-06-23 11:00:00	MSFT	Stock	25.35	25.57	25.34	25.56	18264464.0
2005-06-23 12:00:00	MSFT	Stock	25.56	25.56	25.47	25.52	8031434.0
2005-06-23 13:00:00	MSFT	Stock	25.528	25.62	25.32	25.36	18458655.0
2005-06-23 14:00:00	MSFT	Stock	25.36	25.42	25.32	25.38	8457399.0
2005-06-23 15:00:00	MSFT	Stock	25.38	25.46	25.31	25.31	18651104.0
2005-06-23 16:00:00	MSFT	Stock	25.31	25.363	25.225	25.3	796822.0
2005-06-23 17:00:00	MSFT	Stock	25.32	25.32	25.3	25.32	93084.0
2005-06-23 18:00:00	MSFT	Stock	25.32	25.33	25.29	25.32	39602.0
2005-06-23 08:00:00	NVDA	Stock	0.2307	0.2307	0.2281	0.2283	5520600.0
2005-06-23 09:00:00	NVDA	Stock	0.2279	0.2321	0.2279	0.2307	103017240.0
2005-06-23 10:00:00	NVDA	Stock	0.2309	0.2316	0.2287	0.2313	108278160.0
2005-06-23 11:00:00	NVDA	Stock	0.2313	0.2341	0.2312	0.2341	127340160.0
2005-06-23 12:00:00	NVDA	Stock	0.2341	0.2354	0.2333	0.2348	77483160.0
2005-06-23 13:00:00	NVDA	Stock	0.2348	0.236	0.2332	0.2345	102595680.0
2005-06-23 14:00:00	NVDA	Stock	0.2345	0.2345	0.2317	0.2322	97175640.0
2005-06-23 15:00:00	NVDA	Stock	0.2323	0.2339	0.2311	0.2332	160158840.0
2005-06-23 16:00:00	NVDA	Stock	0.2332	0.2337	0.2316	0.233	2061360.0
2005-06-23 17:00:00	NVDA	Stock	0.2332	0.2332	0.233	0.233	175560.0
2005-06-23 18:00:00	NVDA	Stock	0.233	0.233	0.233	0.233	36000.0
2005-06-23 09:00:00	AMZN	Stock	1.758	1.7675	1.756	1.763	9851540.0
2005-06-23 10:00:00	AMZN	Stock	1.763	1.765	1.755	1.76	15153720.0
2005-06-23 11:00:00	AMZN	Stock	1.7595	1.7755	1.7595	1.7725	12341360.0
2005-06-23 12:00:00	AMZN	Stock	1.772	1.7775	1.765	1.775	9542240.0
2005-06-23 13:00:00	AMZN	Stock	1.7755	1.778	1.758	1.76	16303120.0
2005-06-23 14:00:00	AMZN	Stock	1.76	1.7765	1.759	1.7725	13801620.0
2005-06-23 15:00:00	AMZN	Stock	1.7725	1.7745	1.7665	1.771	26113700.0
2005-06-23 16:00:00	AMZN	Stock	1.7725	1.7752	1.7685	1.772	664780.0
2005-06-23 17:00:00	AMZN	Stock	1.7715	1.772	1.769	1.772	177400.0
2005-06-23 18:00:00	AMZN	Stock	1.7675	1.7675	1.7675	1.7675	42000.0
2005-06-23 09:00:00	CL	Stock	25.7	25.72	25.61	25.675	458600.0
2005-06-23 10:00:00	CL	Stock	25.675	25.735	25.64	25.645	802800.0
2005-06-23 11:00:00	CL	Stock	25.6495	25.665	25.565	25.625	380000.0
2005-06-23 12:00:00	CL	Stock	25.63	25.7	25.625	25.665	539200.0

> showing 50 of 26,686 rows — these rows as CSV

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