PREVIEW / stock_1hour / 2005-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-17.parquet
  size:    567 KB
  rows:    26,964
  symbols: 2,069

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-08-17 08:00:00	AAPL	Stock	1.6593	1.6707	1.6582	1.66	1722420.0
2005-08-17 09:00:00	AAPL	Stock	1.6607	1.6843	1.6561	1.6832	87057432.0
2005-08-17 10:00:00	AAPL	Stock	1.6832	1.6918	1.6768	1.6896	147265356.0
2005-08-17 11:00:00	AAPL	Stock	1.69	1.6943	1.6829	1.6854	71081864.0
2005-08-17 12:00:00	AAPL	Stock	1.6857	1.6864	1.6782	1.6829	46876340.0
2005-08-17 13:00:00	AAPL	Stock	1.6829	1.6868	1.6818	1.6854	29723008.0
2005-08-17 14:00:00	AAPL	Stock	1.6854	1.6875	1.68	1.6825	35695716.0
2005-08-17 15:00:00	AAPL	Stock	1.6821	1.6907	1.6811	1.6846	67186980.0
2005-08-17 16:00:00	AAPL	Stock	1.6836	1.6864	1.6796	1.6804	3988852.0
2005-08-17 17:00:00	AAPL	Stock	1.6804	1.6839	1.6804	1.6821	7559832.0
2005-08-17 18:00:00	AAPL	Stock	1.6811	1.6836	1.6804	1.6836	205100.0
2005-08-17 08:00:00	MSFT	Stock	26.84	26.89	26.7	26.8	65961.0
2005-08-17 09:00:00	MSFT	Stock	26.8	26.85	26.66	26.76	6660881.0
2005-08-17 10:00:00	MSFT	Stock	26.76	26.9	26.7	26.75	11240416.0
2005-08-17 11:00:00	MSFT	Stock	26.74	26.84	26.69	26.838	5525074.0
2005-08-17 12:00:00	MSFT	Stock	26.83	27.02	26.83	27.002	6831907.0
2005-08-17 13:00:00	MSFT	Stock	27.008	27.05	26.91	26.95	4788639.0
2005-08-17 14:00:00	MSFT	Stock	26.95	27.06	26.93	27.03	5053247.0
2005-08-17 15:00:00	MSFT	Stock	27.03	27.15	26.96	26.96	10521941.0
2005-08-17 16:00:00	MSFT	Stock	26.97	27.05	26.82	26.96	592689.0
2005-08-17 17:00:00	MSFT	Stock	26.94	26.95	26.93	26.95	180050.0
2005-08-17 18:00:00	MSFT	Stock	26.98	27.05	26.94	26.94	11379.0
2005-08-17 08:00:00	NVDA	Stock	0.2529	0.2529	0.2514	0.2518	300000.0
2005-08-17 09:00:00	NVDA	Stock	0.2513	0.2547	0.2503	0.2532	82767960.0
2005-08-17 10:00:00	NVDA	Stock	0.2532	0.2542	0.2512	0.2535	141800160.0
2005-08-17 11:00:00	NVDA	Stock	0.2535	0.254	0.2512	0.2527	67879800.0
2005-08-17 12:00:00	NVDA	Stock	0.2528	0.2535	0.2512	0.2526	31201200.0
2005-08-17 13:00:00	NVDA	Stock	0.2525	0.2526	0.252	0.2521	78799320.0
2005-08-17 14:00:00	NVDA	Stock	0.2521	0.2528	0.2516	0.2525	87549720.0
2005-08-17 15:00:00	NVDA	Stock	0.2525	0.253	0.2512	0.2514	111816480.0
2005-08-17 16:00:00	NVDA	Stock	0.2513	0.252	0.2512	0.2512	1044720.0
2005-08-17 17:00:00	NVDA	Stock	0.2513	0.2513	0.2512	0.2513	432000.0
2005-08-17 08:00:00	AMZN	Stock	2.216	2.216	2.216	2.216	18000.0
2005-08-17 09:00:00	AMZN	Stock	2.2165	2.2175	2.2055	2.2115	14011200.0
2005-08-17 10:00:00	AMZN	Stock	2.211	2.2165	2.2075	2.2105	12984020.0
2005-08-17 11:00:00	AMZN	Stock	2.21	2.2145	2.2085	2.212	5639800.0
2005-08-17 12:00:00	AMZN	Stock	2.212	2.2215	2.212	2.2145	5722440.0
2005-08-17 13:00:00	AMZN	Stock	2.215	2.2155	2.21	2.213	5192260.0
2005-08-17 14:00:00	AMZN	Stock	2.213	2.218	2.2105	2.211	5737460.0
2005-08-17 15:00:00	AMZN	Stock	2.211	2.2155	2.2065	2.2065	10455800.0
2005-08-17 16:00:00	AMZN	Stock	2.207	2.21	2.2061	2.207	353200.0
2005-08-17 17:00:00	AMZN	Stock	2.207	2.207	2.207	2.207	4000.0
2005-08-17 09:00:00	CL	Stock	26.15	26.21	26.01	26.055	247800.0
2005-08-17 10:00:00	CL	Stock	26.055	26.07	26.0	26.005	448600.0
2005-08-17 11:00:00	CL	Stock	26.01	26.035	25.925	25.945	381800.0
2005-08-17 12:00:00	CL	Stock	25.945	26.05	25.925	26.005	309200.0
2005-08-17 13:00:00	CL	Stock	26.005	26.015	25.96	25.98	228000.0
2005-08-17 14:00:00	CL	Stock	25.98	26.0	25.935	25.96	439200.0
2005-08-17 15:00:00	CL	Stock	25.965	26.0	25.945	25.945	494000.0
2005-08-17 16:00:00	CL	Stock	25.95	25.95	25.9495	25.9495	30800.0

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

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