PREVIEW / stock_1hour / 2003-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-11-07.parquet
  size:    492 KB
  rows:    22,734
  symbols: 1,664

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-07 08:00:00	AAPL	Stock	0.4134	0.4152	0.4132	0.4152	876400.0
2003-11-07 09:00:00	AAPL	Stock	0.4132	0.4161	0.4107	0.4111	13366416.0
2003-11-07 10:00:00	AAPL	Stock	0.4109	0.4124	0.4105	0.4116	27623736.0
2003-11-07 11:00:00	AAPL	Stock	0.4118	0.4118	0.4085	0.4089	13373024.0
2003-11-07 12:00:00	AAPL	Stock	0.4089	0.4089	0.4071	0.4077	14788144.0
2003-11-07 13:00:00	AAPL	Stock	0.4077	0.4104	0.4077	0.4095	8756440.0
2003-11-07 14:00:00	AAPL	Stock	0.4095	0.4109	0.407	0.4075	34665456.0
2003-11-07 15:00:00	AAPL	Stock	0.4075	0.4075	0.4009	0.4009	66860304.0
2003-11-07 16:00:00	AAPL	Stock	0.4009	0.402	0.4	0.402	4888576.0
2003-11-07 17:00:00	AAPL	Stock	0.402	0.4023	0.4009	0.4023	174160.0
2003-11-07 18:00:00	AAPL	Stock	0.4023	0.4023	0.4023	0.4023	5600.0
2003-11-07 08:00:00	MSFT	Stock	26.34	26.5	26.235	26.43	229967.0
2003-11-07 09:00:00	MSFT	Stock	26.43	26.45	26.24	26.32	8217444.0
2003-11-07 10:00:00	MSFT	Stock	26.31	26.49	26.261	26.43	10633253.0
2003-11-07 11:00:00	MSFT	Stock	26.44	26.46	26.359	26.43	5713774.0
2003-11-07 12:00:00	MSFT	Stock	26.43	26.452	26.27	26.3396	5258809.0
2003-11-07 13:00:00	MSFT	Stock	26.339	26.39	26.26	26.26	3425565.0
2003-11-07 14:00:00	MSFT	Stock	26.29	26.36	26.16	26.17	5842892.0
2003-11-07 15:00:00	MSFT	Stock	26.18	26.2	26.03	26.14	12401144.0
2003-11-07 16:00:00	MSFT	Stock	26.14	26.14	26.01	26.06	798771.0
2003-11-07 17:00:00	MSFT	Stock	26.07	26.11	26.04	26.09	34630.0
2003-11-07 18:00:00	MSFT	Stock	26.09	26.1	26.09	26.1	10591.0
2003-11-07 08:00:00	NVDA	Stock	0.1753	0.1821	0.1708	0.1816	146941080.0
2003-11-07 09:00:00	NVDA	Stock	0.1816	0.1847	0.1767	0.1798	1229471760.0
2003-11-07 10:00:00	NVDA	Stock	0.1798	0.1823	0.1787	0.1803	695089320.0
2003-11-07 11:00:00	NVDA	Stock	0.1803	0.1812	0.1798	0.181	331748280.0
2003-11-07 12:00:00	NVDA	Stock	0.181	0.182	0.1802	0.1811	256956960.0
2003-11-07 13:00:00	NVDA	Stock	0.1812	0.1831	0.1811	0.1822	309424200.0
2003-11-07 14:00:00	NVDA	Stock	0.1822	0.1836	0.1817	0.1835	385160400.0
2003-11-07 15:00:00	NVDA	Stock	0.1835	0.1837	0.1807	0.1811	562874040.0
2003-11-07 16:00:00	NVDA	Stock	0.1811	0.1819	0.1809	0.1812	25252680.0
2003-11-07 17:00:00	NVDA	Stock	0.1812	0.1815	0.181	0.1815	3608400.0
2003-11-07 18:00:00	NVDA	Stock	0.1816	0.1816	0.1815	0.1815	1510200.0
2003-11-07 08:00:00	AMZN	Stock	2.755	2.775	2.755	2.7675	343400.0
2003-11-07 09:00:00	AMZN	Stock	2.765	2.785	2.7421	2.744	31385100.0
2003-11-07 10:00:00	AMZN	Stock	2.7435	2.747	2.7	2.7129	49806020.0
2003-11-07 11:00:00	AMZN	Stock	2.713	2.7325	2.71	2.7235	17117980.0
2003-11-07 12:00:00	AMZN	Stock	2.7231	2.7295	2.71	2.715	10880020.0
2003-11-07 13:00:00	AMZN	Stock	2.7145	2.7295	2.714	2.728	10474060.0
2003-11-07 14:00:00	AMZN	Stock	2.728	2.747	2.7235	2.733	16215520.0
2003-11-07 15:00:00	AMZN	Stock	2.7335	2.7375	2.7125	2.7155	17880940.0
2003-11-07 16:00:00	AMZN	Stock	2.7135	2.7333	2.713	2.716	1581960.0
2003-11-07 17:00:00	AMZN	Stock	2.716	2.716	2.7	2.7025	349840.0
2003-11-07 18:00:00	AMZN	Stock	2.7135	2.7155	2.7135	2.7155	4000.0
2003-11-07 09:00:00	CL	Stock	26.125	26.22	26.075	26.175	616000.0
2003-11-07 10:00:00	CL	Stock	26.175	26.35	26.145	26.35	797200.0
2003-11-07 11:00:00	CL	Stock	26.355	26.5	26.295	26.415	484800.0
2003-11-07 12:00:00	CL	Stock	26.42	26.42	26.26	26.27	346000.0
2003-11-07 13:00:00	CL	Stock	26.27	26.28	26.125	26.165	577200.0
2003-11-07 14:00:00	CL	Stock	26.175	26.2	26.025	26.1	768800.0

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

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