PREVIEW / stock_1hour / 2000-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-10-17.parquet
  size:    300 KB
  rows:    15,602
  symbols: 1,239

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-10-17 08:00:00	AAPL	Stock	0.3929	0.3929	0.3895	0.3895	44800.0
2000-10-17 09:00:00	AAPL	Stock	0.385	0.3917	0.3638	0.3683	128352000.0
2000-10-17 10:00:00	AAPL	Stock	0.3683	0.3705	0.3594	0.3666	60054400.0
2000-10-17 11:00:00	AAPL	Stock	0.3672	0.3694	0.3583	0.3583	65744000.0
2000-10-17 12:00:00	AAPL	Stock	0.3594	0.3627	0.3549	0.3594	80852800.0
2000-10-17 13:00:00	AAPL	Stock	0.3605	0.3627	0.3527	0.3527	83658400.0
2000-10-17 14:00:00	AAPL	Stock	0.3571	0.3583	0.3516	0.3549	51038400.0
2000-10-17 15:00:00	AAPL	Stock	0.3549	0.3616	0.3538	0.3605	85960000.0
2000-10-17 16:00:00	AAPL	Stock	0.3594	0.3616	0.3571	0.3594	10309600.0
2000-10-17 17:00:00	AAPL	Stock	0.3571	0.3594	0.3538	0.356	1948800.0
2000-10-17 18:00:00	AAPL	Stock	0.3538	0.3594	0.3538	0.3571	106400.0
2000-10-17 08:00:00	MSFT	Stock	25.75	26.0938	25.2031	25.75	923400.0
2000-10-17 09:00:00	MSFT	Stock	25.7812	26.2188	25.5938	25.875	16000000.0
2000-10-17 10:00:00	MSFT	Stock	25.9062	26.2031	25.6875	25.9688	12828400.0
2000-10-17 11:00:00	MSFT	Stock	26.0	26.0	25.3125	25.5	13012600.0
2000-10-17 12:00:00	MSFT	Stock	25.5	25.7812	25.4062	25.4688	6151600.0
2000-10-17 13:00:00	MSFT	Stock	25.4688	25.8125	25.25	25.3125	5154400.0
2000-10-17 14:00:00	MSFT	Stock	25.3125	25.5312	25.1875	25.4375	8055400.0
2000-10-17 15:00:00	MSFT	Stock	25.4375	25.5938	25.125	25.2188	11788200.0
2000-10-17 16:00:00	MSFT	Stock	25.2188	25.6875	25.0312	25.3125	2086800.0
2000-10-17 17:00:00	MSFT	Stock	25.25	25.6562	25.0625	25.2188	114800.0
2000-10-17 18:00:00	MSFT	Stock	25.2188	25.2188	25.0	25.125	16800.0
2000-10-17 09:00:00	NVDA	Stock	0.2646	0.2646	0.2594	0.2612	26040000.0
2000-10-17 10:00:00	NVDA	Stock	0.2612	0.2612	0.2516	0.2542	46800000.0
2000-10-17 11:00:00	NVDA	Stock	0.2547	0.2547	0.243	0.2505	63216000.0
2000-10-17 12:00:00	NVDA	Stock	0.251	0.2529	0.2495	0.2513	53568000.0
2000-10-17 13:00:00	NVDA	Stock	0.251	0.2513	0.2448	0.2471	50784000.0
2000-10-17 14:00:00	NVDA	Stock	0.2469	0.251	0.2448	0.2448	75720000.0
2000-10-17 15:00:00	NVDA	Stock	0.2451	0.2496	0.2451	0.2458	100896000.0
2000-10-17 16:00:00	NVDA	Stock	0.2461	0.2479	0.2458	0.2469	19896000.0
2000-10-17 17:00:00	NVDA	Stock	0.2479	0.2479	0.2458	0.2458	168000.0
2000-10-17 08:00:00	AMZN	Stock	1.25	1.25	1.2375	1.2375	48000.0
2000-10-17 09:00:00	AMZN	Stock	1.2313	1.2594	1.1906	1.1922	18224000.0
2000-10-17 10:00:00	AMZN	Stock	1.1906	1.1938	1.0844	1.1156	47040000.0
2000-10-17 11:00:00	AMZN	Stock	1.1156	1.1219	1.0438	1.0563	55958000.0
2000-10-17 12:00:00	AMZN	Stock	1.0531	1.075	1.0438	1.0563	42342000.0
2000-10-17 13:00:00	AMZN	Stock	1.0594	1.0844	1.0547	1.0719	38584000.0
2000-10-17 14:00:00	AMZN	Stock	1.0719	1.0719	1.0563	1.0656	32242000.0
2000-10-17 15:00:00	AMZN	Stock	1.0656	1.1062	1.0656	1.0938	43922000.0
2000-10-17 16:00:00	AMZN	Stock	1.0938	1.1	1.0703	1.0875	2064000.0
2000-10-17 17:00:00	AMZN	Stock	1.0875	1.0875	1.0563	1.075	132000.0
2000-10-17 18:00:00	AMZN	Stock	1.075	1.075	1.075	1.075	4000.0
2000-10-17 09:00:00	CL	Stock	25.525	25.725	25.525	25.575	175000.0
2000-10-17 10:00:00	CL	Stock	25.575	25.63	25.53	25.62	296000.0
2000-10-17 11:00:00	CL	Stock	25.625	25.67	25.535	25.625	322000.0
2000-10-17 12:00:00	CL	Stock	25.62	25.625	25.55	25.565	165600.0
2000-10-17 13:00:00	CL	Stock	25.56	25.625	25.45	25.45	343400.0
2000-10-17 14:00:00	CL	Stock	25.5	25.55	25.375	25.5	323200.0
2000-10-17 15:00:00	CL	Stock	25.51	25.57	25.425	25.46	1581800.0
2000-10-17 16:00:00	CL	Stock	25.45	25.515	25.45	25.515	87400.0

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

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