PREVIEW / stock_1hour / 2007-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-26.parquet
  size:    801 KB
  rows:    38,918
  symbols: 3,110

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-26 09:00:00	AAPL	Stock	5.2111	5.2679	5.0732	5.22	354548488.0
2007-07-26 10:00:00	AAPL	Stock	5.2204	5.3036	5.1921	5.2929	410199384.0
2007-07-26 11:00:00	AAPL	Stock	5.2929	5.2957	5.2179	5.2679	272884304.0
2007-07-26 12:00:00	AAPL	Stock	5.2686	5.2746	5.1643	5.2196	218069768.0
2007-07-26 13:00:00	AAPL	Stock	5.2218	5.225	5.1357	5.1382	183650796.0
2007-07-26 14:00:00	AAPL	Stock	5.1382	5.1661	5.0732	5.1596	281308188.0
2007-07-26 15:00:00	AAPL	Stock	5.1596	5.2411	5.1425	5.2389	294543536.0
2007-07-26 16:00:00	AAPL	Stock	5.2389	5.2389	5.2143	5.2143	26851188.0
2007-07-26 09:00:00	MSFT	Stock	30.24	30.471	30.12	30.33	6483606.0
2007-07-26 10:00:00	MSFT	Stock	30.33	30.53	30.24	30.42	7881254.0
2007-07-26 11:00:00	MSFT	Stock	30.42	30.43	30.04	30.17	8681519.0
2007-07-26 12:00:00	MSFT	Stock	30.17	30.17	29.8	29.96	10210477.0
2007-07-26 13:00:00	MSFT	Stock	29.96	30.0	29.75	29.772	8393077.0
2007-07-26 14:00:00	MSFT	Stock	29.78	29.87	29.51	29.73	11440563.0
2007-07-26 15:00:00	MSFT	Stock	29.73	30.11	29.66	30.07	19799778.0
2007-07-26 16:00:00	MSFT	Stock	30.08	30.08	29.98	29.98	4435962.0
2007-07-26 08:00:00	NVDA	Stock	0.726	0.728	0.7242	0.7242	490500.0
2007-07-26 09:00:00	NVDA	Stock	0.724	0.7333	0.7217	0.7313	45282780.0
2007-07-26 10:00:00	NVDA	Stock	0.7315	0.7497	0.7288	0.7472	109120440.0
2007-07-26 11:00:00	NVDA	Stock	0.747	0.747	0.726	0.7338	110138700.0
2007-07-26 12:00:00	NVDA	Stock	0.7335	0.7342	0.7212	0.7275	72168540.0
2007-07-26 13:00:00	NVDA	Stock	0.7272	0.7337	0.723	0.7328	84754920.0
2007-07-26 14:00:00	NVDA	Stock	0.7327	0.7358	0.718	0.7292	102368220.0
2007-07-26 15:00:00	NVDA	Stock	0.7293	0.7417	0.7233	0.7417	132368100.0
2007-07-26 16:00:00	NVDA	Stock	0.7417	0.745	0.7367	0.7367	18376740.0
2007-07-26 17:00:00	NVDA	Stock	0.7367	0.7393	0.7313	0.7313	1370220.0
2007-07-26 18:00:00	NVDA	Stock	0.7315	0.7345	0.7315	0.7345	58200.0
2007-07-26 05:00:00	AMZN	Stock	4.31	4.31	4.31	4.31	3900.0
2007-07-26 07:00:00	AMZN	Stock	4.3055	4.3055	4.27	4.27	224920.0
2007-07-26 08:00:00	AMZN	Stock	4.2845	4.2895	4.23	4.255	3389800.0
2007-07-26 09:00:00	AMZN	Stock	4.255	4.298	4.24	4.282	51196660.0
2007-07-26 10:00:00	AMZN	Stock	4.283	4.45	4.276	4.387	101877060.0
2007-07-26 11:00:00	AMZN	Stock	4.3875	4.3875	4.3125	4.3425	62651480.0
2007-07-26 12:00:00	AMZN	Stock	4.3445	4.36	4.3095	4.3465	44490300.0
2007-07-26 13:00:00	AMZN	Stock	4.346	4.3485	4.287	4.2875	39738280.0
2007-07-26 14:00:00	AMZN	Stock	4.2875	4.2935	4.1715	4.212	85522160.0
2007-07-26 15:00:00	AMZN	Stock	4.2145	4.2485	4.1985	4.201	62924620.0
2007-07-26 16:00:00	AMZN	Stock	4.201	4.215	4.2	4.215	6781580.0
2007-07-26 17:00:00	AMZN	Stock	4.2195	4.2195	4.18	4.18	322120.0
2007-07-26 18:00:00	AMZN	Stock	4.18	4.2045	4.176	4.1875	204700.0
2007-07-26 19:00:00	AMZN	Stock	4.1875	4.2005	4.185	4.2005	2739500.0
2007-07-26 09:00:00	TLT	Stock	86.74	86.9	86.74	86.89	111900.0
2007-07-26 10:00:00	TLT	Stock	86.9	86.98	86.65	86.7	339780.0
2007-07-26 11:00:00	TLT	Stock	86.71	87.25	86.71	87.04	794910.0
2007-07-26 12:00:00	TLT	Stock	87.01	87.33	86.95	87.18	668300.0
2007-07-26 13:00:00	TLT	Stock	87.19	87.29	87.09	87.2	389983.0
2007-07-26 14:00:00	TLT	Stock	87.17	87.46	87.14	87.22	242225.0
2007-07-26 15:00:00	TLT	Stock	87.2	87.24	87.04	87.05	228700.0
2007-07-26 16:00:00	TLT	Stock	87.08	87.23	87.03	87.03	70800.0
2007-07-26 09:00:00	CL	Stock	34.425	34.945	34.385	34.72	1367800.0

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

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