PREVIEW / stock_1hour / 2004-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-03-23.parquet
  size:    492 KB
  rows:    22,886
  symbols: 1,744

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-23 08:00:00	AAPL	Stock	0.4625	0.4652	0.4625	0.4643	243432.0
2004-03-23 09:00:00	AAPL	Stock	0.4659	0.4661	0.4573	0.4575	49199080.0
2004-03-23 10:00:00	AAPL	Stock	0.4577	0.4604	0.4575	0.458	44864064.0
2004-03-23 11:00:00	AAPL	Stock	0.458	0.4598	0.4536	0.457	62799632.0
2004-03-23 12:00:00	AAPL	Stock	0.457	0.4578	0.4541	0.4563	52651032.0
2004-03-23 13:00:00	AAPL	Stock	0.4563	0.4598	0.4561	0.4591	27178032.0
2004-03-23 14:00:00	AAPL	Stock	0.4593	0.46	0.455	0.4559	31520160.0
2004-03-23 15:00:00	AAPL	Stock	0.4559	0.4566	0.4509	0.4509	78417024.0
2004-03-23 16:00:00	AAPL	Stock	0.4518	0.4525	0.4504	0.4518	3364144.0
2004-03-23 17:00:00	AAPL	Stock	0.4514	0.4518	0.4509	0.4518	305200.0
2004-03-23 18:00:00	AAPL	Stock	0.452	0.452	0.452	0.452	84000.0
2004-03-23 08:00:00	MSFT	Stock	24.8	24.9	24.58	24.64	281521.0
2004-03-23 09:00:00	MSFT	Stock	24.65	24.71	24.4	24.58	12350680.0
2004-03-23 10:00:00	MSFT	Stock	24.58	24.61	24.44	24.52	11639914.0
2004-03-23 11:00:00	MSFT	Stock	24.51	24.53	24.19	24.301	10593258.0
2004-03-23 12:00:00	MSFT	Stock	24.3	24.35	24.2	24.32	8431812.0
2004-03-23 13:00:00	MSFT	Stock	24.31	24.38	24.22	24.26	8827140.0
2004-03-23 14:00:00	MSFT	Stock	24.26	24.5	24.26	24.47	8987875.0
2004-03-23 15:00:00	MSFT	Stock	24.46	24.56	24.15	24.17	16287159.0
2004-03-23 16:00:00	MSFT	Stock	24.15	24.3971	24.1	24.17	1127790.0
2004-03-23 17:00:00	MSFT	Stock	24.18	24.62	24.14	24.18	44148.0
2004-03-23 18:00:00	MSFT	Stock	24.18	24.28	24.18	24.25	28600.0
2004-03-23 08:00:00	NVDA	Stock	0.1834	0.1858	0.1834	0.1858	852000.0
2004-03-23 09:00:00	NVDA	Stock	0.1858	0.1875	0.1854	0.1857	32840880.0
2004-03-23 10:00:00	NVDA	Stock	0.1857	0.1862	0.1844	0.1857	109469160.0
2004-03-23 11:00:00	NVDA	Stock	0.1858	0.1858	0.1833	0.184	52151160.0
2004-03-23 12:00:00	NVDA	Stock	0.184	0.1842	0.182	0.1833	92413800.0
2004-03-23 13:00:00	NVDA	Stock	0.1834	0.1862	0.1829	0.1857	42355320.0
2004-03-23 14:00:00	NVDA	Stock	0.1857	0.1875	0.1852	0.1873	77913960.0
2004-03-23 15:00:00	NVDA	Stock	0.1873	0.1878	0.1829	0.1837	126088320.0
2004-03-23 16:00:00	NVDA	Stock	0.1837	0.1848	0.1837	0.1837	2432280.0
2004-03-23 08:00:00	AMZN	Stock	2.055	2.072	2.0545	2.0675	118000.0
2004-03-23 09:00:00	AMZN	Stock	2.065	2.087	2.052	2.0555	26641320.0
2004-03-23 10:00:00	AMZN	Stock	2.0545	2.061	2.0065	2.015	51638060.0
2004-03-23 11:00:00	AMZN	Stock	2.0155	2.027	1.9925	2.0165	34395760.0
2004-03-23 12:00:00	AMZN	Stock	2.015	2.0315	2.0105	2.0215	19070100.0
2004-03-23 13:00:00	AMZN	Stock	2.022	2.0365	2.0075	2.0195	12057940.0
2004-03-23 14:00:00	AMZN	Stock	2.0195	2.0555	2.0165	2.0515	25249240.0
2004-03-23 15:00:00	AMZN	Stock	2.05	2.053	2.011	2.017	23345060.0
2004-03-23 16:00:00	AMZN	Stock	2.0165	2.02	2.0105	2.011	1056400.0
2004-03-23 17:00:00	AMZN	Stock	2.0105	2.013	2.0105	2.0115	128780.0
2004-03-23 18:00:00	AMZN	Stock	2.013	2.013	2.013	2.013	2000.0
2004-03-23 09:00:00	CL	Stock	26.775	26.81	26.625	26.735	459200.0
2004-03-23 10:00:00	CL	Stock	26.74	26.745	26.45	26.555	2680000.0
2004-03-23 11:00:00	CL	Stock	26.56	26.65	26.545	26.6	734400.0
2004-03-23 12:00:00	CL	Stock	26.6	26.63	26.46	26.5	390000.0
2004-03-23 13:00:00	CL	Stock	26.495	26.625	26.49	26.59	297000.0
2004-03-23 14:00:00	CL	Stock	26.59	26.66	26.555	26.645	451400.0
2004-03-23 15:00:00	CL	Stock	26.64	26.66	26.495	26.5	1066800.0
2004-03-23 16:00:00	CL	Stock	26.495	26.5275	26.495	26.495	133800.0

> showing 50 of 22,886 rows — these rows as CSV

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