PREVIEW / stock_1hour / 2007-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-23.parquet
  size:    765 KB
  rows:    37,466
  symbols: 3,081

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-23 09:00:00	AAPL	Stock	5.1182	5.1239	5.0332	5.065	169085896.0
2007-07-23 10:00:00	AAPL	Stock	5.065	5.1375	5.0532	5.1371	195366192.0
2007-07-23 11:00:00	AAPL	Stock	5.1368	5.1507	5.1214	5.1371	144964036.0
2007-07-23 12:00:00	AAPL	Stock	5.1368	5.1864	5.13	5.18	140462756.0
2007-07-23 13:00:00	AAPL	Stock	5.1799	5.1821	5.1143	5.1264	117794376.0
2007-07-23 14:00:00	AAPL	Stock	5.1261	5.1589	5.12	5.1454	90153364.0
2007-07-23 15:00:00	AAPL	Stock	5.1454	5.1611	5.1071	5.1318	136820096.0
2007-07-23 16:00:00	AAPL	Stock	5.1307	5.1321	5.1307	5.1321	8082592.0
2007-07-23 09:00:00	MSFT	Stock	31.36	31.39	31.15	31.208	4149018.0
2007-07-23 10:00:00	MSFT	Stock	31.2	31.5	31.17	31.49	10491064.0
2007-07-23 11:00:00	MSFT	Stock	31.5	31.52	31.37	31.43	7181885.0
2007-07-23 12:00:00	MSFT	Stock	31.42	31.45	31.33	31.405	4129833.0
2007-07-23 13:00:00	MSFT	Stock	31.405	31.43	31.31	31.33	4078362.0
2007-07-23 14:00:00	MSFT	Stock	31.33	31.4	31.26	31.34	5563724.0
2007-07-23 15:00:00	MSFT	Stock	31.34	31.35	31.12	31.17	10837908.0
2007-07-23 16:00:00	MSFT	Stock	31.17	31.19	31.17	31.19	1362398.0
2007-07-23 08:00:00	NVDA	Stock	0.7508	0.7508	0.7508	0.7508	54000.0
2007-07-23 09:00:00	NVDA	Stock	0.7483	0.7647	0.7467	0.7567	37094760.0
2007-07-23 10:00:00	NVDA	Stock	0.7567	0.7722	0.7508	0.7705	76500780.0
2007-07-23 11:00:00	NVDA	Stock	0.7705	0.7747	0.7677	0.7685	59231940.0
2007-07-23 12:00:00	NVDA	Stock	0.7685	0.769	0.764	0.766	31946820.0
2007-07-23 13:00:00	NVDA	Stock	0.766	0.7665	0.7605	0.7618	27840060.0
2007-07-23 14:00:00	NVDA	Stock	0.7618	0.7642	0.758	0.7635	35303880.0
2007-07-23 15:00:00	NVDA	Stock	0.7633	0.7645	0.7563	0.7585	59766780.0
2007-07-23 16:00:00	NVDA	Stock	0.7585	0.7649	0.7568	0.7583	5292720.0
2007-07-23 17:00:00	NVDA	Stock	0.7583	0.7583	0.757	0.757	130500.0
2007-07-23 07:00:00	AMZN	Stock	3.58	3.6	3.5775	3.6	14000.0
2007-07-23 08:00:00	AMZN	Stock	3.585	3.6225	3.5805	3.6025	259440.0
2007-07-23 09:00:00	AMZN	Stock	3.605	3.6335	3.5607	3.5705	36962400.0
2007-07-23 10:00:00	AMZN	Stock	3.572	3.5805	3.5425	3.5675	28381200.0
2007-07-23 11:00:00	AMZN	Stock	3.5675	3.62	3.5675	3.6015	22077180.0
2007-07-23 12:00:00	AMZN	Stock	3.6015	3.61	3.591	3.6035	15314880.0
2007-07-23 13:00:00	AMZN	Stock	3.6045	3.6105	3.5875	3.597	10495580.0
2007-07-23 14:00:00	AMZN	Stock	3.597	3.601	3.5735	3.599	22278360.0
2007-07-23 15:00:00	AMZN	Stock	3.599	3.6095	3.572	3.583	30440200.0
2007-07-23 16:00:00	AMZN	Stock	3.583	3.6015	3.5795	3.589	3082600.0
2007-07-23 17:00:00	AMZN	Stock	3.591	3.6	3.5875	3.6	87220.0
2007-07-23 18:00:00	AMZN	Stock	3.6	3.601	3.5945	3.5945	25000.0
2007-07-23 19:00:00	AMZN	Stock	3.596	3.6025	3.5925	3.602	80880.0
2007-07-23 09:00:00	TLT	Stock	85.69	85.8	85.69	85.79	110800.0
2007-07-23 10:00:00	TLT	Stock	85.79	85.97	85.73	85.82	291100.0
2007-07-23 11:00:00	TLT	Stock	85.82	85.87	85.71	85.77	99600.0
2007-07-23 12:00:00	TLT	Stock	85.78	85.81	85.73	85.77	65900.0
2007-07-23 13:00:00	TLT	Stock	85.77	85.85	85.76	85.81	12600.0
2007-07-23 14:00:00	TLT	Stock	85.81	85.83	85.76	85.81	41600.0
2007-07-23 15:00:00	TLT	Stock	85.81	85.84	85.76	85.82	125400.0
2007-07-23 16:00:00	TLT	Stock	85.83	85.9	85.82	85.82	25700.0
2007-07-23 09:00:00	CL	Stock	33.955	34.315	33.905	34.275	633400.0
2007-07-23 10:00:00	CL	Stock	34.27	34.39	34.265	34.36	876800.0
2007-07-23 11:00:00	CL	Stock	34.36	34.45	34.325	34.445	706600.0

> showing 50 of 37,466 rows — these rows as CSV

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