PREVIEW / stock_30min / 2008-03-17

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-17.parquet
  size:    1.2 MB
  rows:    69,633
  symbols: 3,282

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
2008-03-17 05:00:00	AAPL	Stock	4.3975	4.3975	4.3975	4.3975	2800.0
2008-03-17 06:30:00	AAPL	Stock	4.4014	4.4014	4.4014	4.4014	28000.0
2008-03-17 07:00:00	AAPL	Stock	4.4036	4.4171	4.3929	4.3961	70000.0
2008-03-17 07:30:00	AAPL	Stock	4.4	4.4243	4.4	4.4243	46200.0
2008-03-17 08:00:00	AAPL	Stock	4.4107	4.4264	4.3821	4.3821	3209612.0
2008-03-17 08:30:00	AAPL	Stock	4.3814	4.3821	4.3493	4.3711	2080316.0
2008-03-17 09:00:00	AAPL	Stock	4.3714	4.3857	4.3643	4.3793	1806084.0
2008-03-17 09:30:00	AAPL	Stock	4.3811	4.4811	4.375	4.4564	116211676.0
2008-03-17 10:00:00	AAPL	Stock	4.4571	4.4911	4.4296	4.4853	71158500.0
2008-03-17 10:30:00	AAPL	Stock	4.4854	4.5143	4.4482	4.4954	84395976.0
2008-03-17 11:00:00	AAPL	Stock	4.495	4.5054	4.4557	4.4664	61554752.0
2008-03-17 11:30:00	AAPL	Stock	4.4668	4.4804	4.4511	4.4529	48781208.0
2008-03-17 12:00:00	AAPL	Stock	4.4532	4.465	4.3975	4.4029	62746964.0
2008-03-17 12:30:00	AAPL	Stock	4.4032	4.4332	4.3961	4.4145	43719844.0
2008-03-17 13:00:00	AAPL	Stock	4.4145	4.42	4.3864	4.3946	46531324.0
2008-03-17 13:30:00	AAPL	Stock	4.3957	4.4643	4.3825	4.4525	76553092.0
2008-03-17 14:00:00	AAPL	Stock	4.4532	4.4746	4.4414	4.4518	68944316.0
2008-03-17 14:30:00	AAPL	Stock	4.4514	4.5246	4.4411	4.515	95062716.0
2008-03-17 15:00:00	AAPL	Stock	4.515	4.5889	4.5075	4.5604	148673840.0
2008-03-17 15:30:00	AAPL	Stock	4.56	4.5925	4.5264	4.5264	105969864.0
2008-03-17 16:00:00	AAPL	Stock	4.5264	4.5439	4.4789	4.5439	13943188.0
2008-03-17 16:30:00	AAPL	Stock	4.5457	4.55	4.5436	4.5479	416808.0
2008-03-17 17:00:00	AAPL	Stock	4.5507	4.5529	4.5261	4.5464	1899996.0
2008-03-17 17:30:00	AAPL	Stock	4.5464	4.5493	4.5261	4.5461	1016064.0
2008-03-17 18:00:00	AAPL	Stock	4.5446	4.5493	4.5429	4.5493	91168.0
2008-03-17 18:30:00	AAPL	Stock	4.5464	4.5464	4.54	4.5457	185696.0
2008-03-17 19:00:00	AAPL	Stock	4.5404	4.5461	4.5404	4.5461	97300.0
2008-03-17 19:30:00	AAPL	Stock	4.5464	4.5571	4.5464	4.555	282380.0
2008-03-17 05:00:00	MSFT	Stock	27.58	27.58	27.56	27.56	400.0
2008-03-17 07:00:00	MSFT	Stock	27.5	27.5	27.4	27.4	1700.0
2008-03-17 07:30:00	MSFT	Stock	27.4	27.4	27.39	27.4	6463.0
2008-03-17 08:00:00	MSFT	Stock	27.35	27.4	27.21	27.25	59954.0
2008-03-17 08:30:00	MSFT	Stock	27.25	27.34	27.2	27.22	83600.0
2008-03-17 09:00:00	MSFT	Stock	27.22	27.39	27.16	27.39	226889.0
2008-03-17 09:30:00	MSFT	Stock	27.39	28.01	27.28	27.91	8208881.0
2008-03-17 10:00:00	MSFT	Stock	27.91	28.02	27.79	27.917	4737107.0
2008-03-17 10:30:00	MSFT	Stock	27.91	28.05	27.79	27.97	5166461.0
2008-03-17 11:00:00	MSFT	Stock	27.97	28.18	27.95	28.17	6823845.0
2008-03-17 11:30:00	MSFT	Stock	28.17	28.4	28.16	28.21	6416144.0
2008-03-17 12:00:00	MSFT	Stock	28.21	28.211	28.02	28.06	5181361.0
2008-03-17 12:30:00	MSFT	Stock	28.06	28.06	27.78	28.03	4882065.0
2008-03-17 13:00:00	MSFT	Stock	28.03	28.05	27.73	27.82	3760468.0
2008-03-17 13:30:00	MSFT	Stock	27.82	28.04	27.77	28.03	3726392.0
2008-03-17 14:00:00	MSFT	Stock	28.04	28.17	28.0	28.015	3568081.0
2008-03-17 14:30:00	MSFT	Stock	28.01	28.4	27.97	28.32	5833411.0
2008-03-17 15:00:00	MSFT	Stock	28.32	28.64	28.25	28.6	9460697.0
2008-03-17 15:30:00	MSFT	Stock	28.61	28.73	28.29	28.315	9798402.0
2008-03-17 16:00:00	MSFT	Stock	28.3	28.495	28.129	28.14	2706320.0
2008-03-17 16:30:00	MSFT	Stock	28.152	28.47	28.152	28.4	41649.0
2008-03-17 17:00:00	MSFT	Stock	28.45	28.45	28.3	28.3	535251.0

> showing 50 of 69,633 rows — these rows as CSV

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