PREVIEW / stock_1hour / 2002-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-30.parquet
  size:    397 KB
  rows:    18,980
  symbols: 1,465

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-30 09:00:00	AAPL	Stock	0.2668	0.2677	0.26	0.267	35073136.0
2002-07-30 10:00:00	AAPL	Stock	0.2666	0.2723	0.2638	0.2675	69655320.0
2002-07-30 11:00:00	AAPL	Stock	0.2673	0.2696	0.2664	0.2675	27583304.0
2002-07-30 12:00:00	AAPL	Stock	0.2676	0.2732	0.2675	0.2723	33839008.0
2002-07-30 13:00:00	AAPL	Stock	0.2723	0.2768	0.2718	0.2739	49004144.0
2002-07-30 14:00:00	AAPL	Stock	0.2739	0.2763	0.2709	0.275	64590792.0
2002-07-30 15:00:00	AAPL	Stock	0.2752	0.277	0.2727	0.2766	44926672.0
2002-07-30 16:00:00	AAPL	Stock	0.2766	0.2766	0.2716	0.2755	18200000.0
2002-07-30 17:00:00	AAPL	Stock	0.2716	0.2716	0.2716	0.2716	5600.0
2002-07-30 18:00:00	AAPL	Stock	0.2723	0.2755	0.2723	0.2755	28000.0
2002-07-30 08:00:00	MSFT	Stock	24.125	24.125	23.799	23.825	141604.0
2002-07-30 09:00:00	MSFT	Stock	24.125	24.125	23.665	23.99	18291318.0
2002-07-30 10:00:00	MSFT	Stock	23.99	24.1	23.79	24.01	23560010.0
2002-07-30 11:00:00	MSFT	Stock	24.015	24.07	23.848	23.935	10183538.0
2002-07-30 12:00:00	MSFT	Stock	23.945	24.05	23.87	24.0	10593368.0
2002-07-30 13:00:00	MSFT	Stock	24.0	24.415	23.975	24.32	17768610.0
2002-07-30 14:00:00	MSFT	Stock	24.32	24.3965	23.68	23.7005	19039758.0
2002-07-30 15:00:00	MSFT	Stock	23.695	24.085	23.695	24.045	17788072.0
2002-07-30 16:00:00	MSFT	Stock	24.05	24.4	23.75	23.825	3468006.0
2002-07-30 17:00:00	MSFT	Stock	23.85	24.0042	23.8	23.869	109700.0
2002-07-30 18:00:00	MSFT	Stock	24.05	24.05	23.825	23.825	25400.0
2002-07-30 08:00:00	NVDA	Stock	0.1262	0.1295	0.125	0.125	2322480.0
2002-07-30 09:00:00	NVDA	Stock	0.1243	0.1312	0.124	0.1307	203843160.0
2002-07-30 10:00:00	NVDA	Stock	0.1304	0.1362	0.1288	0.1361	340922880.0
2002-07-30 11:00:00	NVDA	Stock	0.1361	0.1362	0.131	0.1327	268746360.0
2002-07-30 12:00:00	NVDA	Stock	0.1326	0.1342	0.1314	0.134	145189560.0
2002-07-30 13:00:00	NVDA	Stock	0.134	0.1412	0.1333	0.1403	315063960.0
2002-07-30 14:00:00	NVDA	Stock	0.1404	0.1415	0.1357	0.1358	231899520.0
2002-07-30 15:00:00	NVDA	Stock	0.1359	0.1382	0.1343	0.1352	227841960.0
2002-07-30 16:00:00	NVDA	Stock	0.1352	0.1379	0.0946	0.105	34336320.0
2002-07-30 17:00:00	NVDA	Stock	0.1056	0.1067	0.1022	0.1041	41102760.0
2002-07-30 18:00:00	NVDA	Stock	0.1039	0.1047	0.103	0.1039	6543480.0
2002-07-30 08:00:00	AMZN	Stock	0.7145	0.7165	0.699	0.7045	344000.0
2002-07-30 09:00:00	AMZN	Stock	0.709	0.7165	0.704	0.711	14254700.0
2002-07-30 10:00:00	AMZN	Stock	0.709	0.716	0.7045	0.713	17603820.0
2002-07-30 11:00:00	AMZN	Stock	0.713	0.7255	0.7125	0.7195	12652860.0
2002-07-30 12:00:00	AMZN	Stock	0.7195	0.739	0.719	0.7355	12827500.0
2002-07-30 13:00:00	AMZN	Stock	0.736	0.745	0.7335	0.742	19279220.0
2002-07-30 14:00:00	AMZN	Stock	0.7415	0.7425	0.7295	0.736	12327940.0
2002-07-30 15:00:00	AMZN	Stock	0.7355	0.745	0.7285	0.7385	15036400.0
2002-07-30 16:00:00	AMZN	Stock	0.739	0.7395	0.7275	0.7285	3600000.0
2002-07-30 17:00:00	AMZN	Stock	0.73	0.745	0.73	0.7385	602000.0
2002-07-30 18:00:00	AMZN	Stock	0.7385	0.7385	0.7385	0.7385	4000.0
2002-07-30 09:00:00	CL	Stock	25.95	25.95	25.75	25.755	791000.0
2002-07-30 10:00:00	CL	Stock	25.75	26.0	25.58	25.68	1225400.0
2002-07-30 11:00:00	CL	Stock	25.68	25.86	25.55	25.83	628800.0
2002-07-30 12:00:00	CL	Stock	25.83	25.95	25.69	25.71	475400.0
2002-07-30 13:00:00	CL	Stock	25.685	25.925	25.625	25.84	440600.0
2002-07-30 14:00:00	CL	Stock	25.825	25.825	25.425	25.54	812200.0
2002-07-30 15:00:00	CL	Stock	25.535	25.7	25.465	25.645	1070600.0

> showing 50 of 18,980 rows — these rows as CSV

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