PREVIEW / stock_1hour / 2004-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-30.parquet
  size:    537 KB
  rows:    25,242
  symbols: 1,827

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
2004-09-30 08:00:00	AAPL	Stock	0.6925	0.7018	0.6909	0.6989	1383480.0
2004-09-30 09:00:00	AAPL	Stock	0.6973	0.7013	0.6943	0.6954	62243720.0
2004-09-30 10:00:00	AAPL	Stock	0.6954	0.6979	0.693	0.693	57272992.0
2004-09-30 11:00:00	AAPL	Stock	0.693	0.6945	0.6882	0.6907	37730280.0
2004-09-30 12:00:00	AAPL	Stock	0.6907	0.6911	0.6877	0.688	22476496.0
2004-09-30 13:00:00	AAPL	Stock	0.6879	0.6916	0.6866	0.6904	27021792.0
2004-09-30 14:00:00	AAPL	Stock	0.6904	0.6964	0.6888	0.693	41767320.0
2004-09-30 15:00:00	AAPL	Stock	0.6927	0.6973	0.6896	0.6921	109303712.0
2004-09-30 16:00:00	AAPL	Stock	0.6914	0.6929	0.6905	0.692	20938736.0
2004-09-30 17:00:00	AAPL	Stock	0.692	0.6933	0.6904	0.6932	24724224.0
2004-09-30 18:00:00	AAPL	Stock	0.6904	0.6904	0.6904	0.6904	75600.0
2004-09-30 08:00:00	MSFT	Stock	27.46	27.59	27.45	27.54	66863.0
2004-09-30 09:00:00	MSFT	Stock	27.54	27.77	27.5	27.72	7336431.0
2004-09-30 10:00:00	MSFT	Stock	27.72	27.79	27.67	27.69	8493317.0
2004-09-30 11:00:00	MSFT	Stock	27.69	27.7	27.52	27.56	6166488.0
2004-09-30 12:00:00	MSFT	Stock	27.56	27.68	27.55	27.66	3665172.0
2004-09-30 13:00:00	MSFT	Stock	27.66	27.76	27.64	27.75	2708566.0
2004-09-30 14:00:00	MSFT	Stock	27.75	27.75	27.7	27.72	4093698.0
2004-09-30 15:00:00	MSFT	Stock	27.73	27.73	27.53	27.64	15069742.0
2004-09-30 16:00:00	MSFT	Stock	27.64	27.705	27.49	27.65	9609242.0
2004-09-30 17:00:00	MSFT	Stock	27.6515	27.6847	27.59	27.6517	327006.0
2004-09-30 18:00:00	MSFT	Stock	27.58	27.58	27.58	27.58	2300.0
2004-09-30 08:00:00	NVDA	Stock	0.12	0.12	0.1196	0.1196	4260000.0
2004-09-30 09:00:00	NVDA	Stock	0.12	0.1237	0.1195	0.1229	95850240.0
2004-09-30 10:00:00	NVDA	Stock	0.1229	0.1237	0.1221	0.1225	139337400.0
2004-09-30 11:00:00	NVDA	Stock	0.1226	0.1226	0.1188	0.1192	102115440.0
2004-09-30 12:00:00	NVDA	Stock	0.1192	0.1197	0.1186	0.1196	58211880.0
2004-09-30 13:00:00	NVDA	Stock	0.1195	0.121	0.1189	0.121	54348240.0
2004-09-30 14:00:00	NVDA	Stock	0.121	0.122	0.1201	0.1213	59123400.0
2004-09-30 15:00:00	NVDA	Stock	0.1213	0.1215	0.1202	0.1207	68726520.0
2004-09-30 16:00:00	NVDA	Stock	0.1208	0.1215	0.12	0.121	18335040.0
2004-09-30 17:00:00	NVDA	Stock	0.121	0.1211	0.121	0.121	1854360.0
2004-09-30 18:00:00	NVDA	Stock	0.1208	0.1208	0.1208	0.1208	12000.0
2004-09-30 08:00:00	AMZN	Stock	2.042	2.045	2.042	2.0425	119980.0
2004-09-30 09:00:00	AMZN	Stock	2.0335	2.0565	2.018	2.046	21491880.0
2004-09-30 10:00:00	AMZN	Stock	2.046	2.0575	2.011	2.0215	42596380.0
2004-09-30 11:00:00	AMZN	Stock	2.022	2.041	2.018	2.0315	23005300.0
2004-09-30 12:00:00	AMZN	Stock	2.0315	2.0325	2.02	2.021	12630840.0
2004-09-30 13:00:00	AMZN	Stock	2.021	2.0375	2.0105	2.0375	13195420.0
2004-09-30 14:00:00	AMZN	Stock	2.0375	2.064	2.032	2.059	26085240.0
2004-09-30 15:00:00	AMZN	Stock	2.0585	2.0595	2.0355	2.044	29293860.0
2004-09-30 16:00:00	AMZN	Stock	2.045	2.0475	2.035	2.043	15279420.0
2004-09-30 17:00:00	AMZN	Stock	2.0429	2.0475	2.034	2.034	1331820.0
2004-09-30 18:00:00	AMZN	Stock	2.0335	2.0335	2.0335	2.0335	30000.0
2004-09-30 08:00:00	CL	Stock	22.79	22.79	22.79	22.79	200.0
2004-09-30 09:00:00	CL	Stock	22.75	22.755	22.6	22.65	799200.0
2004-09-30 10:00:00	CL	Stock	22.65	22.76	22.61	22.715	1034000.0
2004-09-30 11:00:00	CL	Stock	22.71	22.725	22.625	22.65	640800.0
2004-09-30 12:00:00	CL	Stock	22.65	22.665	22.58	22.585	666400.0
2004-09-30 13:00:00	CL	Stock	22.585	22.61	22.54	22.565	1278600.0

> showing 50 of 25,242 rows — these rows as CSV

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