PREVIEW / stock_1hour / 2004-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-09.parquet
  size:    485 KB
  rows:    23,653
  symbols: 1,815

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-09 08:00:00	AAPL	Stock	0.532	0.532	0.532	0.532	655200.0
2004-08-09 09:00:00	AAPL	Stock	0.5313	0.5438	0.5313	0.5354	38850952.0
2004-08-09 10:00:00	AAPL	Stock	0.5354	0.5418	0.5348	0.5402	38192112.0
2004-08-09 11:00:00	AAPL	Stock	0.5402	0.5405	0.5371	0.5371	17504480.0
2004-08-09 12:00:00	AAPL	Stock	0.5371	0.5402	0.5366	0.5395	27571096.0
2004-08-09 13:00:00	AAPL	Stock	0.5395	0.5416	0.5384	0.5395	21181328.0
2004-08-09 14:00:00	AAPL	Stock	0.5395	0.5411	0.5379	0.5393	38406704.0
2004-08-09 15:00:00	AAPL	Stock	0.5393	0.5423	0.5389	0.5405	68872384.0
2004-08-09 16:00:00	AAPL	Stock	0.5405	0.5416	0.5402	0.5409	25723600.0
2004-08-09 08:00:00	MSFT	Stock	27.2	27.35	27.15	27.3	58485.0
2004-08-09 09:00:00	MSFT	Stock	27.3	27.3	27.14	27.17	7339931.0
2004-08-09 10:00:00	MSFT	Stock	27.17	27.27	27.1	27.19	10551327.0
2004-08-09 11:00:00	MSFT	Stock	27.18	27.19	27.11	27.16	6741827.0
2004-08-09 12:00:00	MSFT	Stock	27.16	27.19	27.15	27.16	4093722.0
2004-08-09 13:00:00	MSFT	Stock	27.17	27.2	27.16	27.18	3512794.0
2004-08-09 14:00:00	MSFT	Stock	27.18	27.26	27.16	27.24	7132626.0
2004-08-09 15:00:00	MSFT	Stock	27.24	27.25	27.15	27.18	10017176.0
2004-08-09 16:00:00	MSFT	Stock	27.19	27.22	27.17	27.1748	651594.0
2004-08-09 17:00:00	MSFT	Stock	27.19	27.19	27.17	27.18	4380.0
2004-08-09 18:00:00	MSFT	Stock	27.17	27.18	27.17	27.18	200.0
2004-08-09 08:00:00	NVDA	Stock	0.08	0.0804	0.0792	0.0797	2709600.0
2004-08-09 09:00:00	NVDA	Stock	0.0797	0.0817	0.0794	0.0798	189075240.0
2004-08-09 10:00:00	NVDA	Stock	0.0798	0.0814	0.0792	0.0814	338244480.0
2004-08-09 11:00:00	NVDA	Stock	0.0813	0.0839	0.0809	0.0835	371366400.0
2004-08-09 12:00:00	NVDA	Stock	0.0835	0.0839	0.0823	0.0826	158929680.0
2004-08-09 13:00:00	NVDA	Stock	0.0826	0.0832	0.0824	0.0832	95657880.0
2004-08-09 14:00:00	NVDA	Stock	0.0832	0.0836	0.0825	0.083	178096560.0
2004-08-09 15:00:00	NVDA	Stock	0.0832	0.0832	0.0815	0.082	188347800.0
2004-08-09 16:00:00	NVDA	Stock	0.0819	0.085	0.0819	0.085	12165360.0
2004-08-09 17:00:00	NVDA	Stock	0.0851	0.0857	0.0843	0.0849	13104240.0
2004-08-09 18:00:00	NVDA	Stock	0.0853	0.0857	0.0851	0.0854	1782240.0
2004-08-09 08:00:00	AMZN	Stock	1.75	1.79	1.75	1.7805	284020.0
2004-08-09 09:00:00	AMZN	Stock	1.7785	1.7835	1.7425	1.766	34025360.0
2004-08-09 10:00:00	AMZN	Stock	1.7665	1.8075	1.7475	1.8075	51377040.0
2004-08-09 11:00:00	AMZN	Stock	1.807	1.815	1.7865	1.795	28303120.0
2004-08-09 12:00:00	AMZN	Stock	1.7955	1.7955	1.7735	1.778	15916000.0
2004-08-09 13:00:00	AMZN	Stock	1.778	1.7985	1.777	1.788	13508640.0
2004-08-09 14:00:00	AMZN	Stock	1.7885	1.792	1.7795	1.7825	17762180.0
2004-08-09 15:00:00	AMZN	Stock	1.782	1.7825	1.765	1.7665	18602240.0
2004-08-09 16:00:00	AMZN	Stock	1.767	1.769	1.765	1.766	382480.0
2004-08-09 17:00:00	AMZN	Stock	1.7675	1.7675	1.763	1.763	92000.0
2004-08-09 18:00:00	AMZN	Stock	1.765	1.765	1.765	1.765	34000.0
2004-08-09 09:00:00	CL	Stock	25.85	25.965	25.775	25.85	272400.0
2004-08-09 10:00:00	CL	Stock	25.85	25.85	25.595	25.725	521600.0
2004-08-09 11:00:00	CL	Stock	25.725	25.725	25.635	25.68	257600.0
2004-08-09 12:00:00	CL	Stock	25.68	25.79	25.655	25.755	210600.0
2004-08-09 13:00:00	CL	Stock	25.75	25.875	25.75	25.827	294600.0
2004-08-09 14:00:00	CL	Stock	25.835	25.935	25.8	25.87	512600.0
2004-08-09 15:00:00	CL	Stock	25.87	25.87	25.78	25.785	566000.0
2004-08-09 16:00:00	CL	Stock	25.7775	25.78	25.7775	25.78	2400.0

> showing 50 of 23,653 rows — these rows as CSV

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