PREVIEW / stock_1hour / 2007-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-06.parquet
  size:    738 KB
  rows:    36,335
  symbols: 3,032

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
2007-07-06 09:00:00	AAPL	Stock	4.7546	4.7621	4.6571	4.6904	249991140.0
2007-07-06 10:00:00	AAPL	Stock	4.6918	4.7186	4.68	4.7011	154566300.0
2007-07-06 11:00:00	AAPL	Stock	4.7011	4.7439	4.6954	4.7204	127790544.0
2007-07-06 12:00:00	AAPL	Stock	4.72	4.7304	4.7	4.7139	72578856.0
2007-07-06 13:00:00	AAPL	Stock	4.7136	4.7275	4.7046	4.7264	52127600.0
2007-07-06 14:00:00	AAPL	Stock	4.7261	4.7304	4.7175	4.7236	58074128.0
2007-07-06 15:00:00	AAPL	Stock	4.7232	4.7286	4.7179	4.725	95648420.0
2007-07-06 16:00:00	AAPL	Stock	4.7236	4.725	4.7232	4.725	6512128.0
2007-07-06 09:00:00	MSFT	Stock	29.91	30.04	29.9	29.96	5973118.0
2007-07-06 10:00:00	MSFT	Stock	29.96	30.01	29.94	29.97	9633752.0
2007-07-06 11:00:00	MSFT	Stock	29.97	30.0	29.91	29.92	5103538.0
2007-07-06 12:00:00	MSFT	Stock	29.925	29.93	29.72	29.77	5936972.0
2007-07-06 13:00:00	MSFT	Stock	29.78	29.81	29.66	29.76	3907062.0
2007-07-06 14:00:00	MSFT	Stock	29.76	29.91	29.72	29.89	6678932.0
2007-07-06 15:00:00	MSFT	Stock	29.9	29.96	29.87	29.96	9090093.0
2007-07-06 16:00:00	MSFT	Stock	29.94	29.97	29.94	29.97	1220785.0
2007-07-06 08:00:00	NVDA	Stock	0.7258	0.726	0.7258	0.726	42000.0
2007-07-06 09:00:00	NVDA	Stock	0.725	0.7275	0.7237	0.7255	41370660.0
2007-07-06 10:00:00	NVDA	Stock	0.7255	0.7323	0.7253	0.7275	60570120.0
2007-07-06 11:00:00	NVDA	Stock	0.7277	0.7295	0.7262	0.7282	39552060.0
2007-07-06 12:00:00	NVDA	Stock	0.728	0.7287	0.7248	0.7262	30977340.0
2007-07-06 13:00:00	NVDA	Stock	0.726	0.728	0.7255	0.7275	19267740.0
2007-07-06 14:00:00	NVDA	Stock	0.7275	0.7292	0.7273	0.7275	26797920.0
2007-07-06 15:00:00	NVDA	Stock	0.7277	0.7298	0.727	0.7295	55183740.0
2007-07-06 16:00:00	NVDA	Stock	0.7292	0.7295	0.7277	0.7278	2376840.0
2007-07-06 17:00:00	NVDA	Stock	0.728	0.728	0.728	0.728	18000.0
2007-07-06 18:00:00	NVDA	Stock	0.7278	0.7315	0.7275	0.7292	264180.0
2007-07-06 19:00:00	NVDA	Stock	0.7295	0.7295	0.7295	0.7295	6000.0
2007-07-06 08:00:00	AMZN	Stock	3.438	3.438	3.425	3.4265	42640.0
2007-07-06 09:00:00	AMZN	Stock	3.4285	3.438	3.4185	3.4195	6128420.0
2007-07-06 10:00:00	AMZN	Stock	3.4195	3.4279	3.4005	3.405	16546520.0
2007-07-06 11:00:00	AMZN	Stock	3.405	3.426	3.403	3.4215	12820180.0
2007-07-06 12:00:00	AMZN	Stock	3.422	3.423	3.4095	3.42	8460240.0
2007-07-06 13:00:00	AMZN	Stock	3.4195	3.4245	3.413	3.4225	5506000.0
2007-07-06 14:00:00	AMZN	Stock	3.423	3.4484	3.421	3.4465	10202960.0
2007-07-06 15:00:00	AMZN	Stock	3.4465	3.465	3.4435	3.4475	26016780.0
2007-07-06 16:00:00	AMZN	Stock	3.4505	3.4735	3.446	3.4485	1776700.0
2007-07-06 17:00:00	AMZN	Stock	3.4485	3.4485	3.446	3.446	90000.0
2007-07-06 18:00:00	AMZN	Stock	3.4525	3.4525	3.45	3.4525	32000.0
2007-07-06 19:00:00	AMZN	Stock	3.45	3.4525	3.45	3.4525	13200.0
2007-07-06 09:00:00	TLT	Stock	83.54	83.55	83.37	83.4	338300.0
2007-07-06 10:00:00	TLT	Stock	83.39	83.49	83.36	83.43	219100.0
2007-07-06 11:00:00	TLT	Stock	83.42	83.51	83.31	83.36	94714.0
2007-07-06 12:00:00	TLT	Stock	83.36	83.39	83.28	83.35	400900.0
2007-07-06 13:00:00	TLT	Stock	83.36	83.53	83.36	83.49	106700.0
2007-07-06 14:00:00	TLT	Stock	83.49	83.49	83.31	83.34	47900.0
2007-07-06 15:00:00	TLT	Stock	83.33	83.46	83.32	83.41	117650.0
2007-07-06 16:00:00	TLT	Stock	83.42	83.48	83.42	83.48	1600.0
2007-07-06 09:00:00	CL	Stock	33.025	33.035	32.755	32.8	882600.0
2007-07-06 10:00:00	CL	Stock	32.8	32.93	32.77	32.845	517200.0

> showing 50 of 36,335 rows — these rows as CSV

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