PREVIEW / stock_1hour / 2004-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-03-25.parquet
  size:    502 KB
  rows:    23,449
  symbols: 1,739

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-03-25 08:00:00	AAPL	Stock	0.4598	0.4714	0.4598	0.4661	1100400.0
2004-03-25 09:00:00	AAPL	Stock	0.4673	0.4723	0.4652	0.4677	63431088.0
2004-03-25 10:00:00	AAPL	Stock	0.4677	0.4693	0.4632	0.4652	91581224.0
2004-03-25 11:00:00	AAPL	Stock	0.4652	0.4696	0.4623	0.4691	44794904.0
2004-03-25 12:00:00	AAPL	Stock	0.4695	0.4741	0.4663	0.4713	40747000.0
2004-03-25 13:00:00	AAPL	Stock	0.4714	0.4741	0.4702	0.4732	26579728.0
2004-03-25 14:00:00	AAPL	Stock	0.4732	0.475	0.4716	0.4723	63750176.0
2004-03-25 15:00:00	AAPL	Stock	0.4723	0.4805	0.4721	0.4795	89919032.0
2004-03-25 16:00:00	AAPL	Stock	0.4795	0.4818	0.4786	0.4804	5738152.0
2004-03-25 17:00:00	AAPL	Stock	0.4786	0.4786	0.4786	0.4786	392000.0
2004-03-25 18:00:00	AAPL	Stock	0.4818	0.4875	0.4818	0.4875	509600.0
2004-03-25 08:00:00	MSFT	Stock	24.415	24.66	24.415	24.59	87076.0
2004-03-25 09:00:00	MSFT	Stock	24.59	24.84	24.55	24.76	9977995.0
2004-03-25 10:00:00	MSFT	Stock	24.76	24.98	24.68	24.89	13627467.0
2004-03-25 11:00:00	MSFT	Stock	24.88	24.94	24.79	24.88	11208958.0
2004-03-25 12:00:00	MSFT	Stock	24.89	25.08	24.87	24.98	7904837.0
2004-03-25 13:00:00	MSFT	Stock	24.98	25.09	24.93	25.07	6136560.0
2004-03-25 14:00:00	MSFT	Stock	25.08	25.1	24.96	24.98	5710355.0
2004-03-25 15:00:00	MSFT	Stock	24.98	25.24	24.97	25.17	15910555.0
2004-03-25 16:00:00	MSFT	Stock	25.17	25.25	25.17	25.21	1056256.0
2004-03-25 17:00:00	MSFT	Stock	25.2	25.24	24.8	25.24	54300.0
2004-03-25 18:00:00	MSFT	Stock	25.22	25.25	25.22	25.25	11050.0
2004-03-25 08:00:00	NVDA	Stock	0.1942	0.1947	0.1932	0.1934	492000.0
2004-03-25 09:00:00	NVDA	Stock	0.1935	0.1993	0.1932	0.1982	103151760.0
2004-03-25 10:00:00	NVDA	Stock	0.1982	0.1998	0.1968	0.1996	106325040.0
2004-03-25 11:00:00	NVDA	Stock	0.1996	0.2006	0.1987	0.1997	81702000.0
2004-03-25 12:00:00	NVDA	Stock	0.1997	0.2021	0.1997	0.2008	88298040.0
2004-03-25 13:00:00	NVDA	Stock	0.2008	0.2016	0.2003	0.2016	112671960.0
2004-03-25 14:00:00	NVDA	Stock	0.2016	0.2016	0.1993	0.1997	101789160.0
2004-03-25 15:00:00	NVDA	Stock	0.1997	0.2045	0.1997	0.2038	244161600.0
2004-03-25 16:00:00	NVDA	Stock	0.2039	0.2042	0.2033	0.2036	7210560.0
2004-03-25 17:00:00	NVDA	Stock	0.2036	0.2044	0.2035	0.2035	2136000.0
2004-03-25 08:00:00	AMZN	Stock	2.0	2.005	1.9985	2.0	170000.0
2004-03-25 09:00:00	AMZN	Stock	1.9975	2.03	1.9975	2.0145	15458600.0
2004-03-25 10:00:00	AMZN	Stock	2.0145	2.0425	2.0085	2.029	17878160.0
2004-03-25 11:00:00	AMZN	Stock	2.03	2.062	2.029	2.06	15643180.0
2004-03-25 12:00:00	AMZN	Stock	2.0595	2.075	2.0575	2.0735	15101180.0
2004-03-25 13:00:00	AMZN	Stock	2.0735	2.079	2.067	2.076	12233820.0
2004-03-25 14:00:00	AMZN	Stock	2.0755	2.088	2.07	2.082	13160240.0
2004-03-25 15:00:00	AMZN	Stock	2.0815	2.11	2.0815	2.1025	29045160.0
2004-03-25 16:00:00	AMZN	Stock	2.1045	2.11	2.0995	2.109	2884540.0
2004-03-25 17:00:00	AMZN	Stock	2.11	2.137	2.058	2.12	1650000.0
2004-03-25 18:00:00	AMZN	Stock	2.1195	2.12	2.1155	2.12	32000.0
2004-03-25 09:00:00	CL	Stock	26.75	26.86	26.735	26.75	1236000.0
2004-03-25 10:00:00	CL	Stock	26.75	26.9	26.68	26.855	1246400.0
2004-03-25 11:00:00	CL	Stock	26.855	27.015	26.85	26.97	924600.0
2004-03-25 12:00:00	CL	Stock	26.975	27.25	26.955	27.235	670400.0
2004-03-25 13:00:00	CL	Stock	27.25	27.38	27.225	27.38	946000.0
2004-03-25 14:00:00	CL	Stock	27.38	27.425	27.31	27.355	753600.0
2004-03-25 15:00:00	CL	Stock	27.355	27.525	27.345	27.445	1128400.0

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

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