PREVIEW / stock_30min / 2011-02-08

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-08.parquet
  size:    1.4 MB
  rows:    75,881
  symbols: 3,535

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-08 05:30:00	AAPL	Stock	12.5661	12.5661	12.5661	12.5661	2800.0
2011-02-08 06:00:00	AAPL	Stock	12.5771	12.5771	12.5771	12.5771	2800.0
2011-02-08 06:30:00	AAPL	Stock	12.5782	12.5857	12.5493	12.5857	14000.0
2011-02-08 07:00:00	AAPL	Stock	12.5671	12.5893	12.5521	12.5607	194348.0
2011-02-08 07:30:00	AAPL	Stock	12.5643	12.5804	12.55	12.5804	136500.0
2011-02-08 08:00:00	AAPL	Stock	12.5804	12.6139	12.5771	12.5911	2295776.0
2011-02-08 08:30:00	AAPL	Stock	12.5925	12.5989	12.5857	12.5929	635124.0
2011-02-08 09:00:00	AAPL	Stock	12.5921	12.6264	12.5914	12.6264	2437288.0
2011-02-08 09:30:00	AAPL	Stock	12.625	12.6614	12.5768	12.6465	83918408.0
2011-02-08 10:00:00	AAPL	Stock	12.6461	12.6764	12.6307	12.6679	46638760.0
2011-02-08 10:30:00	AAPL	Stock	12.6693	12.6829	12.6618	12.6739	35173264.0
2011-02-08 11:00:00	AAPL	Stock	12.6736	12.6796	12.6493	12.6654	27549928.0
2011-02-08 11:30:00	AAPL	Stock	12.6636	12.6732	12.6579	12.6724	12513060.0
2011-02-08 12:00:00	AAPL	Stock	12.6732	12.6804	12.67	12.6804	14243096.0
2011-02-08 12:30:00	AAPL	Stock	12.6794	12.6957	12.6775	12.6929	19220992.0
2011-02-08 13:00:00	AAPL	Stock	12.6921	12.6946	12.6679	12.6693	19345340.0
2011-02-08 13:30:00	AAPL	Stock	12.6693	12.6784	12.6604	12.6693	14812476.0
2011-02-08 14:00:00	AAPL	Stock	12.6693	12.6818	12.6679	12.68	10531780.0
2011-02-08 14:30:00	AAPL	Stock	12.6806	12.6914	12.6629	12.6724	16592912.0
2011-02-08 15:00:00	AAPL	Stock	12.6725	12.6971	12.6689	12.6768	21585648.0
2011-02-08 15:30:00	AAPL	Stock	12.6764	12.6936	12.6739	12.69	33959296.0
2011-02-08 16:00:00	AAPL	Stock	12.6889	12.6961	12.6634	12.6911	9053912.0
2011-02-08 16:30:00	AAPL	Stock	12.6358	12.6921	12.6358	12.6886	230776.0
2011-02-08 17:00:00	AAPL	Stock	12.6893	12.7089	12.6779	12.6786	1564192.0
2011-02-08 17:30:00	AAPL	Stock	12.6786	12.6896	12.6643	12.6786	548660.0
2011-02-08 18:00:00	AAPL	Stock	12.6768	12.6857	12.6757	12.6786	90188.0
2011-02-08 18:30:00	AAPL	Stock	12.6786	12.6829	12.6782	12.6829	44800.0
2011-02-08 19:00:00	AAPL	Stock	12.6829	12.6986	12.6829	12.6929	397964.0
2011-02-08 19:30:00	AAPL	Stock	12.6921	12.6982	12.6921	12.6932	326060.0
2011-02-08 05:30:00	MSFT	Stock	28.25	28.25	28.25	28.25	1400.0
2011-02-08 06:30:00	MSFT	Stock	28.25	28.25	28.22	28.22	1200.0
2011-02-08 07:00:00	MSFT	Stock	28.22	28.24	28.22	28.24	1100.0
2011-02-08 08:00:00	MSFT	Stock	28.22	28.22	28.17	28.18	25500.0
2011-02-08 08:30:00	MSFT	Stock	28.19	28.19	28.16	28.16	1000.0
2011-02-08 09:00:00	MSFT	Stock	28.16	28.17	28.05	28.1	51140.0
2011-02-08 09:30:00	MSFT	Stock	28.09	28.34	28.05	28.301	5457839.0
2011-02-08 10:00:00	MSFT	Stock	28.3	28.33	28.2	28.211	2928149.0
2011-02-08 10:30:00	MSFT	Stock	28.21	28.26	28.2	28.215	2443962.0
2011-02-08 11:00:00	MSFT	Stock	28.219	28.23	28.13	28.19	2514171.0
2011-02-08 11:30:00	MSFT	Stock	28.19	28.26	28.19	28.21	2867328.0
2011-02-08 12:00:00	MSFT	Stock	28.21	28.21	28.18	28.18	1052218.0
2011-02-08 12:30:00	MSFT	Stock	28.18	28.21	28.14	28.179	1250777.0
2011-02-08 13:00:00	MSFT	Stock	28.173	28.18	28.13	28.15	1570438.0
2011-02-08 13:30:00	MSFT	Stock	28.15	28.18	28.11	28.18	1780233.0
2011-02-08 14:00:00	MSFT	Stock	28.18	28.22	28.17	28.216	1220687.0
2011-02-08 14:30:00	MSFT	Stock	28.22	28.24	28.17	28.221	2976576.0
2011-02-08 15:00:00	MSFT	Stock	28.22	28.24	28.19	28.2	1851417.0
2011-02-08 15:30:00	MSFT	Stock	28.209	28.3	28.2	28.29	4232138.0
2011-02-08 16:00:00	MSFT	Stock	28.29	28.36	28.214	28.28	1488474.0
2011-02-08 16:30:00	MSFT	Stock	28.29	28.303	28.188	28.294	399236.0

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

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