PREVIEW / stock_1hour / 2005-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-15.parquet
  size:    566 KB
  rows:    27,229
  symbols: 2,062

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-15 07:00:00	AAPL	Stock	1.6536	1.6679	1.6461	1.6482	748860.0
2005-08-15 08:00:00	AAPL	Stock	1.6493	1.6786	1.6486	1.6639	12416824.0
2005-08-15 09:00:00	AAPL	Stock	1.6618	1.6957	1.6589	1.695	245564032.0
2005-08-15 10:00:00	AAPL	Stock	1.695	1.7125	1.6843	1.7036	238683032.0
2005-08-15 11:00:00	AAPL	Stock	1.7036	1.7093	1.6964	1.7064	112721448.0
2005-08-15 12:00:00	AAPL	Stock	1.7064	1.7236	1.7043	1.7229	113150520.0
2005-08-15 13:00:00	AAPL	Stock	1.7225	1.7261	1.705	1.7054	123660124.0
2005-08-15 14:00:00	AAPL	Stock	1.7057	1.7168	1.7036	1.7114	89423516.0
2005-08-15 15:00:00	AAPL	Stock	1.7118	1.7171	1.7014	1.7029	128635584.0
2005-08-15 16:00:00	AAPL	Stock	1.7018	1.7107	1.6954	1.7011	12475232.0
2005-08-15 17:00:00	AAPL	Stock	1.7029	1.7043	1.7014	1.7043	326060.0
2005-08-15 18:00:00	AAPL	Stock	1.7018	1.7043	1.7018	1.7036	154700.0
2005-08-15 08:00:00	MSFT	Stock	27.05	27.05	26.98	26.98	2250.0
2005-08-15 09:00:00	MSFT	Stock	27.01	27.05	26.84	26.87	5508565.0
2005-08-15 10:00:00	MSFT	Stock	26.87	26.92	26.69	26.9	7689223.0
2005-08-15 11:00:00	MSFT	Stock	26.91	27.0	26.88	26.94	4517695.0
2005-08-15 12:00:00	MSFT	Stock	26.94	27.13	26.94	27.06	5286529.0
2005-08-15 13:00:00	MSFT	Stock	27.06	27.22	27.05	27.18	5636829.0
2005-08-15 14:00:00	MSFT	Stock	27.18	27.301	27.16	27.29	6184995.0
2005-08-15 15:00:00	MSFT	Stock	27.29	27.3	27.07	27.11	7599548.0
2005-08-15 16:00:00	MSFT	Stock	27.1	27.19	27.053	27.17	322335.0
2005-08-15 17:00:00	MSFT	Stock	27.17	27.19	27.13	27.18	513851.0
2005-08-15 18:00:00	MSFT	Stock	27.19	27.19	27.1	27.11	38364.0
2005-08-15 08:00:00	NVDA	Stock	0.2508	0.252	0.2496	0.25	726000.0
2005-08-15 09:00:00	NVDA	Stock	0.25	0.2506	0.2472	0.2492	101028960.0
2005-08-15 10:00:00	NVDA	Stock	0.2492	0.254	0.2483	0.2535	193968480.0
2005-08-15 11:00:00	NVDA	Stock	0.2535	0.2545	0.2509	0.2542	137300880.0
2005-08-15 12:00:00	NVDA	Stock	0.2541	0.2572	0.2532	0.2564	114100800.0
2005-08-15 13:00:00	NVDA	Stock	0.2563	0.2585	0.2558	0.2582	100066320.0
2005-08-15 14:00:00	NVDA	Stock	0.2581	0.2582	0.2558	0.2572	83046600.0
2005-08-15 15:00:00	NVDA	Stock	0.2573	0.2574	0.2557	0.2559	106972440.0
2005-08-15 16:00:00	NVDA	Stock	0.256	0.2568	0.2557	0.2557	8892000.0
2005-08-15 17:00:00	NVDA	Stock	0.2559	0.256	0.2554	0.256	21782400.0
2005-08-15 09:00:00	AMZN	Stock	2.203	2.224	2.194	2.221	16477160.0
2005-08-15 10:00:00	AMZN	Stock	2.221	2.234	2.2125	2.2335	20884860.0
2005-08-15 11:00:00	AMZN	Stock	2.2335	2.2465	2.2315	2.243	14001000.0
2005-08-15 12:00:00	AMZN	Stock	2.2445	2.265	2.24	2.262	21951220.0
2005-08-15 13:00:00	AMZN	Stock	2.2625	2.2675	2.258	2.265	9995860.0
2005-08-15 14:00:00	AMZN	Stock	2.2655	2.266	2.2595	2.26	6688000.0
2005-08-15 15:00:00	AMZN	Stock	2.26	2.261	2.252	2.252	18460020.0
2005-08-15 16:00:00	AMZN	Stock	2.2525	2.2535	2.246	2.25	390580.0
2005-08-15 17:00:00	AMZN	Stock	2.2535	2.2535	2.2495	2.2495	67680.0
2005-08-15 18:00:00	AMZN	Stock	2.25	2.25	2.192	2.231	286200.0
2005-08-15 09:00:00	CL	Stock	26.435	26.485	26.365	26.4	178800.0
2005-08-15 10:00:00	CL	Stock	26.395	26.425	26.33	26.38	465600.0
2005-08-15 11:00:00	CL	Stock	26.39	26.4	26.3	26.34	242600.0
2005-08-15 12:00:00	CL	Stock	26.34	26.415	26.34	26.37	287200.0
2005-08-15 13:00:00	CL	Stock	26.37	26.47	26.36	26.445	154600.0
2005-08-15 14:00:00	CL	Stock	26.45	26.465	26.395	26.445	206200.0
2005-08-15 15:00:00	CL	Stock	26.45	26.45	26.375	26.385	430000.0

> showing 50 of 27,229 rows — these rows as CSV

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