PREVIEW / stock_1hour / 2002-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-27.parquet
  size:    414 KB
  rows:    19,336
  symbols: 1,441

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-06-27 09:00:00	AAPL	Stock	0.2991	0.3	0.295	0.2984	25676000.0
2002-06-27 10:00:00	AAPL	Stock	0.2984	0.303	0.295	0.3016	44066400.0
2002-06-27 11:00:00	AAPL	Stock	0.302	0.302	0.2932	0.2941	29394400.0
2002-06-27 12:00:00	AAPL	Stock	0.2939	0.2975	0.2938	0.2964	14190400.0
2002-06-27 13:00:00	AAPL	Stock	0.2968	0.3013	0.2948	0.2995	15360800.0
2002-06-27 14:00:00	AAPL	Stock	0.3002	0.3084	0.2989	0.307	30850400.0
2002-06-27 15:00:00	AAPL	Stock	0.3065	0.3071	0.3	0.3046	43405600.0
2002-06-27 16:00:00	AAPL	Stock	0.3045	0.3079	0.2991	0.3046	8428000.0
2002-06-27 08:00:00	MSFT	Stock	27.05	27.405	27.05	27.4	205200.0
2002-06-27 09:00:00	MSFT	Stock	27.415	27.4255	26.89	27.17	13083200.0
2002-06-27 10:00:00	MSFT	Stock	27.17	27.265	26.955	27.145	11766200.0
2002-06-27 11:00:00	MSFT	Stock	27.15	27.165	26.43	26.69	13617000.0
2002-06-27 12:00:00	MSFT	Stock	26.6945	26.915	26.575	26.845	6966000.0
2002-06-27 13:00:00	MSFT	Stock	26.85	27.095	26.775	27.025	8994000.0
2002-06-27 14:00:00	MSFT	Stock	27.03	27.4245	26.985	27.28	11710000.0
2002-06-27 15:00:00	MSFT	Stock	27.28	27.47	27.03	27.46	13392000.0
2002-06-27 16:00:00	MSFT	Stock	27.455	27.515	26.7455	27.46	2883200.0
2002-06-27 17:00:00	MSFT	Stock	27.5	27.545	27.3078	27.5	47600.0
2002-06-27 18:00:00	MSFT	Stock	27.475	27.5	27.475	27.5	2400.0
2002-06-27 08:00:00	NVDA	Stock	0.1669	0.1733	0.1668	0.1727	1932000.0
2002-06-27 09:00:00	NVDA	Stock	0.1727	0.1747	0.1617	0.1634	291996000.0
2002-06-27 10:00:00	NVDA	Stock	0.1632	0.1661	0.1576	0.1579	386772000.0
2002-06-27 11:00:00	NVDA	Stock	0.1577	0.1579	0.1467	0.1522	482520000.0
2002-06-27 12:00:00	NVDA	Stock	0.1517	0.1521	0.1472	0.15	191736000.0
2002-06-27 13:00:00	NVDA	Stock	0.1501	0.1517	0.1482	0.1508	264636000.0
2002-06-27 14:00:00	NVDA	Stock	0.1508	0.1512	0.1422	0.1434	527412000.0
2002-06-27 15:00:00	NVDA	Stock	0.1435	0.1453	0.14	0.1422	526104000.0
2002-06-27 16:00:00	NVDA	Stock	0.1425	0.1492	0.1406	0.1418	50316000.0
2002-06-27 17:00:00	NVDA	Stock	0.1421	0.1632	0.1417	0.1431	4164000.0
2002-06-27 18:00:00	NVDA	Stock	0.143	0.1437	0.1429	0.1429	948000.0
2002-06-27 08:00:00	AMZN	Stock	0.7908	0.8075	0.79	0.8031	116000.0
2002-06-27 09:00:00	AMZN	Stock	0.8075	0.8225	0.795	0.8225	18264000.0
2002-06-27 10:00:00	AMZN	Stock	0.8225	0.823	0.8	0.804	14696000.0
2002-06-27 11:00:00	AMZN	Stock	0.804	0.805	0.77	0.783	11898000.0
2002-06-27 12:00:00	AMZN	Stock	0.782	0.7825	0.768	0.775	7816000.0
2002-06-27 13:00:00	AMZN	Stock	0.7765	0.7815	0.765	0.781	10644000.0
2002-06-27 14:00:00	AMZN	Stock	0.7815	0.7925	0.772	0.774	10346000.0
2002-06-27 15:00:00	AMZN	Stock	0.7735	0.7975	0.765	0.7935	20232000.0
2002-06-27 16:00:00	AMZN	Stock	0.793	0.794	0.781	0.788	5844000.0
2002-06-27 17:00:00	AMZN	Stock	0.7935	0.7935	0.765	0.765	18000.0
2002-06-27 18:00:00	AMZN	Stock	0.793	0.7935	0.793	0.7935	34000.0
2002-06-27 09:00:00	CL	Stock	25.25	25.275	25.075	25.165	1581200.0
2002-06-27 10:00:00	CL	Stock	25.15	25.375	25.15	25.245	1541200.0
2002-06-27 11:00:00	CL	Stock	25.245	25.75	25.175	25.75	1216600.0
2002-06-27 12:00:00	CL	Stock	25.75	25.825	25.6	25.815	1120600.0
2002-06-27 13:00:00	CL	Stock	25.815	25.855	25.7	25.755	701600.0
2002-06-27 14:00:00	CL	Stock	25.785	25.925	25.73	25.825	1009600.0
2002-06-27 15:00:00	CL	Stock	25.83	25.835	25.53	25.78	1118600.0
2002-06-27 16:00:00	CL	Stock	25.78	25.78	25.5	25.765	439800.0
2002-06-27 17:00:00	CL	Stock	25.775	25.775	25.775	25.775	2400.0

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

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