PREVIEW / stock_1hour / 2004-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-04.parquet
  size:    498 KB
  rows:    23,355
  symbols: 1,813

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-08-04 08:00:00	AAPL	Stock	0.5589	0.5589	0.5552	0.5571	184800.0
2004-08-04 09:00:00	AAPL	Stock	0.5568	0.5634	0.5563	0.5609	28480144.0
2004-08-04 10:00:00	AAPL	Stock	0.5608	0.5623	0.5582	0.5589	24607352.0
2004-08-04 11:00:00	AAPL	Stock	0.5589	0.5643	0.558	0.5643	35378672.0
2004-08-04 12:00:00	AAPL	Stock	0.5641	0.5657	0.5632	0.5645	41365128.0
2004-08-04 13:00:00	AAPL	Stock	0.5645	0.5688	0.5645	0.5684	36090432.0
2004-08-04 14:00:00	AAPL	Stock	0.5684	0.5736	0.5684	0.5716	46654160.0
2004-08-04 15:00:00	AAPL	Stock	0.5714	0.573	0.5675	0.5679	49657832.0
2004-08-04 16:00:00	AAPL	Stock	0.5679	0.5693	0.5671	0.5677	4139856.0
2004-08-04 18:00:00	AAPL	Stock	0.5652	0.5652	0.5652	0.5652	128800.0
2004-08-04 08:00:00	MSFT	Stock	28.0	28.05	27.96	28.0	58706.0
2004-08-04 09:00:00	MSFT	Stock	27.99	28.13	27.98	28.07	5288637.0
2004-08-04 10:00:00	MSFT	Stock	28.06	28.2	28.02	28.08	8547330.0
2004-08-04 11:00:00	MSFT	Stock	28.07	28.176	28.04	28.16	5735353.0
2004-08-04 12:00:00	MSFT	Stock	28.16	28.172	28.06	28.11	3631079.0
2004-08-04 13:00:00	MSFT	Stock	28.11	28.14	28.049	28.11	4171866.0
2004-08-04 14:00:00	MSFT	Stock	28.11	28.151	28.05	28.1	6658084.0
2004-08-04 15:00:00	MSFT	Stock	28.1	28.13	27.989	28.04	8622724.0
2004-08-04 16:00:00	MSFT	Stock	28.05	28.11	28.01	28.06	1737864.0
2004-08-04 17:00:00	MSFT	Stock	28.1	28.1	28.1	28.1	500.0
2004-08-04 18:00:00	MSFT	Stock	28.1	28.11	28.1	28.11	1050.0
2004-08-04 08:00:00	NVDA	Stock	0.1234	0.1234	0.1228	0.1228	168000.0
2004-08-04 09:00:00	NVDA	Stock	0.1226	0.125	0.122	0.1241	76345920.0
2004-08-04 10:00:00	NVDA	Stock	0.124	0.1249	0.1233	0.1233	71692200.0
2004-08-04 11:00:00	NVDA	Stock	0.1233	0.1238	0.1225	0.1237	46523880.0
2004-08-04 12:00:00	NVDA	Stock	0.1237	0.1238	0.1224	0.1224	33449640.0
2004-08-04 13:00:00	NVDA	Stock	0.1224	0.1237	0.1219	0.1233	57623520.0
2004-08-04 14:00:00	NVDA	Stock	0.1232	0.1259	0.1232	0.1251	85046760.0
2004-08-04 15:00:00	NVDA	Stock	0.125	0.1256	0.1236	0.1247	93909840.0
2004-08-04 16:00:00	NVDA	Stock	0.1247	0.1252	0.1237	0.1251	7624560.0
2004-08-04 17:00:00	NVDA	Stock	0.1247	0.1251	0.1247	0.1251	95640.0
2004-08-04 18:00:00	NVDA	Stock	0.1247	0.1247	0.1247	0.1247	48000.0
2004-08-04 08:00:00	AMZN	Stock	1.868	1.868	1.855	1.855	162000.0
2004-08-04 09:00:00	AMZN	Stock	1.8575	1.8575	1.82	1.8475	34002300.0
2004-08-04 10:00:00	AMZN	Stock	1.8475	1.866	1.831	1.8475	31168660.0
2004-08-04 11:00:00	AMZN	Stock	1.8475	1.8635	1.8405	1.8595	34628160.0
2004-08-04 12:00:00	AMZN	Stock	1.8595	1.86	1.841	1.843	9088900.0
2004-08-04 13:00:00	AMZN	Stock	1.843	1.857	1.835	1.85	20711940.0
2004-08-04 14:00:00	AMZN	Stock	1.85	1.873	1.844	1.8615	31963240.0
2004-08-04 15:00:00	AMZN	Stock	1.8605	1.863	1.848	1.853	30009180.0
2004-08-04 16:00:00	AMZN	Stock	1.854	1.856	1.8475	1.8475	1605780.0
2004-08-04 17:00:00	AMZN	Stock	1.8475	1.8475	1.8475	1.8475	20000.0
2004-08-04 18:00:00	AMZN	Stock	1.8495	1.851	1.8495	1.851	44000.0
2004-08-04 09:00:00	CL	Stock	26.485	26.485	26.265	26.385	311600.0
2004-08-04 10:00:00	CL	Stock	26.375	26.44	26.3	26.31	451000.0
2004-08-04 11:00:00	CL	Stock	26.31	26.375	26.29	26.32	454400.0
2004-08-04 12:00:00	CL	Stock	26.315	26.395	26.3	26.375	538000.0
2004-08-04 13:00:00	CL	Stock	26.375	26.5	26.365	26.44	345800.0
2004-08-04 14:00:00	CL	Stock	26.44	26.48	26.4	26.43	406600.0
2004-08-04 15:00:00	CL	Stock	26.43	26.47	26.385	26.41	625200.0

> showing 50 of 23,355 rows — these rows as CSV

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