PREVIEW / stock_30min / 2010-04-01

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-01.parquet
  size:    1.4 MB
  rows:    74,246
  symbols: 3,466

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
2010-04-01 05:00:00	AAPL	Stock	8.4021	8.4275	8.4018	8.4275	22400.0
2010-04-01 05:30:00	AAPL	Stock	8.4121	8.4368	8.4121	8.4368	30800.0
2010-04-01 06:00:00	AAPL	Stock	8.4354	8.4354	8.4354	8.4354	2800.0
2010-04-01 06:30:00	AAPL	Stock	8.435	8.4357	8.435	8.4357	33600.0
2010-04-01 07:00:00	AAPL	Stock	8.425	8.4364	8.4143	8.43	86800.0
2010-04-01 07:30:00	AAPL	Stock	8.4286	8.4614	8.4286	8.4543	320824.0
2010-04-01 08:00:00	AAPL	Stock	8.46	8.4614	8.3929	8.4536	3134740.0
2010-04-01 08:30:00	AAPL	Stock	8.4532	8.4743	8.3929	8.4675	2396268.0
2010-04-01 09:00:00	AAPL	Stock	8.4661	8.4821	8.4071	8.4814	1575028.0
2010-04-01 09:30:00	AAPL	Stock	8.4796	8.5261	8.4643	8.5021	114475620.0
2010-04-01 10:00:00	AAPL	Stock	8.5018	8.5107	8.4586	8.4786	52121384.0
2010-04-01 10:30:00	AAPL	Stock	8.4786	8.4918	8.4607	8.4713	30656052.0
2010-04-01 11:00:00	AAPL	Stock	8.4715	8.4739	8.4475	8.4664	29950088.0
2010-04-01 11:30:00	AAPL	Stock	8.4668	8.4698	8.4593	8.4697	17182620.0
2010-04-01 12:00:00	AAPL	Stock	8.4696	8.4782	8.4568	8.4582	16056096.0
2010-04-01 12:30:00	AAPL	Stock	8.4589	8.4721	8.4532	8.4675	13321140.0
2010-04-01 13:00:00	AAPL	Stock	8.4664	8.47	8.4579	8.4579	15249752.0
2010-04-01 13:30:00	AAPL	Stock	8.4575	8.4604	8.3893	8.4093	52897208.0
2010-04-01 14:00:00	AAPL	Stock	8.4082	8.4114	8.3614	8.3668	54660480.0
2010-04-01 14:30:00	AAPL	Stock	8.367	8.3804	8.3125	8.3668	77079380.0
2010-04-01 15:00:00	AAPL	Stock	8.3668	8.3818	8.3586	8.3686	41155576.0
2010-04-01 15:30:00	AAPL	Stock	8.3686	8.4275	8.3682	8.4275	66800524.0
2010-04-01 16:00:00	AAPL	Stock	8.4275	8.4671	8.3804	8.4204	9823016.0
2010-04-01 16:30:00	AAPL	Stock	8.42	8.425	8.3694	8.425	342020.0
2010-04-01 17:00:00	AAPL	Stock	8.4257	8.4279	8.3975	8.425	632604.0
2010-04-01 17:30:00	AAPL	Stock	8.425	8.4275	8.425	8.4268	133644.0
2010-04-01 18:00:00	AAPL	Stock	8.4271	8.4275	8.4254	8.4268	91196.0
2010-04-01 18:30:00	AAPL	Stock	8.425	8.4286	8.4218	8.4286	195160.0
2010-04-01 19:00:00	AAPL	Stock	8.4286	8.4311	8.4282	8.4311	155064.0
2010-04-01 19:30:00	AAPL	Stock	8.4321	8.4321	8.425	8.4286	253204.0
2010-04-01 08:00:00	MSFT	Stock	29.43	29.48	29.4	29.48	15614.0
2010-04-01 08:30:00	MSFT	Stock	29.45	29.48	29.43	29.43	12776.0
2010-04-01 09:00:00	MSFT	Stock	29.42	29.45	29.288	29.38	11354.0
2010-04-01 09:30:00	MSFT	Stock	29.37	29.54	29.35	29.35	5521853.0
2010-04-01 10:00:00	MSFT	Stock	29.36	29.43	29.14	29.2	5988995.0
2010-04-01 10:30:00	MSFT	Stock	29.195	29.2	29.06	29.16	5769306.0
2010-04-01 11:00:00	MSFT	Stock	29.17	29.22	29.14	29.2	2431609.0
2010-04-01 11:30:00	MSFT	Stock	29.21	29.24	29.09	29.095	2420093.0
2010-04-01 12:00:00	MSFT	Stock	29.09	29.27	29.01	29.015	3931087.0
2010-04-01 12:30:00	MSFT	Stock	29.01	29.02	28.8	28.945	8151934.0
2010-04-01 13:00:00	MSFT	Stock	28.94	28.97	28.84	28.94	4189682.0
2010-04-01 13:30:00	MSFT	Stock	28.95	29.0	28.68	28.72	6060185.0
2010-04-01 14:00:00	MSFT	Stock	28.723	28.76	28.62	28.74	5560051.0
2010-04-01 14:30:00	MSFT	Stock	28.74	28.87	28.67	28.86	4605171.0
2010-04-01 15:00:00	MSFT	Stock	28.86	29.04	28.84	28.95	6255086.0
2010-04-01 15:30:00	MSFT	Stock	28.955	29.16	28.95	29.14	8996916.0
2010-04-01 16:00:00	MSFT	Stock	29.14	29.19	28.848	29.12	2308923.0
2010-04-01 16:30:00	MSFT	Stock	28.967	29.15	28.967	29.12	547291.0
2010-04-01 17:00:00	MSFT	Stock	29.11	29.12	29.11	29.12	3611.0
2010-04-01 17:30:00	MSFT	Stock	29.13	29.13	29.11	29.11	911.0

> showing 50 of 74,246 rows — these rows as CSV

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