PREVIEW / stock_30min / 2013-06-28

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-28.parquet
  size:    1.6 MB
  rows:    81,055
  symbols: 3,505

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-06-28 04:30:00	AAPL	Stock	14.0696	14.0696	14.0646	14.0646	5600.0
2013-06-28 05:00:00	AAPL	Stock	14.0646	14.0646	14.0646	14.0646	19600.0
2013-06-28 05:30:00	AAPL	Stock	14.0696	14.0696	14.0696	14.0696	5600.0
2013-06-28 06:30:00	AAPL	Stock	14.0486	14.0486	14.0486	14.0486	12320.0
2013-06-28 07:00:00	AAPL	Stock	14.0357	14.1071	14.0325	14.1071	63840.0
2013-06-28 07:30:00	AAPL	Stock	14.1064	14.1071	14.0661	14.1036	126000.0
2013-06-28 08:00:00	AAPL	Stock	14.0964	14.0982	14.0179	14.045	791364.0
2013-06-28 08:30:00	AAPL	Stock	14.0421	14.0618	14.025	14.0379	386904.0
2013-06-28 09:00:00	AAPL	Stock	14.0375	14.0393	13.9821	13.9821	1053584.0
2013-06-28 09:30:00	AAPL	Stock	13.985	14.0393	13.8882	13.9568	80927280.0
2013-06-28 10:00:00	AAPL	Stock	13.9643	14.0075	13.9189	13.9625	36281308.0
2013-06-28 10:30:00	AAPL	Stock	13.9596	14.0321	13.9314	14.0232	30176580.0
2013-06-28 11:00:00	AAPL	Stock	14.0289	14.13	14.0136	14.0664	41004544.0
2013-06-28 11:30:00	AAPL	Stock	14.0693	14.0821	14.0307	14.0693	20696256.0
2013-06-28 12:00:00	AAPL	Stock	14.0689	14.0982	14.0118	14.0956	19892936.0
2013-06-28 12:30:00	AAPL	Stock	14.0971	14.1771	14.0796	14.15	26168128.0
2013-06-28 13:00:00	AAPL	Stock	14.1521	14.1875	14.1429	14.1754	18060588.0
2013-06-28 13:30:00	AAPL	Stock	14.1761	14.2586	14.1646	14.2421	23636424.0
2013-06-28 14:00:00	AAPL	Stock	14.2421	14.2954	14.2232	14.2304	29216040.0
2013-06-28 14:30:00	AAPL	Stock	14.2289	14.2529	14.2036	14.2329	18159288.0
2013-06-28 15:00:00	AAPL	Stock	14.2321	14.2857	14.2039	14.2854	20802824.0
2013-06-28 15:30:00	AAPL	Stock	14.2854	14.2939	14.1332	14.1486	55208132.0
2013-06-28 16:00:00	AAPL	Stock	14.1457	14.1932	14.0539	14.1459	108881220.0
2013-06-28 16:30:00	AAPL	Stock	14.1764	14.2854	14.1415	14.1768	1989792.0
2013-06-28 17:00:00	AAPL	Stock	14.1754	14.1843	14.1431	14.1814	20696452.0
2013-06-28 17:30:00	AAPL	Stock	14.1818	14.1821	14.1804	14.1821	139636.0
2013-06-28 18:00:00	AAPL	Stock	14.1804	14.1821	14.1786	14.1786	36400.0
2013-06-28 18:30:00	AAPL	Stock	14.1807	14.1821	14.1807	14.1821	27300.0
2013-06-28 19:00:00	AAPL	Stock	14.1804	14.1821	14.1804	14.1821	18060.0
2013-06-28 19:30:00	AAPL	Stock	14.1811	14.1857	14.1811	14.1821	76972.0
2013-06-28 08:00:00	MSFT	Stock	34.61	34.63	34.6	34.62	129950.0
2013-06-28 08:30:00	MSFT	Stock	34.6	34.6	34.6	34.6	350.0
2013-06-28 09:00:00	MSFT	Stock	34.6	34.6	34.36	34.38	32644.0
2013-06-28 09:30:00	MSFT	Stock	34.36	34.7	34.34	34.59	3553136.0
2013-06-28 10:00:00	MSFT	Stock	34.6	34.6	34.37	34.39	3132328.0
2013-06-28 10:30:00	MSFT	Stock	34.38	34.62	34.37	34.57	2552991.0
2013-06-28 11:00:00	MSFT	Stock	34.57	34.73	34.56	34.61	1378553.0
2013-06-28 11:30:00	MSFT	Stock	34.61	34.66	34.535	34.645	1202874.0
2013-06-28 12:00:00	MSFT	Stock	34.65	34.66	34.5	34.525	972775.0
2013-06-28 12:30:00	MSFT	Stock	34.525	34.54	34.48	34.48	1234836.0
2013-06-28 13:00:00	MSFT	Stock	34.485	34.68	34.47	34.665	1736995.0
2013-06-28 13:30:00	MSFT	Stock	34.665	34.715	34.63	34.68	1075098.0
2013-06-28 14:00:00	MSFT	Stock	34.689	34.77	34.68	34.682	1364849.0
2013-06-28 14:30:00	MSFT	Stock	34.685	34.7	34.63	34.655	1587692.0
2013-06-28 15:00:00	MSFT	Stock	34.657	34.71	34.56	34.707	2028274.0
2013-06-28 15:30:00	MSFT	Stock	34.71	34.79	34.5	34.55	7160233.0
2013-06-28 16:00:00	MSFT	Stock	34.53	34.615	34.479	34.524	31902208.0
2013-06-28 16:30:00	MSFT	Stock	34.74	34.75	34.51	34.51	1350605.0
2013-06-28 17:00:00	MSFT	Stock	34.51	34.524	34.49	34.524	2217432.0
2013-06-28 17:30:00	MSFT	Stock	34.5	34.5	34.5	34.5	1100.0

> showing 50 of 81,055 rows — these rows as CSV

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