PREVIEW / stock_1hour / 2000-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-10-20.parquet
  size:    305 KB
  rows:    15,668
  symbols: 1,241

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-20 08:00:00	AAPL	Stock	0.3438	0.3438	0.3371	0.3393	1332800.0
2000-10-20 09:00:00	AAPL	Stock	0.3415	0.3504	0.3326	0.3393	108824800.0
2000-10-20 10:00:00	AAPL	Stock	0.3404	0.3549	0.3393	0.3538	121928800.0
2000-10-20 11:00:00	AAPL	Stock	0.3527	0.3638	0.3516	0.3616	163928800.0
2000-10-20 12:00:00	AAPL	Stock	0.3616	0.3616	0.3527	0.356	76977600.0
2000-10-20 13:00:00	AAPL	Stock	0.356	0.3605	0.3538	0.3549	78036000.0
2000-10-20 14:00:00	AAPL	Stock	0.3549	0.356	0.3471	0.3482	108304000.0
2000-10-20 15:00:00	AAPL	Stock	0.3493	0.3504	0.3438	0.3482	84117600.0
2000-10-20 16:00:00	AAPL	Stock	0.3482	0.3527	0.346	0.3471	10192000.0
2000-10-20 17:00:00	AAPL	Stock	0.3482	0.3504	0.3482	0.3493	817600.0
2000-10-20 18:00:00	AAPL	Stock	0.3504	0.3504	0.3493	0.3504	162400.0
2000-10-20 08:00:00	MSFT	Stock	29.375	31.0	29.25	30.875	305206.0
2000-10-20 09:00:00	MSFT	Stock	30.8125	31.9844	30.375	31.5938	23419400.0
2000-10-20 10:00:00	MSFT	Stock	31.7188	32.5312	31.5312	32.4688	35344200.0
2000-10-20 11:00:00	MSFT	Stock	32.4375	33.0625	32.375	32.7188	27573200.0
2000-10-20 12:00:00	MSFT	Stock	32.75	32.8125	32.4688	32.7812	13318000.0
2000-10-20 13:00:00	MSFT	Stock	32.7812	32.9375	32.75	32.8125	8145000.0
2000-10-20 14:00:00	MSFT	Stock	32.7812	32.8438	32.375	32.7188	12466600.0
2000-10-20 15:00:00	MSFT	Stock	32.7188	32.75	32.4375	32.5938	23372400.0
2000-10-20 16:00:00	MSFT	Stock	32.625	32.7656	32.3594	32.4688	3376000.0
2000-10-20 17:00:00	MSFT	Stock	32.5	32.5938	32.375	32.5	146800.0
2000-10-20 18:00:00	MSFT	Stock	32.4688	32.9062	31.75	32.4688	5400.0
2000-10-20 08:00:00	NVDA	Stock	0.2677	0.2677	0.2667	0.2667	48000.0
2000-10-20 09:00:00	NVDA	Stock	0.2646	0.2646	0.2573	0.2576	41736000.0
2000-10-20 10:00:00	NVDA	Stock	0.2578	0.2667	0.2578	0.2659	43488000.0
2000-10-20 11:00:00	NVDA	Stock	0.2656	0.2846	0.2654	0.2833	72576000.0
2000-10-20 12:00:00	NVDA	Stock	0.2833	0.2885	0.2833	0.2875	64728000.0
2000-10-20 13:00:00	NVDA	Stock	0.2883	0.2969	0.2854	0.2901	40008000.0
2000-10-20 14:00:00	NVDA	Stock	0.2901	0.2935	0.2901	0.2927	44592000.0
2000-10-20 15:00:00	NVDA	Stock	0.2924	0.2932	0.288	0.2901	52704000.0
2000-10-20 16:00:00	NVDA	Stock	0.2914	0.2924	0.2901	0.2911	3912000.0
2000-10-20 17:00:00	NVDA	Stock	0.2924	0.2924	0.2924	0.2924	24000.0
2000-10-20 08:00:00	AMZN	Stock	1.4375	1.4375	1.3469	1.375	232000.0
2000-10-20 09:00:00	AMZN	Stock	1.375	1.4688	1.35	1.4031	36170000.0
2000-10-20 10:00:00	AMZN	Stock	1.4031	1.4406	1.3875	1.4156	27644000.0
2000-10-20 11:00:00	AMZN	Stock	1.4156	1.4219	1.3875	1.4094	13904000.0
2000-10-20 12:00:00	AMZN	Stock	1.4062	1.4438	1.4031	1.4375	14492000.0
2000-10-20 13:00:00	AMZN	Stock	1.4406	1.4938	1.4375	1.4813	25808000.0
2000-10-20 14:00:00	AMZN	Stock	1.4813	1.5094	1.4781	1.4875	34754000.0
2000-10-20 15:00:00	AMZN	Stock	1.4875	1.5625	1.4625	1.5406	63146000.0
2000-10-20 16:00:00	AMZN	Stock	1.5406	1.5563	1.4344	1.5563	2306000.0
2000-10-20 17:00:00	AMZN	Stock	1.5563	1.5625	1.5406	1.55	162000.0
2000-10-20 18:00:00	AMZN	Stock	1.5438	1.5563	1.5438	1.5563	40000.0
2000-10-20 09:00:00	CL	Stock	25.15	25.275	25.15	25.225	457600.0
2000-10-20 10:00:00	CL	Stock	25.225	25.325	25.075	25.08	506800.0
2000-10-20 11:00:00	CL	Stock	25.09	25.3	25.09	25.125	507200.0
2000-10-20 12:00:00	CL	Stock	25.105	25.315	25.105	25.305	194000.0
2000-10-20 13:00:00	CL	Stock	25.29	25.365	25.155	25.23	409000.0
2000-10-20 14:00:00	CL	Stock	25.23	25.415	25.125	25.415	519600.0
2000-10-20 15:00:00	CL	Stock	25.41	25.55	25.31	25.335	393800.0

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

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