PREVIEW / stock_1hour / 2003-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-06-12.parquet
  size:    451 KB
  rows:    21,420
  symbols: 1,586

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
2003-06-12 08:00:00	AAPL	Stock	0.312	0.3125	0.3116	0.3118	1464400.0
2003-06-12 09:00:00	AAPL	Stock	0.3123	0.3168	0.312	0.3143	32556384.0
2003-06-12 10:00:00	AAPL	Stock	0.3141	0.317	0.3123	0.3168	48421744.0
2003-06-12 11:00:00	AAPL	Stock	0.3166	0.3191	0.3159	0.3159	32597544.0
2003-06-12 12:00:00	AAPL	Stock	0.3159	0.3171	0.3145	0.3171	13191976.0
2003-06-12 13:00:00	AAPL	Stock	0.3171	0.3179	0.3159	0.3171	22312584.0
2003-06-12 14:00:00	AAPL	Stock	0.317	0.3174	0.315	0.3168	22149400.0
2003-06-12 15:00:00	AAPL	Stock	0.3168	0.3193	0.3152	0.3173	26666360.0
2003-06-12 16:00:00	AAPL	Stock	0.3179	0.3182	0.3164	0.3179	3085600.0
2003-06-12 17:00:00	AAPL	Stock	0.3168	0.3168	0.3161	0.3161	106400.0
2003-06-12 08:00:00	MSFT	Stock	24.95	25.051	24.88	25.01	250058.0
2003-06-12 09:00:00	MSFT	Stock	25.0	25.04	24.879	24.91	10033120.0
2003-06-12 10:00:00	MSFT	Stock	24.9	25.14	24.76	25.08	13921554.0
2003-06-12 11:00:00	MSFT	Stock	25.09	25.13	24.91	24.99	9242320.0
2003-06-12 12:00:00	MSFT	Stock	24.99	25.03	24.9	24.99	5095396.0
2003-06-12 13:00:00	MSFT	Stock	24.99	25.02	24.86	24.89	4736375.0
2003-06-12 14:00:00	MSFT	Stock	24.8802	24.93	24.74	24.86	6728351.0
2003-06-12 15:00:00	MSFT	Stock	24.87	25.04	24.83	25.0	8770420.0
2003-06-12 16:00:00	MSFT	Stock	25.0	25.1	24.93	25.05	2136086.0
2003-06-12 17:00:00	MSFT	Stock	25.02	25.08	24.995	25.08	282136.0
2003-06-12 18:00:00	MSFT	Stock	25.069	25.09	25.01	25.01	28970.0
2003-06-12 08:00:00	NVDA	Stock	0.2178	0.2189	0.2165	0.2179	1844880.0
2003-06-12 09:00:00	NVDA	Stock	0.2179	0.2195	0.2145	0.2156	142950000.0
2003-06-12 10:00:00	NVDA	Stock	0.2156	0.2171	0.2121	0.2162	232580400.0
2003-06-12 11:00:00	NVDA	Stock	0.2162	0.2171	0.2136	0.2137	112648080.0
2003-06-12 12:00:00	NVDA	Stock	0.2137	0.2152	0.2133	0.214	111684120.0
2003-06-12 13:00:00	NVDA	Stock	0.2139	0.214	0.212	0.2127	92664840.0
2003-06-12 14:00:00	NVDA	Stock	0.2125	0.2133	0.2114	0.2124	122996160.0
2003-06-12 15:00:00	NVDA	Stock	0.2125	0.2133	0.2118	0.2121	165359880.0
2003-06-12 16:00:00	NVDA	Stock	0.2121	0.2129	0.2115	0.2117	7620000.0
2003-06-12 17:00:00	NVDA	Stock	0.2117	0.2121	0.2117	0.2121	168000.0
2003-06-12 18:00:00	NVDA	Stock	0.2117	0.2117	0.2116	0.2117	192000.0
2003-06-12 08:00:00	AMZN	Stock	1.746	1.76	1.7435	1.7525	340100.0
2003-06-12 09:00:00	AMZN	Stock	1.753	1.77	1.746	1.7475	28117480.0
2003-06-12 10:00:00	AMZN	Stock	1.746	1.7675	1.7355	1.753	31724200.0
2003-06-12 11:00:00	AMZN	Stock	1.755	1.7585	1.7455	1.7475	17816780.0
2003-06-12 12:00:00	AMZN	Stock	1.7483	1.7635	1.745	1.7615	14290560.0
2003-06-12 13:00:00	AMZN	Stock	1.7615	1.7615	1.75	1.753	7965820.0
2003-06-12 14:00:00	AMZN	Stock	1.7535	1.754	1.746	1.749	9739680.0
2003-06-12 15:00:00	AMZN	Stock	1.749	1.77	1.7485	1.76	19443040.0
2003-06-12 16:00:00	AMZN	Stock	1.7605	1.768	1.757	1.762	835880.0
2003-06-12 17:00:00	AMZN	Stock	1.766	1.766	1.76	1.765	166000.0
2003-06-12 18:00:00	AMZN	Stock	1.7635	1.7675	1.7625	1.7675	109000.0
2003-06-12 09:00:00	CL	Stock	29.55	29.575	29.45	29.525	198200.0
2003-06-12 10:00:00	CL	Stock	29.515	29.585	29.4	29.555	443800.0
2003-06-12 11:00:00	CL	Stock	29.545	29.685	29.525	29.65	371800.0
2003-06-12 12:00:00	CL	Stock	29.65	29.91	29.645	29.865	507000.0
2003-06-12 13:00:00	CL	Stock	29.88	29.915	29.805	29.83	356000.0
2003-06-12 14:00:00	CL	Stock	29.835	29.895	29.765	29.885	288400.0
2003-06-12 15:00:00	CL	Stock	29.89	29.905	29.835	29.885	613600.0

> showing 50 of 21,420 rows — these rows as CSV

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