PREVIEW / stock_30min / 2013-08-05

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-05.parquet
  size:    1.5 MB
  rows:    78,433
  symbols: 3,503

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
2013-08-05 04:00:00	AAPL	Stock	16.5054	16.55	16.5054	16.55	5600.0
2013-08-05 05:00:00	AAPL	Stock	16.5675	16.5675	16.5675	16.5675	2800.0
2013-08-05 06:00:00	AAPL	Stock	16.5771	16.5771	16.5771	16.5771	2800.0
2013-08-05 06:30:00	AAPL	Stock	16.6029	16.6257	16.6018	16.6071	75264.0
2013-08-05 07:00:00	AAPL	Stock	16.5979	16.7143	16.5843	16.6825	957964.0
2013-08-05 07:30:00	AAPL	Stock	16.6818	16.6832	16.6246	16.6411	758828.0
2013-08-05 08:00:00	AAPL	Stock	16.6268	16.7121	16.4643	16.6457	1476412.0
2013-08-05 08:30:00	AAPL	Stock	16.6461	16.6664	16.6236	16.6382	1162224.0
2013-08-05 09:00:00	AAPL	Stock	16.6246	16.6382	16.5932	16.5986	1192828.0
2013-08-05 09:30:00	AAPL	Stock	16.5914	16.6414	16.5054	16.62	63544180.0
2013-08-05 10:00:00	AAPL	Stock	16.62	16.7404	16.6043	16.6793	41496252.0
2013-08-05 10:30:00	AAPL	Stock	16.6773	16.7607	16.6514	16.7536	26778360.0
2013-08-05 11:00:00	AAPL	Stock	16.7536	16.7643	16.7161	16.7296	16772252.0
2013-08-05 11:30:00	AAPL	Stock	16.7279	16.7339	16.6575	16.6882	17833536.0
2013-08-05 12:00:00	AAPL	Stock	16.6875	16.73	16.6821	16.7036	8990184.0
2013-08-05 12:30:00	AAPL	Stock	16.7064	16.7464	16.6836	16.7396	8883168.0
2013-08-05 13:00:00	AAPL	Stock	16.7396	16.7786	16.7107	16.7732	13711124.0
2013-08-05 13:30:00	AAPL	Stock	16.775	16.7946	16.7425	16.7789	16374344.0
2013-08-05 14:00:00	AAPL	Stock	16.7793	16.7861	16.7432	16.7823	12841696.0
2013-08-05 14:30:00	AAPL	Stock	16.7832	16.7868	16.7336	16.7429	12191116.0
2013-08-05 15:00:00	AAPL	Stock	16.7489	16.7839	16.7336	16.7804	10683008.0
2013-08-05 15:30:00	AAPL	Stock	16.7804	16.8096	16.7411	16.7643	33595128.0
2013-08-05 16:00:00	AAPL	Stock	16.7661	16.7811	16.6942	16.775	13731032.0
2013-08-05 16:30:00	AAPL	Stock	16.775	16.782	16.7661	16.77	491736.0
2013-08-05 17:00:00	AAPL	Stock	16.5193	16.7779	16.5193	16.7779	117600.0
2013-08-05 17:30:00	AAPL	Stock	16.7768	16.7786	16.7768	16.7768	48972.0
2013-08-05 18:00:00	AAPL	Stock	16.7732	16.7768	16.7689	16.7689	35084.0
2013-08-05 18:30:00	AAPL	Stock	16.7686	16.7768	16.7657	16.7657	172508.0
2013-08-05 19:00:00	AAPL	Stock	16.7643	16.7643	16.75	16.75	123788.0
2013-08-05 19:30:00	AAPL	Stock	16.7504	16.7504	16.7368	16.7496	163268.0
2013-08-05 05:00:00	MSFT	Stock	31.86	32.09	31.86	32.09	200.0
2013-08-05 05:30:00	MSFT	Stock	32.09	32.09	32.09	32.09	200.0
2013-08-05 07:00:00	MSFT	Stock	31.96	31.96	31.96	31.96	400.0
2013-08-05 08:00:00	MSFT	Stock	31.89	31.9	31.81	31.83	1012.0
2013-08-05 08:30:00	MSFT	Stock	31.89	31.89	31.8	31.8	2400.0
2013-08-05 09:00:00	MSFT	Stock	31.82	31.88	31.79	31.84	8100.0
2013-08-05 09:30:00	MSFT	Stock	31.9	31.91	31.78	31.86	2279677.0
2013-08-05 10:00:00	MSFT	Stock	31.85	31.94	31.83	31.93	2182849.0
2013-08-05 10:30:00	MSFT	Stock	31.93	32.0	31.88	31.88	2692924.0
2013-08-05 11:00:00	MSFT	Stock	31.89	31.91	31.83	31.84	1583179.0
2013-08-05 11:30:00	MSFT	Stock	31.845	31.845	31.69	31.705	1380754.0
2013-08-05 12:00:00	MSFT	Stock	31.705	31.76	31.69	31.73	996137.0
2013-08-05 12:30:00	MSFT	Stock	31.73	31.74	31.7	31.72	1147238.0
2013-08-05 13:00:00	MSFT	Stock	31.72	31.82	31.69	31.8	1376801.0
2013-08-05 13:30:00	MSFT	Stock	31.805	31.81	31.74	31.74	1041225.0
2013-08-05 14:00:00	MSFT	Stock	31.75	31.78	31.71	31.723	1463756.0
2013-08-05 14:30:00	MSFT	Stock	31.727	31.76	31.69	31.705	2389661.0
2013-08-05 15:00:00	MSFT	Stock	31.71	31.73	31.64	31.67	2362520.0
2013-08-05 15:30:00	MSFT	Stock	31.687	31.705	31.65	31.69	4788149.0
2013-08-05 16:00:00	MSFT	Stock	31.69	31.89	31.68	31.89	4945327.0

> showing 50 of 78,433 rows — these rows as CSV

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