PREVIEW / stock_30min / 2010-01-12

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-12.parquet
  size:    1.4 MB
  rows:    74,701
  symbols: 3,447

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-01-12 04:00:00	AAPL	Stock	7.4768	7.4768	7.4625	7.4625	11200.0
2010-01-12 04:30:00	AAPL	Stock	7.4557	7.4557	7.4557	7.4557	2800.0
2010-01-12 06:30:00	AAPL	Stock	7.4632	7.4632	7.4632	7.4632	2800.0
2010-01-12 07:00:00	AAPL	Stock	7.4325	7.46	7.4286	7.4496	25060.0
2010-01-12 07:30:00	AAPL	Stock	7.4496	7.4593	7.4496	7.4582	20048.0
2010-01-12 08:00:00	AAPL	Stock	7.4589	7.4643	7.4375	7.4443	930860.0
2010-01-12 08:30:00	AAPL	Stock	7.4396	7.4496	7.4393	7.4404	827204.0
2010-01-12 09:00:00	AAPL	Stock	7.4379	7.4725	7.4346	7.4721	1286208.0
2010-01-12 09:30:00	AAPL	Stock	7.4711	7.4851	7.4079	7.4264	95089204.0
2010-01-12 10:00:00	AAPL	Stock	7.4264	7.4664	7.4196	7.4614	49991564.0
2010-01-12 10:30:00	AAPL	Stock	7.4607	7.4864	7.4382	7.4725	39542216.0
2010-01-12 11:00:00	AAPL	Stock	7.4725	7.4918	7.4579	7.4689	30639476.0
2010-01-12 11:30:00	AAPL	Stock	7.4684	7.4811	7.455	7.4671	23906428.0
2010-01-12 12:00:00	AAPL	Stock	7.4661	7.4693	7.4136	7.4171	30592940.0
2010-01-12 12:30:00	AAPL	Stock	7.4182	7.4411	7.4107	7.425	37756852.0
2010-01-12 13:00:00	AAPL	Stock	7.425	7.4389	7.4154	7.426	26383028.0
2010-01-12 13:30:00	AAPL	Stock	7.426	7.4321	7.4054	7.4318	25077192.0
2010-01-12 14:00:00	AAPL	Stock	7.4314	7.4321	7.3871	7.4004	32782148.0
2010-01-12 14:30:00	AAPL	Stock	7.4004	7.4143	7.3871	7.4068	28627508.0
2010-01-12 15:00:00	AAPL	Stock	7.4071	7.4071	7.3721	7.3996	40645780.0
2010-01-12 15:30:00	AAPL	Stock	7.3996	7.4196	7.3737	7.4189	57767948.0
2010-01-12 16:00:00	AAPL	Stock	7.4189	7.4317	7.4136	7.4186	9043720.0
2010-01-12 16:30:00	AAPL	Stock	7.4372	7.5039	7.4027	7.4229	742560.0
2010-01-12 17:00:00	AAPL	Stock	7.4229	7.425	7.4186	7.4221	111216.0
2010-01-12 17:30:00	AAPL	Stock	7.4218	7.4243	7.4186	7.4186	39508.0
2010-01-12 18:00:00	AAPL	Stock	7.4204	7.4218	7.4129	7.4139	714448.0
2010-01-12 18:30:00	AAPL	Stock	7.4139	7.4164	7.3964	7.3971	139580.0
2010-01-12 19:00:00	AAPL	Stock	7.4	7.4107	7.3946	7.4107	154364.0
2010-01-12 19:30:00	AAPL	Stock	7.4086	7.4186	7.4086	7.4175	180936.0
2010-01-12 06:00:00	MSFT	Stock	30.02	30.02	30.0	30.0	1300.0
2010-01-12 06:30:00	MSFT	Stock	29.99	29.99	29.99	29.99	1000.0
2010-01-12 07:00:00	MSFT	Stock	29.98	30.06	29.97	30.06	1582.0
2010-01-12 07:30:00	MSFT	Stock	30.05	30.05	30.05	30.05	150.0
2010-01-12 08:00:00	MSFT	Stock	30.06	30.1	30.0	30.05	16867.0
2010-01-12 08:30:00	MSFT	Stock	30.05	30.07	30.04	30.07	8375.0
2010-01-12 09:00:00	MSFT	Stock	30.07	30.18	30.05	30.18	26710.0
2010-01-12 09:30:00	MSFT	Stock	30.18	30.22	29.93	30.15	8269262.0
2010-01-12 10:00:00	MSFT	Stock	30.16	30.33	30.12	30.32	4840588.0
2010-01-12 10:30:00	MSFT	Stock	30.31	30.4	30.24	30.36	3194997.0
2010-01-12 11:00:00	MSFT	Stock	30.365	30.395	30.27	30.285	2543968.0
2010-01-12 11:30:00	MSFT	Stock	30.29	30.31	30.15	30.17	2848353.0
2010-01-12 12:00:00	MSFT	Stock	30.17	30.18	30.05	30.08	3619195.0
2010-01-12 12:30:00	MSFT	Stock	30.08	30.14	30.0	30.01	3523319.0
2010-01-12 13:00:00	MSFT	Stock	30.005	30.03	29.96	29.96	3875283.0
2010-01-12 13:30:00	MSFT	Stock	29.96	30.09	29.91	30.03	4497540.0
2010-01-12 14:00:00	MSFT	Stock	30.04	30.11	30.0	30.06	3420093.0
2010-01-12 14:30:00	MSFT	Stock	30.06	30.1	30.0	30.085	2781027.0
2010-01-12 15:00:00	MSFT	Stock	30.09	30.12	30.01	30.12	4602465.0
2010-01-12 15:30:00	MSFT	Stock	30.11	30.13	30.01	30.1	10928058.0
2010-01-12 16:00:00	MSFT	Stock	30.07	30.27	30.04	30.07	5361423.0

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

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