PREVIEW / stock_1hour / 2003-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-06-09.parquet
  size:    442 KB
  rows:    21,465
  symbols: 1,585

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-09 08:00:00	AAPL	Stock	0.3059	0.3061	0.3036	0.3036	274400.0
2003-06-09 09:00:00	AAPL	Stock	0.3036	0.3043	0.2973	0.3009	49515088.0
2003-06-09 10:00:00	AAPL	Stock	0.3005	0.3021	0.297	0.2973	41182176.0
2003-06-09 11:00:00	AAPL	Stock	0.2977	0.3	0.297	0.2996	38965808.0
2003-06-09 12:00:00	AAPL	Stock	0.2996	0.3016	0.2991	0.3005	20222496.0
2003-06-09 13:00:00	AAPL	Stock	0.3005	0.3034	0.2991	0.3029	17519320.0
2003-06-09 14:00:00	AAPL	Stock	0.3029	0.3036	0.2982	0.2988	19135816.0
2003-06-09 15:00:00	AAPL	Stock	0.2988	0.3011	0.298	0.2998	36876392.0
2003-06-09 16:00:00	AAPL	Stock	0.3	0.3009	0.2988	0.3	442400.0
2003-06-09 17:00:00	AAPL	Stock	0.3	0.3	0.3	0.3	39200.0
2003-06-09 08:00:00	MSFT	Stock	23.76	23.86	23.68	23.76	133741.0
2003-06-09 09:00:00	MSFT	Stock	23.779	23.982	23.7	23.9	12522197.0
2003-06-09 10:00:00	MSFT	Stock	23.9	23.964	23.69	23.82	14131349.0
2003-06-09 11:00:00	MSFT	Stock	23.814	23.89	23.75	23.84	8269968.0
2003-06-09 12:00:00	MSFT	Stock	23.84	23.89	23.75	23.79	6612342.0
2003-06-09 13:00:00	MSFT	Stock	23.79	23.85	23.75	23.78	7433145.0
2003-06-09 14:00:00	MSFT	Stock	23.79	23.82	23.6	23.65	8693140.0
2003-06-09 15:00:00	MSFT	Stock	23.66	23.76	23.5999	23.71	10010364.0
2003-06-09 16:00:00	MSFT	Stock	23.715	23.86	23.69	23.82	812467.0
2003-06-09 17:00:00	MSFT	Stock	23.81	23.86	23.757	23.78	26995.0
2003-06-09 18:00:00	MSFT	Stock	23.781	23.781	23.78	23.78	2256.0
2003-06-09 08:00:00	NVDA	Stock	0.2144	0.2144	0.2117	0.2125	648000.0
2003-06-09 09:00:00	NVDA	Stock	0.2125	0.2188	0.2117	0.2168	144872400.0
2003-06-09 10:00:00	NVDA	Stock	0.2168	0.2177	0.2088	0.2122	174273240.0
2003-06-09 11:00:00	NVDA	Stock	0.2122	0.2144	0.2115	0.213	83240880.0
2003-06-09 12:00:00	NVDA	Stock	0.2129	0.214	0.2111	0.2119	52254840.0
2003-06-09 13:00:00	NVDA	Stock	0.212	0.2136	0.2108	0.213	64567800.0
2003-06-09 14:00:00	NVDA	Stock	0.2131	0.2135	0.2105	0.2112	58861680.0
2003-06-09 15:00:00	NVDA	Stock	0.2112	0.2122	0.2097	0.2121	91865280.0
2003-06-09 16:00:00	NVDA	Stock	0.2121	0.2129	0.2115	0.2122	8009400.0
2003-06-09 17:00:00	NVDA	Stock	0.2122	0.2128	0.2122	0.2125	809880.0
2003-06-09 18:00:00	NVDA	Stock	0.2133	0.2133	0.2133	0.2133	36000.0
2003-06-09 08:00:00	AMZN	Stock	1.6865	1.6865	1.6675	1.6675	44000.0
2003-06-09 09:00:00	AMZN	Stock	1.663	1.7235	1.654	1.6935	28396580.0
2003-06-09 10:00:00	AMZN	Stock	1.6935	1.699	1.666	1.6825	33606800.0
2003-06-09 11:00:00	AMZN	Stock	1.683	1.695	1.68	1.6825	15215120.0
2003-06-09 12:00:00	AMZN	Stock	1.684	1.6925	1.679	1.683	9135960.0
2003-06-09 13:00:00	AMZN	Stock	1.6815	1.69	1.675	1.6775	10685120.0
2003-06-09 14:00:00	AMZN	Stock	1.678	1.7015	1.675	1.693	23829700.0
2003-06-09 15:00:00	AMZN	Stock	1.694	1.7	1.676	1.685	31516880.0
2003-06-09 16:00:00	AMZN	Stock	1.6855	1.69	1.6825	1.69	1865380.0
2003-06-09 17:00:00	AMZN	Stock	1.6865	1.6865	1.683	1.6865	1475480.0
2003-06-09 18:00:00	AMZN	Stock	1.683	1.683	1.6825	1.6825	18000.0
2003-06-09 09:00:00	CL	Stock	29.3	29.445	29.3	29.445	305400.0
2003-06-09 10:00:00	CL	Stock	29.445	29.6	29.415	29.6	575400.0
2003-06-09 11:00:00	CL	Stock	29.6	29.665	29.57	29.63	266600.0
2003-06-09 12:00:00	CL	Stock	29.635	29.68	29.52	29.54	281000.0
2003-06-09 13:00:00	CL	Stock	29.53	29.645	29.47	29.59	395000.0
2003-06-09 14:00:00	CL	Stock	29.59	29.62	29.215	29.215	521000.0
2003-06-09 15:00:00	CL	Stock	29.235	29.455	29.235	29.38	529400.0

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

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