PREVIEW / stock_30min / 2007-07-20

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-20.parquet
  size:    1.1 MB
  rows:    63,695
  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:30: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.0236	5.0311	69574148.0
2007-07-20 10:30:00	AAPL	Stock	5.0311	5.0357	5.0121	5.0289	70412076.0
2007-07-20 11:00:00	AAPL	Stock	5.0289	5.0446	5.0282	5.0386	46125380.0
2007-07-20 11:30:00	AAPL	Stock	5.0381	5.0454	5.0179	5.0279	57908172.0
2007-07-20 12:00:00	AAPL	Stock	5.0282	5.0332	5.0	5.0329	65965536.0
2007-07-20 12:30:00	AAPL	Stock	5.0329	5.0443	5.0257	5.0314	53275684.0
2007-07-20 13:00:00	AAPL	Stock	5.0314	5.0679	5.0286	5.0568	69348468.0
2007-07-20 13:30:00	AAPL	Stock	5.0563	5.0904	5.0514	5.085	74139632.0
2007-07-20 14:00:00	AAPL	Stock	5.085	5.1493	5.0764	5.1136	130450208.0
2007-07-20 14:30:00	AAPL	Stock	5.1136	5.1368	5.1054	5.1286	87469564.0
2007-07-20 15:00:00	AAPL	Stock	5.1282	5.1446	5.1232	5.1311	78323616.0
2007-07-20 15:30:00	AAPL	Stock	5.1314	5.1361	5.0714	5.1346	115435432.0
2007-07-20 16:00:00	AAPL	Stock	5.1339	5.1341	5.1339	5.1339	12063688.0
2007-07-20 09:30:00	MSFT	Stock	31.15	31.2	30.79	30.82	10780497.0
2007-07-20 10:00:00	MSFT	Stock	30.83	30.89	30.79	30.84	5439100.0
2007-07-20 10:30:00	MSFT	Stock	30.84	31.0	30.84	30.985	6720663.0
2007-07-20 11:00:00	MSFT	Stock	30.98	31.0	30.92	30.98	5470534.0
2007-07-20 11:30:00	MSFT	Stock	30.98	31.04	30.95	31.01	7999430.0
2007-07-20 12:00:00	MSFT	Stock	31.0	31.02	30.93	31.0	4482441.0
2007-07-20 12:30:00	MSFT	Stock	31.01	31.01	30.94	30.96	4347385.0
2007-07-20 13:00:00	MSFT	Stock	30.96	31.0	30.92	30.96	3799856.0
2007-07-20 13:30:00	MSFT	Stock	30.96	31.04	30.95	31.02	3294863.0
2007-07-20 14:00:00	MSFT	Stock	31.02	31.15	30.97	31.13	6506129.0
2007-07-20 14:30:00	MSFT	Stock	31.13	31.14	31.04	31.09	4157731.0
2007-07-20 15:00:00	MSFT	Stock	31.09	31.18	31.05	31.1	5099558.0
2007-07-20 15:30:00	MSFT	Stock	31.1	31.19	31.02	31.19	8347704.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.7608	0.7608	0.7608	24000.0
2007-07-20 08:30:00	NVDA	Stock	0.761	0.761	0.761	0.761	12000.0
2007-07-20 09:00:00	NVDA	Stock	0.761	0.7648	0.76	0.7647	901800.0
2007-07-20 09:30:00	NVDA	Stock	0.7647	0.7673	0.7587	0.761	93304500.0
2007-07-20 10:00:00	NVDA	Stock	0.761	0.7667	0.7593	0.7655	28457340.0
2007-07-20 10:30:00	NVDA	Stock	0.7657	0.7677	0.7635	0.766	32879580.0
2007-07-20 11:00:00	NVDA	Stock	0.7662	0.767	0.7627	0.7643	32120160.0
2007-07-20 11:30:00	NVDA	Stock	0.7647	0.7647	0.7532	0.7557	31340880.0
2007-07-20 12:00:00	NVDA	Stock	0.7555	0.7557	0.75	0.7517	19821480.0
2007-07-20 12:30:00	NVDA	Stock	0.7517	0.753	0.748	0.7498	26469300.0
2007-07-20 13:00:00	NVDA	Stock	0.7497	0.7532	0.7488	0.7516	19095060.0
2007-07-20 13:30:00	NVDA	Stock	0.7517	0.7558	0.7508	0.7538	20608980.0
2007-07-20 14:00:00	NVDA	Stock	0.754	0.7603	0.7528	0.7582	27787140.0
2007-07-20 14:30:00	NVDA	Stock	0.758	0.7607	0.756	0.7593	24233640.0
2007-07-20 15:00:00	NVDA	Stock	0.7593	0.7604	0.7543	0.7543	33196560.0
2007-07-20 15:30:00	NVDA	Stock	0.7545	0.7553	0.7493	0.7517	57102000.0
2007-07-20 16:00:00	NVDA	Stock	0.7517	0.756	0.7505	0.756	51290700.0
2007-07-20 16:30:00	NVDA	Stock	0.751	0.751	0.7503	0.7503	70800.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.7467	146100.0
2007-07-20 18:30:00	NVDA	Stock	0.7477	0.7483	0.7475	0.7483	59100.0
2007-07-20 19:00:00	NVDA	Stock	0.7467	0.7467	0.7467	0.7467	6000.0

> showing 50 of 63,695 rows — these rows as CSV

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