PREVIEW / stock_30min / 2011-02-09

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-09.parquet
  size:    1.4 MB
  rows:    75,366
  symbols: 3,540

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-09 04:00:00	AAPL	Stock	12.6786	12.6786	12.6786	12.6786	9800.0
2011-02-09 05:00:00	AAPL	Stock	12.6786	12.6786	12.6786	12.6786	5600.0
2011-02-09 06:30:00	AAPL	Stock	12.6771	12.6793	12.6771	12.6786	64120.0
2011-02-09 07:00:00	AAPL	Stock	12.6782	12.6964	12.6561	12.6921	202300.0
2011-02-09 07:30:00	AAPL	Stock	12.6957	12.6964	12.6625	12.6679	145824.0
2011-02-09 08:00:00	AAPL	Stock	12.6718	12.6932	12.6679	12.6771	1537228.0
2011-02-09 08:30:00	AAPL	Stock	12.68	12.6893	12.6736	12.685	589008.0
2011-02-09 09:00:00	AAPL	Stock	12.6875	12.69	12.6754	12.6857	1092168.0
2011-02-09 09:30:00	AAPL	Stock	12.6843	12.7396	12.6739	12.7364	63146944.0
2011-02-09 10:00:00	AAPL	Stock	12.7364	12.7621	12.7307	12.7554	48122536.0
2011-02-09 10:30:00	AAPL	Stock	12.7554	12.8214	12.7475	12.8107	49669256.0
2011-02-09 11:00:00	AAPL	Stock	12.8107	12.8164	12.7543	12.7721	55179376.0
2011-02-09 11:30:00	AAPL	Stock	12.7714	12.7821	12.7468	12.7764	28537628.0
2011-02-09 12:00:00	AAPL	Stock	12.7764	12.8046	12.7571	12.8032	27546288.0
2011-02-09 12:30:00	AAPL	Stock	12.8021	12.8207	12.7982	12.7986	21375424.0
2011-02-09 13:00:00	AAPL	Stock	12.8	12.8161	12.7946	12.8121	15082564.0
2011-02-09 13:30:00	AAPL	Stock	12.8125	12.8161	12.7768	12.7768	20946464.0
2011-02-09 14:00:00	AAPL	Stock	12.7782	12.7782	12.7279	12.7454	39424924.0
2011-02-09 14:30:00	AAPL	Stock	12.7454	12.7764	12.7314	12.7529	30306332.0
2011-02-09 15:00:00	AAPL	Stock	12.7543	12.7929	12.7518	12.7851	24292016.0
2011-02-09 15:30:00	AAPL	Stock	12.785	12.7914	12.7686	12.79	37132732.0
2011-02-09 16:00:00	AAPL	Stock	12.7914	12.7971	12.7674	12.7899	7561512.0
2011-02-09 16:30:00	AAPL	Stock	12.7836	12.8071	12.7682	12.7839	1170064.0
2011-02-09 17:00:00	AAPL	Stock	12.7832	12.7843	12.6752	12.7564	561876.0
2011-02-09 17:30:00	AAPL	Stock	12.7607	12.7643	12.7536	12.7639	214368.0
2011-02-09 18:00:00	AAPL	Stock	12.7629	12.7914	12.76	12.775	140588.0
2011-02-09 18:30:00	AAPL	Stock	12.7714	12.7714	12.7686	12.7696	16436.0
2011-02-09 19:00:00	AAPL	Stock	12.7739	12.7768	12.7736	12.7768	118888.0
2011-02-09 19:30:00	AAPL	Stock	12.7768	12.7857	12.7714	12.7732	277900.0
2011-02-09 08:00:00	MSFT	Stock	28.2	28.26	28.2	28.26	515.0
2011-02-09 08:30:00	MSFT	Stock	28.22	28.25	28.21	28.25	1800.0
2011-02-09 09:00:00	MSFT	Stock	28.24	28.44	28.15	28.18	44714.0
2011-02-09 09:30:00	MSFT	Stock	28.18	28.26	28.11	28.222	2431802.0
2011-02-09 10:00:00	MSFT	Stock	28.23	28.26	28.11	28.151	3811525.0
2011-02-09 10:30:00	MSFT	Stock	28.15	28.19	28.11	28.13	3214972.0
2011-02-09 11:00:00	MSFT	Stock	28.13	28.16	28.04	28.08	3976408.0
2011-02-09 11:30:00	MSFT	Stock	28.085	28.12	28.08	28.09	1978006.0
2011-02-09 12:00:00	MSFT	Stock	28.09	28.16	28.08	28.121	3635392.0
2011-02-09 12:30:00	MSFT	Stock	28.123	28.16	28.11	28.115	1643043.0
2011-02-09 13:00:00	MSFT	Stock	28.115	28.15	28.1	28.11	1466798.0
2011-02-09 13:30:00	MSFT	Stock	28.112	28.15	28.1	28.11	2998233.0
2011-02-09 14:00:00	MSFT	Stock	28.11	28.13	28.04	28.09	3760658.0
2011-02-09 14:30:00	MSFT	Stock	28.09	28.11	28.03	28.035	6429448.0
2011-02-09 15:00:00	MSFT	Stock	28.03	28.05	27.96	27.996	5245351.0
2011-02-09 15:30:00	MSFT	Stock	27.995	28.01	27.91	27.952	8110338.0
2011-02-09 16:00:00	MSFT	Stock	27.95	28.083	27.95	27.96	2072385.0
2011-02-09 16:30:00	MSFT	Stock	27.96	28.013	27.92	27.95	20900.0
2011-02-09 17:00:00	MSFT	Stock	27.93	27.96	27.78	27.86	16890.0
2011-02-09 17:30:00	MSFT	Stock	27.9	27.91	27.9	27.9	8600.0
2011-02-09 18:00:00	MSFT	Stock	27.91	27.97	27.91	27.92	18631.0

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

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