PREVIEW / stock_1hour / 2003-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-05.parquet
  size:    470 KB
  rows:    22,252
  symbols: 1,620

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
2003-09-05 08:00:00	AAPL	Stock	0.408	0.408	0.4027	0.407	3735200.0
2003-09-05 09:00:00	AAPL	Stock	0.4071	0.4104	0.4054	0.4088	23389128.0
2003-09-05 10:00:00	AAPL	Stock	0.4088	0.4132	0.4084	0.4104	28560392.0
2003-09-05 11:00:00	AAPL	Stock	0.4102	0.4134	0.4089	0.4127	14952504.0
2003-09-05 12:00:00	AAPL	Stock	0.4127	0.4132	0.408	0.4082	30443000.0
2003-09-05 13:00:00	AAPL	Stock	0.4088	0.4091	0.4023	0.403	36163064.0
2003-09-05 14:00:00	AAPL	Stock	0.403	0.4038	0.4002	0.4038	44754304.0
2003-09-05 15:00:00	AAPL	Stock	0.4039	0.4043	0.4011	0.4011	31597944.0
2003-09-05 16:00:00	AAPL	Stock	0.4011	0.4018	0.4	0.4009	1657600.0
2003-09-05 17:00:00	AAPL	Stock	0.4027	0.4027	0.4027	0.4027	44800.0
2003-09-05 08:00:00	MSFT	Stock	28.5	28.75	28.35	28.35	4211376.0
2003-09-05 09:00:00	MSFT	Stock	28.32	28.46	28.17	28.4	8752392.0
2003-09-05 10:00:00	MSFT	Stock	28.4	28.591	28.35	28.5712	10433807.0
2003-09-05 11:00:00	MSFT	Stock	28.57	28.75	28.49	28.73	7268153.0
2003-09-05 12:00:00	MSFT	Stock	28.724	28.73	28.45	28.55	5807546.0
2003-09-05 13:00:00	MSFT	Stock	28.55	28.55	28.32	28.46	8435714.0
2003-09-05 14:00:00	MSFT	Stock	28.46	28.47	28.25	28.39	5778128.0
2003-09-05 15:00:00	MSFT	Stock	28.38	28.5	28.31	28.38	5881207.0
2003-09-05 16:00:00	MSFT	Stock	28.38	28.44	28.36	28.38	600776.0
2003-09-05 17:00:00	MSFT	Stock	28.37	28.4875	28.36	28.36	41618.0
2003-09-05 18:00:00	MSFT	Stock	28.39	28.39	28.36	28.36	2530.0
2003-09-05 08:00:00	NVDA	Stock	0.1493	0.1496	0.1478	0.1483	4213560.0
2003-09-05 09:00:00	NVDA	Stock	0.1482	0.1533	0.1471	0.1529	173288400.0
2003-09-05 10:00:00	NVDA	Stock	0.1529	0.1562	0.1517	0.1561	220777560.0
2003-09-05 11:00:00	NVDA	Stock	0.1559	0.1592	0.1558	0.1583	256816560.0
2003-09-05 12:00:00	NVDA	Stock	0.1582	0.1587	0.1547	0.157	117307800.0
2003-09-05 13:00:00	NVDA	Stock	0.157	0.1572	0.1547	0.155	111034560.0
2003-09-05 14:00:00	NVDA	Stock	0.155	0.1562	0.1537	0.1561	104264040.0
2003-09-05 15:00:00	NVDA	Stock	0.1561	0.1569	0.1543	0.1555	115813080.0
2003-09-05 16:00:00	NVDA	Stock	0.1556	0.1562	0.1554	0.1561	8291520.0
2003-09-05 18:00:00	NVDA	Stock	0.1561	0.1562	0.1561	0.1562	72000.0
2003-09-05 08:00:00	AMZN	Stock	2.3635	2.3645	2.345	2.345	306100.0
2003-09-05 09:00:00	AMZN	Stock	2.345	2.374	2.343	2.361	22271720.0
2003-09-05 10:00:00	AMZN	Stock	2.361	2.3725	2.353	2.3675	20527780.0
2003-09-05 11:00:00	AMZN	Stock	2.3675	2.371	2.3565	2.3625	12159040.0
2003-09-05 12:00:00	AMZN	Stock	2.3625	2.3635	2.3475	2.351	13481820.0
2003-09-05 13:00:00	AMZN	Stock	2.352	2.352	2.325	2.332	25175720.0
2003-09-05 14:00:00	AMZN	Stock	2.3315	2.3405	2.305	2.3355	30962700.0
2003-09-05 15:00:00	AMZN	Stock	2.3355	2.343	2.325	2.329	17715760.0
2003-09-05 16:00:00	AMZN	Stock	2.325	2.348	2.3215	2.324	903600.0
2003-09-05 17:00:00	AMZN	Stock	2.327	2.327	2.324	2.325	121860.0
2003-09-05 18:00:00	AMZN	Stock	2.325	2.325	2.325	2.325	13800.0
2003-09-05 09:00:00	CL	Stock	28.075	28.13	28.015	28.07	236000.0
2003-09-05 10:00:00	CL	Stock	28.095	28.15	28.01	28.02	452000.0
2003-09-05 11:00:00	CL	Stock	28.02	28.08	27.975	28.01	245000.0
2003-09-05 12:00:00	CL	Stock	28.01	28.025	27.94	27.99	301200.0
2003-09-05 13:00:00	CL	Stock	27.99	28.0595	27.915	28.01	336400.0
2003-09-05 14:00:00	CL	Stock	28.005	28.08	27.965	28.035	256000.0
2003-09-05 15:00:00	CL	Stock	28.035	28.15	28.02	28.09	662200.0
2003-09-05 16:00:00	CL	Stock	28.09	28.115	28.09	28.095	94400.0

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

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