PREVIEW / stock_1hour / 2005-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-13.parquet
  size:    560 KB
  rows:    26,701
  symbols: 2,067

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
2005-09-13 08:00:00	AAPL	Stock	1.8354	1.8354	1.8179	1.8236	1674540.0
2005-09-13 09:00:00	AAPL	Stock	1.8214	1.8446	1.8182	1.82	70577836.0
2005-09-13 10:00:00	AAPL	Stock	1.8204	1.83	1.8168	1.8207	70670796.0
2005-09-13 11:00:00	AAPL	Stock	1.8207	1.825	1.7971	1.8171	104562192.0
2005-09-13 12:00:00	AAPL	Stock	1.8171	1.8246	1.8104	1.82	47638388.0
2005-09-13 13:00:00	AAPL	Stock	1.8204	1.8218	1.8129	1.8193	48284796.0
2005-09-13 14:00:00	AAPL	Stock	1.8193	1.8307	1.8161	1.8243	54951960.0
2005-09-13 15:00:00	AAPL	Stock	1.8243	1.825	1.8143	1.815	70660632.0
2005-09-13 16:00:00	AAPL	Stock	1.8154	1.8214	1.8107	1.8125	3252508.0
2005-09-13 17:00:00	AAPL	Stock	1.8111	1.8125	1.8107	1.8125	71400.0
2005-09-13 18:00:00	AAPL	Stock	1.8111	1.815	1.8111	1.8146	62300.0
2005-09-13 08:00:00	MSFT	Stock	26.61	26.61	26.5	26.59	20754.0
2005-09-13 09:00:00	MSFT	Stock	26.59	26.59	26.48	26.49	5632802.0
2005-09-13 10:00:00	MSFT	Stock	26.48	26.55	26.37	26.41	9319354.0
2005-09-13 11:00:00	MSFT	Stock	26.41	26.5	26.38	26.482	8014108.0
2005-09-13 12:00:00	MSFT	Stock	26.49	26.55	26.42	26.53	5930757.0
2005-09-13 13:00:00	MSFT	Stock	26.53	26.64	26.5	26.6	5756698.0
2005-09-13 14:00:00	MSFT	Stock	26.6	26.76	26.5	26.64	9146732.0
2005-09-13 15:00:00	MSFT	Stock	26.64	26.64	26.47	26.489	9650044.0
2005-09-13 16:00:00	MSFT	Stock	26.48	26.53	26.452	26.53	1880641.0
2005-09-13 17:00:00	MSFT	Stock	26.55	26.55	26.52	26.55	5654.0
2005-09-13 18:00:00	MSFT	Stock	26.52	26.52	26.52	26.52	936.0
2005-09-13 09:00:00	NVDA	Stock	0.2667	0.2691	0.2661	0.2685	73732560.0
2005-09-13 10:00:00	NVDA	Stock	0.2684	0.2743	0.2682	0.2729	160032360.0
2005-09-13 11:00:00	NVDA	Stock	0.2731	0.2733	0.2712	0.2733	108404280.0
2005-09-13 12:00:00	NVDA	Stock	0.2733	0.2733	0.2715	0.2732	39885480.0
2005-09-13 13:00:00	NVDA	Stock	0.2732	0.2738	0.2726	0.2738	44839440.0
2005-09-13 14:00:00	NVDA	Stock	0.2738	0.2766	0.2736	0.2745	195551280.0
2005-09-13 15:00:00	NVDA	Stock	0.2746	0.2767	0.2745	0.2754	201812400.0
2005-09-13 16:00:00	NVDA	Stock	0.2754	0.277	0.2741	0.277	2124600.0
2005-09-13 17:00:00	NVDA	Stock	0.2769	0.2769	0.2769	0.2769	12000.0
2005-09-13 18:00:00	NVDA	Stock	0.2758	0.2758	0.2758	0.2758	108000.0
2005-09-13 08:00:00	AMZN	Stock	2.225	2.225	2.206	2.2175	79000.0
2005-09-13 09:00:00	AMZN	Stock	2.2125	2.2195	2.187	2.1985	15403160.0
2005-09-13 10:00:00	AMZN	Stock	2.1985	2.2	2.1735	2.178	15935560.0
2005-09-13 11:00:00	AMZN	Stock	2.1775	2.1875	2.172	2.1785	13348820.0
2005-09-13 12:00:00	AMZN	Stock	2.1785	2.199	2.1725	2.197	6987280.0
2005-09-13 13:00:00	AMZN	Stock	2.1965	2.2075	2.191	2.2065	8205280.0
2005-09-13 14:00:00	AMZN	Stock	2.2065	2.219	2.204	2.2115	14750280.0
2005-09-13 15:00:00	AMZN	Stock	2.211	2.211	2.19	2.197	13953220.0
2005-09-13 16:00:00	AMZN	Stock	2.198	2.2045	2.1965	2.2005	495980.0
2005-09-13 17:00:00	AMZN	Stock	2.2	2.206	2.2	2.206	48000.0
2005-09-13 18:00:00	AMZN	Stock	2.206	2.206	2.206	2.206	2000.0
2005-09-13 09:00:00	CL	Stock	26.375	26.405	26.265	26.31	395000.0
2005-09-13 10:00:00	CL	Stock	26.315	26.4	26.285	26.285	238400.0
2005-09-13 11:00:00	CL	Stock	26.285	26.33	26.24	26.285	451600.0
2005-09-13 12:00:00	CL	Stock	26.285	26.34	26.2	26.34	252000.0
2005-09-13 13:00:00	CL	Stock	26.34	26.435	26.34	26.405	353400.0
2005-09-13 14:00:00	CL	Stock	26.405	26.455	26.39	26.405	561800.0
2005-09-13 15:00:00	CL	Stock	26.41	26.435	26.37	26.4	665000.0

> showing 50 of 26,701 rows — these rows as CSV

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