PREVIEW / stock_1hour / 2002-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-28.parquet
  size:    476 KB
  rows:    22,014
  symbols: 1,452

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-28 08:00:00	AAPL	Stock	0.3048	0.3048	0.3048	0.3048	44800.0
2002-06-28 09:00:00	AAPL	Stock	0.3043	0.3138	0.303	0.3114	25065600.0
2002-06-28 10:00:00	AAPL	Stock	0.3107	0.3152	0.3077	0.3093	30884000.0
2002-06-28 11:00:00	AAPL	Stock	0.3096	0.3114	0.3089	0.3105	27042400.0
2002-06-28 12:00:00	AAPL	Stock	0.3107	0.3179	0.3105	0.3164	40107200.0
2002-06-28 13:00:00	AAPL	Stock	0.3164	0.318	0.3152	0.3164	19152000.0
2002-06-28 14:00:00	AAPL	Stock	0.3166	0.3182	0.3125	0.3145	23111200.0
2002-06-28 15:00:00	AAPL	Stock	0.3145	0.3168	0.3089	0.3163	47174400.0
2002-06-28 16:00:00	AAPL	Stock	0.3163	0.3164	0.3071	0.3164	16105600.0
2002-06-28 17:00:00	AAPL	Stock	0.3168	0.3168	0.3161	0.3168	3483200.0
2002-06-28 18:00:00	AAPL	Stock	0.316	0.3169	0.316	0.3161	1052800.0
2002-06-28 08:00:00	MSFT	Stock	27.4	27.55	27.375	27.385	306000.0
2002-06-28 09:00:00	MSFT	Stock	27.399	27.65	27.26	27.455	11618200.0
2002-06-28 10:00:00	MSFT	Stock	27.455	27.795	27.435	27.775	11450000.0
2002-06-28 11:00:00	MSFT	Stock	27.79	27.825	27.57	27.77	5384200.0
2002-06-28 12:00:00	MSFT	Stock	27.765	27.895	27.675	27.79	6802600.0
2002-06-28 13:00:00	MSFT	Stock	27.79	27.85	27.62	27.7	6012800.0
2002-06-28 14:00:00	MSFT	Stock	27.7	27.86	27.485	27.54	9649000.0
2002-06-28 15:00:00	MSFT	Stock	27.54	27.62	27.0	27.0	12724400.0
2002-06-28 16:00:00	MSFT	Stock	27.05	27.7105	26.925	27.05	9439000.0
2002-06-28 17:00:00	MSFT	Stock	27.06	27.36	27.055	27.1	5219000.0
2002-06-28 18:00:00	MSFT	Stock	27.1	27.3582	27.1	27.35	701400.0
2002-06-28 08:00:00	NVDA	Stock	0.1436	0.1436	0.1402	0.1417	1656000.0
2002-06-28 09:00:00	NVDA	Stock	0.1413	0.1427	0.1369	0.1392	302700000.0
2002-06-28 10:00:00	NVDA	Stock	0.1392	0.1442	0.1387	0.1434	363888000.0
2002-06-28 11:00:00	NVDA	Stock	0.1434	0.1457	0.1418	0.145	169068000.0
2002-06-28 12:00:00	NVDA	Stock	0.1448	0.1491	0.1444	0.1462	238728000.0
2002-06-28 13:00:00	NVDA	Stock	0.1464	0.1472	0.1414	0.1437	135408000.0
2002-06-28 14:00:00	NVDA	Stock	0.1437	0.1461	0.14	0.142	169452000.0
2002-06-28 15:00:00	NVDA	Stock	0.1417	0.1435	0.1397	0.1432	246096000.0
2002-06-28 16:00:00	NVDA	Stock	0.1431	0.1437	0.1426	0.1426	59748000.0
2002-06-28 17:00:00	NVDA	Stock	0.1427	0.1433	0.1425	0.1431	22944000.0
2002-06-28 18:00:00	NVDA	Stock	0.1431	0.1432	0.1429	0.1429	16032000.0
2002-06-28 08:00:00	AMZN	Stock	0.794	0.794	0.765	0.775	484000.0
2002-06-28 09:00:00	AMZN	Stock	0.78	0.7975	0.77	0.7875	11150000.0
2002-06-28 10:00:00	AMZN	Stock	0.7855	0.79	0.776	0.7885	15368000.0
2002-06-28 11:00:00	AMZN	Stock	0.788	0.79	0.7845	0.79	6876000.0
2002-06-28 12:00:00	AMZN	Stock	0.7895	0.804	0.7885	0.802	14190000.0
2002-06-28 13:00:00	AMZN	Stock	0.803	0.811	0.8025	0.81	12594000.0
2002-06-28 14:00:00	AMZN	Stock	0.81	0.818	0.8045	0.81	18020000.0
2002-06-28 15:00:00	AMZN	Stock	0.81	0.8175	0.8023	0.812	17238000.0
2002-06-28 16:00:00	AMZN	Stock	0.8125	0.815	0.798	0.8125	4440000.0
2002-06-28 17:00:00	AMZN	Stock	0.8135	0.8135	0.81	0.81	6838000.0
2002-06-28 18:00:00	AMZN	Stock	0.8055	0.8138	0.8055	0.8125	838000.0
2002-06-28 09:00:00	CL	Stock	25.65	25.7	25.58	25.605	467000.0
2002-06-28 10:00:00	CL	Stock	25.615	25.875	25.6	25.7	668600.0
2002-06-28 11:00:00	CL	Stock	25.7	25.835	25.63	25.705	458000.0
2002-06-28 12:00:00	CL	Stock	25.72	25.75	25.625	25.665	468800.0
2002-06-28 13:00:00	CL	Stock	25.655	25.655	25.475	25.51	631000.0
2002-06-28 14:00:00	CL	Stock	25.505	25.54	25.35	25.36	559400.0

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

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