PREVIEW / stock_1hour / 2006-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-06.parquet
  size:    610 KB
  rows:    28,653
  symbols: 2,211

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-04-06 04:00:00	AAPL	Stock	2.45	2.4607	2.45	2.4607	150304.0
2006-04-06 05:00:00	AAPL	Stock	2.4607	2.475	2.4607	2.4664	366352.0
2006-04-06 06:00:00	AAPL	Stock	2.4643	2.4643	2.4518	2.4518	270200.0
2006-04-06 07:00:00	AAPL	Stock	2.4536	2.4536	2.4357	2.4468	1988644.0
2006-04-06 08:00:00	AAPL	Stock	2.4464	2.4561	2.4243	2.4343	18543084.0
2006-04-06 09:00:00	AAPL	Stock	2.4339	2.4821	2.42	2.4736	442232420.0
2006-04-06 10:00:00	AAPL	Stock	2.4736	2.5	2.4643	2.4982	470402016.0
2006-04-06 11:00:00	AAPL	Stock	2.4986	2.5229	2.4918	2.4993	360514168.0
2006-04-06 12:00:00	AAPL	Stock	2.4993	2.5311	2.4907	2.525	250274192.0
2006-04-06 13:00:00	AAPL	Stock	2.5246	2.5657	2.5225	2.56	329189672.0
2006-04-06 14:00:00	AAPL	Stock	2.5604	2.5682	2.5479	2.5639	279416592.0
2006-04-06 15:00:00	AAPL	Stock	2.5643	2.5732	2.525	2.5429	473798556.0
2006-04-06 16:00:00	AAPL	Stock	2.5429	2.5714	2.4885	2.5432	8812412.0
2006-04-06 17:00:00	AAPL	Stock	2.5436	2.546	2.5375	2.5396	5295220.0
2006-04-06 18:00:00	AAPL	Stock	2.5393	2.5414	2.5393	2.5407	329336.0
2006-04-06 07:00:00	MSFT	Stock	27.7	27.7	27.65	27.65	1600.0
2006-04-06 08:00:00	MSFT	Stock	27.72	27.72	27.65	27.7	12939.0
2006-04-06 09:00:00	MSFT	Stock	27.7	27.73	27.64	27.64	3684892.0
2006-04-06 10:00:00	MSFT	Stock	27.64	27.7	27.59	27.63	4769061.0
2006-04-06 11:00:00	MSFT	Stock	27.64	27.64	27.47	27.47	5192900.0
2006-04-06 12:00:00	MSFT	Stock	27.47	27.584	27.37	27.45	6657956.0
2006-04-06 13:00:00	MSFT	Stock	27.45	27.54	27.41	27.52	6574858.0
2006-04-06 14:00:00	MSFT	Stock	27.52	27.61	27.43	27.45	8425526.0
2006-04-06 15:00:00	MSFT	Stock	27.46	27.65	27.45	27.53	12489142.0
2006-04-06 16:00:00	MSFT	Stock	27.52	27.58	27.52	27.53	125621.0
2006-04-06 17:00:00	MSFT	Stock	27.56	27.56	27.517	27.517	491800.0
2006-04-06 18:00:00	MSFT	Stock	27.59	27.59	27.59	27.59	370.0
2006-04-06 07:00:00	NVDA	Stock	0.5096	0.5096	0.5096	0.5096	18120.0
2006-04-06 08:00:00	NVDA	Stock	0.5083	0.5087	0.5067	0.5068	534000.0
2006-04-06 09:00:00	NVDA	Stock	0.5074	0.514	0.5034	0.5071	123466440.0
2006-04-06 10:00:00	NVDA	Stock	0.5071	0.5121	0.5055	0.5077	128288520.0
2006-04-06 11:00:00	NVDA	Stock	0.5077	0.5107	0.5037	0.5043	106958280.0
2006-04-06 12:00:00	NVDA	Stock	0.5043	0.5085	0.5008	0.5056	103370880.0
2006-04-06 13:00:00	NVDA	Stock	0.5056	0.512	0.5047	0.5102	87754200.0
2006-04-06 14:00:00	NVDA	Stock	0.5104	0.5119	0.5073	0.5087	75058440.0
2006-04-06 15:00:00	NVDA	Stock	0.5087	0.5118	0.5064	0.5102	125138400.0
2006-04-06 16:00:00	NVDA	Stock	0.5099	0.5121	0.509	0.51	930600.0
2006-04-06 17:00:00	NVDA	Stock	0.5089	0.5093	0.5084	0.5093	48000.0
2006-04-06 18:00:00	NVDA	Stock	0.5102	0.5102	0.5102	0.5102	216000.0
2006-04-06 08:00:00	AMZN	Stock	1.855	1.855	1.855	1.855	10000.0
2006-04-06 09:00:00	AMZN	Stock	1.864	1.8705	1.8565	1.867	7647420.0
2006-04-06 10:00:00	AMZN	Stock	1.8675	1.889	1.865	1.8825	28352920.0
2006-04-06 11:00:00	AMZN	Stock	1.8825	1.899	1.8825	1.894	24468500.0
2006-04-06 12:00:00	AMZN	Stock	1.894	1.8965	1.8845	1.8925	12523760.0
2006-04-06 13:00:00	AMZN	Stock	1.8925	1.939	1.8925	1.934	26763560.0
2006-04-06 14:00:00	AMZN	Stock	1.934	1.942	1.913	1.9175	32572100.0
2006-04-06 15:00:00	AMZN	Stock	1.9175	1.9285	1.9105	1.925	47186080.0
2006-04-06 16:00:00	AMZN	Stock	1.924	1.9375	1.8893	1.9265	1154860.0
2006-04-06 17:00:00	AMZN	Stock	1.9265	1.9325	1.9265	1.9325	59000.0
2006-04-06 09:00:00	CL	Stock	28.99	29.02	28.87	28.915	175400.0

> showing 50 of 28,653 rows — these rows as CSV

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