PREVIEW / stock_1hour / 2004-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-16.parquet
  size:    527 KB
  rows:    25,300
  symbols: 1,874

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-11-16 08:00:00	AAPL	Stock	0.9868	1.0536	0.9863	0.9863	711592.0
2004-11-16 09:00:00	AAPL	Stock	0.9863	0.9863	0.975	0.9779	41298880.0
2004-11-16 10:00:00	AAPL	Stock	0.9782	0.9786	0.9729	0.9752	51055704.0
2004-11-16 11:00:00	AAPL	Stock	0.9757	0.9827	0.9754	0.9779	46184544.0
2004-11-16 12:00:00	AAPL	Stock	0.9777	0.9784	0.9743	0.977	25941944.0
2004-11-16 13:00:00	AAPL	Stock	0.9768	0.9798	0.9739	0.9779	33483072.0
2004-11-16 14:00:00	AAPL	Stock	0.9779	0.9791	0.9768	0.9779	37145304.0
2004-11-16 15:00:00	AAPL	Stock	0.9777	0.9813	0.9777	0.9809	44948008.0
2004-11-16 16:00:00	AAPL	Stock	0.9805	0.9864	0.9802	0.9864	3668784.0
2004-11-16 17:00:00	AAPL	Stock	0.981	0.9861	0.981	0.9839	100800.0
2004-11-16 18:00:00	AAPL	Stock	0.9854	0.9857	0.9854	0.9857	112000.0
2004-11-16 08:00:00	MSFT	Stock	27.38	27.39	27.28	27.28	89713.0
2004-11-16 09:00:00	MSFT	Stock	27.28	27.39	27.14	27.16	9231732.0
2004-11-16 10:00:00	MSFT	Stock	27.15	27.1877	27.05	27.15	12754219.0
2004-11-16 11:00:00	MSFT	Stock	27.15	27.19	27.12	27.14	6992550.0
2004-11-16 12:00:00	MSFT	Stock	27.13	27.2	27.11	27.17	6983138.0
2004-11-16 13:00:00	MSFT	Stock	27.16	27.21	27.16	27.18	4625770.0
2004-11-16 14:00:00	MSFT	Stock	27.18	27.24	27.12	27.179	6874095.0
2004-11-16 15:00:00	MSFT	Stock	27.18	27.25	27.11	27.12	12513902.0
2004-11-16 16:00:00	MSFT	Stock	27.12	27.19	27.09	27.16	1138572.0
2004-11-16 17:00:00	MSFT	Stock	27.16	27.18	27.12	27.18	50225.0
2004-11-16 18:00:00	MSFT	Stock	27.15	27.39	27.15	27.18	39045.0
2004-11-16 08:00:00	NVDA	Stock	0.1562	0.1566	0.1533	0.155	1502520.0
2004-11-16 09:00:00	NVDA	Stock	0.1554	0.1557	0.1512	0.1514	78985920.0
2004-11-16 10:00:00	NVDA	Stock	0.1514	0.1529	0.1497	0.1527	81289080.0
2004-11-16 11:00:00	NVDA	Stock	0.1528	0.1536	0.1522	0.1527	53275920.0
2004-11-16 12:00:00	NVDA	Stock	0.1527	0.1532	0.1525	0.1531	33786000.0
2004-11-16 13:00:00	NVDA	Stock	0.1532	0.1552	0.1531	0.1547	63902880.0
2004-11-16 14:00:00	NVDA	Stock	0.1546	0.1548	0.1525	0.1529	38064600.0
2004-11-16 15:00:00	NVDA	Stock	0.1529	0.1533	0.1522	0.1526	107368920.0
2004-11-16 16:00:00	NVDA	Stock	0.1526	0.1537	0.1521	0.1537	3879480.0
2004-11-16 17:00:00	NVDA	Stock	0.1537	0.1537	0.1526	0.1532	1670400.0
2004-11-16 18:00:00	NVDA	Stock	0.1533	0.1533	0.1532	0.1532	300000.0
2004-11-16 08:00:00	AMZN	Stock	2.0448	2.0448	2.0205	2.0205	756000.0
2004-11-16 09:00:00	AMZN	Stock	2.0255	2.045	2.0	2.012	20182720.0
2004-11-16 10:00:00	AMZN	Stock	2.012	2.0155	1.992	2.0085	27799260.0
2004-11-16 11:00:00	AMZN	Stock	2.009	2.0205	2.0015	2.008	11261840.0
2004-11-16 12:00:00	AMZN	Stock	2.008	2.019	2.002	2.003	10419880.0
2004-11-16 13:00:00	AMZN	Stock	2.0025	2.0055	1.9925	2.004	19506580.0
2004-11-16 14:00:00	AMZN	Stock	2.0035	2.0075	1.9875	1.9905	12943640.0
2004-11-16 15:00:00	AMZN	Stock	1.991	2.0035	1.99	2.0035	20568060.0
2004-11-16 16:00:00	AMZN	Stock	2.0035	2.0035	1.9975	2.0	2145260.0
2004-11-16 17:00:00	AMZN	Stock	2.0035	2.017	1.995	1.9996	1065020.0
2004-11-16 18:00:00	AMZN	Stock	2.0	2.0	2.0	2.0	28000.0
2004-11-16 09:00:00	CL	Stock	23.95	24.045	23.95	24.005	372200.0
2004-11-16 10:00:00	CL	Stock	23.995	24.025	23.85	23.95	723000.0
2004-11-16 11:00:00	CL	Stock	23.95	24.045	23.9	24.035	549600.0
2004-11-16 12:00:00	CL	Stock	24.03	24.14	24.015	24.125	578400.0
2004-11-16 13:00:00	CL	Stock	24.135	24.195	24.11	24.13	584800.0
2004-11-16 14:00:00	CL	Stock	24.125	24.155	24.075	24.155	716800.0

> showing 50 of 25,300 rows — these rows as CSV

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