PREVIEW / stock_1hour / 2003-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-23.parquet
  size:    466 KB
  rows:    22,096
  symbols: 1,613

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
2003-09-23 09:00:00	AAPL	Stock	0.393	0.4011	0.3907	0.3993	33433736.0
2003-09-23 10:00:00	AAPL	Stock	0.3995	0.3996	0.3943	0.3963	21432544.0
2003-09-23 11:00:00	AAPL	Stock	0.3963	0.3971	0.3946	0.3968	7992208.0
2003-09-23 12:00:00	AAPL	Stock	0.397	0.3991	0.3954	0.3973	10534048.0
2003-09-23 13:00:00	AAPL	Stock	0.3971	0.3984	0.3961	0.398	7547848.0
2003-09-23 14:00:00	AAPL	Stock	0.3977	0.3996	0.3973	0.3995	11124456.0
2003-09-23 15:00:00	AAPL	Stock	0.3996	0.4009	0.3971	0.4002	33302304.0
2003-09-23 16:00:00	AAPL	Stock	0.4005	0.4005	0.3973	0.4005	862400.0
2003-09-23 17:00:00	AAPL	Stock	0.4005	0.4005	0.4005	0.4005	1416800.0
2003-09-23 08:00:00	MSFT	Stock	29.2	29.25	29.18	29.202	39824.0
2003-09-23 09:00:00	MSFT	Stock	29.24	29.28	28.88	29.18	7210388.0
2003-09-23 10:00:00	MSFT	Stock	29.18	29.39	29.1	29.19	10831552.0
2003-09-23 11:00:00	MSFT	Stock	29.18	29.28	29.0	29.14	8016731.0
2003-09-23 12:00:00	MSFT	Stock	29.141	29.24	29.1	29.18	3395853.0
2003-09-23 13:00:00	MSFT	Stock	29.18	29.28	29.11	29.16	3859333.0
2003-09-23 14:00:00	MSFT	Stock	29.16	29.39	29.11	29.371	5818658.0
2003-09-23 15:00:00	MSFT	Stock	29.39	29.63	29.37	29.58	9942863.0
2003-09-23 16:00:00	MSFT	Stock	29.58	29.71	29.54	29.62	937039.0
2003-09-23 17:00:00	MSFT	Stock	29.64	29.7	29.64	29.669	543300.0
2003-09-23 18:00:00	MSFT	Stock	29.64	29.64	29.64	29.64	558.0
2003-09-23 08:00:00	NVDA	Stock	0.1596	0.1599	0.1591	0.1591	2503200.0
2003-09-23 09:00:00	NVDA	Stock	0.1592	0.1612	0.1588	0.1605	99818040.0
2003-09-23 10:00:00	NVDA	Stock	0.1607	0.1608	0.1585	0.1585	103720200.0
2003-09-23 11:00:00	NVDA	Stock	0.1586	0.1594	0.157	0.1582	95514720.0
2003-09-23 12:00:00	NVDA	Stock	0.1582	0.1591	0.1579	0.1587	66055680.0
2003-09-23 13:00:00	NVDA	Stock	0.1587	0.1602	0.1583	0.1594	53974800.0
2003-09-23 14:00:00	NVDA	Stock	0.1594	0.1602	0.1592	0.1597	43600440.0
2003-09-23 15:00:00	NVDA	Stock	0.1598	0.1612	0.1597	0.1607	90513960.0
2003-09-23 16:00:00	NVDA	Stock	0.1606	0.1607	0.1581	0.1581	2754840.0
2003-09-23 17:00:00	NVDA	Stock	0.1602	0.1603	0.1597	0.1597	587520.0
2003-09-23 18:00:00	NVDA	Stock	0.1601	0.1601	0.1598	0.1598	60480.0
2003-09-23 08:00:00	AMZN	Stock	2.3723	2.3825	2.3723	2.379	538580.0
2003-09-23 09:00:00	AMZN	Stock	2.3785	2.398	2.3675	2.394	19816340.0
2003-09-23 10:00:00	AMZN	Stock	2.394	2.424	2.384	2.4174	35167460.0
2003-09-23 11:00:00	AMZN	Stock	2.417	2.455	2.414	2.4425	49267000.0
2003-09-23 12:00:00	AMZN	Stock	2.444	2.467	2.44	2.4635	26762380.0
2003-09-23 13:00:00	AMZN	Stock	2.4645	2.517	2.46	2.5085	84911040.0
2003-09-23 14:00:00	AMZN	Stock	2.5086	2.539	2.5035	2.5345	61731620.0
2003-09-23 15:00:00	AMZN	Stock	2.5335	2.546	2.5155	2.5225	76105080.0
2003-09-23 16:00:00	AMZN	Stock	2.5225	2.531	2.52	2.5295	4239460.0
2003-09-23 17:00:00	AMZN	Stock	2.5265	2.5325	2.521	2.53	667000.0
2003-09-23 18:00:00	AMZN	Stock	2.529	2.529	2.525	2.5275	82020.0
2003-09-23 09:00:00	CL	Stock	27.5	27.65	27.5	27.595	184600.0
2003-09-23 10:00:00	CL	Stock	27.595	27.745	27.53	27.53	479000.0
2003-09-23 11:00:00	CL	Stock	27.525	27.72	27.525	27.715	304600.0
2003-09-23 12:00:00	CL	Stock	27.72	27.775	27.645	27.72	468800.0
2003-09-23 13:00:00	CL	Stock	27.725	27.75	27.665	27.675	401200.0
2003-09-23 14:00:00	CL	Stock	27.675	27.76	27.645	27.745	262800.0
2003-09-23 15:00:00	CL	Stock	27.75	27.8	27.68	27.72	486600.0
2003-09-23 16:00:00	CL	Stock	27.72	27.72	27.715	27.715	235400.0

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

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