PREVIEW / stock_1hour / 2007-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-10.parquet
  size:    792 KB
  rows:    39,198
  symbols: 3,146

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-10-10 05:00:00	AAPL	Stock	5.985	5.985	5.985	5.985	14000.0
2007-10-10 07:00:00	AAPL	Stock	5.9946	5.9946	5.9679	5.9818	165200.0
2007-10-10 08:00:00	AAPL	Stock	5.9768	6.0104	5.9696	5.9964	2957836.0
2007-10-10 09:00:00	AAPL	Stock	5.9964	6.0071	5.92	5.9343	110306560.0
2007-10-10 10:00:00	AAPL	Stock	5.9339	5.9521	5.9143	5.9425	108145184.0
2007-10-10 11:00:00	AAPL	Stock	5.9425	5.9792	5.9375	5.9486	111407072.0
2007-10-10 12:00:00	AAPL	Stock	5.9486	5.9657	5.9286	5.9579	67499684.0
2007-10-10 13:00:00	AAPL	Stock	5.9578	5.9586	5.9286	5.9414	62178340.0
2007-10-10 14:00:00	AAPL	Stock	5.9414	5.9671	5.9321	5.9607	88337536.0
2007-10-10 15:00:00	AAPL	Stock	5.9611	5.9739	5.95	5.955	100239076.0
2007-10-10 16:00:00	AAPL	Stock	5.9539	5.9568	5.9386	5.9411	14189700.0
2007-10-10 17:00:00	AAPL	Stock	5.9429	5.9568	5.9418	5.9489	533568.0
2007-10-10 18:00:00	AAPL	Stock	5.9518	5.9643	5.9464	5.9571	1324176.0
2007-10-10 19:00:00	AAPL	Stock	5.9571	5.9596	5.9464	5.9596	310884.0
2007-10-10 08:00:00	MSFT	Stock	30.08	30.13	30.08	30.13	53884.0
2007-10-10 09:00:00	MSFT	Stock	30.13	30.37	30.0	30.32	4406027.0
2007-10-10 10:00:00	MSFT	Stock	30.31	30.34	30.16	30.2	4500922.0
2007-10-10 11:00:00	MSFT	Stock	30.2	30.29	30.195	30.22	3067689.0
2007-10-10 12:00:00	MSFT	Stock	30.23	30.331	30.229	30.25	3116000.0
2007-10-10 13:00:00	MSFT	Stock	30.25	30.26	30.181	30.215	4205598.0
2007-10-10 14:00:00	MSFT	Stock	30.22	30.28	30.12	30.27	4302659.0
2007-10-10 15:00:00	MSFT	Stock	30.26	30.32	30.2	30.23	7032791.0
2007-10-10 16:00:00	MSFT	Stock	30.23	30.267	30.2	30.22	1486956.0
2007-10-10 17:00:00	MSFT	Stock	30.23	30.34	30.2	30.34	68687.0
2007-10-10 18:00:00	MSFT	Stock	30.28	30.29	30.22	30.22	10290.0
2007-10-10 19:00:00	MSFT	Stock	30.23	30.25	30.23	30.23	700.0
2007-10-10 07:00:00	NVDA	Stock	0.9455	0.9455	0.9455	0.9455	4000.0
2007-10-10 08:00:00	NVDA	Stock	0.9222	0.925	0.921	0.922	44400.0
2007-10-10 09:00:00	NVDA	Stock	0.9225	0.928	0.9188	0.9203	30516200.0
2007-10-10 10:00:00	NVDA	Stock	0.92	0.9236	0.9113	0.9161	48736720.0
2007-10-10 11:00:00	NVDA	Stock	0.916	0.9168	0.9043	0.9068	52418080.0
2007-10-10 12:00:00	NVDA	Stock	0.9068	0.9088	0.9008	0.9033	50593240.0
2007-10-10 13:00:00	NVDA	Stock	0.9033	0.9035	0.9005	0.9033	44184640.0
2007-10-10 14:00:00	NVDA	Stock	0.9033	0.9135	0.903	0.9123	49257320.0
2007-10-10 15:00:00	NVDA	Stock	0.912	0.9278	0.912	0.9225	92339920.0
2007-10-10 16:00:00	NVDA	Stock	0.9225	0.9232	0.9106	0.9228	20380040.0
2007-10-10 17:00:00	NVDA	Stock	0.9228	0.9275	0.9228	0.925	684360.0
2007-10-10 18:00:00	NVDA	Stock	0.925	0.9262	0.925	0.9258	83200.0
2007-10-10 19:00:00	NVDA	Stock	0.9213	0.9213	0.9213	0.9213	35400.0
2007-10-10 07:00:00	AMZN	Stock	4.75	4.75	4.75	4.75	2000.0
2007-10-10 08:00:00	AMZN	Stock	4.7965	4.7965	4.765	4.7725	102120.0
2007-10-10 09:00:00	AMZN	Stock	4.779	4.7875	4.752	4.7605	14554380.0
2007-10-10 10:00:00	AMZN	Stock	4.7625	4.7874	4.755	4.767	16731860.0
2007-10-10 11:00:00	AMZN	Stock	4.768	4.7735	4.76	4.764	10234300.0
2007-10-10 12:00:00	AMZN	Stock	4.7645	4.7675	4.732	4.7395	9455220.0
2007-10-10 13:00:00	AMZN	Stock	4.7395	4.745	4.7185	4.731	8233360.0
2007-10-10 14:00:00	AMZN	Stock	4.731	4.7475	4.727	4.7435	11383200.0
2007-10-10 15:00:00	AMZN	Stock	4.7455	4.7535	4.7185	4.733	26584520.0
2007-10-10 16:00:00	AMZN	Stock	4.733	4.7675	4.727	4.7275	14332280.0
2007-10-10 17:00:00	AMZN	Stock	4.733	4.733	4.727	4.729	141560.0

> showing 50 of 39,198 rows — these rows as CSV

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