PREVIEW / stock_1hour / 2005-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-17.parquet
  size:    548 KB
  rows:    26,127
  symbols: 1,983

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-05-17 08:00:00	AAPL	Stock	1.2625	1.2625	1.2446	1.2493	7059388.0
2005-05-17 09:00:00	AAPL	Stock	1.2504	1.2571	1.2371	1.2393	115845604.0
2005-05-17 10:00:00	AAPL	Stock	1.2393	1.2461	1.2336	1.2375	115927476.0
2005-05-17 11:00:00	AAPL	Stock	1.2375	1.2554	1.2371	1.2446	68795720.0
2005-05-17 12:00:00	AAPL	Stock	1.2446	1.25	1.2446	1.2464	44930928.0
2005-05-17 13:00:00	AAPL	Stock	1.2461	1.2568	1.2439	1.2539	56114744.0
2005-05-17 14:00:00	AAPL	Stock	1.2539	1.2664	1.2504	1.2604	92715392.0
2005-05-17 15:00:00	AAPL	Stock	1.2607	1.2632	1.2579	1.2629	76832560.0
2005-05-17 16:00:00	AAPL	Stock	1.2629	1.2668	1.2614	1.2661	3287032.0
2005-05-17 17:00:00	AAPL	Stock	1.2643	1.2664	1.2632	1.2664	786240.0
2005-05-17 18:00:00	AAPL	Stock	1.2664	1.2679	1.2664	1.2679	435484.0
2005-05-17 08:00:00	MSFT	Stock	25.45	25.45	25.37	25.37	27215.0
2005-05-17 09:00:00	MSFT	Stock	25.37	25.42	25.27	25.33	4967560.0
2005-05-17 10:00:00	MSFT	Stock	25.33	25.37	25.26	25.27	5107691.0
2005-05-17 11:00:00	MSFT	Stock	25.27	25.39	25.25	25.33	7075352.0
2005-05-17 12:00:00	MSFT	Stock	25.32	25.33	25.25	25.27	2281287.0
2005-05-17 13:00:00	MSFT	Stock	25.27	25.34	25.26	25.3	3962485.0
2005-05-17 14:00:00	MSFT	Stock	25.3	25.46	25.28	25.4	6574689.0
2005-05-17 15:00:00	MSFT	Stock	25.41	25.5	25.38	25.49	7917975.0
2005-05-17 16:00:00	MSFT	Stock	25.49	25.51	25.46	25.49	198163.0
2005-05-17 17:00:00	MSFT	Stock	25.46	25.5	25.352	25.47	107061.0
2005-05-17 18:00:00	MSFT	Stock	25.48	25.48	25.48	25.48	920.0
2005-05-17 08:00:00	NVDA	Stock	0.2132	0.2141	0.2117	0.2127	1032000.0
2005-05-17 09:00:00	NVDA	Stock	0.2124	0.2143	0.2101	0.2142	101229480.0
2005-05-17 10:00:00	NVDA	Stock	0.2142	0.2144	0.2117	0.2128	124636800.0
2005-05-17 11:00:00	NVDA	Stock	0.2127	0.2131	0.2112	0.2114	62848440.0
2005-05-17 12:00:00	NVDA	Stock	0.2114	0.2125	0.2113	0.2115	37199760.0
2005-05-17 13:00:00	NVDA	Stock	0.2115	0.2135	0.2111	0.2132	61406520.0
2005-05-17 14:00:00	NVDA	Stock	0.2132	0.2152	0.2126	0.2143	99176880.0
2005-05-17 15:00:00	NVDA	Stock	0.2143	0.2147	0.2135	0.2142	128881560.0
2005-05-17 16:00:00	NVDA	Stock	0.2147	0.2149	0.2137	0.2142	4517400.0
2005-05-17 17:00:00	NVDA	Stock	0.2142	0.2142	0.2137	0.2137	743280.0
2005-05-17 18:00:00	NVDA	Stock	0.2138	0.2142	0.2138	0.2142	72000.0
2005-05-17 08:00:00	AMZN	Stock	1.7215	1.7255	1.7215	1.7255	162000.0
2005-05-17 09:00:00	AMZN	Stock	1.7225	1.741	1.7165	1.728	10380260.0
2005-05-17 10:00:00	AMZN	Stock	1.728	1.73	1.715	1.721	11134580.0
2005-05-17 11:00:00	AMZN	Stock	1.721	1.7245	1.717	1.717	4201900.0
2005-05-17 12:00:00	AMZN	Stock	1.7175	1.7175	1.705	1.706	6262220.0
2005-05-17 13:00:00	AMZN	Stock	1.7055	1.7135	1.7045	1.7055	7228040.0
2005-05-17 14:00:00	AMZN	Stock	1.7055	1.7235	1.7055	1.723	7553280.0
2005-05-17 15:00:00	AMZN	Stock	1.723	1.737	1.7185	1.7365	17335660.0
2005-05-17 16:00:00	AMZN	Stock	1.7365	1.7375	1.727	1.736	323640.0
2005-05-17 17:00:00	AMZN	Stock	1.735	1.7365	1.7342	1.735	137800.0
2005-05-17 09:00:00	CL	Stock	24.465	24.56	24.465	24.525	382000.0
2005-05-17 10:00:00	CL	Stock	24.52	24.54	24.5	24.52	735200.0
2005-05-17 11:00:00	CL	Stock	24.515	24.54	24.48	24.505	821200.0
2005-05-17 12:00:00	CL	Stock	24.505	24.54	24.5	24.5075	564400.0
2005-05-17 13:00:00	CL	Stock	24.505	24.55	24.5	24.51	601800.0
2005-05-17 14:00:00	CL	Stock	24.51	24.62	24.5	24.615	935200.0
2005-05-17 15:00:00	CL	Stock	24.615	24.795	24.605	24.795	913600.0

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

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