PREVIEW / stock_1hour / 2001-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-22.parquet
  size:    317 KB
  rows:    16,245
  symbols: 1,264

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
2001-01-22 08:00:00	AAPL	Stock	0.3304	0.3449	0.327	0.3326	1215200.0
2001-01-22 09:00:00	AAPL	Stock	0.3337	0.3504	0.3292	0.3415	97462400.0
2001-01-22 10:00:00	AAPL	Stock	0.3415	0.3482	0.3359	0.3393	101533600.0
2001-01-22 11:00:00	AAPL	Stock	0.3393	0.3393	0.3359	0.3371	44441600.0
2001-01-22 12:00:00	AAPL	Stock	0.3371	0.3393	0.3304	0.3337	56784000.0
2001-01-22 13:00:00	AAPL	Stock	0.3326	0.3359	0.3315	0.3326	33342400.0
2001-01-22 14:00:00	AAPL	Stock	0.3326	0.3348	0.3315	0.3348	25082400.0
2001-01-22 15:00:00	AAPL	Stock	0.3348	0.3438	0.3348	0.3432	80976000.0
2001-01-22 16:00:00	AAPL	Stock	0.3426	0.3449	0.332	0.3438	3466400.0
2001-01-22 17:00:00	AAPL	Stock	0.3438	0.3438	0.3404	0.3415	156800.0
2001-01-22 18:00:00	AAPL	Stock	0.3404	0.3404	0.3404	0.3404	16800.0
2001-01-22 08:00:00	MSFT	Stock	29.9062	30.5156	29.75	30.25	437200.0
2001-01-22 09:00:00	MSFT	Stock	30.25	30.5	29.8438	30.1875	13328200.0
2001-01-22 10:00:00	MSFT	Stock	30.1875	30.3125	29.8125	30.0625	16002600.0
2001-01-22 11:00:00	MSFT	Stock	30.0625	30.2188	29.8438	29.8438	8967000.0
2001-01-22 12:00:00	MSFT	Stock	29.875	30.0	29.7969	29.9375	6174400.0
2001-01-22 13:00:00	MSFT	Stock	29.9062	30.0	29.5625	29.625	5520200.0
2001-01-22 14:00:00	MSFT	Stock	29.5938	29.875	29.5	29.7812	5911600.0
2001-01-22 15:00:00	MSFT	Stock	29.7812	30.0938	29.6562	30.0625	9853000.0
2001-01-22 16:00:00	MSFT	Stock	30.0625	30.4062	29.75	30.125	2448400.0
2001-01-22 17:00:00	MSFT	Stock	30.0938	30.0938	30.0	30.0156	38200.0
2001-01-22 18:00:00	MSFT	Stock	30.0625	30.0625	30.0	30.0	600.0
2001-01-22 08:00:00	NVDA	Stock	0.2128	0.2128	0.2128	0.2128	24000.0
2001-01-22 09:00:00	NVDA	Stock	0.2135	0.2161	0.2086	0.2133	53496000.0
2001-01-22 10:00:00	NVDA	Stock	0.2128	0.2188	0.2091	0.2159	37008000.0
2001-01-22 11:00:00	NVDA	Stock	0.2156	0.2167	0.2039	0.2068	67224000.0
2001-01-22 12:00:00	NVDA	Stock	0.207	0.2083	0.2023	0.2049	55176000.0
2001-01-22 13:00:00	NVDA	Stock	0.2047	0.2078	0.2042	0.2063	27144000.0
2001-01-22 14:00:00	NVDA	Stock	0.2063	0.2073	0.2052	0.2068	19152000.0
2001-01-22 15:00:00	NVDA	Stock	0.2068	0.2102	0.2039	0.2083	65664000.0
2001-01-22 16:00:00	NVDA	Stock	0.2083	0.2104	0.204	0.204	4632000.0
2001-01-22 08:00:00	AMZN	Stock	1.0031	1.0031	0.9531	0.9594	178000.0
2001-01-22 09:00:00	AMZN	Stock	0.975	0.9875	0.9625	0.9688	8804000.0
2001-01-22 10:00:00	AMZN	Stock	0.9719	0.9875	0.9688	0.9781	12306000.0
2001-01-22 11:00:00	AMZN	Stock	0.9781	0.9969	0.975	0.9875	12400000.0
2001-01-22 12:00:00	AMZN	Stock	0.9875	0.9906	0.975	0.9844	5518000.0
2001-01-22 13:00:00	AMZN	Stock	0.9844	0.9844	0.9344	0.9469	10098000.0
2001-01-22 14:00:00	AMZN	Stock	0.95	0.9531	0.9281	0.95	8212000.0
2001-01-22 15:00:00	AMZN	Stock	0.9516	0.9562	0.925	0.9281	15706000.0
2001-01-22 16:00:00	AMZN	Stock	0.9281	0.9375	0.925	0.925	6084000.0
2001-01-22 17:00:00	AMZN	Stock	0.9297	0.9375	0.9281	0.9375	28000.0
2001-01-22 09:00:00	CL	Stock	28.33	28.625	28.2	28.625	266400.0
2001-01-22 10:00:00	CL	Stock	28.62	28.65	28.54	28.565	308000.0
2001-01-22 11:00:00	CL	Stock	28.575	28.6	28.48	28.55	394200.0
2001-01-22 12:00:00	CL	Stock	28.525	28.55	28.325	28.35	347000.0
2001-01-22 13:00:00	CL	Stock	28.35	28.35	28.0	28.07	340800.0
2001-01-22 14:00:00	CL	Stock	28.065	28.125	27.925	28.09	285400.0
2001-01-22 15:00:00	CL	Stock	28.09	28.49	28.065	28.42	551600.0
2001-01-22 16:00:00	CL	Stock	28.39	28.39	28.39	28.39	160800.0
2001-01-22 17:00:00	CL	Stock	28.39	28.39	28.39	28.39	17000.0

> showing 50 of 16,245 rows — these rows as CSV

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