PREVIEW / stock_1hour / 2006-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-04.parquet
  size:    625 KB
  rows:    30,200
  symbols: 2,397

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
2006-10-04 08:00:00	AAPL	Stock	2.6532	2.6586	2.6493	2.6536	816984.0
2006-10-04 09:00:00	AAPL	Stock	2.6536	2.6536	2.6157	2.6164	90331388.0
2006-10-04 10:00:00	AAPL	Stock	2.6161	2.6607	2.6129	2.6568	167522460.0
2006-10-04 11:00:00	AAPL	Stock	2.6561	2.6868	2.6532	2.6757	154564816.0
2006-10-04 12:00:00	AAPL	Stock	2.6754	2.6779	2.6636	2.675	67769604.0
2006-10-04 13:00:00	AAPL	Stock	2.6739	2.6796	2.6664	2.6761	65491860.0
2006-10-04 14:00:00	AAPL	Stock	2.6764	2.6951	2.6736	2.6932	125906032.0
2006-10-04 15:00:00	AAPL	Stock	2.6932	2.6935	2.6771	2.6921	127090376.0
2006-10-04 16:00:00	AAPL	Stock	2.6914	2.7429	2.6514	2.6571	8589168.0
2006-10-04 17:00:00	AAPL	Stock	2.6571	2.6911	2.6507	2.675	6453076.0
2006-10-04 18:00:00	AAPL	Stock	2.6754	2.6921	2.6679	2.6729	9870896.0
2006-10-04 19:00:00	AAPL	Stock	2.6757	2.6804	2.6714	2.6714	398552.0
2006-10-04 06:00:00	MSFT	Stock	27.37	27.37	27.37	27.37	800.0
2006-10-04 07:00:00	MSFT	Stock	27.37	27.45	27.37	27.43	2592.0
2006-10-04 08:00:00	MSFT	Stock	27.43	27.43	27.37	27.4	24697.0
2006-10-04 09:00:00	MSFT	Stock	27.41	27.63	27.35	27.583	8252441.0
2006-10-04 10:00:00	MSFT	Stock	27.58	27.8	27.55	27.71	12994432.0
2006-10-04 11:00:00	MSFT	Stock	27.72	27.8	27.68	27.74	9715365.0
2006-10-04 12:00:00	MSFT	Stock	27.74	27.85	27.73	27.8	10661553.0
2006-10-04 13:00:00	MSFT	Stock	27.8	27.9	27.72	27.86	9020992.0
2006-10-04 14:00:00	MSFT	Stock	27.85	27.94	27.83	27.9	10765353.0
2006-10-04 15:00:00	MSFT	Stock	27.9	27.96	27.84	27.95	18723552.0
2006-10-04 16:00:00	MSFT	Stock	27.94	27.98	27.92	27.94	263713.0
2006-10-04 17:00:00	MSFT	Stock	27.91	27.92	27.91	27.92	1270.0
2006-10-04 18:00:00	MSFT	Stock	27.92	27.96	27.91	27.96	12961.0
2006-10-04 19:00:00	MSFT	Stock	27.96	27.96	27.96	27.96	200.0
2006-10-04 08:00:00	NVDA	Stock	0.4717	0.4762	0.4713	0.4717	1071960.0
2006-10-04 09:00:00	NVDA	Stock	0.472	0.4912	0.471	0.4877	236217900.0
2006-10-04 10:00:00	NVDA	Stock	0.4877	0.5003	0.4877	0.4997	354756060.0
2006-10-04 11:00:00	NVDA	Stock	0.4997	0.5132	0.499	0.5005	302802180.0
2006-10-04 12:00:00	NVDA	Stock	0.5005	0.5045	0.4987	0.5013	98009460.0
2006-10-04 13:00:00	NVDA	Stock	0.5012	0.5062	0.5008	0.5033	103841460.0
2006-10-04 14:00:00	NVDA	Stock	0.5035	0.5117	0.5035	0.51	113684160.0
2006-10-04 15:00:00	NVDA	Stock	0.5098	0.5182	0.5072	0.5182	217895580.0
2006-10-04 16:00:00	NVDA	Stock	0.518	0.518	0.5167	0.5177	1921680.0
2006-10-04 17:00:00	NVDA	Stock	0.5178	0.5222	0.5172	0.5217	1112700.0
2006-10-04 18:00:00	NVDA	Stock	0.5217	0.5248	0.518	0.5218	387840.0
2006-10-04 19:00:00	NVDA	Stock	0.5222	0.5222	0.5222	0.5222	6000.0
2006-10-04 09:00:00	AMZN	Stock	1.5895	1.593	1.565	1.5845	12887220.0
2006-10-04 10:00:00	AMZN	Stock	1.584	1.6225	1.577	1.62	26140320.0
2006-10-04 11:00:00	AMZN	Stock	1.6195	1.6315	1.6075	1.6265	27444720.0
2006-10-04 12:00:00	AMZN	Stock	1.626	1.631	1.617	1.62	10621360.0
2006-10-04 13:00:00	AMZN	Stock	1.6205	1.6275	1.613	1.6245	13178580.0
2006-10-04 14:00:00	AMZN	Stock	1.6255	1.6325	1.6235	1.6315	15050060.0
2006-10-04 15:00:00	AMZN	Stock	1.6315	1.6415	1.6265	1.6375	30023780.0
2006-10-04 16:00:00	AMZN	Stock	1.639	1.6395	1.6355	1.6385	215840.0
2006-10-04 17:00:00	AMZN	Stock	1.637	1.637	1.636	1.636	16000.0
2006-10-04 18:00:00	AMZN	Stock	1.638	1.638	1.637	1.637	26940.0
2006-10-04 09:00:00	CL	Stock	31.03	31.03	30.905	30.925	1981200.0
2006-10-04 10:00:00	CL	Stock	30.925	31.11	30.9	31.055	749400.0

> showing 50 of 30,200 rows — these rows as CSV

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