PREVIEW / stock_1hour / 2007-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-07.parquet
  size:    780 KB
  rows:    38,152
  symbols: 3,117

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-07 09:00:00	AAPL	Stock	4.8193	4.8929	4.8007	4.875	116710048.0
2007-08-07 10:00:00	AAPL	Stock	4.875	4.9014	4.85	4.8925	126168532.0
2007-08-07 11:00:00	AAPL	Stock	4.8925	4.8929	4.8625	4.885	72676240.0
2007-08-07 12:00:00	AAPL	Stock	4.8857	4.8911	4.8707	4.8804	47817280.0
2007-08-07 13:00:00	AAPL	Stock	4.88	4.8886	4.8464	4.8529	95822216.0
2007-08-07 14:00:00	AAPL	Stock	4.8543	4.8643	4.7368	4.8254	242681180.0
2007-08-07 15:00:00	AAPL	Stock	4.8246	4.8986	4.7954	4.8243	175983304.0
2007-08-07 16:00:00	AAPL	Stock	4.8207	4.8296	4.8207	4.8225	15085476.0
2007-08-07 09:00:00	MSFT	Stock	29.33	29.41	29.22	29.26	3042401.0
2007-08-07 10:00:00	MSFT	Stock	29.25	29.35	29.15	29.159	5619149.0
2007-08-07 11:00:00	MSFT	Stock	29.15	29.24	29.14	29.19	4348995.0
2007-08-07 12:00:00	MSFT	Stock	29.19	29.24	29.14	29.2	3823905.0
2007-08-07 13:00:00	MSFT	Stock	29.2	29.39	29.2	29.3	4002127.0
2007-08-07 14:00:00	MSFT	Stock	29.31	29.4	29.05	29.35	9297669.0
2007-08-07 15:00:00	MSFT	Stock	29.36	29.79	29.33	29.54	11385604.0
2007-08-07 16:00:00	MSFT	Stock	29.52	29.55	29.52	29.55	2811434.0
2007-08-07 08:00:00	NVDA	Stock	0.7183	0.7183	0.7118	0.7118	474000.0
2007-08-07 09:00:00	NVDA	Stock	0.7158	0.7322	0.7092	0.7313	59756100.0
2007-08-07 10:00:00	NVDA	Stock	0.7313	0.7317	0.7167	0.7223	89861520.0
2007-08-07 11:00:00	NVDA	Stock	0.7223	0.7233	0.7172	0.718	41191380.0
2007-08-07 12:00:00	NVDA	Stock	0.7178	0.7202	0.7132	0.7133	38135640.0
2007-08-07 13:00:00	NVDA	Stock	0.7133	0.7302	0.711	0.7117	49439340.0
2007-08-07 14:00:00	NVDA	Stock	0.7117	0.7238	0.7055	0.7238	133768200.0
2007-08-07 15:00:00	NVDA	Stock	0.7243	0.7382	0.72	0.7263	116289060.0
2007-08-07 16:00:00	NVDA	Stock	0.7263	0.7308	0.7207	0.7308	12452460.0
2007-08-07 17:00:00	NVDA	Stock	0.7305	0.7417	0.7263	0.7407	1100520.0
2007-08-07 18:00:00	NVDA	Stock	0.715	0.7417	0.715	0.7417	688800.0
2007-08-07 19:00:00	NVDA	Stock	0.7408	0.7408	0.7407	0.7407	13500.0
2007-08-07 06:00:00	AMZN	Stock	3.905	3.905	3.905	3.905	2000.0
2007-08-07 07:00:00	AMZN	Stock	3.915	3.925	3.915	3.925	4000.0
2007-08-07 08:00:00	AMZN	Stock	3.9285	3.93	3.9215	3.9255	129000.0
2007-08-07 09:00:00	AMZN	Stock	3.9225	3.944	3.912	3.94	9188780.0
2007-08-07 10:00:00	AMZN	Stock	3.9395	3.9615	3.925	3.934	17368320.0
2007-08-07 11:00:00	AMZN	Stock	3.935	3.961	3.929	3.9595	11402580.0
2007-08-07 12:00:00	AMZN	Stock	3.96	3.9635	3.9315	3.9335	17015220.0
2007-08-07 13:00:00	AMZN	Stock	3.9325	3.9505	3.926	3.9425	7651460.0
2007-08-07 14:00:00	AMZN	Stock	3.942	3.9505	3.8945	3.93	26975600.0
2007-08-07 15:00:00	AMZN	Stock	3.9285	4.0	3.9285	3.956	37887760.0
2007-08-07 16:00:00	AMZN	Stock	3.956	3.965	3.955	3.957	387780.0
2007-08-07 17:00:00	AMZN	Stock	3.9665	3.9665	3.9625	3.965	8000.0
2007-08-07 18:00:00	AMZN	Stock	3.9625	3.9655	3.95	3.9575	152740.0
2007-08-07 19:00:00	AMZN	Stock	3.955	3.959	3.955	3.959	10000.0
2007-08-07 09:00:00	TLT	Stock	87.43	87.43	87.37	87.4	297000.0
2007-08-07 10:00:00	TLT	Stock	87.39	87.45	87.35	87.45	150500.0
2007-08-07 11:00:00	TLT	Stock	87.44	87.49	87.41	87.48	25600.0
2007-08-07 12:00:00	TLT	Stock	87.47	87.55	87.45	87.48	92200.0
2007-08-07 13:00:00	TLT	Stock	87.48	87.58	87.44	87.47	207800.0
2007-08-07 14:00:00	TLT	Stock	87.47	87.71	87.31	87.45	962800.0
2007-08-07 15:00:00	TLT	Stock	87.39	87.4	86.92	87.06	793900.0
2007-08-07 16:00:00	TLT	Stock	87.22	87.22	87.22	87.22	100.0

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

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