PREVIEW / stock_1hour / 2000-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-10.parquet
  size:    295 KB
  rows:    15,235
  symbols: 1,195

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-07-10 08:00:00	AAPL	Stock	0.9821	0.9821	0.971	0.971	22400.0
2000-07-10 09:00:00	AAPL	Stock	0.9732	0.9989	0.9598	0.9967	50159200.0
2000-07-10 10:00:00	AAPL	Stock	0.9972	1.0257	0.9955	1.0167	101169600.0
2000-07-10 11:00:00	AAPL	Stock	1.0145	1.0156	1.0022	1.0134	28330400.0
2000-07-10 12:00:00	AAPL	Stock	1.0145	1.0257	1.0078	1.0223	40152000.0
2000-07-10 13:00:00	AAPL	Stock	1.0223	1.0402	1.0223	1.0379	77056000.0
2000-07-10 14:00:00	AAPL	Stock	1.0379	1.0402	1.01	1.0251	38656800.0
2000-07-10 15:00:00	AAPL	Stock	1.0268	1.0301	1.0112	1.019	44335200.0
2000-07-10 16:00:00	AAPL	Stock	1.019	1.0268	1.0112	1.0134	6333600.0
2000-07-10 17:00:00	AAPL	Stock	1.0134	1.0201	1.0134	1.0201	22400.0
2000-07-10 08:00:00	MSFT	Stock	41.0	41.0156	40.125	40.6875	46800.0
2000-07-10 09:00:00	MSFT	Stock	40.625	40.8438	40.0938	40.1875	9022600.0
2000-07-10 10:00:00	MSFT	Stock	40.2188	40.5312	40.0	40.0625	8181400.0
2000-07-10 11:00:00	MSFT	Stock	40.0625	40.25	39.8438	40.125	7518600.0
2000-07-10 12:00:00	MSFT	Stock	40.1562	40.1875	39.9062	39.9062	4481400.0
2000-07-10 13:00:00	MSFT	Stock	39.9375	40.25	39.9062	40.25	5735600.0
2000-07-10 14:00:00	MSFT	Stock	40.2188	40.3125	39.9688	40.0	4981000.0
2000-07-10 15:00:00	MSFT	Stock	40.0	40.1562	39.6875	39.75	9465600.0
2000-07-10 16:00:00	MSFT	Stock	39.7188	40.1094	39.5	39.5625	2133400.0
2000-07-10 17:00:00	MSFT	Stock	39.625	39.6875	39.5312	39.5625	7600.0
2000-07-10 18:00:00	MSFT	Stock	39.5312	39.5312	39.5312	39.5312	200.0
2000-07-10 08:00:00	NVDA	Stock	0.2438	0.2438	0.2417	0.2417	72000.0
2000-07-10 09:00:00	NVDA	Stock	0.2417	0.2542	0.2375	0.2458	37176000.0
2000-07-10 10:00:00	NVDA	Stock	0.2458	0.2461	0.2406	0.2422	25440000.0
2000-07-10 11:00:00	NVDA	Stock	0.2422	0.2422	0.2359	0.2385	29352000.0
2000-07-10 12:00:00	NVDA	Stock	0.2388	0.2458	0.2388	0.2451	19032000.0
2000-07-10 13:00:00	NVDA	Stock	0.2458	0.2599	0.2453	0.2599	84384000.0
2000-07-10 14:00:00	NVDA	Stock	0.2594	0.2609	0.2521	0.2576	59856000.0
2000-07-10 15:00:00	NVDA	Stock	0.2565	0.2604	0.2477	0.2547	73848000.0
2000-07-10 16:00:00	NVDA	Stock	0.2549	0.2549	0.2523	0.2549	3936000.0
2000-07-10 17:00:00	NVDA	Stock	0.2586	0.2586	0.2557	0.2557	216000.0
2000-07-10 08:00:00	AMZN	Stock	1.8062	1.8125	1.8	1.8	260000.0
2000-07-10 09:00:00	AMZN	Stock	1.8125	1.8188	1.7656	1.7781	8560000.0
2000-07-10 10:00:00	AMZN	Stock	1.775	1.7781	1.7531	1.7562	13234000.0
2000-07-10 11:00:00	AMZN	Stock	1.7562	1.7812	1.75	1.7781	12948000.0
2000-07-10 12:00:00	AMZN	Stock	1.7781	1.8	1.775	1.7969	9232000.0
2000-07-10 13:00:00	AMZN	Stock	1.8	1.8094	1.7938	1.8031	11496000.0
2000-07-10 14:00:00	AMZN	Stock	1.8031	1.8031	1.7781	1.7906	7176000.0
2000-07-10 15:00:00	AMZN	Stock	1.7906	1.7969	1.75	1.7562	16440000.0
2000-07-10 16:00:00	AMZN	Stock	1.7531	1.8203	1.7375	1.7531	1908000.0
2000-07-10 17:00:00	AMZN	Stock	1.7562	1.7562	1.7562	1.7562	2000.0
2000-07-10 18:00:00	AMZN	Stock	1.75	1.75	1.75	1.75	4000.0
2000-07-10 09:00:00	CL	Stock	28.625	28.9375	28.5938	28.875	178200.0
2000-07-10 10:00:00	CL	Stock	28.8438	28.9062	28.5625	28.5625	214400.0
2000-07-10 11:00:00	CL	Stock	28.5625	28.625	28.4375	28.4688	239600.0
2000-07-10 12:00:00	CL	Stock	28.4375	28.5	28.3125	28.4062	287800.0
2000-07-10 13:00:00	CL	Stock	28.4062	28.4688	28.375	28.4688	106400.0
2000-07-10 14:00:00	CL	Stock	28.4688	28.4688	27.875	28.0	690200.0
2000-07-10 15:00:00	CL	Stock	28.0	28.0312	27.75	27.8438	1027600.0
2000-07-10 16:00:00	CL	Stock	27.8438	27.8438	27.8125	27.8438	204400.0

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

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