PREVIEW / stock_1hour / 2007-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-05.parquet
  size:    744 KB
  rows:    36,542
  symbols: 3,033

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-05 09:00:00	AAPL	Stock	4.6	4.7054	4.5961	4.6507	329688352.0
2007-07-05 10:00:00	AAPL	Stock	4.6504	4.6964	4.6357	4.6939	293213928.0
2007-07-05 11:00:00	AAPL	Stock	4.6946	4.6961	4.6625	4.6732	149811704.0
2007-07-05 12:00:00	AAPL	Stock	4.6729	4.6786	4.6532	4.6654	111778576.0
2007-07-05 13:00:00	AAPL	Stock	4.6654	4.6868	4.6646	4.6725	74926824.0
2007-07-05 14:00:00	AAPL	Stock	4.6721	4.7253	4.6704	4.7207	179943680.0
2007-07-05 15:00:00	AAPL	Stock	4.7207	4.7489	4.7075	4.7407	237875008.0
2007-07-05 16:00:00	AAPL	Stock	4.7407	4.7411	4.7407	4.7411	7950768.0
2007-07-05 09:00:00	MSFT	Stock	30.05	30.22	29.95	30.0	7137229.0
2007-07-05 10:00:00	MSFT	Stock	30.01	30.06	29.95	29.98	5554586.0
2007-07-05 11:00:00	MSFT	Stock	29.982	30.002	29.87	29.94	5167404.0
2007-07-05 12:00:00	MSFT	Stock	29.94	29.959	29.83	29.911	4034703.0
2007-07-05 13:00:00	MSFT	Stock	29.92	30.0	29.9	29.961	3062144.0
2007-07-05 14:00:00	MSFT	Stock	29.96	30.0	29.95	29.96	7672996.0
2007-07-05 15:00:00	MSFT	Stock	29.97	30.02	29.91	29.99	8758038.0
2007-07-05 16:00:00	MSFT	Stock	29.99	29.99	29.99	29.99	1259217.0
2007-07-05 08:00:00	NVDA	Stock	0.7183	0.7183	0.715	0.7167	132000.0
2007-07-05 09:00:00	NVDA	Stock	0.7152	0.7233	0.715	0.7225	31588080.0
2007-07-05 10:00:00	NVDA	Stock	0.7225	0.725	0.7203	0.7213	64143780.0
2007-07-05 11:00:00	NVDA	Stock	0.7215	0.7232	0.7197	0.7228	46459200.0
2007-07-05 12:00:00	NVDA	Stock	0.7227	0.7245	0.7213	0.7237	49286220.0
2007-07-05 13:00:00	NVDA	Stock	0.7237	0.7245	0.7227	0.723	36193020.0
2007-07-05 14:00:00	NVDA	Stock	0.7228	0.7283	0.7225	0.7272	55377540.0
2007-07-05 15:00:00	NVDA	Stock	0.727	0.7278	0.7253	0.7255	68603280.0
2007-07-05 16:00:00	NVDA	Stock	0.7258	0.7272	0.7237	0.7237	254040.0
2007-07-05 18:00:00	NVDA	Stock	0.726	0.727	0.726	0.727	78000.0
2007-07-05 19:00:00	NVDA	Stock	0.7272	0.7272	0.7272	0.7272	72600.0
2007-07-05 08:00:00	AMZN	Stock	3.473	3.478	3.473	3.478	15980.0
2007-07-05 09:00:00	AMZN	Stock	3.478	3.4825	3.4515	3.457	6730100.0
2007-07-05 10:00:00	AMZN	Stock	3.4575	3.461	3.4315	3.44	13159180.0
2007-07-05 11:00:00	AMZN	Stock	3.4405	3.442	3.407	3.417	13932860.0
2007-07-05 12:00:00	AMZN	Stock	3.417	3.418	3.403	3.411	10635420.0
2007-07-05 13:00:00	AMZN	Stock	3.4115	3.416	3.407	3.4125	5353740.0
2007-07-05 14:00:00	AMZN	Stock	3.4128	3.432	3.4105	3.43	11667500.0
2007-07-05 15:00:00	AMZN	Stock	3.43	3.4385	3.424	3.4365	22954000.0
2007-07-05 16:00:00	AMZN	Stock	3.4365	3.4385	3.433	3.4365	2296020.0
2007-07-05 17:00:00	AMZN	Stock	3.4365	3.4365	3.4315	3.4315	16000.0
2007-07-05 19:00:00	AMZN	Stock	3.432	3.432	3.432	3.432	2000.0
2007-07-05 09:00:00	TLT	Stock	84.31	84.42	84.24	84.41	1074460.0
2007-07-05 10:00:00	TLT	Stock	84.4	84.4	84.1	84.11	1724100.0
2007-07-05 11:00:00	TLT	Stock	84.1	84.18	83.87	83.89	880500.0
2007-07-05 12:00:00	TLT	Stock	83.89	84.06	83.89	84.01	129200.0
2007-07-05 13:00:00	TLT	Stock	84.02	84.05	83.97	84.01	131281.0
2007-07-05 14:00:00	TLT	Stock	84.02	84.03	83.82	83.83	216800.0
2007-07-05 15:00:00	TLT	Stock	83.82	83.84	83.72	83.81	312000.0
2007-07-05 16:00:00	TLT	Stock	83.8	83.82	83.79	83.82	1400.0
2007-07-05 09:00:00	CL	Stock	33.0	33.05	32.85	32.89	356000.0
2007-07-05 10:00:00	CL	Stock	32.895	33.015	32.88	33.005	739280.0
2007-07-05 11:00:00	CL	Stock	33.0	33.025	32.96	32.99	750600.0
2007-07-05 12:00:00	CL	Stock	32.99	33.055	32.985	33.015	631600.0

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

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