PREVIEW / stock_1hour / 2000-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-09.parquet
  size:    291 KB
  rows:    15,261
  symbols: 1,204

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-08-09 08:00:00	AAPL	Stock	0.8527	0.8655	0.8527	0.8616	11866400.0
2000-08-09 09:00:00	AAPL	Stock	0.8594	0.8616	0.8471	0.8493	81043200.0
2000-08-09 10:00:00	AAPL	Stock	0.8482	0.865	0.8482	0.8549	104501600.0
2000-08-09 11:00:00	AAPL	Stock	0.8549	0.8571	0.8504	0.8549	53659200.0
2000-08-09 12:00:00	AAPL	Stock	0.8544	0.8594	0.8538	0.8571	28436800.0
2000-08-09 13:00:00	AAPL	Stock	0.8583	0.8594	0.8516	0.8516	15646400.0
2000-08-09 14:00:00	AAPL	Stock	0.8516	0.8571	0.8493	0.8549	31522400.0
2000-08-09 15:00:00	AAPL	Stock	0.8549	0.8594	0.8438	0.8482	38796800.0
2000-08-09 16:00:00	AAPL	Stock	0.8482	0.8661	0.8449	0.8493	13014400.0
2000-08-09 17:00:00	AAPL	Stock	0.8449	0.8571	0.8449	0.8571	16800.0
2000-08-09 08:00:00	MSFT	Stock	37.0469	37.3125	36.8125	36.875	254200.0
2000-08-09 09:00:00	MSFT	Stock	36.8438	37.1406	36.5625	36.875	11637400.0
2000-08-09 10:00:00	MSFT	Stock	36.9062	37.4375	36.8594	37.0938	15001600.0
2000-08-09 11:00:00	MSFT	Stock	37.0938	37.2812	36.9062	37.25	8462600.0
2000-08-09 12:00:00	MSFT	Stock	37.25	37.375	37.0	37.3125	4851800.0
2000-08-09 13:00:00	MSFT	Stock	37.3125	37.375	37.0312	37.0312	6632000.0
2000-08-09 14:00:00	MSFT	Stock	37.0625	37.2188	36.8438	37.1406	5937800.0
2000-08-09 15:00:00	MSFT	Stock	37.125	37.25	36.9375	37.1562	8577000.0
2000-08-09 16:00:00	MSFT	Stock	37.1562	37.25	36.9688	37.125	1449800.0
2000-08-09 17:00:00	MSFT	Stock	37.1875	37.25	37.0	37.0	6000.0
2000-08-09 18:00:00	MSFT	Stock	37.0	37.0	36.9688	36.9688	1200.0
2000-08-09 08:00:00	NVDA	Stock	0.2854	0.2854	0.2854	0.2854	72000.0
2000-08-09 09:00:00	NVDA	Stock	0.2846	0.2857	0.2763	0.2822	24600000.0
2000-08-09 10:00:00	NVDA	Stock	0.2822	0.2828	0.2732	0.2802	26832000.0
2000-08-09 11:00:00	NVDA	Stock	0.2797	0.281	0.268	0.2703	30792000.0
2000-08-09 12:00:00	NVDA	Stock	0.2703	0.275	0.2693	0.2737	9624000.0
2000-08-09 13:00:00	NVDA	Stock	0.2734	0.2749	0.2703	0.2711	8232000.0
2000-08-09 14:00:00	NVDA	Stock	0.2724	0.281	0.2724	0.2789	11184000.0
2000-08-09 15:00:00	NVDA	Stock	0.2792	0.2802	0.2708	0.2721	20592000.0
2000-08-09 16:00:00	NVDA	Stock	0.2721	0.275	0.2717	0.275	2616000.0
2000-08-09 08:00:00	AMZN	Stock	1.6	1.6625	1.6	1.6562	518000.0
2000-08-09 09:00:00	AMZN	Stock	1.675	1.7125	1.5188	1.5375	39172000.0
2000-08-09 10:00:00	AMZN	Stock	1.5375	1.55	1.525	1.5406	29390000.0
2000-08-09 11:00:00	AMZN	Stock	1.5406	1.5594	1.5375	1.5438	23474000.0
2000-08-09 12:00:00	AMZN	Stock	1.5469	1.5719	1.5438	1.5625	12776000.0
2000-08-09 13:00:00	AMZN	Stock	1.5609	1.5844	1.5531	1.5563	16630000.0
2000-08-09 14:00:00	AMZN	Stock	1.5594	1.5844	1.5563	1.5734	16486000.0
2000-08-09 15:00:00	AMZN	Stock	1.5719	1.5781	1.5375	1.5438	35322000.0
2000-08-09 16:00:00	AMZN	Stock	1.5438	1.55	1.5375	1.5406	2578000.0
2000-08-09 17:00:00	AMZN	Stock	1.5438	1.55	1.5375	1.5469	68000.0
2000-08-09 18:00:00	AMZN	Stock	1.5469	1.5469	1.5438	1.5438	20000.0
2000-08-09 09:00:00	CL	Stock	26.4375	26.4375	25.7812	25.9062	460800.0
2000-08-09 10:00:00	CL	Stock	25.9062	26.1562	25.8438	26.0625	544600.0
2000-08-09 11:00:00	CL	Stock	26.0625	26.8125	26.0	26.75	504200.0
2000-08-09 12:00:00	CL	Stock	26.7188	26.75	26.4062	26.5312	224800.0
2000-08-09 13:00:00	CL	Stock	26.5	26.75	26.4062	26.6562	296600.0
2000-08-09 14:00:00	CL	Stock	26.6562	26.7188	26.5	26.5625	228400.0
2000-08-09 15:00:00	CL	Stock	26.4688	26.5312	26.375	26.4688	268400.0
2000-08-09 16:00:00	CL	Stock	26.5	26.5	26.0625	26.375	176200.0
2000-08-09 17:00:00	CL	Stock	26.4688	26.4688	26.4688	26.4688	10000.0

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

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