PREVIEW / stock_1hour / 2006-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-06.parquet
  size:    666 KB
  rows:    31,646
  symbols: 2,468

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
2006-12-06 07:00:00	AAPL	Stock	3.2668	3.2668	3.2668	3.2668	2800.0
2006-12-06 08:00:00	AAPL	Stock	3.2589	3.2589	3.2357	3.2411	4516204.0
2006-12-06 09:00:00	AAPL	Stock	3.2411	3.2586	3.2325	3.245	82058256.0
2006-12-06 10:00:00	AAPL	Stock	3.245	3.2639	3.2382	3.2475	104401640.0
2006-12-06 11:00:00	AAPL	Stock	3.2479	3.2561	3.2382	3.2389	59758552.0
2006-12-06 12:00:00	AAPL	Stock	3.2386	3.2518	3.2293	3.2436	103394788.0
2006-12-06 13:00:00	AAPL	Stock	3.2436	3.2521	3.2414	3.2432	56931196.0
2006-12-06 14:00:00	AAPL	Stock	3.2429	3.2536	3.2307	3.2318	53107348.0
2006-12-06 15:00:00	AAPL	Stock	3.2318	3.2325	3.2025	3.2086	162225084.0
2006-12-06 16:00:00	AAPL	Stock	3.2082	3.2596	3.2057	3.2146	4867744.0
2006-12-06 17:00:00	AAPL	Stock	3.2143	3.215	3.2082	3.2125	528528.0
2006-12-06 18:00:00	AAPL	Stock	3.2081	3.2143	3.2081	3.2132	719432.0
2006-12-06 19:00:00	AAPL	Stock	3.2125	3.2161	3.2107	3.2111	279384.0
2006-12-06 08:00:00	MSFT	Stock	29.13	29.15	29.01	29.04	12700.0
2006-12-06 09:00:00	MSFT	Stock	29.04	29.1	28.91	29.06	7152515.0
2006-12-06 10:00:00	MSFT	Stock	29.07	29.13	28.97	29.09	6925159.0
2006-12-06 11:00:00	MSFT	Stock	29.08	29.12	28.97	28.97	5186332.0
2006-12-06 12:00:00	MSFT	Stock	28.97	29.03	28.93	28.96	5098909.0
2006-12-06 13:00:00	MSFT	Stock	28.96	29.0	28.92	28.93	5041175.0
2006-12-06 14:00:00	MSFT	Stock	28.92	28.95	28.88	28.93	5782755.0
2006-12-06 15:00:00	MSFT	Stock	28.93	29.01	28.87	29.01	9854124.0
2006-12-06 16:00:00	MSFT	Stock	29.0	29.13	28.9	28.99	486384.0
2006-12-06 17:00:00	MSFT	Stock	28.99	29.09	28.988	28.988	54115.0
2006-12-06 18:00:00	MSFT	Stock	28.99	28.99	28.97	28.97	1800.0
2006-12-06 07:00:00	NVDA	Stock	0.61	0.61	0.61	0.61	60000.0
2006-12-06 08:00:00	NVDA	Stock	0.6113	0.6125	0.6113	0.6117	274860.0
2006-12-06 09:00:00	NVDA	Stock	0.6117	0.612	0.6008	0.6055	60491700.0
2006-12-06 10:00:00	NVDA	Stock	0.6057	0.6112	0.6043	0.606	75073800.0
2006-12-06 11:00:00	NVDA	Stock	0.6062	0.6083	0.6055	0.6073	58991220.0
2006-12-06 12:00:00	NVDA	Stock	0.6073	0.6092	0.6033	0.6082	56283900.0
2006-12-06 13:00:00	NVDA	Stock	0.6078	0.6083	0.6052	0.6067	38586720.0
2006-12-06 14:00:00	NVDA	Stock	0.6067	0.6088	0.6053	0.6067	77354040.0
2006-12-06 15:00:00	NVDA	Stock	0.6067	0.6092	0.6047	0.6092	77579640.0
2006-12-06 16:00:00	NVDA	Stock	0.6092	0.6103	0.6088	0.6092	1974900.0
2006-12-06 17:00:00	NVDA	Stock	0.6071	0.6092	0.6071	0.6092	400560.0
2006-12-06 08:00:00	AMZN	Stock	1.9265	1.9265	1.9265	1.9265	10000.0
2006-12-06 09:00:00	AMZN	Stock	1.933	1.971	1.932	1.9585	17408560.0
2006-12-06 10:00:00	AMZN	Stock	1.957	1.979	1.95	1.9565	22535580.0
2006-12-06 11:00:00	AMZN	Stock	1.956	1.965	1.954	1.9585	24668920.0
2006-12-06 12:00:00	AMZN	Stock	1.958	1.958	1.9495	1.951	7601320.0
2006-12-06 13:00:00	AMZN	Stock	1.951	1.9515	1.941	1.9455	9426580.0
2006-12-06 14:00:00	AMZN	Stock	1.9455	1.9485	1.9375	1.939	8412460.0
2006-12-06 15:00:00	AMZN	Stock	1.939	1.945	1.933	1.944	20571100.0
2006-12-06 16:00:00	AMZN	Stock	1.9455	1.949	1.9425	1.9475	389140.0
2006-12-06 17:00:00	AMZN	Stock	1.942	1.945	1.942	1.945	16620.0
2006-12-06 18:00:00	AMZN	Stock	1.9475	1.9475	1.9475	1.9475	4000.0
2006-12-06 19:00:00	AMZN	Stock	1.959	1.959	1.959	1.959	2000.0
2006-12-06 08:00:00	CL	Stock	32.79	32.79	32.79	32.79	19400.0
2006-12-06 09:00:00	CL	Stock	32.795	32.915	32.755	32.865	299400.0
2006-12-06 10:00:00	CL	Stock	32.85	32.875	32.755	32.79	375600.0

> showing 50 of 31,646 rows — these rows as CSV

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