PREVIEW / stock_1hour / 2004-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-03.parquet
  size:    492 KB
  rows:    23,227
  symbols: 1,774

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-06-03 09:00:00	AAPL	Stock	0.5125	0.5177	0.508	0.515	36109304.0
2004-06-03 10:00:00	AAPL	Stock	0.515	0.515	0.5054	0.5077	50684592.0
2004-06-03 11:00:00	AAPL	Stock	0.5077	0.5095	0.5052	0.5082	19219256.0
2004-06-03 12:00:00	AAPL	Stock	0.5084	0.512	0.5071	0.5116	25787272.0
2004-06-03 13:00:00	AAPL	Stock	0.5118	0.5136	0.5091	0.5091	16238712.0
2004-06-03 14:00:00	AAPL	Stock	0.5091	0.5107	0.5066	0.5091	37398816.0
2004-06-03 15:00:00	AAPL	Stock	0.5089	0.5107	0.5061	0.5084	51648184.0
2004-06-03 16:00:00	AAPL	Stock	0.5064	0.5091	0.5064	0.5071	4978400.0
2004-06-03 17:00:00	AAPL	Stock	0.5091	0.5092	0.5091	0.5091	3136000.0
2004-06-03 08:00:00	MSFT	Stock	26.14	26.19	26.09	26.1	52373.0
2004-06-03 09:00:00	MSFT	Stock	26.08	26.11	25.97	26.0	4980173.0
2004-06-03 10:00:00	MSFT	Stock	25.99	26.05	25.93	26.0	9417509.0
2004-06-03 11:00:00	MSFT	Stock	26.0	26.05	25.99	26.02	5869458.0
2004-06-03 12:00:00	MSFT	Stock	26.02	26.13	26.01	26.05	3923260.0
2004-06-03 13:00:00	MSFT	Stock	26.05	26.08	26.0	26.01	3773861.0
2004-06-03 14:00:00	MSFT	Stock	26.01	26.0238	25.9399	26.0	4586813.0
2004-06-03 15:00:00	MSFT	Stock	26.0	26.101	25.87	25.87	11554730.0
2004-06-03 16:00:00	MSFT	Stock	25.87	26.04	25.84	25.99	1026841.0
2004-06-03 17:00:00	MSFT	Stock	25.98	25.98	25.96	25.96	15700.0
2004-06-03 18:00:00	MSFT	Stock	25.99	26.0	25.99	26.0	3500.0
2004-06-03 09:00:00	NVDA	Stock	0.1922	0.1942	0.1877	0.1887	117250800.0
2004-06-03 10:00:00	NVDA	Stock	0.1887	0.1921	0.1874	0.1891	143827440.0
2004-06-03 11:00:00	NVDA	Stock	0.1891	0.1897	0.188	0.1893	60600120.0
2004-06-03 12:00:00	NVDA	Stock	0.1893	0.1893	0.1866	0.1872	61583280.0
2004-06-03 13:00:00	NVDA	Stock	0.1872	0.1882	0.186	0.1861	36084240.0
2004-06-03 14:00:00	NVDA	Stock	0.1861	0.1861	0.1842	0.1854	101012760.0
2004-06-03 15:00:00	NVDA	Stock	0.1853	0.1863	0.1838	0.1842	145102320.0
2004-06-03 16:00:00	NVDA	Stock	0.1844	0.1882	0.184	0.1875	19702560.0
2004-06-03 17:00:00	NVDA	Stock	0.1871	0.1871	0.1842	0.1867	1183920.0
2004-06-03 18:00:00	NVDA	Stock	0.187	0.187	0.187	0.187	60000.0
2004-06-03 08:00:00	AMZN	Stock	2.5055	2.5135	2.49	2.4975	642000.0
2004-06-03 09:00:00	AMZN	Stock	2.4975	2.5175	2.4875	2.5	28846160.0
2004-06-03 10:00:00	AMZN	Stock	2.5	2.5025	2.4825	2.4875	35221720.0
2004-06-03 11:00:00	AMZN	Stock	2.4875	2.5105	2.485	2.507	21992040.0
2004-06-03 12:00:00	AMZN	Stock	2.5075	2.5175	2.5	2.502	18970860.0
2004-06-03 13:00:00	AMZN	Stock	2.5015	2.5027	2.491	2.492	14657040.0
2004-06-03 14:00:00	AMZN	Stock	2.491	2.4925	2.472	2.4775	21558060.0
2004-06-03 15:00:00	AMZN	Stock	2.4775	2.4805	2.471	2.473	18232960.0
2004-06-03 16:00:00	AMZN	Stock	2.474	2.493	2.4699	2.4714	3865760.0
2004-06-03 17:00:00	AMZN	Stock	2.4945	2.4945	2.47	2.4795	120400.0
2004-06-03 09:00:00	CL	Stock	28.56	28.65	28.5	28.61	265800.0
2004-06-03 10:00:00	CL	Stock	28.605	28.695	28.56	28.625	414800.0
2004-06-03 11:00:00	CL	Stock	28.625	28.67	28.6	28.645	329000.0
2004-06-03 12:00:00	CL	Stock	28.635	28.66	28.625	28.63	152000.0
2004-06-03 13:00:00	CL	Stock	28.63	28.655	28.595	28.61	249600.0
2004-06-03 14:00:00	CL	Stock	28.61	28.615	28.55	28.59	371400.0
2004-06-03 15:00:00	CL	Stock	28.585	28.59	28.5	28.535	757600.0
2004-06-03 16:00:00	CL	Stock	28.51	28.5255	28.51	28.5255	12800.0

> showing 48 of 23,227 rows — these rows as CSV

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