PREVIEW / stock_1hour / 2004-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-04.parquet
  size:    526 KB
  rows:    24,333
  symbols: 1,865

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-11-04 08:00:00	AAPL	Stock	0.9839	0.9875	0.9823	0.987	281960.0
2004-11-04 09:00:00	AAPL	Stock	0.9866	0.992	0.9798	0.9882	131037200.0
2004-11-04 10:00:00	AAPL	Stock	0.9882	0.9907	0.9709	0.9775	194039160.0
2004-11-04 11:00:00	AAPL	Stock	0.9772	0.9891	0.9755	0.982	129986472.0
2004-11-04 12:00:00	AAPL	Stock	0.9818	0.987	0.9788	0.9798	66420648.0
2004-11-04 13:00:00	AAPL	Stock	0.9804	0.9882	0.9766	0.9863	57683976.0
2004-11-04 14:00:00	AAPL	Stock	0.9863	0.9902	0.9848	0.9857	71424472.0
2004-11-04 15:00:00	AAPL	Stock	0.9857	0.9875	0.9721	0.9721	223969368.0
2004-11-04 16:00:00	AAPL	Stock	0.9721	0.9895	0.9663	0.9714	18360888.0
2004-11-04 17:00:00	AAPL	Stock	0.9696	0.9721	0.9679	0.9696	381360.0
2004-11-04 18:00:00	AAPL	Stock	0.9698	0.9786	0.9698	0.9721	118720.0
2004-11-04 08:00:00	MSFT	Stock	28.37	28.51	28.37	28.46	69320.0
2004-11-04 09:00:00	MSFT	Stock	28.45	28.58	28.37	28.5	8711526.0
2004-11-04 10:00:00	MSFT	Stock	28.5	28.65	28.45	28.65	9575168.0
2004-11-04 11:00:00	MSFT	Stock	28.65	28.76	28.61	28.7	11746557.0
2004-11-04 12:00:00	MSFT	Stock	28.7	28.83	28.67	28.78	8054552.0
2004-11-04 13:00:00	MSFT	Stock	28.79	28.85	28.71	28.82	9012580.0
2004-11-04 14:00:00	MSFT	Stock	28.82	28.87	28.78	28.82	8446885.0
2004-11-04 15:00:00	MSFT	Stock	28.81	29.0	28.81	29.0	19750289.0
2004-11-04 16:00:00	MSFT	Stock	28.99	29.03	28.74	29.01	6809393.0
2004-11-04 17:00:00	MSFT	Stock	29.02	29.04	28.38	29.02	32570.0
2004-11-04 18:00:00	MSFT	Stock	29.02	29.02	29.02	29.02	724.0
2004-11-04 08:00:00	NVDA	Stock	0.1243	0.1258	0.1243	0.1258	264000.0
2004-11-04 09:00:00	NVDA	Stock	0.1258	0.1276	0.125	0.1264	100699560.0
2004-11-04 10:00:00	NVDA	Stock	0.1264	0.1265	0.1243	0.1255	80981280.0
2004-11-04 11:00:00	NVDA	Stock	0.1254	0.1265	0.1252	0.1259	46311360.0
2004-11-04 12:00:00	NVDA	Stock	0.1258	0.1272	0.1255	0.1267	47836920.0
2004-11-04 13:00:00	NVDA	Stock	0.1267	0.13	0.1267	0.1296	155563320.0
2004-11-04 14:00:00	NVDA	Stock	0.1296	0.13	0.1282	0.1286	115639920.0
2004-11-04 15:00:00	NVDA	Stock	0.1286	0.1292	0.1266	0.1279	262435680.0
2004-11-04 16:00:00	NVDA	Stock	0.1282	0.1375	0.1275	0.1352	145905360.0
2004-11-04 17:00:00	NVDA	Stock	0.1353	0.1412	0.1279	0.1396	125886840.0
2004-11-04 18:00:00	NVDA	Stock	0.1394	0.1403	0.1384	0.1392	18850080.0
2004-11-04 08:00:00	AMZN	Stock	1.79	1.796	1.785	1.785	14000.0
2004-11-04 09:00:00	AMZN	Stock	1.796	1.8035	1.7805	1.8015	19171100.0
2004-11-04 10:00:00	AMZN	Stock	1.801	1.8035	1.776	1.7975	22179700.0
2004-11-04 11:00:00	AMZN	Stock	1.7975	1.821	1.7895	1.7995	17951000.0
2004-11-04 12:00:00	AMZN	Stock	1.799	1.825	1.795	1.824	16025580.0
2004-11-04 13:00:00	AMZN	Stock	1.8245	1.845	1.8235	1.844	20723580.0
2004-11-04 14:00:00	AMZN	Stock	1.8445	1.8515	1.8415	1.8495	17720900.0
2004-11-04 15:00:00	AMZN	Stock	1.8495	1.8645	1.8425	1.846	33554360.0
2004-11-04 16:00:00	AMZN	Stock	1.846	1.849	1.8405	1.8455	1654600.0
2004-11-04 17:00:00	AMZN	Stock	1.8425	1.8475	1.8218	1.845	216120.0
2004-11-04 18:00:00	AMZN	Stock	1.8425	1.8425	1.8385	1.84	26000.0
2004-11-04 09:00:00	CL	Stock	22.825	22.975	22.75	22.97	697200.0
2004-11-04 10:00:00	CL	Stock	22.97	23.085	22.955	23.055	1222800.0
2004-11-04 11:00:00	CL	Stock	23.05	23.185	23.04	23.15	993800.0
2004-11-04 12:00:00	CL	Stock	23.145	23.185	23.085	23.12	1075600.0
2004-11-04 13:00:00	CL	Stock	23.13	23.215	23.11	23.19	847200.0
2004-11-04 14:00:00	CL	Stock	23.18	23.23	23.175	23.206	798400.0

> showing 50 of 24,333 rows — these rows as CSV

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