PREVIEW / stock_30min / 2007-11-20

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-20.parquet
  size:    1.2 MB
  rows:    68,716
  symbols: 3,212

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-11-20 06:30:00	AAPL	Stock	5.9525	6.0175	5.9525	6.0175	173124.0
2007-11-20 07:00:00	AAPL	Stock	6.0175	6.0175	5.9911	5.9982	448728.0
2007-11-20 07:30:00	AAPL	Stock	5.9982	6.0004	5.9179	5.9636	983612.0
2007-11-20 08:00:00	AAPL	Stock	5.9518	5.9814	5.9296	5.9346	4270224.0
2007-11-20 08:30:00	AAPL	Stock	5.9361	5.9411	5.8993	5.9286	3719016.0
2007-11-20 09:00:00	AAPL	Stock	5.9286	5.9418	5.9	5.9179	2278640.0
2007-11-20 09:30:00	AAPL	Stock	5.9179	6.0554	5.8936	6.0393	170070824.0
2007-11-20 10:00:00	AAPL	Stock	6.0397	6.1032	6.0275	6.0514	147162372.0
2007-11-20 10:30:00	AAPL	Stock	6.0514	6.1139	6.035	6.1111	106436036.0
2007-11-20 11:00:00	AAPL	Stock	6.1107	6.1354	6.0743	6.0943	91592312.0
2007-11-20 11:30:00	AAPL	Stock	6.0942	6.1214	6.0789	6.0829	63590436.0
2007-11-20 12:00:00	AAPL	Stock	6.0836	6.0918	6.0257	6.0529	98005516.0
2007-11-20 12:30:00	AAPL	Stock	6.0529	6.0607	5.9957	6.0121	87868536.0
2007-11-20 13:00:00	AAPL	Stock	6.013	6.0132	5.9218	5.9421	116543056.0
2007-11-20 13:30:00	AAPL	Stock	5.9425	6.0214	5.9375	6.0071	75235132.0
2007-11-20 14:00:00	AAPL	Stock	6.0068	6.0429	5.8929	5.9029	140529144.0
2007-11-20 14:30:00	AAPL	Stock	5.9029	5.9757	5.8779	5.9161	128323776.0
2007-11-20 15:00:00	AAPL	Stock	5.9143	5.9914	5.8404	5.9594	133704116.0
2007-11-20 15:30:00	AAPL	Stock	5.9596	6.0732	5.9554	6.0287	161753312.0
2007-11-20 16:00:00	AAPL	Stock	6.0332	6.05	5.9634	6.0304	6951168.0
2007-11-20 16:30:00	AAPL	Stock	6.0321	6.0354	6.0043	6.0321	707560.0
2007-11-20 17:00:00	AAPL	Stock	6.0321	6.0482	6.0304	6.0482	1107512.0
2007-11-20 17:30:00	AAPL	Stock	6.0482	6.05	6.0396	6.0429	669732.0
2007-11-20 18:00:00	AAPL	Stock	6.0429	6.0471	6.0279	6.0289	512232.0
2007-11-20 18:30:00	AAPL	Stock	6.0389	6.0425	6.0329	6.0396	110656.0
2007-11-20 19:00:00	AAPL	Stock	6.0396	6.0396	6.0143	6.0246	383432.0
2007-11-20 19:30:00	AAPL	Stock	6.0246	6.0396	6.0196	6.0196	502208.0
2007-11-20 07:00:00	MSFT	Stock	34.2	34.2	34.19	34.2	600.0
2007-11-20 07:30:00	MSFT	Stock	34.13	34.13	34.11	34.12	400.0
2007-11-20 08:00:00	MSFT	Stock	34.1	34.25	34.09	34.22	32483.0
2007-11-20 08:30:00	MSFT	Stock	34.25	34.35	34.12	34.13	69392.0
2007-11-20 09:00:00	MSFT	Stock	34.13	34.24	33.96	34.16	914874.0
2007-11-20 09:30:00	MSFT	Stock	34.21	34.62	34.1	34.54	7694965.0
2007-11-20 10:00:00	MSFT	Stock	34.54	34.68	34.36	34.49	6338868.0
2007-11-20 10:30:00	MSFT	Stock	34.49	34.82	34.45	34.73	5650930.0
2007-11-20 11:00:00	MSFT	Stock	34.73	34.85	34.67	34.78	4797448.0
2007-11-20 11:30:00	MSFT	Stock	34.78	34.81	34.73	34.803	3669868.0
2007-11-20 12:00:00	MSFT	Stock	34.8	34.97	34.76	34.91	6033431.0
2007-11-20 12:30:00	MSFT	Stock	34.915	34.94	34.74	34.828	5659729.0
2007-11-20 13:00:00	MSFT	Stock	34.8	34.81	34.53	34.56	10459915.0
2007-11-20 13:30:00	MSFT	Stock	34.56	34.65	34.54	34.58	3806035.0
2007-11-20 14:00:00	MSFT	Stock	34.58	34.65	34.45	34.47	10024048.0
2007-11-20 14:30:00	MSFT	Stock	34.46	34.59	34.39	34.43	7724111.0
2007-11-20 15:00:00	MSFT	Stock	34.43	34.65	34.37	34.619	9193344.0
2007-11-20 15:30:00	MSFT	Stock	34.61	34.82	34.51	34.63	14584082.0
2007-11-20 16:00:00	MSFT	Stock	34.63	34.85	34.56	34.62	1650072.0
2007-11-20 16:30:00	MSFT	Stock	34.58	34.63	34.58	34.63	178335.0
2007-11-20 17:00:00	MSFT	Stock	34.65	34.73	34.65	34.73	9331.0
2007-11-20 17:30:00	MSFT	Stock	34.747	34.747	34.58	34.58	1504540.0
2007-11-20 18:00:00	MSFT	Stock	34.73	34.73	34.7	34.7	1674.0

> showing 50 of 68,716 rows — these rows as CSV

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