PREVIEW / stock_30min / 2006-07-31

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-07-31.parquet
  size:    905 KB
  rows:    49,732
  symbols: 2,318

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
2006-07-31 06:00:00	AAPL	Stock	2.3821	2.3821	2.3821	2.3821	33600.0
2006-07-31 07:00:00	AAPL	Stock	2.3793	2.3793	2.3732	2.3732	101836.0
2006-07-31 07:30:00	AAPL	Stock	2.3796	2.3829	2.3757	2.3829	28000.0
2006-07-31 08:00:00	AAPL	Stock	2.3821	2.4018	2.3796	2.3982	5472096.0
2006-07-31 08:30:00	AAPL	Stock	2.3982	2.4018	2.3875	2.3914	4563356.0
2006-07-31 09:00:00	AAPL	Stock	2.3889	2.3936	2.3846	2.3864	4235560.0
2006-07-31 09:30:00	AAPL	Stock	2.3868	2.3964	2.3671	2.3896	146081124.0
2006-07-31 10:00:00	AAPL	Stock	2.3896	2.4511	2.3875	2.4414	173504604.0
2006-07-31 10:30:00	AAPL	Stock	2.4414	2.4446	2.4243	2.4343	104633060.0
2006-07-31 11:00:00	AAPL	Stock	2.4343	2.4393	2.4204	2.4264	58706816.0
2006-07-31 11:30:00	AAPL	Stock	2.4264	2.4383	2.4246	2.4268	38649240.0
2006-07-31 12:00:00	AAPL	Stock	2.4268	2.4354	2.4239	2.4279	32561536.0
2006-07-31 12:30:00	AAPL	Stock	2.4279	2.4289	2.4211	2.4214	33703516.0
2006-07-31 13:00:00	AAPL	Stock	2.4218	2.4336	2.4214	2.4318	30424688.0
2006-07-31 13:30:00	AAPL	Stock	2.4318	2.4389	2.4275	2.4289	44214884.0
2006-07-31 14:00:00	AAPL	Stock	2.4289	2.4307	2.4229	2.4286	30027564.0
2006-07-31 14:30:00	AAPL	Stock	2.4286	2.4314	2.4193	2.4268	31851988.0
2006-07-31 15:00:00	AAPL	Stock	2.4264	2.4371	2.4229	2.4329	46319980.0
2006-07-31 15:30:00	AAPL	Stock	2.4332	2.4336	2.4161	2.4246	77921816.0
2006-07-31 16:00:00	AAPL	Stock	2.425	2.4271	2.4232	2.4268	1691172.0
2006-07-31 16:30:00	AAPL	Stock	2.4232	2.4268	2.4221	2.4268	253960.0
2006-07-31 17:00:00	AAPL	Stock	2.425	2.4271	2.4232	2.4243	2921884.0
2006-07-31 17:30:00	AAPL	Stock	2.4232	2.4268	2.4232	2.4264	83748.0
2006-07-31 18:00:00	AAPL	Stock	2.4268	2.4271	2.4246	2.4268	51548.0
2006-07-31 08:00:00	MSFT	Stock	24.23	24.24	24.21	24.22	2690.0
2006-07-31 09:00:00	MSFT	Stock	24.16	24.2	24.07	24.08	26350.0
2006-07-31 09:30:00	MSFT	Stock	24.07	24.34	24.07	24.34	5227924.0
2006-07-31 10:00:00	MSFT	Stock	24.34	24.38	24.27	24.37	2776956.0
2006-07-31 10:30:00	MSFT	Stock	24.37	24.42	24.29	24.3	2225526.0
2006-07-31 11:00:00	MSFT	Stock	24.3	24.33	24.2	24.21	2790977.0
2006-07-31 11:30:00	MSFT	Stock	24.21	24.24	24.11	24.11	2073790.0
2006-07-31 12:00:00	MSFT	Stock	24.11	24.24	24.08	24.183	2170836.0
2006-07-31 12:30:00	MSFT	Stock	24.18	24.2	24.11	24.17	1748474.0
2006-07-31 13:00:00	MSFT	Stock	24.17	24.2	24.11	24.12	1091889.0
2006-07-31 13:30:00	MSFT	Stock	24.12	24.28	24.12	24.188	2696585.0
2006-07-31 14:00:00	MSFT	Stock	24.18	24.22	24.13	24.16	1447566.0
2006-07-31 14:30:00	MSFT	Stock	24.152	24.17	24.11	24.13	2086488.0
2006-07-31 15:00:00	MSFT	Stock	24.13	24.17	24.08	24.08	2947049.0
2006-07-31 15:30:00	MSFT	Stock	24.08	24.12	24.01	24.07	6160264.0
2006-07-31 16:00:00	MSFT	Stock	24.07	24.17	24.03	24.16	328027.0
2006-07-31 16:30:00	MSFT	Stock	24.17	24.17	24.03	24.14	1303389.0
2006-07-31 17:00:00	MSFT	Stock	24.13	24.15	24.12	24.15	3572.0
2006-07-31 17:30:00	MSFT	Stock	24.12	24.12	24.03	24.03	9461.0
2006-07-31 18:00:00	MSFT	Stock	24.03	24.12	24.03	24.12	1438.0
2006-07-31 08:00:00	NVDA	Stock	0.3778	0.3788	0.3778	0.3778	194700.0
2006-07-31 09:00:00	NVDA	Stock	0.3773	0.3775	0.3717	0.3735	507000.0
2006-07-31 09:30:00	NVDA	Stock	0.3738	0.3772	0.3703	0.3727	58767780.0
2006-07-31 10:00:00	NVDA	Stock	0.3727	0.375	0.3687	0.3747	53165160.0
2006-07-31 10:30:00	NVDA	Stock	0.3748	0.3763	0.3712	0.3762	43394700.0
2006-07-31 11:00:00	NVDA	Stock	0.3762	0.3777	0.3732	0.3732	45512460.0

> showing 50 of 49,732 rows — these rows as CSV

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