PREVIEW / stock_1hour / 2006-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-25.parquet
  size:    620 KB
  rows:    29,398
  symbols: 2,266

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-05-25 07:00:00	AAPL	Stock	2.2568	2.2768	2.2568	2.2768	53200.0
2006-05-25 08:00:00	AAPL	Stock	2.2775	2.2886	2.2714	2.2886	1568028.0
2006-05-25 09:00:00	AAPL	Stock	2.2857	2.3018	2.2732	2.2793	86553964.0
2006-05-25 10:00:00	AAPL	Stock	2.2793	2.2948	2.2604	2.2746	93452156.0
2006-05-25 11:00:00	AAPL	Stock	2.2746	2.2839	2.2686	2.2832	49773472.0
2006-05-25 12:00:00	AAPL	Stock	2.2832	2.2857	2.2675	2.2771	39977448.0
2006-05-25 13:00:00	AAPL	Stock	2.2775	2.2857	2.2711	2.2818	33737480.0
2006-05-25 14:00:00	AAPL	Stock	2.2821	2.2914	2.2782	2.2882	48504596.0
2006-05-25 15:00:00	AAPL	Stock	2.2882	2.3007	2.2818	2.3	86126656.0
2006-05-25 16:00:00	AAPL	Stock	2.2971	2.3018	2.2946	2.3	786548.0
2006-05-25 17:00:00	AAPL	Stock	2.2993	2.2996	2.2957	2.2996	153356.0
2006-05-25 18:00:00	AAPL	Stock	2.2982	2.2982	2.2961	2.2961	222068.0
2006-05-25 08:00:00	MSFT	Stock	23.59	23.62	23.45	23.57	684951.0
2006-05-25 09:00:00	MSFT	Stock	23.58	23.78	23.5	23.708	10033527.0
2006-05-25 10:00:00	MSFT	Stock	23.71	23.73	23.58	23.69	12482013.0
2006-05-25 11:00:00	MSFT	Stock	23.68	23.76	23.68	23.76	7623551.0
2006-05-25 12:00:00	MSFT	Stock	23.76	23.92	23.73	23.78	15436695.0
2006-05-25 13:00:00	MSFT	Stock	23.77	23.78	23.59	23.69	7954223.0
2006-05-25 14:00:00	MSFT	Stock	23.69	23.73	23.65	23.7	6604281.0
2006-05-25 15:00:00	MSFT	Stock	23.69	23.87	23.67	23.75	19587307.0
2006-05-25 16:00:00	MSFT	Stock	23.73	23.8	23.67	23.74	1423598.0
2006-05-25 17:00:00	MSFT	Stock	23.72	23.74	23.72	23.74	2362.0
2006-05-25 18:00:00	MSFT	Stock	23.74	23.75	23.71	23.72	1626.0
2006-05-25 08:00:00	NVDA	Stock	0.4038	0.4082	0.4038	0.4082	97800.0
2006-05-25 09:00:00	NVDA	Stock	0.4075	0.4143	0.4007	0.4033	43681380.0
2006-05-25 10:00:00	NVDA	Stock	0.4033	0.4053	0.3968	0.3992	92020260.0
2006-05-25 11:00:00	NVDA	Stock	0.3993	0.4042	0.3978	0.403	70338600.0
2006-05-25 12:00:00	NVDA	Stock	0.403	0.4033	0.3983	0.3988	39834060.0
2006-05-25 13:00:00	NVDA	Stock	0.399	0.3998	0.3965	0.3983	42522780.0
2006-05-25 14:00:00	NVDA	Stock	0.3982	0.4007	0.3973	0.398	54388560.0
2006-05-25 15:00:00	NVDA	Stock	0.3978	0.399	0.3967	0.3987	72764580.0
2006-05-25 16:00:00	NVDA	Stock	0.4017	0.4017	0.3973	0.399	659220.0
2006-05-25 17:00:00	NVDA	Stock	0.399	0.399	0.399	0.399	12000.0
2006-05-25 08:00:00	AMZN	Stock	1.7615	1.7785	1.76	1.7725	249500.0
2006-05-25 09:00:00	AMZN	Stock	1.7725	1.7845	1.7595	1.76	16326520.0
2006-05-25 10:00:00	AMZN	Stock	1.7605	1.764	1.73	1.7535	27085000.0
2006-05-25 11:00:00	AMZN	Stock	1.753	1.757	1.7415	1.757	13630140.0
2006-05-25 12:00:00	AMZN	Stock	1.757	1.7585	1.739	1.75	10414240.0
2006-05-25 13:00:00	AMZN	Stock	1.75	1.752	1.742	1.743	9825840.0
2006-05-25 14:00:00	AMZN	Stock	1.743	1.764	1.738	1.7635	12162020.0
2006-05-25 15:00:00	AMZN	Stock	1.7635	1.784	1.76	1.78	24057520.0
2006-05-25 16:00:00	AMZN	Stock	1.7795	1.785	1.7795	1.784	50000.0
2006-05-25 09:00:00	CL	Stock	29.89	29.94	29.805	29.905	259600.0
2006-05-25 10:00:00	CL	Stock	29.905	30.025	29.42	29.89	679800.0
2006-05-25 11:00:00	CL	Stock	29.89	29.965	29.85	29.905	451800.0
2006-05-25 12:00:00	CL	Stock	29.92	29.925	29.87	29.92	304400.0
2006-05-25 13:00:00	CL	Stock	29.92	29.945	29.87	29.925	350200.0
2006-05-25 14:00:00	CL	Stock	29.925	29.97	29.885	29.895	299800.0
2006-05-25 15:00:00	CL	Stock	29.9	29.995	29.895	29.985	493200.0

> showing 49 of 29,398 rows — these rows as CSV

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