PREVIEW / stock_1hour / 2001-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-24.parquet
  size:    314 KB
  rows:    16,014
  symbols: 1,268

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-24 08:00:00	AAPL	Stock	0.3761	0.3828	0.375	0.375	2419200.0
2001-01-24 09:00:00	AAPL	Stock	0.375	0.375	0.3616	0.3661	126162400.0
2001-01-24 10:00:00	AAPL	Stock	0.365	0.3661	0.3594	0.365	88692800.0
2001-01-24 11:00:00	AAPL	Stock	0.365	0.3672	0.3549	0.356	105364000.0
2001-01-24 12:00:00	AAPL	Stock	0.356	0.3594	0.3527	0.3549	64489600.0
2001-01-24 13:00:00	AAPL	Stock	0.3538	0.356	0.3493	0.3527	57993600.0
2001-01-24 14:00:00	AAPL	Stock	0.3527	0.3594	0.3516	0.3549	36741600.0
2001-01-24 15:00:00	AAPL	Stock	0.356	0.3672	0.3549	0.3672	120551200.0
2001-01-24 16:00:00	AAPL	Stock	0.3661	0.3705	0.3588	0.3638	7806400.0
2001-01-24 17:00:00	AAPL	Stock	0.3638	0.3661	0.3627	0.365	72800.0
2001-01-24 18:00:00	AAPL	Stock	0.365	0.365	0.3627	0.3627	22400.0
2001-01-24 08:00:00	MSFT	Stock	30.8125	30.9688	30.5	30.625	148400.0
2001-01-24 09:00:00	MSFT	Stock	30.625	30.9688	30.4375	30.9375	11468400.0
2001-01-24 10:00:00	MSFT	Stock	30.9375	31.4375	30.8438	31.2812	20671400.0
2001-01-24 11:00:00	MSFT	Stock	31.2812	31.6562	31.25	31.5	15513200.0
2001-01-24 12:00:00	MSFT	Stock	31.5	31.5312	31.125	31.4375	11380800.0
2001-01-24 13:00:00	MSFT	Stock	31.4688	31.4688	31.0938	31.2812	9771000.0
2001-01-24 14:00:00	MSFT	Stock	31.2812	31.5312	31.25	31.5	7103400.0
2001-01-24 15:00:00	MSFT	Stock	31.5	31.7188	31.2812	31.4062	16708600.0
2001-01-24 16:00:00	MSFT	Stock	31.4688	31.5156	31.1094	31.3438	6289400.0
2001-01-24 17:00:00	MSFT	Stock	31.3438	31.4062	31.0625	31.375	20000.0
2001-01-24 18:00:00	MSFT	Stock	31.375	31.4062	31.375	31.4062	1800.0
2001-01-24 08:00:00	NVDA	Stock	0.2292	0.2292	0.2286	0.2286	120000.0
2001-01-24 09:00:00	NVDA	Stock	0.2284	0.2313	0.2214	0.225	44256000.0
2001-01-24 10:00:00	NVDA	Stock	0.2253	0.2258	0.2148	0.2177	51552000.0
2001-01-24 11:00:00	NVDA	Stock	0.2177	0.2247	0.2167	0.2219	65400000.0
2001-01-24 12:00:00	NVDA	Stock	0.2214	0.2289	0.2188	0.225	63576000.0
2001-01-24 13:00:00	NVDA	Stock	0.2255	0.2263	0.2208	0.224	37056000.0
2001-01-24 14:00:00	NVDA	Stock	0.224	0.2247	0.2198	0.2229	41400000.0
2001-01-24 15:00:00	NVDA	Stock	0.2221	0.231	0.2219	0.2276	79080000.0
2001-01-24 16:00:00	NVDA	Stock	0.2279	0.2286	0.2271	0.2271	7320000.0
2001-01-24 08:00:00	AMZN	Stock	0.9562	0.9562	0.95	0.95	96000.0
2001-01-24 09:00:00	AMZN	Stock	0.95	0.9875	0.95	0.9844	24124000.0
2001-01-24 10:00:00	AMZN	Stock	0.9828	1.0219	0.9812	1.0125	34392000.0
2001-01-24 11:00:00	AMZN	Stock	1.0125	1.1188	1.0094	1.1125	64200000.0
2001-01-24 12:00:00	AMZN	Stock	1.1156	1.1188	1.0375	1.0438	40018000.0
2001-01-24 13:00:00	AMZN	Stock	1.0438	1.0656	1.0188	1.0375	20538000.0
2001-01-24 14:00:00	AMZN	Stock	1.0406	1.0812	1.0219	1.0656	25224000.0
2001-01-24 15:00:00	AMZN	Stock	1.0688	1.0969	1.0625	1.0906	31770000.0
2001-01-24 16:00:00	AMZN	Stock	1.0906	1.0953	0.9625	1.075	2956000.0
2001-01-24 17:00:00	AMZN	Stock	1.075	1.0812	1.0719	1.075	78000.0
2001-01-24 18:00:00	AMZN	Stock	1.075	1.075	1.075	1.075	36000.0
2001-01-24 09:00:00	CL	Stock	28.66	28.66	28.25	28.255	330200.0
2001-01-24 10:00:00	CL	Stock	28.255	28.325	28.02	28.075	400400.0
2001-01-24 11:00:00	CL	Stock	28.125	28.6	28.125	28.575	286000.0
2001-01-24 12:00:00	CL	Stock	28.575	28.865	28.575	28.85	257000.0
2001-01-24 13:00:00	CL	Stock	28.85	29.245	28.85	29.18	554600.0
2001-01-24 14:00:00	CL	Stock	29.16	29.2	29.105	29.18	264400.0
2001-01-24 15:00:00	CL	Stock	29.16	29.2	28.975	29.03	591600.0
2001-01-24 16:00:00	CL	Stock	29.05	29.05	29.05	29.05	77600.0

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

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