PREVIEW / stock_1hour / 2007-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-20.parquet
  size:    765 KB
  rows:    37,244
  symbols: 3,062

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-20 09:00:00	AAPL	Stock	5.0589	5.0657	5.0139	5.03	194904612.0
2007-07-20 10:00:00	AAPL	Stock	5.0293	5.0432	5.0121	5.0289	139986224.0
2007-07-20 11:00:00	AAPL	Stock	5.0289	5.0454	5.0179	5.0279	104033552.0
2007-07-20 12:00:00	AAPL	Stock	5.0282	5.0443	5.0	5.0314	119241220.0
2007-07-20 13:00:00	AAPL	Stock	5.0314	5.0904	5.0286	5.085	143488100.0
2007-07-20 14:00:00	AAPL	Stock	5.085	5.1493	5.0764	5.1286	217919772.0
2007-07-20 15:00:00	AAPL	Stock	5.1282	5.1446	5.0714	5.1346	193759048.0
2007-07-20 16:00:00	AAPL	Stock	5.1339	5.1341	5.1339	5.1339	12063688.0
2007-07-20 09:00:00	MSFT	Stock	31.15	31.2	30.79	30.82	10780497.0
2007-07-20 10:00:00	MSFT	Stock	30.83	31.0	30.79	30.985	12159763.0
2007-07-20 11:00:00	MSFT	Stock	30.98	31.04	30.92	31.01	13469964.0
2007-07-20 12:00:00	MSFT	Stock	31.0	31.02	30.93	30.96	8829826.0
2007-07-20 13:00:00	MSFT	Stock	30.96	31.04	30.92	31.02	7094719.0
2007-07-20 14:00:00	MSFT	Stock	31.02	31.15	30.97	31.09	10663860.0
2007-07-20 15:00:00	MSFT	Stock	31.09	31.19	31.02	31.19	13447262.0
2007-07-20 16:00:00	MSFT	Stock	31.16	31.16	31.16	31.16	1829082.0
2007-07-20 08:00:00	NVDA	Stock	0.7608	0.761	0.7608	0.761	36000.0
2007-07-20 09:00:00	NVDA	Stock	0.761	0.7673	0.7587	0.761	94206300.0
2007-07-20 10:00:00	NVDA	Stock	0.761	0.7677	0.7593	0.766	61336920.0
2007-07-20 11:00:00	NVDA	Stock	0.7662	0.767	0.7532	0.7557	63461040.0
2007-07-20 12:00:00	NVDA	Stock	0.7555	0.7557	0.748	0.7498	46290780.0
2007-07-20 13:00:00	NVDA	Stock	0.7497	0.7558	0.7488	0.7538	39704040.0
2007-07-20 14:00:00	NVDA	Stock	0.754	0.7607	0.7528	0.7593	52020780.0
2007-07-20 15:00:00	NVDA	Stock	0.7593	0.7604	0.7493	0.7517	90298560.0
2007-07-20 16:00:00	NVDA	Stock	0.7517	0.756	0.7503	0.7503	51361500.0
2007-07-20 17:00:00	NVDA	Stock	0.7502	0.7502	0.7502	0.7502	30000.0
2007-07-20 18:00:00	NVDA	Stock	0.75	0.75	0.7467	0.7483	205200.0
2007-07-20 19:00:00	NVDA	Stock	0.7467	0.7467	0.7467	0.7467	6000.0
2007-07-20 08:00:00	AMZN	Stock	3.635	3.635	3.619	3.63	277000.0
2007-07-20 09:00:00	AMZN	Stock	3.626	3.65	3.5625	3.5695	38457980.0
2007-07-20 10:00:00	AMZN	Stock	3.5695	3.6025	3.564	3.5733	20337000.0
2007-07-20 11:00:00	AMZN	Stock	3.573	3.577	3.526	3.534	26319720.0
2007-07-20 12:00:00	AMZN	Stock	3.534	3.567	3.525	3.5535	18033560.0
2007-07-20 13:00:00	AMZN	Stock	3.5545	3.595	3.5535	3.59	21770700.0
2007-07-20 14:00:00	AMZN	Stock	3.5895	3.595	3.563	3.5715	14045020.0
2007-07-20 15:00:00	AMZN	Stock	3.573	3.5875	3.56	3.5815	31740640.0
2007-07-20 16:00:00	AMZN	Stock	3.5805	3.605	3.572	3.6	909940.0
2007-07-20 17:00:00	AMZN	Stock	3.5855	3.596	3.585	3.595	48920.0
2007-07-20 18:00:00	AMZN	Stock	3.5875	3.589	3.58	3.58	67640.0
2007-07-20 19:00:00	AMZN	Stock	3.5805	3.5805	3.5805	3.5805	10000.0
2007-07-20 09:00:00	TLT	Stock	85.38	85.8	85.32	85.75	182300.0
2007-07-20 10:00:00	TLT	Stock	85.74	86.08	85.67	85.85	612200.0
2007-07-20 11:00:00	TLT	Stock	85.87	86.01	85.8	85.97	163000.0
2007-07-20 12:00:00	TLT	Stock	85.98	86.03	85.88	86.03	114200.0
2007-07-20 13:00:00	TLT	Stock	86.03	86.04	85.88	85.9	96800.0
2007-07-20 14:00:00	TLT	Stock	85.91	85.95	85.85	85.86	113950.0
2007-07-20 15:00:00	TLT	Stock	85.86	85.88	85.83	85.86	156200.0
2007-07-20 16:00:00	TLT	Stock	85.87	85.96	85.87	85.96	17900.0
2007-07-20 09:00:00	CL	Stock	34.185	34.245	34.125	34.23	1175600.0
2007-07-20 10:00:00	CL	Stock	34.235	34.37	34.2	34.26	832800.0

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

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