PREVIEW / stock_30min / 2011-04-14

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-14.parquet
  size:    1.4 MB
  rows:    73,935
  symbols: 3,515

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
2011-04-14 04:00:00	AAPL	Stock	12.0	12.0	12.0	12.0	2800.0
2011-04-14 05:00:00	AAPL	Stock	11.9664	11.9664	11.9664	11.9664	2800.0
2011-04-14 05:30:00	AAPL	Stock	11.9714	11.9714	11.9464	11.9464	42000.0
2011-04-14 06:00:00	AAPL	Stock	11.9379	11.9379	11.9286	11.9286	19600.0
2011-04-14 06:30:00	AAPL	Stock	11.9371	11.9493	11.9286	11.9393	26880.0
2011-04-14 07:00:00	AAPL	Stock	11.9321	11.9464	11.9146	11.925	362516.0
2011-04-14 07:30:00	AAPL	Stock	11.9246	11.9375	11.9207	11.9314	311724.0
2011-04-14 08:00:00	AAPL	Stock	11.9296	11.9536	11.9296	11.9471	634060.0
2011-04-14 08:30:00	AAPL	Stock	11.9446	11.975	11.9325	11.9725	881748.0
2011-04-14 09:00:00	AAPL	Stock	11.9696	11.9696	11.9429	11.9636	1333500.0
2011-04-14 09:30:00	AAPL	Stock	11.9636	12.0	11.9021	11.9389	58461788.0
2011-04-14 10:00:00	AAPL	Stock	11.9393	11.9579	11.9164	11.9496	28656656.0
2011-04-14 10:30:00	AAPL	Stock	11.9489	11.9575	11.9079	11.9114	22697808.0
2011-04-14 11:00:00	AAPL	Stock	11.9118	11.9121	11.8693	11.8829	30270072.0
2011-04-14 11:30:00	AAPL	Stock	11.8832	11.9	11.8654	11.8911	16827524.0
2011-04-14 12:00:00	AAPL	Stock	11.8911	11.9036	11.8839	11.8879	14126700.0
2011-04-14 12:30:00	AAPL	Stock	11.8871	11.905	11.8843	11.8996	11043116.0
2011-04-14 13:00:00	AAPL	Stock	11.9	11.9204	11.8832	11.8902	13601252.0
2011-04-14 13:30:00	AAPL	Stock	11.8902	11.8943	11.8661	11.8699	13059116.0
2011-04-14 14:00:00	AAPL	Stock	11.8696	11.9018	11.8693	11.8864	10913616.0
2011-04-14 14:30:00	AAPL	Stock	11.8875	11.9011	11.8661	11.8889	17134488.0
2011-04-14 15:00:00	AAPL	Stock	11.8893	11.9193	11.8861	11.9039	18140444.0
2011-04-14 15:30:00	AAPL	Stock	11.9035	11.905	11.8593	11.8596	31707116.0
2011-04-14 16:00:00	AAPL	Stock	11.8604	11.9518	11.8125	11.8479	6134128.0
2011-04-14 16:30:00	AAPL	Stock	11.859	11.9043	11.8275	11.8343	1001308.0
2011-04-14 17:00:00	AAPL	Stock	11.8307	11.8411	11.8296	11.8368	358680.0
2011-04-14 17:30:00	AAPL	Stock	11.8329	11.8429	11.8321	11.8411	185500.0
2011-04-14 18:00:00	AAPL	Stock	11.8418	11.8721	11.8418	11.8429	253764.0
2011-04-14 18:30:00	AAPL	Stock	11.8429	11.8479	11.8429	11.8432	63280.0
2011-04-14 19:00:00	AAPL	Stock	11.8479	11.85	11.8446	11.85	57512.0
2011-04-14 19:30:00	AAPL	Stock	11.85	11.8536	11.8482	11.8482	57456.0
2011-04-14 05:30:00	MSFT	Stock	25.5	25.5	25.5	25.5	200.0
2011-04-14 06:00:00	MSFT	Stock	25.43	25.43	25.37	25.37	200.0
2011-04-14 06:30:00	MSFT	Stock	25.38	25.38	25.38	25.38	200.0
2011-04-14 07:00:00	MSFT	Stock	25.35	25.5	25.35	25.42	5700.0
2011-04-14 07:30:00	MSFT	Stock	25.42	25.42	25.39	25.42	11478.0
2011-04-14 08:00:00	MSFT	Stock	25.42	25.42	25.37	25.39	33400.0
2011-04-14 08:30:00	MSFT	Stock	25.39	25.39	25.33	25.37	107452.0
2011-04-14 09:00:00	MSFT	Stock	25.36	25.47	25.35	25.45	64452.0
2011-04-14 09:30:00	MSFT	Stock	25.44	25.44	25.1	25.142	10537536.0
2011-04-14 10:00:00	MSFT	Stock	25.149	25.25	25.09	25.24	5274415.0
2011-04-14 10:30:00	MSFT	Stock	25.25	25.35	25.23	25.25	4890435.0
2011-04-14 11:00:00	MSFT	Stock	25.25	25.27	25.18	25.21	2943509.0
2011-04-14 11:30:00	MSFT	Stock	25.21	25.33	25.2	25.31	2143475.0
2011-04-14 12:00:00	MSFT	Stock	25.31	25.36	25.29	25.32	2590405.0
2011-04-14 12:30:00	MSFT	Stock	25.32	25.33	25.26	25.31	1778546.0
2011-04-14 13:00:00	MSFT	Stock	25.315	25.35	25.26	25.272	2050963.0
2011-04-14 13:30:00	MSFT	Stock	25.27	25.3	25.2	25.2	2817796.0
2011-04-14 14:00:00	MSFT	Stock	25.205	25.3	25.19	25.25	2665684.0
2011-04-14 14:30:00	MSFT	Stock	25.26	25.33	25.25	25.27	2532117.0

> showing 50 of 73,935 rows — these rows as CSV

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