PREVIEW / stock_1hour / 2005-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-26.parquet
  size:    549 KB
  rows:    26,536
  symbols: 2,057

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-08-26 08:00:00	AAPL	Stock	1.6493	1.6539	1.6493	1.6518	881524.0
2005-08-26 09:00:00	AAPL	Stock	1.6514	1.6568	1.6261	1.6332	53804940.0
2005-08-26 10:00:00	AAPL	Stock	1.6332	1.6346	1.62	1.6318	61229336.0
2005-08-26 11:00:00	AAPL	Stock	1.6318	1.6318	1.6268	1.6304	20832728.0
2005-08-26 12:00:00	AAPL	Stock	1.6307	1.64	1.6307	1.6379	30051112.0
2005-08-26 13:00:00	AAPL	Stock	1.6379	1.64	1.635	1.6368	18680984.0
2005-08-26 14:00:00	AAPL	Stock	1.6368	1.6421	1.635	1.6386	27994820.0
2005-08-26 15:00:00	AAPL	Stock	1.6382	1.6414	1.6332	1.6339	41808816.0
2005-08-26 16:00:00	AAPL	Stock	1.6336	1.6375	1.6307	1.6336	1451212.0
2005-08-26 17:00:00	AAPL	Stock	1.6339	1.6339	1.6332	1.6336	70812.0
2005-08-26 18:00:00	AAPL	Stock	1.6329	1.6329	1.6286	1.6286	94052.0
2005-08-26 08:00:00	MSFT	Stock	27.04	27.1	27.04	27.08	24370.0
2005-08-26 09:00:00	MSFT	Stock	27.06	27.08	26.94	27.012	4125666.0
2005-08-26 10:00:00	MSFT	Stock	27.01	27.02	26.93	26.96	5456380.0
2005-08-26 11:00:00	MSFT	Stock	26.95	27.0	26.87	26.95	4237556.0
2005-08-26 12:00:00	MSFT	Stock	26.949	27.01	26.9	26.95	2754575.0
2005-08-26 13:00:00	MSFT	Stock	26.95	27.01	26.92	26.979	3285201.0
2005-08-26 14:00:00	MSFT	Stock	26.97	27.07	26.9	27.05	5358016.0
2005-08-26 15:00:00	MSFT	Stock	27.05	27.08	26.97	26.97	9686247.0
2005-08-26 16:00:00	MSFT	Stock	26.97	27.0	26.94	26.95	457412.0
2005-08-26 17:00:00	MSFT	Stock	26.97	26.98	26.94	26.98	6311.0
2005-08-26 09:00:00	NVDA	Stock	0.2442	0.245	0.2422	0.2425	25696560.0
2005-08-26 10:00:00	NVDA	Stock	0.2424	0.2426	0.24	0.2411	81566760.0
2005-08-26 11:00:00	NVDA	Stock	0.241	0.2414	0.2402	0.2405	22996200.0
2005-08-26 12:00:00	NVDA	Stock	0.2405	0.2429	0.2402	0.2402	39753960.0
2005-08-26 13:00:00	NVDA	Stock	0.2402	0.2406	0.2387	0.2392	43537920.0
2005-08-26 14:00:00	NVDA	Stock	0.2391	0.2412	0.2387	0.2404	45191760.0
2005-08-26 15:00:00	NVDA	Stock	0.2404	0.2413	0.2402	0.241	57844080.0
2005-08-26 16:00:00	NVDA	Stock	0.2407	0.241	0.24	0.241	669840.0
2005-08-26 17:00:00	NVDA	Stock	0.2407	0.2407	0.2407	0.2407	12000.0
2005-08-26 09:00:00	AMZN	Stock	2.1225	2.1265	2.113	2.126	8390300.0
2005-08-26 10:00:00	AMZN	Stock	2.1255	2.1315	2.116	2.1225	12566340.0
2005-08-26 11:00:00	AMZN	Stock	2.1225	2.1265	2.122	2.123	4841600.0
2005-08-26 12:00:00	AMZN	Stock	2.124	2.126	2.1235	2.1245	4399700.0
2005-08-26 13:00:00	AMZN	Stock	2.1245	2.127	2.121	2.122	4309880.0
2005-08-26 14:00:00	AMZN	Stock	2.122	2.129	2.121	2.1255	7897100.0
2005-08-26 15:00:00	AMZN	Stock	2.125	2.1315	2.1185	2.12	12347940.0
2005-08-26 16:00:00	AMZN	Stock	2.1195	2.1235	2.116	2.1185	492300.0
2005-08-26 17:00:00	AMZN	Stock	2.1235	2.1235	2.1235	2.1235	18000.0
2005-08-26 08:00:00	CL	Stock	26.235	26.235	26.235	26.235	2200.0
2005-08-26 09:00:00	CL	Stock	26.215	26.215	26.075	26.09	416200.0
2005-08-26 10:00:00	CL	Stock	26.085	26.117	26.03	26.117	497200.0
2005-08-26 11:00:00	CL	Stock	26.12	26.13	26.035	26.045	454400.0
2005-08-26 12:00:00	CL	Stock	26.065	26.105	26.035	26.035	285600.0
2005-08-26 13:00:00	CL	Stock	26.04	26.075	26.005	26.055	304800.0
2005-08-26 14:00:00	CL	Stock	26.055	26.165	26.03	26.115	455000.0
2005-08-26 15:00:00	CL	Stock	26.115	26.15	26.091	26.1	513200.0
2005-08-26 16:00:00	CL	Stock	26.085	26.085	26.085	26.085	4000.0
2005-08-26 17:00:00	CL	Stock	26.085	26.085	26.085	26.085	200.0

> showing 49 of 26,536 rows — these rows as CSV

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