PREVIEW / stock_30min / 2011-02-11

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-11.parquet
  size:    1.4 MB
  rows:    75,870
  symbols: 3,536

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-02-11 04:00:00	AAPL	Stock	12.6032	12.6086	12.6032	12.6086	5600.0
2011-02-11 04:30:00	AAPL	Stock	12.5929	12.615	12.5929	12.6036	16800.0
2011-02-11 05:00:00	AAPL	Stock	12.6043	12.6043	12.6043	12.6043	5600.0
2011-02-11 06:00:00	AAPL	Stock	12.5786	12.6089	12.5786	12.5857	16912.0
2011-02-11 07:00:00	AAPL	Stock	12.6071	12.6571	12.6071	12.6375	94360.0
2011-02-11 07:30:00	AAPL	Stock	12.6164	12.6582	12.6164	12.6554	224616.0
2011-02-11 08:00:00	AAPL	Stock	12.6446	12.7132	12.64	12.7071	1296092.0
2011-02-11 08:30:00	AAPL	Stock	12.7014	12.7093	12.6882	12.7018	1079484.0
2011-02-11 09:00:00	AAPL	Stock	12.7014	12.7064	12.6671	12.6721	1648920.0
2011-02-11 09:30:00	AAPL	Stock	12.6718	12.7446	12.6264	12.7214	67455052.0
2011-02-11 10:00:00	AAPL	Stock	12.7214	12.7393	12.705	12.723	35247632.0
2011-02-11 10:30:00	AAPL	Stock	12.7232	12.7325	12.7143	12.7302	22440376.0
2011-02-11 11:00:00	AAPL	Stock	12.7282	12.7421	12.7071	12.7109	29469636.0
2011-02-11 11:30:00	AAPL	Stock	12.7136	12.7357	12.7096	12.7307	18457992.0
2011-02-11 12:00:00	AAPL	Stock	12.7307	12.7414	12.7171	12.7254	16555952.0
2011-02-11 12:30:00	AAPL	Stock	12.7243	12.7786	12.7236	12.7686	28442092.0
2011-02-11 13:00:00	AAPL	Stock	12.7682	12.7771	12.7357	12.7536	22761816.0
2011-02-11 13:30:00	AAPL	Stock	12.7539	12.7679	12.7514	12.7643	10196900.0
2011-02-11 14:00:00	AAPL	Stock	12.7643	12.7689	12.7489	12.7536	11463032.0
2011-02-11 14:30:00	AAPL	Stock	12.7536	12.7643	12.7393	12.7468	17885952.0
2011-02-11 15:00:00	AAPL	Stock	12.7471	12.7582	12.7364	12.7532	16964248.0
2011-02-11 15:30:00	AAPL	Stock	12.7536	12.7543	12.7325	12.745	45990560.0
2011-02-11 16:00:00	AAPL	Stock	12.745	12.7484	12.6584	12.7371	9761444.0
2011-02-11 16:30:00	AAPL	Stock	12.7396	12.7521	12.7368	12.7375	66556.0
2011-02-11 17:00:00	AAPL	Stock	12.7224	12.7407	12.7224	12.7375	79268.0
2011-02-11 17:30:00	AAPL	Stock	12.7407	12.7407	12.7357	12.7357	84868.0
2011-02-11 18:00:00	AAPL	Stock	12.7343	12.7446	12.7339	12.7393	78652.0
2011-02-11 18:30:00	AAPL	Stock	12.7393	12.7436	12.7393	12.7436	58996.0
2011-02-11 19:00:00	AAPL	Stock	12.7436	12.75	12.7436	12.7475	78512.0
2011-02-11 19:30:00	AAPL	Stock	12.7482	12.7518	12.7464	12.7464	159236.0
2011-02-11 04:30:00	MSFT	Stock	27.5	27.5	27.5	27.5	100.0
2011-02-11 05:30:00	MSFT	Stock	27.38	27.38	27.38	27.38	100.0
2011-02-11 06:30:00	MSFT	Stock	27.48	27.5	27.48	27.5	5100.0
2011-02-11 07:00:00	MSFT	Stock	27.49	27.5	27.48	27.5	22375.0
2011-02-11 07:30:00	MSFT	Stock	27.56	27.88	27.56	27.83	136380.0
2011-02-11 08:00:00	MSFT	Stock	27.83	27.95	27.59	27.92	277281.0
2011-02-11 08:30:00	MSFT	Stock	27.91	27.94	27.81	27.84	90992.0
2011-02-11 09:00:00	MSFT	Stock	27.85	27.9	27.75	27.76	316702.0
2011-02-11 09:30:00	MSFT	Stock	27.76	27.81	27.24	27.3	13074607.0
2011-02-11 10:00:00	MSFT	Stock	27.3	27.34	27.17	27.222	6947417.0
2011-02-11 10:30:00	MSFT	Stock	27.23	27.47	27.22	27.465	5944260.0
2011-02-11 11:00:00	MSFT	Stock	27.468	27.5	27.33	27.358	4948470.0
2011-02-11 11:30:00	MSFT	Stock	27.35	27.36	27.23	27.26	4745543.0
2011-02-11 12:00:00	MSFT	Stock	27.26	27.29	27.18	27.18	5126774.0
2011-02-11 12:30:00	MSFT	Stock	27.185	27.19	27.07	27.09	6710883.0
2011-02-11 13:00:00	MSFT	Stock	27.09	27.24	27.085	27.23	4072668.0
2011-02-11 13:30:00	MSFT	Stock	27.23	27.28	27.2	27.26	2939253.0
2011-02-11 14:00:00	MSFT	Stock	27.26	27.31	27.24	27.27	4032079.0
2011-02-11 14:30:00	MSFT	Stock	27.271	27.32	27.26	27.3	5346286.0
2011-02-11 15:00:00	MSFT	Stock	27.3	27.33	27.25	27.279	4689854.0

> showing 50 of 75,870 rows — these rows as CSV

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