PREVIEW / stock_30min / 2014-02-12

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-12.parquet
  size:    1.6 MB
  rows:    81,162
  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
2014-02-12 04:00:00	AAPL	Stock	19.1929	19.1929	19.1929	19.1929	5600.0
2014-02-12 05:00:00	AAPL	Stock	19.2107	19.2314	19.1896	19.2304	85904.0
2014-02-12 05:30:00	AAPL	Stock	19.2204	19.2204	19.2039	19.2057	16800.0
2014-02-12 06:00:00	AAPL	Stock	19.2011	19.2011	19.1754	19.1754	22400.0
2014-02-12 06:30:00	AAPL	Stock	19.1754	19.1764	19.1754	19.1764	8260.0
2014-02-12 07:00:00	AAPL	Stock	19.1393	19.1511	19.1393	19.1511	15820.0
2014-02-12 07:30:00	AAPL	Stock	19.1679	19.1679	19.1429	19.1429	84308.0
2014-02-12 08:00:00	AAPL	Stock	19.1457	19.1914	19.1393	19.1664	289408.0
2014-02-12 08:30:00	AAPL	Stock	19.1668	19.1964	19.1646	19.1921	471688.0
2014-02-12 09:00:00	AAPL	Stock	19.1925	19.1929	19.1414	19.175	814856.0
2014-02-12 09:30:00	AAPL	Stock	19.1768	19.27	19.1004	19.1536	54593000.0
2014-02-12 10:00:00	AAPL	Stock	19.1529	19.1571	19.0443	19.1246	25402748.0
2014-02-12 10:30:00	AAPL	Stock	19.1257	19.2036	19.0971	19.1682	20741168.0
2014-02-12 11:00:00	AAPL	Stock	19.1704	19.2411	19.1682	19.1857	14922432.0
2014-02-12 11:30:00	AAPL	Stock	19.1857	19.2046	19.1089	19.1232	13342028.0
2014-02-12 12:00:00	AAPL	Stock	19.1229	19.1739	19.1146	19.1396	8048880.0
2014-02-12 12:30:00	AAPL	Stock	19.1421	19.1546	19.0896	19.1464	8255688.0
2014-02-12 13:00:00	AAPL	Stock	19.1464	19.1961	19.1366	19.1682	7548156.0
2014-02-12 13:30:00	AAPL	Stock	19.1671	19.25	19.1654	19.2107	23107952.0
2014-02-12 14:00:00	AAPL	Stock	19.2111	19.2182	19.1643	19.1935	9140320.0
2014-02-12 14:30:00	AAPL	Stock	19.1964	19.1986	19.1457	19.1539	8247988.0
2014-02-12 15:00:00	AAPL	Stock	19.1554	19.1785	19.1071	19.1079	10502492.0
2014-02-12 15:30:00	AAPL	Stock	19.1091	19.14	19.0916	19.1379	21161560.0
2014-02-12 16:00:00	AAPL	Stock	19.1393	19.1614	19.1207	19.1436	19152952.0
2014-02-12 16:30:00	AAPL	Stock	19.1429	19.1589	19.1429	19.15	249396.0
2014-02-12 17:00:00	AAPL	Stock	19.1471	19.1486	19.1429	19.1429	61320.0
2014-02-12 17:30:00	AAPL	Stock	19.1454	19.1493	19.1396	19.1396	80052.0
2014-02-12 18:00:00	AAPL	Stock	19.1429	19.1468	19.1429	19.1468	19600.0
2014-02-12 18:30:00	AAPL	Stock	19.14	19.1457	19.14	19.1443	80696.0
2014-02-12 19:00:00	AAPL	Stock	19.1429	19.1446	19.1429	19.1446	27300.0
2014-02-12 19:30:00	AAPL	Stock	19.1482	19.1532	19.1464	19.1468	202972.0
2014-02-12 08:00:00	MSFT	Stock	37.17	37.2	37.17	37.19	2760.0
2014-02-12 08:30:00	MSFT	Stock	37.19	37.19	37.19	37.19	300.0
2014-02-12 09:00:00	MSFT	Stock	37.2	37.37	37.2	37.37	23974.0
2014-02-12 09:30:00	MSFT	Stock	37.33	37.49	37.3	37.48	2950013.0
2014-02-12 10:00:00	MSFT	Stock	37.49	37.535	37.41	37.475	2474477.0
2014-02-12 10:30:00	MSFT	Stock	37.48	37.51	37.43	37.46	1762934.0
2014-02-12 11:00:00	MSFT	Stock	37.469	37.54	37.4	37.43	1125912.0
2014-02-12 11:30:00	MSFT	Stock	37.43	37.45	37.4	37.43	1258687.0
2014-02-12 12:00:00	MSFT	Stock	37.425	37.54	37.41	37.52	1093759.0
2014-02-12 12:30:00	MSFT	Stock	37.52	37.6	37.52	37.575	1195932.0
2014-02-12 13:00:00	MSFT	Stock	37.575	37.59	37.49	37.56	1105717.0
2014-02-12 13:30:00	MSFT	Stock	37.56	37.58	37.49	37.555	934821.0
2014-02-12 14:00:00	MSFT	Stock	37.56	37.58	37.52	37.53	808436.0
2014-02-12 14:30:00	MSFT	Stock	37.535	37.56	37.49	37.52	1615461.0
2014-02-12 15:00:00	MSFT	Stock	37.515	37.55	37.49	37.5	1768708.0
2014-02-12 15:30:00	MSFT	Stock	37.5	37.54	37.42	37.46	4649817.0
2014-02-12 16:00:00	MSFT	Stock	37.47	37.52	37.175	37.47	3385342.0
2014-02-12 16:30:00	MSFT	Stock	37.481	37.527	37.45	37.45	3567.0
2014-02-12 17:30:00	MSFT	Stock	37.5	37.5	37.5	37.5	200.0

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

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