PREVIEW / stock_1hour / 2002-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-11.parquet
  size:    420 KB
  rows:    19,806
  symbols: 1,448

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
2002-07-11 08:00:00	AAPL	Stock	0.3125	0.3125	0.3098	0.3098	72800.0
2002-07-11 09:00:00	AAPL	Stock	0.3045	0.3127	0.303	0.3116	29573600.0
2002-07-11 10:00:00	AAPL	Stock	0.3114	0.3184	0.308	0.313	44184000.0
2002-07-11 11:00:00	AAPL	Stock	0.3132	0.3146	0.3079	0.3102	20020000.0
2002-07-11 12:00:00	AAPL	Stock	0.3102	0.3173	0.308	0.3164	29758400.0
2002-07-11 13:00:00	AAPL	Stock	0.3164	0.3209	0.3138	0.3205	33241600.0
2002-07-11 14:00:00	AAPL	Stock	0.3205	0.3234	0.317	0.3171	46916800.0
2002-07-11 15:00:00	AAPL	Stock	0.3175	0.3277	0.3159	0.3264	57204000.0
2002-07-11 16:00:00	AAPL	Stock	0.3266	0.3279	0.3167	0.3167	98173600.0
2002-07-11 17:00:00	AAPL	Stock	0.3266	0.3393	0.325	0.3348	10192000.0
2002-07-11 18:00:00	AAPL	Stock	0.3339	0.3339	0.3268	0.3339	789600.0
2002-07-11 08:00:00	MSFT	Stock	26.24	26.24	26.025	26.1	98000.0
2002-07-11 09:00:00	MSFT	Stock	26.1	26.115	25.6435	26.05	16283000.0
2002-07-11 10:00:00	MSFT	Stock	26.045	26.3525	25.625	25.885	23367000.0
2002-07-11 11:00:00	MSFT	Stock	25.885	26.025	25.66	25.78	10597400.0
2002-07-11 12:00:00	MSFT	Stock	25.775	26.36	25.715	26.21	14537800.0
2002-07-11 13:00:00	MSFT	Stock	26.237	26.31	25.89	26.045	15638000.0
2002-07-11 14:00:00	MSFT	Stock	26.06	26.345	25.755	25.785	19973000.0
2002-07-11 15:00:00	MSFT	Stock	25.79	26.5375	25.76	26.455	18875600.0
2002-07-11 16:00:00	MSFT	Stock	26.455	28.45	25.8	26.385	4118000.0
2002-07-11 17:00:00	MSFT	Stock	26.385	27.0	26.375	26.91	536800.0
2002-07-11 18:00:00	MSFT	Stock	26.915	26.975	26.0308	26.945	123000.0
2002-07-11 08:00:00	NVDA	Stock	0.1517	0.152	0.1508	0.1508	1428000.0
2002-07-11 09:00:00	NVDA	Stock	0.1507	0.1571	0.1486	0.1562	131940000.0
2002-07-11 10:00:00	NVDA	Stock	0.1566	0.1608	0.155	0.1571	259896000.0
2002-07-11 11:00:00	NVDA	Stock	0.157	0.1579	0.1534	0.1545	80712000.0
2002-07-11 12:00:00	NVDA	Stock	0.1546	0.16	0.1537	0.1585	122148000.0
2002-07-11 13:00:00	NVDA	Stock	0.1587	0.1618	0.1582	0.1609	130632000.0
2002-07-11 14:00:00	NVDA	Stock	0.1609	0.1641	0.1602	0.1617	187920000.0
2002-07-11 15:00:00	NVDA	Stock	0.1618	0.1667	0.1617	0.1662	173364000.0
2002-07-11 16:00:00	NVDA	Stock	0.1661	0.1703	0.159	0.1661	24768000.0
2002-07-11 17:00:00	NVDA	Stock	0.1683	0.1747	0.1661	0.1723	5748000.0
2002-07-11 18:00:00	NVDA	Stock	0.1725	0.1737	0.1661	0.1736	948000.0
2002-07-11 08:00:00	AMZN	Stock	0.7475	0.76	0.736	0.736	152000.0
2002-07-11 09:00:00	AMZN	Stock	0.7359	0.745	0.7	0.715	23628000.0
2002-07-11 10:00:00	AMZN	Stock	0.715	0.7465	0.711	0.72	20786000.0
2002-07-11 11:00:00	AMZN	Stock	0.7225	0.7245	0.7105	0.717	7078000.0
2002-07-11 12:00:00	AMZN	Stock	0.7165	0.742	0.7115	0.7365	13816000.0
2002-07-11 13:00:00	AMZN	Stock	0.7365	0.747	0.728	0.747	12858000.0
2002-07-11 14:00:00	AMZN	Stock	0.7465	0.777	0.7425	0.7715	28588000.0
2002-07-11 15:00:00	AMZN	Stock	0.7716	0.792	0.768	0.7795	31970000.0
2002-07-11 16:00:00	AMZN	Stock	0.7775	0.784	0.7435	0.744	2340000.0
2002-07-11 17:00:00	AMZN	Stock	0.785	0.795	0.7775	0.795	200000.0
2002-07-11 18:00:00	AMZN	Stock	0.7775	0.7775	0.7775	0.7775	120000.0
2002-07-11 09:00:00	CL	Stock	24.75	24.935	24.63	24.925	760200.0
2002-07-11 10:00:00	CL	Stock	24.905	25.09	24.805	24.98	1362600.0
2002-07-11 11:00:00	CL	Stock	24.985	25.03	24.75	24.795	713000.0
2002-07-11 12:00:00	CL	Stock	24.785	24.875	24.555	24.81	1081000.0
2002-07-11 13:00:00	CL	Stock	24.805	24.98	24.775	24.91	721600.0
2002-07-11 14:00:00	CL	Stock	24.905	25.045	24.9	25.025	750600.0

> showing 50 of 19,806 rows — these rows as CSV

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