PREVIEW / stock_1hour / 2007-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-10.parquet
  size:    792 KB
  rows:    38,616
  symbols: 3,126

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-08-10 09:00:00	AAPL	Stock	4.3971	4.4236	4.3393	4.3889	214043788.0
2007-08-10 10:00:00	AAPL	Stock	4.3889	4.4036	4.2964	4.35	240091096.0
2007-08-10 11:00:00	AAPL	Stock	4.3493	4.4821	4.3489	4.4746	235830616.0
2007-08-10 12:00:00	AAPL	Stock	4.4746	4.5625	4.4018	4.4611	226163532.0
2007-08-10 13:00:00	AAPL	Stock	4.4611	4.5307	4.4232	4.4636	131755540.0
2007-08-10 14:00:00	AAPL	Stock	4.4625	4.5	4.44	4.4425	113213240.0
2007-08-10 15:00:00	AAPL	Stock	4.4429	4.4989	4.4339	4.4643	155091272.0
2007-08-10 16:00:00	AAPL	Stock	4.4643	4.4707	4.4636	4.4643	7353136.0
2007-08-10 09:00:00	MSFT	Stock	28.9	29.05	28.67	28.9	8513615.0
2007-08-10 10:00:00	MSFT	Stock	28.9	28.9	28.26	28.44	12828227.0
2007-08-10 11:00:00	MSFT	Stock	28.44	28.8	28.42	28.75	11386176.0
2007-08-10 12:00:00	MSFT	Stock	28.75	28.91	28.52	28.54	9322969.0
2007-08-10 13:00:00	MSFT	Stock	28.54	28.77	28.52	28.6	8252730.0
2007-08-10 14:00:00	MSFT	Stock	28.6	28.69	28.48	28.57	7385149.0
2007-08-10 15:00:00	MSFT	Stock	28.58	28.8	28.49	28.7	13022828.0
2007-08-10 16:00:00	MSFT	Stock	28.7	28.73	28.68	28.71	1138819.0
2007-08-10 05:00:00	NVDA	Stock	0.7533	0.7533	0.7533	0.7533	24000.0
2007-08-10 07:00:00	NVDA	Stock	0.7443	0.7443	0.7118	0.7118	851040.0
2007-08-10 08:00:00	NVDA	Stock	0.7185	0.7233	0.7025	0.7058	16237860.0
2007-08-10 09:00:00	NVDA	Stock	0.7083	0.7382	0.6898	0.7322	253491540.0
2007-08-10 10:00:00	NVDA	Stock	0.732	0.735	0.7075	0.7137	209886060.0
2007-08-10 11:00:00	NVDA	Stock	0.713	0.73	0.7125	0.73	123323280.0
2007-08-10 12:00:00	NVDA	Stock	0.73	0.7342	0.7108	0.7132	128251740.0
2007-08-10 13:00:00	NVDA	Stock	0.7132	0.7325	0.7093	0.7223	121833960.0
2007-08-10 14:00:00	NVDA	Stock	0.722	0.7303	0.7178	0.7211	79810680.0
2007-08-10 15:00:00	NVDA	Stock	0.721	0.735	0.7203	0.7343	140431740.0
2007-08-10 16:00:00	NVDA	Stock	0.7343	0.7343	0.73	0.7317	6957960.0
2007-08-10 17:00:00	NVDA	Stock	0.732	0.732	0.7292	0.7302	115440.0
2007-08-10 18:00:00	NVDA	Stock	0.7302	0.7332	0.73	0.7317	188520.0
2007-08-10 19:00:00	NVDA	Stock	0.7317	0.7317	0.7285	0.7285	239400.0
2007-08-10 06:00:00	AMZN	Stock	3.6865	3.6865	3.6765	3.6765	12000.0
2007-08-10 07:00:00	AMZN	Stock	3.7	3.7	3.646	3.6475	44000.0
2007-08-10 08:00:00	AMZN	Stock	3.6565	3.67	3.625	3.6495	563500.0
2007-08-10 09:00:00	AMZN	Stock	3.645	3.722	3.645	3.6785	22376440.0
2007-08-10 10:00:00	AMZN	Stock	3.6795	3.684	3.6185	3.6575	22625180.0
2007-08-10 11:00:00	AMZN	Stock	3.656	3.742	3.631	3.74	26950000.0
2007-08-10 12:00:00	AMZN	Stock	3.7405	3.825	3.725	3.725	33436720.0
2007-08-10 13:00:00	AMZN	Stock	3.7255	3.761	3.7215	3.7485	18762820.0
2007-08-10 14:00:00	AMZN	Stock	3.749	3.7675	3.708	3.708	18091160.0
2007-08-10 15:00:00	AMZN	Stock	3.7105	3.7715	3.7095	3.7395	30031620.0
2007-08-10 16:00:00	AMZN	Stock	3.741	3.741	3.732	3.738	3041640.0
2007-08-10 17:00:00	AMZN	Stock	3.731	3.732	3.731	3.732	10000.0
2007-08-10 18:00:00	AMZN	Stock	3.7325	3.7325	3.7055	3.7055	194580.0
2007-08-10 19:00:00	AMZN	Stock	3.738	3.738	3.738	3.738	8200.0
2007-08-10 09:00:00	TLT	Stock	86.49	86.59	86.41	86.45	235100.0
2007-08-10 10:00:00	TLT	Stock	86.45	86.7	86.41	86.7	147700.0
2007-08-10 11:00:00	TLT	Stock	86.69	86.69	86.44	86.6	65700.0
2007-08-10 12:00:00	TLT	Stock	86.6	86.65	86.31	86.48	156900.0
2007-08-10 13:00:00	TLT	Stock	86.47	86.47	86.26	86.32	171500.0
2007-08-10 14:00:00	TLT	Stock	86.31	86.4	86.23	86.27	88800.0

> showing 50 of 38,616 rows — these rows as CSV

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