PREVIEW / stock_30min / 2014-05-29

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-29.parquet
  size:    1.6 MB
  rows:    81,119
  symbols: 3,550

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
2014-05-29 04:30:00	AAPL	Stock	22.3789	22.3789	22.3789	22.3789	5600.0
2014-05-29 05:00:00	AAPL	Stock	22.3821	22.3821	22.3821	22.3821	5600.0
2014-05-29 05:30:00	AAPL	Stock	22.3571	22.3643	22.3571	22.3643	33600.0
2014-05-29 06:00:00	AAPL	Stock	22.3311	22.4071	22.3311	22.405	39032.0
2014-05-29 06:30:00	AAPL	Stock	22.3661	22.3661	22.3571	22.3571	11200.0
2014-05-29 07:00:00	AAPL	Stock	22.3686	22.3686	22.34	22.3496	59108.0
2014-05-29 07:30:00	AAPL	Stock	22.3525	22.3811	22.3514	22.3696	110544.0
2014-05-29 08:00:00	AAPL	Stock	22.3804	22.3839	22.3464	22.3732	426188.0
2014-05-29 08:30:00	AAPL	Stock	22.3586	22.3929	22.3429	22.3821	747796.0
2014-05-29 09:00:00	AAPL	Stock	22.3839	22.4343	22.3796	22.4232	1624784.0
2014-05-29 09:30:00	AAPL	Stock	22.4232	22.5218	22.4204	22.5011	50859368.0
2014-05-29 10:00:00	AAPL	Stock	22.4964	22.5179	22.4507	22.503	24069304.0
2014-05-29 10:30:00	AAPL	Stock	22.4968	22.505	22.4221	22.4614	21540624.0
2014-05-29 11:00:00	AAPL	Stock	22.4596	22.4893	22.4329	22.4854	12838448.0
2014-05-29 11:30:00	AAPL	Stock	22.4852	22.4943	22.4554	22.46	6917540.0
2014-05-29 12:00:00	AAPL	Stock	22.4596	22.4929	22.4321	22.4929	10078320.0
2014-05-29 12:30:00	AAPL	Stock	22.4929	22.53	22.4736	22.5286	12066656.0
2014-05-29 13:00:00	AAPL	Stock	22.5264	22.6264	22.525	22.61	21607348.0
2014-05-29 13:30:00	AAPL	Stock	22.6096	22.6407	22.5732	22.6157	20721540.0
2014-05-29 14:00:00	AAPL	Stock	22.6118	22.7139	22.6075	22.7139	22565732.0
2014-05-29 14:30:00	AAPL	Stock	22.7121	22.73	22.6614	22.7029	18195576.0
2014-05-29 15:00:00	AAPL	Stock	22.7036	22.7454	22.6882	22.6961	16167620.0
2014-05-29 15:30:00	AAPL	Stock	22.6964	22.7036	22.6161	22.6886	37371124.0
2014-05-29 16:00:00	AAPL	Stock	22.6886	22.6993	22.5652	22.6921	9601928.0
2014-05-29 16:30:00	AAPL	Stock	22.6929	22.7243	22.6921	22.7139	561988.0
2014-05-29 17:00:00	AAPL	Stock	22.7004	22.7321	22.6921	22.7321	536340.0
2014-05-29 17:30:00	AAPL	Stock	22.7321	22.7446	22.7146	22.7446	741748.0
2014-05-29 18:00:00	AAPL	Stock	22.7354	22.7461	22.6921	22.745	196224.0
2014-05-29 18:30:00	AAPL	Stock	22.7414	22.7464	22.7321	22.7321	156688.0
2014-05-29 19:00:00	AAPL	Stock	22.7325	22.7354	22.7325	22.7354	5600.0
2014-05-29 19:30:00	AAPL	Stock	22.7286	22.7393	22.7286	22.7393	120708.0
2014-05-29 08:30:00	MSFT	Stock	40.11	40.11	40.11	40.11	300.0
2014-05-29 09:00:00	MSFT	Stock	40.11	40.18	40.09	40.12	10226.0
2014-05-29 09:30:00	MSFT	Stock	40.15	40.19	39.915	39.945	2539692.0
2014-05-29 10:00:00	MSFT	Stock	39.94	40.07	39.935	40.02	1773288.0
2014-05-29 10:30:00	MSFT	Stock	40.01	40.1	39.98	40.05	1276052.0
2014-05-29 11:00:00	MSFT	Stock	40.055	40.12	40.02	40.12	688999.0
2014-05-29 11:30:00	MSFT	Stock	40.12	40.14	40.02	40.045	774570.0
2014-05-29 12:00:00	MSFT	Stock	40.04	40.09	40.035	40.06	625443.0
2014-05-29 12:30:00	MSFT	Stock	40.05	40.07	40.02	40.03	573919.0
2014-05-29 13:00:00	MSFT	Stock	40.03	40.04	39.92	39.949	936055.0
2014-05-29 13:30:00	MSFT	Stock	39.947	40.015	39.91	39.99	700726.0
2014-05-29 14:00:00	MSFT	Stock	39.995	40.04	39.99	40.03	539711.0
2014-05-29 14:30:00	MSFT	Stock	40.036	40.13	40.02	40.11	1045990.0
2014-05-29 15:00:00	MSFT	Stock	40.11	40.21	40.1	40.19	1365839.0
2014-05-29 15:30:00	MSFT	Stock	40.2	40.35	40.18	40.34	4958226.0
2014-05-29 16:00:00	MSFT	Stock	40.34	40.348	40.108	40.34	1437775.0
2014-05-29 16:30:00	MSFT	Stock	40.34	40.34	40.102	40.131	7418.0
2014-05-29 17:00:00	MSFT	Stock	40.28	40.34	40.25	40.28	36518.0
2014-05-29 17:30:00	MSFT	Stock	40.29	40.29	40.28	40.28	435.0

> showing 50 of 81,119 rows — these rows as CSV

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