PREVIEW / stock_1hour / 2004-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-26.parquet
  size:    513 KB
  rows:    24,649
  symbols: 1,809

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-07-26 08:00:00	AAPL	Stock	0.5479	0.5518	0.5473	0.5518	123200.0
2004-07-26 09:00:00	AAPL	Stock	0.5509	0.5607	0.5488	0.5566	45614632.0
2004-07-26 10:00:00	AAPL	Stock	0.5566	0.5616	0.5509	0.5577	67484368.0
2004-07-26 11:00:00	AAPL	Stock	0.5577	0.558	0.5496	0.5559	45524024.0
2004-07-26 12:00:00	AAPL	Stock	0.5559	0.557	0.5548	0.5563	51701440.0
2004-07-26 13:00:00	AAPL	Stock	0.5563	0.5568	0.5527	0.5545	32271736.0
2004-07-26 14:00:00	AAPL	Stock	0.5546	0.5566	0.5518	0.5541	34136368.0
2004-07-26 15:00:00	AAPL	Stock	0.5538	0.5598	0.5525	0.5591	79293592.0
2004-07-26 16:00:00	AAPL	Stock	0.5584	0.5595	0.5582	0.5582	7569744.0
2004-07-26 17:00:00	AAPL	Stock	0.5582	0.5582	0.5582	0.5582	121800.0
2004-07-26 08:00:00	MSFT	Stock	28.3	28.36	28.2	28.25	109560.0
2004-07-26 09:00:00	MSFT	Stock	28.27	28.57	28.199	28.5	12434374.0
2004-07-26 10:00:00	MSFT	Stock	28.5	28.71	28.4	28.58	12836343.0
2004-07-26 11:00:00	MSFT	Stock	28.57	28.63	28.349	28.57	11648332.0
2004-07-26 12:00:00	MSFT	Stock	28.56	28.59	28.38	28.43	7096205.0
2004-07-26 13:00:00	MSFT	Stock	28.43	28.59	28.37	28.41	6942549.0
2004-07-26 14:00:00	MSFT	Stock	28.41	28.55	28.369	28.48	6902933.0
2004-07-26 15:00:00	MSFT	Stock	28.48	28.66	28.45	28.66	10731975.0
2004-07-26 16:00:00	MSFT	Stock	28.65	28.67	28.44	28.65	764354.0
2004-07-26 17:00:00	MSFT	Stock	28.66	28.66	28.59	28.61	37926.0
2004-07-26 18:00:00	MSFT	Stock	28.61	28.66	28.5141	28.66	12979.0
2004-07-26 08:00:00	NVDA	Stock	0.1219	0.1228	0.1219	0.1228	179760.0
2004-07-26 09:00:00	NVDA	Stock	0.1226	0.1245	0.1222	0.1236	42501720.0
2004-07-26 10:00:00	NVDA	Stock	0.1236	0.1241	0.1202	0.1216	79438080.0
2004-07-26 11:00:00	NVDA	Stock	0.1214	0.1216	0.1185	0.1205	70349280.0
2004-07-26 12:00:00	NVDA	Stock	0.1205	0.1214	0.1195	0.1197	22336200.0
2004-07-26 13:00:00	NVDA	Stock	0.1197	0.1198	0.1177	0.1178	81856080.0
2004-07-26 14:00:00	NVDA	Stock	0.1177	0.1192	0.1172	0.1176	76918320.0
2004-07-26 15:00:00	NVDA	Stock	0.1176	0.1192	0.1175	0.1183	81514560.0
2004-07-26 16:00:00	NVDA	Stock	0.1183	0.1197	0.1183	0.1192	2664720.0
2004-07-26 17:00:00	NVDA	Stock	0.1192	0.1193	0.1184	0.1193	352200.0
2004-07-26 18:00:00	NVDA	Stock	0.1195	0.1195	0.1195	0.1195	36000.0
2004-07-26 08:00:00	AMZN	Stock	2.025	2.025	2.0055	2.0055	501280.0
2004-07-26 09:00:00	AMZN	Stock	2.0055	2.012	1.918	1.945	67599120.0
2004-07-26 10:00:00	AMZN	Stock	1.945	1.969	1.934	1.9365	52582680.0
2004-07-26 11:00:00	AMZN	Stock	1.935	1.947	1.9165	1.939	44577060.0
2004-07-26 12:00:00	AMZN	Stock	1.939	1.9585	1.9295	1.9355	22714380.0
2004-07-26 13:00:00	AMZN	Stock	1.9351	1.9585	1.926	1.9414	25085680.0
2004-07-26 14:00:00	AMZN	Stock	1.941	1.9525	1.933	1.939	16559940.0
2004-07-26 15:00:00	AMZN	Stock	1.939	1.95	1.9275	1.9405	38433880.0
2004-07-26 16:00:00	AMZN	Stock	1.9405	1.9445	1.936	1.9425	963900.0
2004-07-26 17:00:00	AMZN	Stock	1.939	1.939	1.9375	1.9375	136960.0
2004-07-26 18:00:00	AMZN	Stock	1.9395	1.94	1.934	1.934	22000.0
2004-07-26 09:00:00	CL	Stock	26.385	26.405	26.16	26.19	721200.0
2004-07-26 10:00:00	CL	Stock	26.225	26.225	26.105	26.155	1047000.0
2004-07-26 11:00:00	CL	Stock	26.155	26.27	26.135	26.26	835600.0
2004-07-26 12:00:00	CL	Stock	26.265	26.405	26.245	26.39	755000.0
2004-07-26 13:00:00	CL	Stock	26.39	26.52	26.35	26.355	538000.0
2004-07-26 14:00:00	CL	Stock	26.355	26.37	26.245	26.305	933400.0
2004-07-26 15:00:00	CL	Stock	26.305	26.38	26.26	26.32	1348800.0

> showing 50 of 24,649 rows — these rows as CSV

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