PREVIEW / stock_1hour / 2004-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-05.parquet
  size:    503 KB
  rows:    23,731
  symbols: 1,811

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
2004-08-05 09:00:00	AAPL	Stock	0.5677	0.5768	0.5661	0.5755	39465160.0
2004-08-05 10:00:00	AAPL	Stock	0.5755	0.5768	0.5723	0.5736	39095896.0
2004-08-05 11:00:00	AAPL	Stock	0.5738	0.5752	0.5725	0.5741	27086024.0
2004-08-05 12:00:00	AAPL	Stock	0.5741	0.5748	0.5666	0.5668	32700136.0
2004-08-05 13:00:00	AAPL	Stock	0.5668	0.5686	0.5629	0.5652	21801472.0
2004-08-05 14:00:00	AAPL	Stock	0.5652	0.5686	0.5643	0.5648	32032392.0
2004-08-05 15:00:00	AAPL	Stock	0.5646	0.5661	0.558	0.5607	49515480.0
2004-08-05 16:00:00	AAPL	Stock	0.5607	0.5607	0.5582	0.5607	2680216.0
2004-08-05 17:00:00	AAPL	Stock	0.5605	0.5605	0.5605	0.5605	67200.0
2004-08-05 08:00:00	MSFT	Stock	28.08	28.15	28.08	28.14	17900.0
2004-08-05 09:00:00	MSFT	Stock	28.13	28.21	28.11	28.17	4073634.0
2004-08-05 10:00:00	MSFT	Stock	28.17	28.17	28.05	28.09	7367922.0
2004-08-05 11:00:00	MSFT	Stock	28.08	28.14	27.93	27.95	6565523.0
2004-08-05 12:00:00	MSFT	Stock	27.95	27.96	27.8	27.83	7297188.0
2004-08-05 13:00:00	MSFT	Stock	27.83	27.87	27.75	27.83	4762926.0
2004-08-05 14:00:00	MSFT	Stock	27.83	27.84	27.64	27.66	8570155.0
2004-08-05 15:00:00	MSFT	Stock	27.66	27.72	27.52	27.54	13657131.0
2004-08-05 16:00:00	MSFT	Stock	27.53	27.56	27.46	27.47	931991.0
2004-08-05 17:00:00	MSFT	Stock	27.5	27.55	27.47	27.55	19700.0
2004-08-05 18:00:00	MSFT	Stock	27.55	27.56	27.5	27.52	4150.0
2004-08-05 08:00:00	NVDA	Stock	0.1254	0.1254	0.1254	0.1254	360000.0
2004-08-05 09:00:00	NVDA	Stock	0.1255	0.1267	0.1243	0.125	69779640.0
2004-08-05 10:00:00	NVDA	Stock	0.125	0.1257	0.1229	0.1255	108797400.0
2004-08-05 11:00:00	NVDA	Stock	0.1254	0.1261	0.1248	0.1253	72264480.0
2004-08-05 12:00:00	NVDA	Stock	0.1252	0.1255	0.1238	0.1246	56142360.0
2004-08-05 13:00:00	NVDA	Stock	0.1247	0.1259	0.1245	0.1255	60735000.0
2004-08-05 14:00:00	NVDA	Stock	0.1254	0.1259	0.1233	0.1235	60787080.0
2004-08-05 15:00:00	NVDA	Stock	0.1233	0.1243	0.1192	0.1211	238113600.0
2004-08-05 16:00:00	NVDA	Stock	0.1213	0.1213	0.0854	0.0929	82741920.0
2004-08-05 17:00:00	NVDA	Stock	0.0932	0.0954	0.091	0.093	107973600.0
2004-08-05 18:00:00	NVDA	Stock	0.0932	0.0952	0.0932	0.0944	10715760.0
2004-08-05 08:00:00	AMZN	Stock	1.868	1.8765	1.868	1.8745	135800.0
2004-08-05 09:00:00	AMZN	Stock	1.872	1.874	1.8525	1.8715	16164220.0
2004-08-05 10:00:00	AMZN	Stock	1.8715	1.872	1.83	1.832	21210220.0
2004-08-05 11:00:00	AMZN	Stock	1.8325	1.8325	1.7915	1.794	33787200.0
2004-08-05 12:00:00	AMZN	Stock	1.794	1.798	1.781	1.7885	31658880.0
2004-08-05 13:00:00	AMZN	Stock	1.7885	1.795	1.779	1.7895	14808580.0
2004-08-05 14:00:00	AMZN	Stock	1.7895	1.795	1.7735	1.775	12908540.0
2004-08-05 15:00:00	AMZN	Stock	1.776	1.7825	1.769	1.7805	31127580.0
2004-08-05 16:00:00	AMZN	Stock	1.7805	1.7825	1.776	1.778	1992880.0
2004-08-05 17:00:00	AMZN	Stock	1.772	1.772	1.772	1.772	39500.0
2004-08-05 09:00:00	CL	Stock	26.435	26.435	26.285	26.35	191600.0
2004-08-05 10:00:00	CL	Stock	26.355	26.39	26.3	26.37	231400.0
2004-08-05 11:00:00	CL	Stock	26.37	26.435	26.2	26.22	274400.0
2004-08-05 12:00:00	CL	Stock	26.215	26.235	26.135	26.23	308400.0
2004-08-05 13:00:00	CL	Stock	26.23	26.25	26.165	26.22	200600.0
2004-08-05 14:00:00	CL	Stock	26.225	26.23	26.05	26.065	235200.0
2004-08-05 15:00:00	CL	Stock	26.075	26.205	26.075	26.105	511200.0

> showing 48 of 23,731 rows — these rows as CSV

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