PREVIEW / stock_1hour / 2006-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-17.parquet
  size:    598 KB
  rows:    28,204
  symbols: 2,195

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-02-17 04:00:00	AAPL	Stock	2.5179	2.5179	2.5179	2.5179	2800.0
2006-02-17 06:00:00	AAPL	Stock	2.5161	2.5161	2.5161	2.5161	5600.0
2006-02-17 07:00:00	AAPL	Stock	2.5157	2.5157	2.5089	2.5129	210000.0
2006-02-17 08:00:00	AAPL	Stock	2.5125	2.5146	2.4911	2.4936	1841756.0
2006-02-17 09:00:00	AAPL	Stock	2.4936	2.5229	2.4861	2.5036	130432372.0
2006-02-17 10:00:00	AAPL	Stock	2.5036	2.5304	2.4918	2.5204	125544888.0
2006-02-17 11:00:00	AAPL	Stock	2.5204	2.5318	2.5139	2.5196	84685216.0
2006-02-17 12:00:00	AAPL	Stock	2.5196	2.5268	2.5146	2.5229	41216308.0
2006-02-17 13:00:00	AAPL	Stock	2.5229	2.5279	2.5179	2.5196	32777248.0
2006-02-17 14:00:00	AAPL	Stock	2.5199	2.5232	2.5182	2.52	29777356.0
2006-02-17 15:00:00	AAPL	Stock	2.5204	2.5207	2.5036	2.5104	114578464.0
2006-02-17 16:00:00	AAPL	Stock	2.5104	2.5168	2.5079	2.5111	3558660.0
2006-02-17 17:00:00	AAPL	Stock	2.5157	2.5157	2.5102	2.5111	142380.0
2006-02-17 18:00:00	AAPL	Stock	2.5114	2.5114	2.5104	2.5107	83440.0
2006-02-17 07:00:00	MSFT	Stock	26.71	26.71	26.69	26.69	300.0
2006-02-17 08:00:00	MSFT	Stock	26.69	26.71	26.65	26.7	8950.0
2006-02-17 09:00:00	MSFT	Stock	26.7	26.73	26.65	26.68	7371100.0
2006-02-17 10:00:00	MSFT	Stock	26.68	26.72	26.56	26.6	4892983.0
2006-02-17 11:00:00	MSFT	Stock	26.6	26.7	26.6	26.678	4560200.0
2006-02-17 12:00:00	MSFT	Stock	26.68	26.7	26.63	26.66	4596375.0
2006-02-17 13:00:00	MSFT	Stock	26.65	26.75	26.63	26.7	5107445.0
2006-02-17 14:00:00	MSFT	Stock	26.71	26.74	26.65	26.68	3842823.0
2006-02-17 15:00:00	MSFT	Stock	26.68	26.74	26.63	26.72	8349840.0
2006-02-17 16:00:00	MSFT	Stock	26.7	26.71	26.68	26.7	493118.0
2006-02-17 17:00:00	MSFT	Stock	26.699	26.699	26.699	26.699	1915.0
2006-02-17 18:00:00	MSFT	Stock	26.68	26.68	26.66	26.66	7900.0
2006-02-17 07:00:00	NVDA	Stock	0.4375	0.4417	0.4308	0.4321	2890200.0
2006-02-17 08:00:00	NVDA	Stock	0.4321	0.4332	0.422	0.4229	56512440.0
2006-02-17 09:00:00	NVDA	Stock	0.4232	0.425	0.4094	0.4112	589360320.0
2006-02-17 10:00:00	NVDA	Stock	0.4112	0.4129	0.4055	0.4065	448107840.0
2006-02-17 11:00:00	NVDA	Stock	0.4062	0.4116	0.4017	0.4032	287407200.0
2006-02-17 12:00:00	NVDA	Stock	0.4032	0.4066	0.4027	0.4042	142898040.0
2006-02-17 13:00:00	NVDA	Stock	0.4043	0.4046	0.3976	0.3978	178706280.0
2006-02-17 14:00:00	NVDA	Stock	0.3979	0.4022	0.3951	0.4009	263034720.0
2006-02-17 15:00:00	NVDA	Stock	0.4008	0.4016	0.3948	0.3956	329363280.0
2006-02-17 16:00:00	NVDA	Stock	0.3955	0.3961	0.3952	0.3956	20952720.0
2006-02-17 17:00:00	NVDA	Stock	0.396	0.396	0.3954	0.3956	372600.0
2006-02-17 18:00:00	NVDA	Stock	0.3954	0.3954	0.395	0.395	288000.0
2006-02-17 09:00:00	AMZN	Stock	1.945	1.962	1.945	1.9575	18934720.0
2006-02-17 10:00:00	AMZN	Stock	1.9575	1.9605	1.9475	1.9565	12876740.0
2006-02-17 11:00:00	AMZN	Stock	1.9565	1.962	1.9515	1.9595	11521080.0
2006-02-17 12:00:00	AMZN	Stock	1.9595	1.9615	1.955	1.9575	8547680.0
2006-02-17 13:00:00	AMZN	Stock	1.9575	1.9665	1.9575	1.9635	6199080.0
2006-02-17 14:00:00	AMZN	Stock	1.963	1.969	1.9585	1.96	5755020.0
2006-02-17 15:00:00	AMZN	Stock	1.9605	1.965	1.9465	1.959	19874240.0
2006-02-17 16:00:00	AMZN	Stock	1.958	1.9595	1.954	1.956	109820.0
2006-02-17 17:00:00	AMZN	Stock	1.955	1.955	1.955	1.955	12000.0
2006-02-17 18:00:00	AMZN	Stock	1.955	1.955	1.955	1.955	34640.0
2006-02-17 09:00:00	CL	Stock	27.385	27.425	27.25	27.305	629800.0
2006-02-17 10:00:00	CL	Stock	27.305	27.385	27.26	27.365	454600.0

> showing 50 of 28,204 rows — these rows as CSV

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