PREVIEW / stock_1hour / 2003-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-20.parquet
  size:    450 KB
  rows:    21,336
  symbols: 1,611

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-08-20 08:00:00	AAPL	Stock	0.3629	0.3629	0.3605	0.3605	11200.0
2003-08-20 09:00:00	AAPL	Stock	0.36	0.3675	0.3593	0.3661	26898648.0
2003-08-20 10:00:00	AAPL	Stock	0.3661	0.3679	0.3643	0.3673	31514952.0
2003-08-20 11:00:00	AAPL	Stock	0.3673	0.3732	0.367	0.3729	28929768.0
2003-08-20 12:00:00	AAPL	Stock	0.3729	0.3759	0.3705	0.3757	28639744.0
2003-08-20 13:00:00	AAPL	Stock	0.3755	0.3768	0.3739	0.375	20989416.0
2003-08-20 14:00:00	AAPL	Stock	0.375	0.3754	0.3713	0.375	29250984.0
2003-08-20 15:00:00	AAPL	Stock	0.3749	0.3798	0.3745	0.3754	76849304.0
2003-08-20 16:00:00	AAPL	Stock	0.3752	0.3768	0.3673	0.3725	9290400.0
2003-08-20 17:00:00	AAPL	Stock	0.3759	0.3759	0.3759	0.3759	50400.0
2003-08-20 18:00:00	AAPL	Stock	0.3732	0.3732	0.3732	0.3732	5600.0
2003-08-20 08:00:00	MSFT	Stock	26.52	26.53	26.35	26.36	52026.0
2003-08-20 09:00:00	MSFT	Stock	26.37	26.388	26.14	26.18	13339298.0
2003-08-20 10:00:00	MSFT	Stock	26.18	26.26	26.0	26.23	9918614.0
2003-08-20 11:00:00	MSFT	Stock	26.25	26.43	26.2	26.37	6921256.0
2003-08-20 12:00:00	MSFT	Stock	26.37	26.42	26.32	26.39	4584457.0
2003-08-20 13:00:00	MSFT	Stock	26.4	26.5	26.34	26.46	3548305.0
2003-08-20 14:00:00	MSFT	Stock	26.46	26.5	26.37	26.44	5047581.0
2003-08-20 15:00:00	MSFT	Stock	26.44	26.53	26.35	26.44	6459553.0
2003-08-20 16:00:00	MSFT	Stock	26.43	26.5	26.3156	26.43	1318266.0
2003-08-20 17:00:00	MSFT	Stock	26.42	26.43	26.41	26.41	14615.0
2003-08-20 18:00:00	MSFT	Stock	26.4	26.41	26.4	26.41	300.0
2003-08-20 08:00:00	NVDA	Stock	0.1457	0.1467	0.1456	0.1467	1343400.0
2003-08-20 09:00:00	NVDA	Stock	0.1461	0.1475	0.1438	0.1457	129879000.0
2003-08-20 10:00:00	NVDA	Stock	0.1458	0.1465	0.1444	0.1462	176579160.0
2003-08-20 11:00:00	NVDA	Stock	0.1462	0.1474	0.1455	0.1472	102911280.0
2003-08-20 12:00:00	NVDA	Stock	0.1472	0.1475	0.1462	0.1468	60743160.0
2003-08-20 13:00:00	NVDA	Stock	0.1468	0.1498	0.1468	0.1486	104479200.0
2003-08-20 14:00:00	NVDA	Stock	0.1486	0.1492	0.1469	0.1477	78994560.0
2003-08-20 15:00:00	NVDA	Stock	0.1477	0.1484	0.1466	0.1469	120309000.0
2003-08-20 16:00:00	NVDA	Stock	0.1468	0.1475	0.145	0.1475	7473840.0
2003-08-20 17:00:00	NVDA	Stock	0.1467	0.1471	0.1465	0.1471	492000.0
2003-08-20 18:00:00	NVDA	Stock	0.1471	0.1471	0.1471	0.1471	24000.0
2003-08-20 08:00:00	AMZN	Stock	2.1555	2.1765	2.1555	2.1765	52000.0
2003-08-20 09:00:00	AMZN	Stock	2.156	2.174	2.15	2.1705	21700240.0
2003-08-20 10:00:00	AMZN	Stock	2.1705	2.1825	2.16	2.1795	28022840.0
2003-08-20 11:00:00	AMZN	Stock	2.18	2.197	2.179	2.196	19181240.0
2003-08-20 12:00:00	AMZN	Stock	2.196	2.196	2.1855	2.187	12025320.0
2003-08-20 13:00:00	AMZN	Stock	2.1875	2.192	2.1855	2.188	9662400.0
2003-08-20 14:00:00	AMZN	Stock	2.1875	2.188	2.1765	2.179	9769160.0
2003-08-20 15:00:00	AMZN	Stock	2.1795	2.19	2.173	2.1885	19937700.0
2003-08-20 16:00:00	AMZN	Stock	2.189	2.1925	2.1845	2.1875	3560200.0
2003-08-20 17:00:00	AMZN	Stock	2.1825	2.19	2.1825	2.189	154000.0
2003-08-20 18:00:00	AMZN	Stock	2.188	2.1925	2.188	2.192	30000.0
2003-08-20 09:00:00	CL	Stock	27.22	27.29	27.18	27.19	146200.0
2003-08-20 10:00:00	CL	Stock	27.18	27.24	27.08	27.1	183400.0
2003-08-20 11:00:00	CL	Stock	27.115	27.26	27.115	27.225	136800.0
2003-08-20 12:00:00	CL	Stock	27.225	27.225	27.13	27.16	232200.0
2003-08-20 13:00:00	CL	Stock	27.165	27.305	27.165	27.265	421800.0
2003-08-20 14:00:00	CL	Stock	27.28	27.315	27.245	27.315	238200.0

> showing 50 of 21,336 rows — these rows as CSV

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