PREVIEW / stock_1hour / 2004-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-27.parquet
  size:    508 KB
  rows:    23,936
  symbols: 1,763

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-04-27 08:00:00	AAPL	Stock	0.4846	0.4857	0.4846	0.4854	134400.0
2004-04-27 09:00:00	AAPL	Stock	0.4854	0.4882	0.4766	0.4795	51750104.0
2004-04-27 10:00:00	AAPL	Stock	0.4793	0.4827	0.4779	0.48	53505088.0
2004-04-27 11:00:00	AAPL	Stock	0.48	0.4829	0.478	0.4821	26566008.0
2004-04-27 12:00:00	AAPL	Stock	0.4821	0.4839	0.4818	0.4825	19170144.0
2004-04-27 13:00:00	AAPL	Stock	0.4827	0.4832	0.4798	0.48	16367904.0
2004-04-27 14:00:00	AAPL	Stock	0.4805	0.4807	0.477	0.4786	40502000.0
2004-04-27 15:00:00	AAPL	Stock	0.4788	0.4823	0.4779	0.4811	33932864.0
2004-04-27 16:00:00	AAPL	Stock	0.4809	0.4823	0.4802	0.4815	7994280.0
2004-04-27 08:00:00	MSFT	Stock	27.22	27.24	27.18	27.24	18990.0
2004-04-27 09:00:00	MSFT	Stock	27.24	27.25	27.13	27.22	10043847.0
2004-04-27 10:00:00	MSFT	Stock	27.17	27.37	27.16	27.22	15656230.0
2004-04-27 11:00:00	MSFT	Stock	27.22	27.28	27.17	27.23	7453932.0
2004-04-27 12:00:00	MSFT	Stock	27.24	27.29	27.2	27.27	4258743.0
2004-04-27 13:00:00	MSFT	Stock	27.27	27.37	27.2	27.34	9263378.0
2004-04-27 14:00:00	MSFT	Stock	27.34	27.36	27.18	27.23	11709221.0
2004-04-27 15:00:00	MSFT	Stock	27.22	27.36	27.18	27.26	10604917.0
2004-04-27 16:00:00	MSFT	Stock	27.25	27.297	27.176	27.23	3184043.0
2004-04-27 17:00:00	MSFT	Stock	27.23	27.27	27.23	27.27	13779.0
2004-04-27 18:00:00	MSFT	Stock	27.24	27.24	27.23	27.23	1351102.0
2004-04-27 08:00:00	NVDA	Stock	0.1861	0.1866	0.1861	0.1862	798120.0
2004-04-27 09:00:00	NVDA	Stock	0.1867	0.1916	0.1865	0.1907	52185480.0
2004-04-27 10:00:00	NVDA	Stock	0.1907	0.1932	0.1895	0.1897	104200440.0
2004-04-27 11:00:00	NVDA	Stock	0.1897	0.19	0.1866	0.1892	65424840.0
2004-04-27 12:00:00	NVDA	Stock	0.1892	0.19	0.1887	0.1899	15986040.0
2004-04-27 13:00:00	NVDA	Stock	0.1899	0.19	0.1877	0.1896	24235440.0
2004-04-27 14:00:00	NVDA	Stock	0.1896	0.1897	0.1842	0.1856	89700840.0
2004-04-27 15:00:00	NVDA	Stock	0.1856	0.186	0.1838	0.1846	67477080.0
2004-04-27 16:00:00	NVDA	Stock	0.1842	0.1854	0.1842	0.185	1731480.0
2004-04-27 17:00:00	NVDA	Stock	0.1846	0.1846	0.1846	0.1846	552000.0
2004-04-27 08:00:00	AMZN	Stock	2.362	2.3655	2.362	2.3655	28000.0
2004-04-27 09:00:00	AMZN	Stock	2.3675	2.383	2.343	2.3475	15047280.0
2004-04-27 10:00:00	AMZN	Stock	2.3475	2.3603	2.3425	2.3465	20957320.0
2004-04-27 11:00:00	AMZN	Stock	2.346	2.3575	2.3395	2.3575	12825480.0
2004-04-27 12:00:00	AMZN	Stock	2.358	2.383	2.355	2.382	15664300.0
2004-04-27 13:00:00	AMZN	Stock	2.383	2.4375	2.382	2.4285	31423680.0
2004-04-27 14:00:00	AMZN	Stock	2.4285	2.44	2.3945	2.407	29827560.0
2004-04-27 15:00:00	AMZN	Stock	2.407	2.424	2.386	2.4005	26205960.0
2004-04-27 16:00:00	AMZN	Stock	2.4	2.4045	2.3905	2.4	1281220.0
2004-04-27 17:00:00	AMZN	Stock	2.395	2.395	2.395	2.395	4000.0
2004-04-27 18:00:00	AMZN	Stock	2.3995	2.3995	2.3995	2.3995	18400.0
2004-04-27 09:00:00	CL	Stock	28.5	28.525	28.455	28.48	350200.0
2004-04-27 10:00:00	CL	Stock	28.48	28.565	28.465	28.54	624200.0
2004-04-27 11:00:00	CL	Stock	28.54	28.55	28.515	28.525	338200.0
2004-04-27 12:00:00	CL	Stock	28.525	28.53	28.465	28.485	444800.0
2004-04-27 13:00:00	CL	Stock	28.48	28.525	28.475	28.525	206600.0
2004-04-27 14:00:00	CL	Stock	28.52	28.54	28.45	28.485	543400.0
2004-04-27 15:00:00	CL	Stock	28.485	28.55	28.45	28.505	874200.0
2004-04-27 16:00:00	CL	Stock	28.51	28.5115	28.51	28.51	20200.0

> showing 49 of 23,936 rows — these rows as CSV

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