PREVIEW / stock_1hour / 2005-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-06.parquet
  size:    544 KB
  rows:    25,834
  symbols: 2,016

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-07-06 08:00:00	AAPL	Stock	1.3571	1.3571	1.3461	1.3464	740488.0
2005-07-06 09:00:00	AAPL	Stock	1.3464	1.3536	1.3429	1.3468	52330908.0
2005-07-06 10:00:00	AAPL	Stock	1.3464	1.3536	1.3443	1.3525	53441780.0
2005-07-06 11:00:00	AAPL	Stock	1.3521	1.3629	1.3514	1.3579	60967900.0
2005-07-06 12:00:00	AAPL	Stock	1.3579	1.3582	1.3379	1.3421	61689208.0
2005-07-06 13:00:00	AAPL	Stock	1.3418	1.3486	1.3418	1.3454	30166388.0
2005-07-06 14:00:00	AAPL	Stock	1.3454	1.3464	1.3286	1.3361	55580700.0
2005-07-06 15:00:00	AAPL	Stock	1.3361	1.3432	1.3339	1.3354	67189164.0
2005-07-06 16:00:00	AAPL	Stock	1.3354	1.3451	1.3325	1.3354	3005828.0
2005-07-06 17:00:00	AAPL	Stock	1.3354	1.3371	1.3354	1.3371	3972584.0
2005-07-06 18:00:00	AAPL	Stock	1.3357	1.3368	1.3354	1.3354	40376.0
2005-07-06 07:00:00	MSFT	Stock	24.98	25.0	24.98	24.99	6400.0
2005-07-06 08:00:00	MSFT	Stock	24.98	25.0	24.96	25.0	12897.0
2005-07-06 09:00:00	MSFT	Stock	25.0	25.215	24.92	25.0	8447902.0
2005-07-06 10:00:00	MSFT	Stock	25.0	25.04	24.93	24.98	12507193.0
2005-07-06 11:00:00	MSFT	Stock	24.97	24.98	24.9	24.92	6467134.0
2005-07-06 12:00:00	MSFT	Stock	24.91	24.95	24.829	24.87	6901239.0
2005-07-06 13:00:00	MSFT	Stock	24.86	24.95	24.85	24.86	4335254.0
2005-07-06 14:00:00	MSFT	Stock	24.86	24.88	24.74	24.78	9075890.0
2005-07-06 15:00:00	MSFT	Stock	24.77	24.9	24.69	24.7	12351260.0
2005-07-06 16:00:00	MSFT	Stock	24.71	24.891	24.7	24.7	2436650.0
2005-07-06 17:00:00	MSFT	Stock	24.72	24.73	24.7	24.73	132140.0
2005-07-06 18:00:00	MSFT	Stock	24.73	24.73	24.72	24.73	2652.0
2005-07-06 08:00:00	NVDA	Stock	0.2289	0.2329	0.2279	0.2279	96000.0
2005-07-06 09:00:00	NVDA	Stock	0.2292	0.2292	0.2257	0.226	68223720.0
2005-07-06 10:00:00	NVDA	Stock	0.226	0.228	0.2253	0.228	128427360.0
2005-07-06 11:00:00	NVDA	Stock	0.2281	0.2322	0.2271	0.2317	91848240.0
2005-07-06 12:00:00	NVDA	Stock	0.2317	0.2328	0.231	0.2325	80139960.0
2005-07-06 13:00:00	NVDA	Stock	0.2325	0.2342	0.2323	0.2338	79997280.0
2005-07-06 14:00:00	NVDA	Stock	0.2337	0.2337	0.2319	0.2333	90632760.0
2005-07-06 15:00:00	NVDA	Stock	0.2332	0.234	0.232	0.2332	147354120.0
2005-07-06 16:00:00	NVDA	Stock	0.2332	0.2332	0.2328	0.233	803760.0
2005-07-06 17:00:00	NVDA	Stock	0.233	0.2373	0.2326	0.2333	1212360.0
2005-07-06 18:00:00	NVDA	Stock	0.2325	0.2325	0.2325	0.2325	12000.0
2005-07-06 08:00:00	AMZN	Stock	1.706	1.706	1.706	1.706	6000.0
2005-07-06 09:00:00	AMZN	Stock	1.7055	1.72	1.693	1.7115	16047900.0
2005-07-06 10:00:00	AMZN	Stock	1.711	1.72	1.705	1.7105	15678300.0
2005-07-06 11:00:00	AMZN	Stock	1.7105	1.7145	1.7095	1.7125	5761420.0
2005-07-06 12:00:00	AMZN	Stock	1.7125	1.7135	1.7025	1.7055	4712080.0
2005-07-06 13:00:00	AMZN	Stock	1.706	1.713	1.705	1.7094	5112880.0
2005-07-06 14:00:00	AMZN	Stock	1.7095	1.7095	1.6935	1.7005	15387820.0
2005-07-06 15:00:00	AMZN	Stock	1.7	1.709	1.6945	1.703	14733660.0
2005-07-06 16:00:00	AMZN	Stock	1.703	1.7075	1.703	1.703	5409720.0
2005-07-06 17:00:00	AMZN	Stock	1.703	1.703	1.703	1.703	16560.0
2005-07-06 09:00:00	CL	Stock	25.125	25.13	24.98	25.05	329600.0
2005-07-06 10:00:00	CL	Stock	25.06	25.07	24.955	24.98	531200.0
2005-07-06 11:00:00	CL	Stock	24.98	24.995	24.9	24.9	364400.0
2005-07-06 12:00:00	CL	Stock	24.9	24.945	24.88	24.925	435000.0
2005-07-06 13:00:00	CL	Stock	24.915	24.945	24.87	24.885	305400.0
2005-07-06 14:00:00	CL	Stock	24.88	24.88	24.75	24.795	791800.0

> showing 50 of 25,834 rows — these rows as CSV

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