PREVIEW / stock_1hour / 2005-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-03.parquet
  size:    552 KB
  rows:    26,241
  symbols: 1,975

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
2005-06-03 05:00:00	AAPL	Stock	1.405	1.405	1.405	1.405	2800.0
2005-06-03 07:00:00	AAPL	Stock	1.4118	1.425	1.3561	1.3607	3918992.0
2005-06-03 08:00:00	AAPL	Stock	1.3607	1.3821	1.3561	1.3686	25350388.0
2005-06-03 09:00:00	AAPL	Stock	1.3686	1.3779	1.3529	1.3704	214252864.0
2005-06-03 10:00:00	AAPL	Stock	1.3707	1.375	1.3489	1.3561	240510396.0
2005-06-03 11:00:00	AAPL	Stock	1.3561	1.3696	1.3525	1.3532	124248040.0
2005-06-03 12:00:00	AAPL	Stock	1.3529	1.3575	1.3489	1.3554	62159496.0
2005-06-03 13:00:00	AAPL	Stock	1.3554	1.3575	1.3521	1.356	71220940.0
2005-06-03 14:00:00	AAPL	Stock	1.3557	1.3671	1.3546	1.3642	77591836.0
2005-06-03 15:00:00	AAPL	Stock	1.3639	1.3661	1.3604	1.3657	117556768.0
2005-06-03 16:00:00	AAPL	Stock	1.365	1.3707	1.365	1.3671	3622892.0
2005-06-03 17:00:00	AAPL	Stock	1.3671	1.3679	1.3655	1.3668	597184.0
2005-06-03 18:00:00	AAPL	Stock	1.3668	1.3679	1.3668	1.3668	123480.0
2005-06-03 08:00:00	MSFT	Stock	25.77	25.82	25.73	25.81	19739.0
2005-06-03 09:00:00	MSFT	Stock	25.8	25.81	25.65	25.76	7060820.0
2005-06-03 10:00:00	MSFT	Stock	25.76	25.77	25.42	25.46	24141444.0
2005-06-03 11:00:00	MSFT	Stock	25.46	25.58	25.34	25.4	15969741.0
2005-06-03 12:00:00	MSFT	Stock	25.41	25.451	25.37	25.44	6923978.0
2005-06-03 13:00:00	MSFT	Stock	25.44	25.46	25.38	25.4	8066438.0
2005-06-03 14:00:00	MSFT	Stock	25.42	25.44	25.38	25.4	6258876.0
2005-06-03 15:00:00	MSFT	Stock	25.4	25.49	25.34	25.42	9130864.0
2005-06-03 16:00:00	MSFT	Stock	25.43	25.45	25.4	25.45	501194.0
2005-06-03 17:00:00	MSFT	Stock	25.45	25.46	25.404	25.45	19066.0
2005-06-03 18:00:00	MSFT	Stock	25.43	25.43	25.43	25.43	100.0
2005-06-03 08:00:00	NVDA	Stock	0.2371	0.2375	0.2346	0.2371	384000.0
2005-06-03 09:00:00	NVDA	Stock	0.2362	0.2368	0.2333	0.2363	102218520.0
2005-06-03 10:00:00	NVDA	Stock	0.2362	0.2377	0.2346	0.2368	130366680.0
2005-06-03 11:00:00	NVDA	Stock	0.2368	0.2372	0.2352	0.2358	57764640.0
2005-06-03 12:00:00	NVDA	Stock	0.2358	0.2361	0.2351	0.2359	36710880.0
2005-06-03 13:00:00	NVDA	Stock	0.2359	0.2371	0.2351	0.2367	55017960.0
2005-06-03 14:00:00	NVDA	Stock	0.2366	0.2367	0.2357	0.2359	41465400.0
2005-06-03 15:00:00	NVDA	Stock	0.236	0.2365	0.2356	0.2358	87505320.0
2005-06-03 16:00:00	NVDA	Stock	0.2359	0.2362	0.2354	0.2362	1766040.0
2005-06-03 17:00:00	NVDA	Stock	0.2359	0.2359	0.2357	0.2357	4766400.0
2005-06-03 18:00:00	NVDA	Stock	0.2357	0.2357	0.2356	0.2356	473760.0
2005-06-03 08:00:00	AMZN	Stock	1.825	1.828	1.823	1.823	73400.0
2005-06-03 09:00:00	AMZN	Stock	1.823	1.8265	1.8075	1.81	8244420.0
2005-06-03 10:00:00	AMZN	Stock	1.81	1.8125	1.804	1.807	13859640.0
2005-06-03 11:00:00	AMZN	Stock	1.807	1.8105	1.797	1.8	8893960.0
2005-06-03 12:00:00	AMZN	Stock	1.7995	1.7995	1.782	1.791	17380400.0
2005-06-03 13:00:00	AMZN	Stock	1.7915	1.7925	1.786	1.792	4906680.0
2005-06-03 14:00:00	AMZN	Stock	1.792	1.792	1.766	1.7705	14219860.0
2005-06-03 15:00:00	AMZN	Stock	1.772	1.786	1.7685	1.7775	27218660.0
2005-06-03 16:00:00	AMZN	Stock	1.778	1.782	1.775	1.781	676960.0
2005-06-03 17:00:00	AMZN	Stock	1.781	1.781	1.7735	1.775	158500.0
2005-06-03 18:00:00	AMZN	Stock	1.7745	1.775	1.7745	1.775	16000.0
2005-06-03 09:00:00	CL	Stock	24.68	24.79	24.68	24.745	463400.0
2005-06-03 10:00:00	CL	Stock	24.745	24.755	24.67	24.685	640600.0
2005-06-03 11:00:00	CL	Stock	24.68	24.705	24.6	24.6	771800.0
2005-06-03 12:00:00	CL	Stock	24.605	24.605	24.515	24.565	523600.0

> showing 50 of 26,241 rows — these rows as CSV

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