PREVIEW / stock_1hour / 2006-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-19.parquet
  size:    615 KB
  rows:    29,048
  symbols: 2,269

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-19 07:00:00	AAPL	Stock	2.2714	2.2714	2.2714	2.2714	26600.0
2006-05-19 08:00:00	AAPL	Stock	2.2732	2.2775	2.2689	2.2757	1716960.0
2006-05-19 09:00:00	AAPL	Stock	2.2757	2.2818	2.2436	2.255	199658760.0
2006-05-19 10:00:00	AAPL	Stock	2.255	2.2886	2.2464	2.2675	190244264.0
2006-05-19 11:00:00	AAPL	Stock	2.2671	2.2686	2.2471	2.2618	110707940.0
2006-05-19 12:00:00	AAPL	Stock	2.2614	2.2839	2.2529	2.2821	99025500.0
2006-05-19 13:00:00	AAPL	Stock	2.2821	2.3171	2.2743	2.3111	109877740.0
2006-05-19 14:00:00	AAPL	Stock	2.3111	2.3139	2.2771	2.281	99226540.0
2006-05-19 15:00:00	AAPL	Stock	2.2811	2.3093	2.2661	2.3032	143126256.0
2006-05-19 16:00:00	AAPL	Stock	2.3032	2.3093	2.2857	2.3089	9180584.0
2006-05-19 17:00:00	AAPL	Stock	2.3104	2.3179	2.3036	2.3125	642992.0
2006-05-19 18:00:00	AAPL	Stock	2.3125	2.3143	2.31	2.3107	303240.0
2006-05-19 08:00:00	MSFT	Stock	22.93	22.96	22.85	22.91	76030.0
2006-05-19 09:00:00	MSFT	Stock	22.91	22.94	22.6	22.71	22073058.0
2006-05-19 10:00:00	MSFT	Stock	22.7	22.74	22.54	22.67	15494576.0
2006-05-19 11:00:00	MSFT	Stock	22.67	22.76	22.6	22.72	13652829.0
2006-05-19 12:00:00	MSFT	Stock	22.72	22.78	22.67	22.73	9256071.0
2006-05-19 13:00:00	MSFT	Stock	22.73	22.78	22.66	22.72	7498696.0
2006-05-19 14:00:00	MSFT	Stock	22.72	22.77	22.55	22.56	10263562.0
2006-05-19 15:00:00	MSFT	Stock	22.55	22.71	22.52	22.55	17058677.0
2006-05-19 16:00:00	MSFT	Stock	22.53	22.58	22.53	22.57	413936.0
2006-05-19 17:00:00	MSFT	Stock	22.56	22.58	22.54	22.57	59393.0
2006-05-19 18:00:00	MSFT	Stock	22.58	22.59	22.58	22.59	1320.0
2006-05-19 08:00:00	NVDA	Stock	0.4042	0.4053	0.403	0.4053	414000.0
2006-05-19 09:00:00	NVDA	Stock	0.4053	0.415	0.3968	0.4118	177188640.0
2006-05-19 10:00:00	NVDA	Stock	0.412	0.4123	0.4028	0.4053	134945160.0
2006-05-19 11:00:00	NVDA	Stock	0.4052	0.4083	0.4	0.4035	127105800.0
2006-05-19 12:00:00	NVDA	Stock	0.4035	0.407	0.4007	0.4027	84541980.0
2006-05-19 13:00:00	NVDA	Stock	0.4027	0.4075	0.4018	0.4065	133212780.0
2006-05-19 14:00:00	NVDA	Stock	0.4066	0.4137	0.4053	0.4058	134010000.0
2006-05-19 15:00:00	NVDA	Stock	0.4058	0.4085	0.4013	0.4057	104159700.0
2006-05-19 16:00:00	NVDA	Stock	0.4057	0.4065	0.4047	0.4058	1289760.0
2006-05-19 17:00:00	NVDA	Stock	0.4067	0.4067	0.4067	0.4067	60000.0
2006-05-19 09:00:00	AMZN	Stock	1.645	1.663	1.6275	1.647	29275980.0
2006-05-19 10:00:00	AMZN	Stock	1.645	1.6485	1.6175	1.6205	22840580.0
2006-05-19 11:00:00	AMZN	Stock	1.6205	1.6315	1.6015	1.628	22790220.0
2006-05-19 12:00:00	AMZN	Stock	1.6285	1.6785	1.6245	1.676	24565400.0
2006-05-19 13:00:00	AMZN	Stock	1.676	1.7	1.645	1.6685	24740260.0
2006-05-19 14:00:00	AMZN	Stock	1.6685	1.694	1.6615	1.6795	19565880.0
2006-05-19 15:00:00	AMZN	Stock	1.6795	1.6995	1.664	1.697	45802220.0
2006-05-19 16:00:00	AMZN	Stock	1.6975	1.7035	1.6905	1.6965	708440.0
2006-05-19 17:00:00	AMZN	Stock	1.6965	1.7	1.695	1.695	54000.0
2006-05-19 18:00:00	AMZN	Stock	1.691	1.691	1.6905	1.6905	19040.0
2006-05-19 09:00:00	CL	Stock	30.035	30.0615	29.855	29.985	1416600.0
2006-05-19 10:00:00	CL	Stock	29.96	30.035	29.755	29.785	1385600.0
2006-05-19 11:00:00	CL	Stock	29.785	29.805	29.525	29.58	989600.0
2006-05-19 12:00:00	CL	Stock	29.585	29.7	29.54	29.61	692600.0
2006-05-19 13:00:00	CL	Stock	29.61	29.755	29.6	29.72	578800.0
2006-05-19 14:00:00	CL	Stock	29.7115	29.77	29.595	29.64	455400.0
2006-05-19 15:00:00	CL	Stock	29.6365	29.785	29.55	29.725	980200.0

> showing 50 of 29,048 rows — these rows as CSV

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