PREVIEW / stock_1hour / 2003-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-11-17.parquet
  size:    520 KB
  rows:    23,890
  symbols: 1,674

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-11-17 08:00:00	AAPL	Stock	0.3821	0.3821	0.3795	0.3795	16800.0
2003-11-17 09:00:00	AAPL	Stock	0.3832	0.3832	0.3752	0.3766	37384088.0
2003-11-17 10:00:00	AAPL	Stock	0.3764	0.3773	0.3745	0.3773	33165776.0
2003-11-17 11:00:00	AAPL	Stock	0.3775	0.3779	0.3741	0.3771	23065224.0
2003-11-17 12:00:00	AAPL	Stock	0.3771	0.3786	0.3761	0.378	18639712.0
2003-11-17 13:00:00	AAPL	Stock	0.378	0.3791	0.3745	0.3755	19590088.0
2003-11-17 14:00:00	AAPL	Stock	0.3757	0.3791	0.375	0.3788	16445632.0
2003-11-17 15:00:00	AAPL	Stock	0.3788	0.3793	0.375	0.3779	49687288.0
2003-11-17 16:00:00	AAPL	Stock	0.3768	0.3782	0.3759	0.378	6414240.0
2003-11-17 17:00:00	AAPL	Stock	0.378	0.378	0.3768	0.3768	2804536.0
2003-11-17 18:00:00	AAPL	Stock	0.378	0.378	0.3768	0.3768	40488.0
2003-11-17 08:00:00	MSFT	Stock	25.4	25.4	25.29	25.31	61400.0
2003-11-17 09:00:00	MSFT	Stock	25.31	25.45	25.22	25.28	9792566.0
2003-11-17 10:00:00	MSFT	Stock	25.28	25.3	25.1	25.14	15410819.0
2003-11-17 11:00:00	MSFT	Stock	25.14	25.17	25.05	25.17	13335434.0
2003-11-17 12:00:00	MSFT	Stock	25.17	25.18	25.1	25.11	6141681.0
2003-11-17 13:00:00	MSFT	Stock	25.12	25.12	25.01	25.02	10016153.0
2003-11-17 14:00:00	MSFT	Stock	25.02	25.08	24.95	25.011	17178179.0
2003-11-17 15:00:00	MSFT	Stock	25.01	25.26	25.01	25.18	22668924.0
2003-11-17 16:00:00	MSFT	Stock	25.2	25.24	25.1	25.19	1641178.0
2003-11-17 17:00:00	MSFT	Stock	25.19	25.21	25.0721	25.0721	278953.0
2003-11-17 18:00:00	MSFT	Stock	25.2	25.21	25.0979	25.19	10300.0
2003-11-17 08:00:00	NVDA	Stock	0.1667	0.1671	0.1651	0.1658	1227480.0
2003-11-17 09:00:00	NVDA	Stock	0.1659	0.1683	0.1646	0.1666	94066200.0
2003-11-17 10:00:00	NVDA	Stock	0.1662	0.1667	0.164	0.1645	98657280.0
2003-11-17 11:00:00	NVDA	Stock	0.1645	0.1646	0.1634	0.1645	61460760.0
2003-11-17 12:00:00	NVDA	Stock	0.1645	0.1646	0.1639	0.1643	55556880.0
2003-11-17 13:00:00	NVDA	Stock	0.1643	0.1645	0.1637	0.1642	42084120.0
2003-11-17 14:00:00	NVDA	Stock	0.1643	0.1649	0.1641	0.1647	86555640.0
2003-11-17 15:00:00	NVDA	Stock	0.1647	0.1664	0.1644	0.1662	88819800.0
2003-11-17 16:00:00	NVDA	Stock	0.1663	0.1696	0.1653	0.1687	9229560.0
2003-11-17 17:00:00	NVDA	Stock	0.1686	0.1687	0.1648	0.1687	4799880.0
2003-11-17 18:00:00	NVDA	Stock	0.1687	0.169	0.165	0.1677	786000.0
2003-11-17 08:00:00	AMZN	Stock	2.6145	2.6145	2.589	2.6005	234000.0
2003-11-17 09:00:00	AMZN	Stock	2.6	2.6245	2.581	2.602	21686080.0
2003-11-17 10:00:00	AMZN	Stock	2.5999	2.602	2.5525	2.555	30228020.0
2003-11-17 11:00:00	AMZN	Stock	2.556	2.556	2.519	2.5525	38754880.0
2003-11-17 12:00:00	AMZN	Stock	2.5525	2.5581	2.531	2.539	16598340.0
2003-11-17 13:00:00	AMZN	Stock	2.5395	2.5395	2.502	2.5095	24942080.0
2003-11-17 14:00:00	AMZN	Stock	2.51	2.52	2.479	2.4985	48402780.0
2003-11-17 15:00:00	AMZN	Stock	2.4985	2.5225	2.4805	2.5225	58444480.0
2003-11-17 16:00:00	AMZN	Stock	2.5225	2.5225	2.5155	2.517	3160360.0
2003-11-17 17:00:00	AMZN	Stock	2.5175	2.5195	2.515	2.5151	518040.0
2003-11-17 18:00:00	AMZN	Stock	2.5151	2.5151	2.498	2.5075	74980.0
2003-11-17 09:00:00	CL	Stock	26.055	26.205	26.005	26.075	520000.0
2003-11-17 10:00:00	CL	Stock	26.09	26.16	26.06	26.13	387800.0
2003-11-17 11:00:00	CL	Stock	26.13	26.2	25.98	26.0	757400.0
2003-11-17 12:00:00	CL	Stock	26.0	26.015	25.88	25.885	475600.0
2003-11-17 13:00:00	CL	Stock	25.885	25.965	25.875	25.905	418600.0
2003-11-17 14:00:00	CL	Stock	25.91	25.935	25.8	25.825	818400.0

> showing 50 of 23,890 rows — these rows as CSV

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