PREVIEW / stock_1hour / 2000-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-20.parquet
  size:    292 KB
  rows:    15,235
  symbols: 1,178

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
2000-06-20 08:00:00	AAPL	Stock	0.863	0.8772	0.8627	0.8627	1008000.0
2000-06-20 09:00:00	AAPL	Stock	0.8672	0.9169	0.865	0.9057	96454400.0
2000-06-20 10:00:00	AAPL	Stock	0.9063	0.9152	0.9023	0.9113	61824000.0
2000-06-20 11:00:00	AAPL	Stock	0.9113	0.9129	0.8945	0.8956	84638400.0
2000-06-20 12:00:00	AAPL	Stock	0.8956	0.9096	0.8945	0.9063	41182400.0
2000-06-20 13:00:00	AAPL	Stock	0.9057	0.9141	0.9007	0.9079	24651200.0
2000-06-20 14:00:00	AAPL	Stock	0.9074	0.928	0.9063	0.9219	77862400.0
2000-06-20 15:00:00	AAPL	Stock	0.9213	0.9219	0.8973	0.9018	88502400.0
2000-06-20 16:00:00	AAPL	Stock	0.904	0.9104	0.8929	0.9102	13742400.0
2000-06-20 17:00:00	AAPL	Stock	0.9063	0.9102	0.9018	0.9018	33600.0
2000-06-20 18:00:00	AAPL	Stock	0.9102	0.9102	0.9102	0.9102	22400.0
2000-06-20 08:00:00	MSFT	Stock	36.75	36.875	36.6875	36.875	34000.0
2000-06-20 09:00:00	MSFT	Stock	36.8125	37.2188	36.8125	37.1562	8028000.0
2000-06-20 10:00:00	MSFT	Stock	37.1875	37.4375	37.0312	37.375	10026400.0
2000-06-20 11:00:00	MSFT	Stock	37.375	37.4062	37.0	37.0625	7162400.0
2000-06-20 12:00:00	MSFT	Stock	37.0625	37.25	37.0	37.1875	4277000.0
2000-06-20 13:00:00	MSFT	Stock	37.1875	37.4688	37.1562	37.4375	4671800.0
2000-06-20 14:00:00	MSFT	Stock	37.4375	37.5625	37.2188	37.3125	8450400.0
2000-06-20 15:00:00	MSFT	Stock	37.3125	37.625	37.2188	37.4375	16296400.0
2000-06-20 16:00:00	MSFT	Stock	37.4375	37.625	37.1875	37.25	2487000.0
2000-06-20 17:00:00	MSFT	Stock	37.25	37.4688	37.125	37.25	57400.0
2000-06-20 18:00:00	MSFT	Stock	37.125	37.125	37.0625	37.125	8800.0
2000-06-20 08:00:00	NVDA	Stock	0.3281	0.3315	0.3281	0.3312	528000.0
2000-06-20 09:00:00	NVDA	Stock	0.3333	0.3411	0.3229	0.3299	87456000.0
2000-06-20 10:00:00	NVDA	Stock	0.3271	0.3405	0.3271	0.3276	123888000.0
2000-06-20 11:00:00	NVDA	Stock	0.3273	0.3307	0.3247	0.3247	101280000.0
2000-06-20 12:00:00	NVDA	Stock	0.3234	0.3293	0.323	0.3285	79920000.0
2000-06-20 13:00:00	NVDA	Stock	0.329	0.3352	0.3271	0.3294	48768000.0
2000-06-20 14:00:00	NVDA	Stock	0.3293	0.3315	0.325	0.3289	62640000.0
2000-06-20 15:00:00	NVDA	Stock	0.3286	0.3307	0.325	0.3266	83520000.0
2000-06-20 16:00:00	NVDA	Stock	0.3266	0.3276	0.324	0.3271	11328000.0
2000-06-20 17:00:00	NVDA	Stock	0.3271	0.3271	0.3271	0.3271	192000.0
2000-06-20 08:00:00	AMZN	Stock	2.2688	2.2688	2.2688	2.2688	6000.0
2000-06-20 09:00:00	AMZN	Stock	2.2812	2.4	2.275	2.3969	15432000.0
2000-06-20 10:00:00	AMZN	Stock	2.3969	2.4313	2.3625	2.3906	23118000.0
2000-06-20 11:00:00	AMZN	Stock	2.3906	2.3906	2.2562	2.2812	26404000.0
2000-06-20 12:00:00	AMZN	Stock	2.2812	2.3375	2.2781	2.3031	8634000.0
2000-06-20 13:00:00	AMZN	Stock	2.3031	2.3438	2.3	2.3438	7096000.0
2000-06-20 14:00:00	AMZN	Stock	2.3438	2.3938	2.325	2.3438	24510000.0
2000-06-20 15:00:00	AMZN	Stock	2.3438	2.35	2.2875	2.3062	14348000.0
2000-06-20 16:00:00	AMZN	Stock	2.3062	2.3594	2.2812	2.3062	2100000.0
2000-06-20 17:00:00	AMZN	Stock	2.3062	2.3062	2.3062	2.3062	6000.0
2000-06-20 18:00:00	AMZN	Stock	2.3156	2.3156	2.3125	2.3125	4000.0
2000-06-20 09:00:00	CL	Stock	28.375	28.375	27.9375	28.0625	353200.0
2000-06-20 10:00:00	CL	Stock	28.0938	28.2812	28.0312	28.1875	608600.0
2000-06-20 11:00:00	CL	Stock	28.1875	28.375	28.1875	28.3125	309600.0
2000-06-20 12:00:00	CL	Stock	28.3125	28.4688	28.3125	28.4062	292400.0
2000-06-20 13:00:00	CL	Stock	28.375	28.8125	28.3438	28.7188	357200.0
2000-06-20 14:00:00	CL	Stock	28.75	28.9062	28.6875	28.75	360400.0
2000-06-20 15:00:00	CL	Stock	28.75	28.8125	28.5	28.7188	626400.0

> showing 50 of 15,235 rows — these rows as CSV

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