PREVIEW / stock_30min / 2013-08-12

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-12.parquet
  size:    1.5 MB
  rows:    79,330
  symbols: 3,521

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-12 04:30:00	AAPL	Stock	16.2679	16.2743	16.2611	16.2611	8400.0
2013-08-12 05:00:00	AAPL	Stock	16.2625	16.2625	16.2379	16.2379	44800.0
2013-08-12 05:30:00	AAPL	Stock	16.2689	16.2689	16.2589	16.2689	11200.0
2013-08-12 06:00:00	AAPL	Stock	16.25	16.2571	16.25	16.25	25200.0
2013-08-12 06:30:00	AAPL	Stock	16.285	16.3054	16.285	16.3029	42000.0
2013-08-12 07:00:00	AAPL	Stock	16.3321	16.3375	16.2857	16.3161	138068.0
2013-08-12 07:30:00	AAPL	Stock	16.3139	16.3679	16.3018	16.3046	624680.0
2013-08-12 08:00:00	AAPL	Stock	16.3046	16.3536	16.2857	16.3489	1744092.0
2013-08-12 08:30:00	AAPL	Stock	16.3507	16.3629	16.3257	16.3275	731164.0
2013-08-12 09:00:00	AAPL	Stock	16.3257	16.34	16.2996	16.3104	1432928.0
2013-08-12 09:30:00	AAPL	Stock	16.3046	16.535	16.3046	16.4907	66720836.0
2013-08-12 10:00:00	AAPL	Stock	16.4904	16.5714	16.4764	16.5675	42182616.0
2013-08-12 10:30:00	AAPL	Stock	16.5632	16.6429	16.5629	16.6343	36215564.0
2013-08-12 11:00:00	AAPL	Stock	16.6371	16.6939	16.625	16.6354	32126220.0
2013-08-12 11:30:00	AAPL	Stock	16.6332	16.665	16.63	16.6521	12609996.0
2013-08-12 12:00:00	AAPL	Stock	16.6546	16.6739	16.5957	16.6046	17090668.0
2013-08-12 12:30:00	AAPL	Stock	16.6073	16.6536	16.5964	16.6418	11693416.0
2013-08-12 13:00:00	AAPL	Stock	16.6418	16.71	16.6268	16.7011	14495404.0
2013-08-12 13:30:00	AAPL	Stock	16.6982	16.71	16.6521	16.6687	12172132.0
2013-08-12 14:00:00	AAPL	Stock	16.6671	16.7039	16.6643	16.6807	7920108.0
2013-08-12 14:30:00	AAPL	Stock	16.6839	16.7214	16.6557	16.7143	13721848.0
2013-08-12 15:00:00	AAPL	Stock	16.7164	16.7375	16.6793	16.6793	19379108.0
2013-08-12 15:30:00	AAPL	Stock	16.6836	16.7271	16.6379	16.6943	36549212.0
2013-08-12 16:00:00	AAPL	Stock	16.6914	16.6975	16.596	16.6957	12750752.0
2013-08-12 16:30:00	AAPL	Stock	16.6986	16.7143	16.68	16.7086	876764.0
2013-08-12 17:00:00	AAPL	Stock	16.7121	16.7143	16.6914	16.7143	383180.0
2013-08-12 17:30:00	AAPL	Stock	16.71	16.7211	16.71	16.7207	94472.0
2013-08-12 18:00:00	AAPL	Stock	16.7179	16.7179	16.7143	16.7143	44184.0
2013-08-12 18:30:00	AAPL	Stock	16.7143	16.725	16.7143	16.7175	108808.0
2013-08-12 19:00:00	AAPL	Stock	16.7175	16.7229	16.7143	16.7229	90300.0
2013-08-12 19:30:00	AAPL	Stock	16.7264	16.73	16.7232	16.7293	155960.0
2013-08-12 07:30:00	MSFT	Stock	32.46	32.46	32.46	32.46	250.0
2013-08-12 08:00:00	MSFT	Stock	32.57	32.7	32.56	32.57	10680.0
2013-08-12 08:30:00	MSFT	Stock	32.57	32.57	32.57	32.57	2000.0
2013-08-12 09:00:00	MSFT	Stock	32.57	32.59	32.46	32.47	39927.0
2013-08-12 09:30:00	MSFT	Stock	32.46	32.83	32.46	32.68	4774598.0
2013-08-12 10:00:00	MSFT	Stock	32.69	32.78	32.67	32.73	1978192.0
2013-08-12 10:30:00	MSFT	Stock	32.73	32.94	32.72	32.938	2006011.0
2013-08-12 11:00:00	MSFT	Stock	32.93	32.97	32.82	32.885	1818491.0
2013-08-12 11:30:00	MSFT	Stock	32.885	32.93	32.85	32.88	1270627.0
2013-08-12 12:00:00	MSFT	Stock	32.875	32.88	32.785	32.8	1544675.0
2013-08-12 12:30:00	MSFT	Stock	32.8	32.875	32.76	32.85	1033336.0
2013-08-12 13:00:00	MSFT	Stock	32.86	32.86	32.78	32.829	1140270.0
2013-08-12 13:30:00	MSFT	Stock	32.83	32.85	32.763	32.8	951111.0
2013-08-12 14:00:00	MSFT	Stock	32.795	32.8	32.76	32.785	591312.0
2013-08-12 14:30:00	MSFT	Stock	32.79	32.85	32.77	32.835	1262828.0
2013-08-12 15:00:00	MSFT	Stock	32.85	32.89	32.82	32.86	1731627.0
2013-08-12 15:30:00	MSFT	Stock	32.86	32.91	32.84	32.88	3221121.0
2013-08-12 16:00:00	MSFT	Stock	32.87	32.98	32.7	32.87	1579809.0
2013-08-12 16:30:00	MSFT	Stock	32.86	32.86	32.86	32.86	4800.0

> showing 50 of 79,330 rows — these rows as CSV

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