PREVIEW / stock_1hour / 2002-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-19.parquet
  size:    419 KB
  rows:    19,807
  symbols: 1,437

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
2002-06-19 08:00:00	AAPL	Stock	0.3107	0.315	0.3041	0.3125	20613600.0
2002-06-19 09:00:00	AAPL	Stock	0.3125	0.3125	0.3054	0.3079	359279200.0
2002-06-19 10:00:00	AAPL	Stock	0.308	0.3104	0.3054	0.3089	441868000.0
2002-06-19 11:00:00	AAPL	Stock	0.3096	0.3143	0.3086	0.3134	207082400.0
2002-06-19 12:00:00	AAPL	Stock	0.3134	0.3139	0.3102	0.3114	97977600.0
2002-06-19 13:00:00	AAPL	Stock	0.3116	0.3116	0.3098	0.3109	52113600.0
2002-06-19 14:00:00	AAPL	Stock	0.3111	0.3129	0.3068	0.3082	151603200.0
2002-06-19 15:00:00	AAPL	Stock	0.308	0.3091	0.3014	0.3055	264628000.0
2002-06-19 16:00:00	AAPL	Stock	0.3057	0.3102	0.3045	0.3048	29136800.0
2002-06-19 17:00:00	AAPL	Stock	0.3057	0.307	0.3052	0.3059	4043200.0
2002-06-19 18:00:00	AAPL	Stock	0.3055	0.3055	0.3055	0.3055	22400.0
2002-06-19 08:00:00	MSFT	Stock	27.725	27.725	27.525	27.625	171600.0
2002-06-19 09:00:00	MSFT	Stock	27.625	27.971	27.55	27.655	11577000.0
2002-06-19 10:00:00	MSFT	Stock	27.645	27.74	27.455	27.625	13056600.0
2002-06-19 11:00:00	MSFT	Stock	27.625	27.84	27.585	27.735	9908400.0
2002-06-19 12:00:00	MSFT	Stock	27.735	27.75	27.59	27.68	8137800.0
2002-06-19 13:00:00	MSFT	Stock	27.68	27.7005	27.535	27.58	6257000.0
2002-06-19 14:00:00	MSFT	Stock	27.57	27.615	27.3045	27.36	11178600.0
2002-06-19 15:00:00	MSFT	Stock	27.36	27.435	27.16	27.175	12592600.0
2002-06-19 16:00:00	MSFT	Stock	27.175	27.574	27.155	27.185	5577400.0
2002-06-19 17:00:00	MSFT	Stock	27.185	27.195	27.16	27.18	1079200.0
2002-06-19 18:00:00	MSFT	Stock	27.2	27.22	27.18	27.22	103400.0
2002-06-19 08:00:00	NVDA	Stock	0.2275	0.2354	0.225	0.2254	2712000.0
2002-06-19 09:00:00	NVDA	Stock	0.2258	0.2725	0.218	0.2212	378816000.0
2002-06-19 10:00:00	NVDA	Stock	0.221	0.221	0.2158	0.2198	373812000.0
2002-06-19 11:00:00	NVDA	Stock	0.2198	0.2229	0.2195	0.2196	189756000.0
2002-06-19 12:00:00	NVDA	Stock	0.2196	0.2206	0.2123	0.2138	292032000.0
2002-06-19 13:00:00	NVDA	Stock	0.2138	0.2156	0.2108	0.2113	214404000.0
2002-06-19 14:00:00	NVDA	Stock	0.2113	0.2116	0.2045	0.2076	328176000.0
2002-06-19 15:00:00	NVDA	Stock	0.2076	0.2077	0.197	0.1979	733392000.0
2002-06-19 16:00:00	NVDA	Stock	0.1979	0.2121	0.1962	0.1974	36732000.0
2002-06-19 17:00:00	NVDA	Stock	0.1974	0.1987	0.1974	0.198	2568000.0
2002-06-19 18:00:00	NVDA	Stock	0.1983	0.1991	0.1979	0.198	1032000.0
2002-06-19 08:00:00	AMZN	Stock	0.933	0.9392	0.9171	0.92	152000.0
2002-06-19 09:00:00	AMZN	Stock	0.9235	0.938	0.918	0.9215	24180000.0
2002-06-19 10:00:00	AMZN	Stock	0.921	0.9475	0.9155	0.9455	26418000.0
2002-06-19 11:00:00	AMZN	Stock	0.9455	0.955	0.942	0.944	17092000.0
2002-06-19 12:00:00	AMZN	Stock	0.945	0.9475	0.9335	0.9364	12986000.0
2002-06-19 13:00:00	AMZN	Stock	0.9364	0.9495	0.934	0.94	10820000.0
2002-06-19 14:00:00	AMZN	Stock	0.94	0.9425	0.9305	0.9365	17494000.0
2002-06-19 15:00:00	AMZN	Stock	0.936	0.942	0.9135	0.9145	21290000.0
2002-06-19 16:00:00	AMZN	Stock	0.915	0.921	0.9135	0.916	14382000.0
2002-06-19 17:00:00	AMZN	Stock	0.915	0.915	0.915	0.915	838000.0
2002-06-19 18:00:00	AMZN	Stock	0.9245	0.925	0.9245	0.925	30000.0
2002-06-19 09:00:00	CL	Stock	26.3	26.57	26.26	26.53	438000.0
2002-06-19 10:00:00	CL	Stock	26.525	26.525	26.26	26.315	466200.0
2002-06-19 11:00:00	CL	Stock	26.3	26.475	26.285	26.425	402800.0
2002-06-19 12:00:00	CL	Stock	26.41	26.435	26.22	26.22	531200.0
2002-06-19 13:00:00	CL	Stock	26.22	26.34	26.19	26.225	353400.0
2002-06-19 14:00:00	CL	Stock	26.23	26.3	26.2	26.245	530400.0

> showing 50 of 19,807 rows — these rows as CSV

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