PREVIEW / stock_1hour / 2005-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-12.parquet
  size:    553 KB
  rows:    26,300
  symbols: 2,019

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-07-12 07:00:00	AAPL	Stock	1.3682	1.3718	1.3682	1.3714	225400.0
2005-07-12 08:00:00	AAPL	Stock	1.375	1.3786	1.3654	1.3675	1501108.0
2005-07-12 09:00:00	AAPL	Stock	1.3679	1.3714	1.3611	1.3693	40556684.0
2005-07-12 10:00:00	AAPL	Stock	1.3696	1.37	1.3571	1.3614	76210148.0
2005-07-12 11:00:00	AAPL	Stock	1.3614	1.3621	1.3539	1.3568	49004508.0
2005-07-12 12:00:00	AAPL	Stock	1.3571	1.3607	1.3546	1.3582	24549700.0
2005-07-12 13:00:00	AAPL	Stock	1.3579	1.3686	1.3554	1.3639	50794436.0
2005-07-12 14:00:00	AAPL	Stock	1.3639	1.3696	1.3625	1.365	44468144.0
2005-07-12 15:00:00	AAPL	Stock	1.365	1.3675	1.3614	1.3661	92282484.0
2005-07-12 16:00:00	AAPL	Stock	1.3657	1.3689	1.3618	1.3632	2766988.0
2005-07-12 17:00:00	AAPL	Stock	1.365	1.3661	1.3625	1.3661	760480.0
2005-07-12 18:00:00	AAPL	Stock	1.3629	1.3643	1.3629	1.3643	135100.0
2005-07-12 08:00:00	MSFT	Stock	25.25	25.25	25.21	25.22	23800.0
2005-07-12 09:00:00	MSFT	Stock	25.22	25.31	25.21	25.238	6123630.0
2005-07-12 10:00:00	MSFT	Stock	25.24	25.49	25.2	25.47	14851986.0
2005-07-12 11:00:00	MSFT	Stock	25.47	25.49	25.38	25.4	6525974.0
2005-07-12 12:00:00	MSFT	Stock	25.4	25.49	25.39	25.47	4710222.0
2005-07-12 13:00:00	MSFT	Stock	25.47	25.58	25.47	25.55	6876846.0
2005-07-12 14:00:00	MSFT	Stock	25.55	25.6	25.45	25.55	7935438.0
2005-07-12 15:00:00	MSFT	Stock	25.552	25.62	25.44	25.59	14430100.0
2005-07-12 16:00:00	MSFT	Stock	25.6	25.61	25.5	25.56	774179.0
2005-07-12 17:00:00	MSFT	Stock	25.56	25.61	25.461	25.59	102800.0
2005-07-12 18:00:00	MSFT	Stock	25.6	25.61	25.6	25.61	13496.0
2005-07-12 09:00:00	NVDA	Stock	0.2381	0.2385	0.2345	0.2347	78254400.0
2005-07-12 10:00:00	NVDA	Stock	0.2347	0.2347	0.2318	0.2333	91456200.0
2005-07-12 11:00:00	NVDA	Stock	0.2333	0.2343	0.2325	0.2328	44636040.0
2005-07-12 12:00:00	NVDA	Stock	0.2329	0.2342	0.2326	0.2341	23739720.0
2005-07-12 13:00:00	NVDA	Stock	0.2341	0.2353	0.2336	0.234	61676280.0
2005-07-12 14:00:00	NVDA	Stock	0.2339	0.2384	0.2339	0.2377	155933880.0
2005-07-12 15:00:00	NVDA	Stock	0.2377	0.2384	0.2362	0.2367	97496280.0
2005-07-12 16:00:00	NVDA	Stock	0.2367	0.2371	0.2367	0.2368	2698920.0
2005-07-12 17:00:00	NVDA	Stock	0.2367	0.2368	0.2367	0.2368	312000.0
2005-07-12 08:00:00	AMZN	Stock	1.7755	1.7755	1.7755	1.7755	6000.0
2005-07-12 09:00:00	AMZN	Stock	1.7775	1.8	1.773	1.8	12235880.0
2005-07-12 10:00:00	AMZN	Stock	1.8	1.811	1.795	1.811	23361400.0
2005-07-12 11:00:00	AMZN	Stock	1.81	1.814	1.7995	1.804	16753900.0
2005-07-12 12:00:00	AMZN	Stock	1.8045	1.805	1.799	1.7995	7774620.0
2005-07-12 13:00:00	AMZN	Stock	1.7995	1.8147	1.7995	1.814	15738960.0
2005-07-12 14:00:00	AMZN	Stock	1.814	1.826	1.812	1.82	15736640.0
2005-07-12 15:00:00	AMZN	Stock	1.82	1.827	1.814	1.815	24429460.0
2005-07-12 16:00:00	AMZN	Stock	1.8155	1.819	1.8135	1.8155	324940.0
2005-07-12 17:00:00	AMZN	Stock	1.817	1.817	1.817	1.817	2000.0
2005-07-12 18:00:00	AMZN	Stock	1.817	1.82	1.817	1.82	15820.0
2005-07-12 09:00:00	CL	Stock	25.15	25.47	25.15	25.46	478800.0
2005-07-12 10:00:00	CL	Stock	25.46	25.48	25.38	25.395	598800.0
2005-07-12 11:00:00	CL	Stock	25.39	25.48	25.375	25.47	378800.0
2005-07-12 12:00:00	CL	Stock	25.47	25.515	25.425	25.43	428400.0
2005-07-12 13:00:00	CL	Stock	25.42	25.5	25.405	25.5	187400.0
2005-07-12 14:00:00	CL	Stock	25.5	25.51	25.45	25.475	365600.0
2005-07-12 15:00:00	CL	Stock	25.475	25.59	25.415	25.43	556200.0

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

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