PREVIEW / stock_1hour / 2005-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-20.parquet
  size:    526 KB
  rows:    24,850
  symbols: 1,966

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-20 07:00:00	AAPL	Stock	1.3411	1.3411	1.3411	1.3411	5600.0
2005-05-20 08:00:00	AAPL	Stock	1.3411	1.3411	1.3268	1.3318	1941968.0
2005-05-20 09:00:00	AAPL	Stock	1.33	1.3411	1.3268	1.3371	84947492.0
2005-05-20 10:00:00	AAPL	Stock	1.3364	1.3446	1.3286	1.3432	94405668.0
2005-05-20 11:00:00	AAPL	Stock	1.3432	1.3446	1.3346	1.3379	65694776.0
2005-05-20 12:00:00	AAPL	Stock	1.3379	1.3379	1.3321	1.3354	37325512.0
2005-05-20 13:00:00	AAPL	Stock	1.3354	1.34	1.3332	1.3393	40711440.0
2005-05-20 14:00:00	AAPL	Stock	1.3389	1.3425	1.3371	1.3414	51440368.0
2005-05-20 15:00:00	AAPL	Stock	1.3411	1.3425	1.3379	1.3414	68164376.0
2005-05-20 16:00:00	AAPL	Stock	1.3418	1.3429	1.3396	1.3425	3020808.0
2005-05-20 17:00:00	AAPL	Stock	1.3411	1.3421	1.3407	1.3407	212800.0
2005-05-20 18:00:00	AAPL	Stock	1.3407	1.3407	1.34	1.34	44800.0
2005-05-20 08:00:00	MSFT	Stock	25.84	25.85	25.83	25.84	4380.0
2005-05-20 09:00:00	MSFT	Stock	25.83	25.92	25.74	25.82	9763132.0
2005-05-20 10:00:00	MSFT	Stock	25.82	25.91	25.78	25.86	7324379.0
2005-05-20 11:00:00	MSFT	Stock	25.87	25.89	25.82	25.87	8957661.0
2005-05-20 12:00:00	MSFT	Stock	25.87	25.92	25.84	25.85	5111644.0
2005-05-20 13:00:00	MSFT	Stock	25.85	25.89	25.81	25.83	7648017.0
2005-05-20 14:00:00	MSFT	Stock	25.84	25.87	25.78	25.79	10149589.0
2005-05-20 15:00:00	MSFT	Stock	25.8	25.83	25.73	25.79	13942489.0
2005-05-20 16:00:00	MSFT	Stock	25.71	25.8	25.69	25.78	335234.0
2005-05-20 17:00:00	MSFT	Stock	25.77	25.77	25.77	25.77	5500.0
2005-05-20 18:00:00	MSFT	Stock	25.78	25.78	25.78	25.78	1450.0
2005-05-20 08:00:00	NVDA	Stock	0.2148	0.215	0.2136	0.215	60000.0
2005-05-20 09:00:00	NVDA	Stock	0.2113	0.2161	0.2113	0.2139	48566280.0
2005-05-20 10:00:00	NVDA	Stock	0.2139	0.2147	0.2126	0.2145	85637160.0
2005-05-20 11:00:00	NVDA	Stock	0.2145	0.2146	0.2137	0.2145	26882640.0
2005-05-20 12:00:00	NVDA	Stock	0.2146	0.2157	0.2142	0.2153	29466840.0
2005-05-20 13:00:00	NVDA	Stock	0.2153	0.2158	0.2149	0.2156	25054680.0
2005-05-20 14:00:00	NVDA	Stock	0.2157	0.2182	0.2155	0.2177	126752280.0
2005-05-20 15:00:00	NVDA	Stock	0.2176	0.2192	0.2174	0.2191	154709520.0
2005-05-20 16:00:00	NVDA	Stock	0.2192	0.2193	0.2189	0.2193	13377000.0
2005-05-20 09:00:00	AMZN	Stock	1.766	1.7785	1.756	1.762	11633080.0
2005-05-20 10:00:00	AMZN	Stock	1.7615	1.763	1.7524	1.7555	16609500.0
2005-05-20 11:00:00	AMZN	Stock	1.756	1.756	1.7515	1.7555	10210880.0
2005-05-20 12:00:00	AMZN	Stock	1.7555	1.756	1.752	1.7535	7797200.0
2005-05-20 13:00:00	AMZN	Stock	1.7535	1.7575	1.748	1.7555	16924520.0
2005-05-20 14:00:00	AMZN	Stock	1.756	1.775	1.754	1.774	18152040.0
2005-05-20 15:00:00	AMZN	Stock	1.774	1.78	1.772	1.7745	17024600.0
2005-05-20 16:00:00	AMZN	Stock	1.7765	1.7765	1.7725	1.7735	473160.0
2005-05-20 17:00:00	AMZN	Stock	1.7735	1.775	1.7735	1.775	8000.0
2005-05-20 09:00:00	CL	Stock	25.49	25.5	25.4	25.45	724800.0
2005-05-20 10:00:00	CL	Stock	25.445	25.47	25.365	25.385	398800.0
2005-05-20 11:00:00	CL	Stock	25.385	25.395	25.29	25.375	338400.0
2005-05-20 12:00:00	CL	Stock	25.385	25.5	25.375	25.495	365600.0
2005-05-20 13:00:00	CL	Stock	25.5	25.5	25.375	25.42	371000.0
2005-05-20 14:00:00	CL	Stock	25.42	25.51	25.415	25.46	489400.0
2005-05-20 15:00:00	CL	Stock	25.465	25.58	25.45	25.535	769800.0
2005-05-20 16:00:00	CL	Stock	25.56	25.56	25.56	25.56	2600.0

> showing 49 of 24,850 rows — these rows as CSV

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