PREVIEW / stock_30min / 2014-05-02

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-02.parquet
  size:    1.5 MB
  rows:    80,217
  symbols: 3,533

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-05-02 04:00:00	AAPL	Stock	21.1429	21.1429	21.1429	21.1429	5600.0
2014-05-02 06:00:00	AAPL	Stock	21.1786	21.1786	21.1786	21.1786	2800.0
2014-05-02 06:30:00	AAPL	Stock	21.1786	21.1786	21.1786	21.1786	2800.0
2014-05-02 07:00:00	AAPL	Stock	21.1768	21.1768	21.1607	21.1643	54320.0
2014-05-02 07:30:00	AAPL	Stock	21.1607	21.1696	21.1607	21.1696	42000.0
2014-05-02 08:00:00	AAPL	Stock	21.1611	21.1743	21.1429	21.1611	199640.0
2014-05-02 08:30:00	AAPL	Stock	21.1604	21.2107	21.1604	21.1639	449344.0
2014-05-02 09:00:00	AAPL	Stock	21.1646	21.1786	21.1511	21.1654	499688.0
2014-05-02 09:30:00	AAPL	Stock	21.155	21.2214	21.0911	21.1529	31548356.0
2014-05-02 10:00:00	AAPL	Stock	21.1489	21.1964	21.1161	21.1586	13129900.0
2014-05-02 10:30:00	AAPL	Stock	21.1536	21.1707	21.0611	21.1164	16096472.0
2014-05-02 11:00:00	AAPL	Stock	21.115	21.1464	21.1029	21.1125	6679372.0
2014-05-02 11:30:00	AAPL	Stock	21.1139	21.1896	21.1075	21.1732	8792196.0
2014-05-02 12:00:00	AAPL	Stock	21.1729	21.1886	21.1557	21.1761	5544392.0
2014-05-02 12:30:00	AAPL	Stock	21.1753	21.1946	21.1593	21.1621	4524380.0
2014-05-02 13:00:00	AAPL	Stock	21.1614	21.1654	21.1371	21.1436	6148324.0
2014-05-02 13:30:00	AAPL	Stock	21.1425	21.1461	21.1132	21.1132	5743136.0
2014-05-02 14:00:00	AAPL	Stock	21.112	21.1339	21.1054	21.1232	6294652.0
2014-05-02 14:30:00	AAPL	Stock	21.1239	21.155	21.1212	21.1336	5895204.0
2014-05-02 15:00:00	AAPL	Stock	21.1354	21.1875	21.1282	21.1543	10317692.0
2014-05-02 15:30:00	AAPL	Stock	21.155	21.1696	21.1334	21.1636	21852376.0
2014-05-02 16:00:00	AAPL	Stock	21.1636	21.1686	21.1472	21.1625	6115340.0
2014-05-02 16:30:00	AAPL	Stock	21.1632	21.1636	21.0896	21.1636	744016.0
2014-05-02 17:00:00	AAPL	Stock	21.1589	21.1611	21.14	21.14	235956.0
2014-05-02 17:30:00	AAPL	Stock	21.1393	21.1636	21.1393	21.1393	269892.0
2014-05-02 18:00:00	AAPL	Stock	21.14	21.1471	21.1375	21.1429	174160.0
2014-05-02 18:30:00	AAPL	Stock	21.1393	21.1514	21.1393	21.1514	95284.0
2014-05-02 19:00:00	AAPL	Stock	21.1464	21.1514	21.1429	21.1429	42784.0
2014-05-02 19:30:00	AAPL	Stock	21.1514	21.1589	21.1429	21.1439	94024.0
2014-05-02 07:30:00	MSFT	Stock	40.09	40.1	40.09	40.09	1350.0
2014-05-02 08:00:00	MSFT	Stock	40.09	40.09	40.07	40.07	2357.0
2014-05-02 08:30:00	MSFT	Stock	40.09	40.14	40.07	40.07	8090.0
2014-05-02 09:00:00	MSFT	Stock	40.07	40.4	40.07	40.31	101808.0
2014-05-02 09:30:00	MSFT	Stock	40.31	40.34	39.84	39.875	5283220.0
2014-05-02 10:00:00	MSFT	Stock	39.87	40.02	39.845	39.98	3180038.0
2014-05-02 10:30:00	MSFT	Stock	39.98	40.04	39.84	39.86	2284961.0
2014-05-02 11:00:00	MSFT	Stock	39.86	39.96	39.77	39.78	1373049.0
2014-05-02 11:30:00	MSFT	Stock	39.79	39.94	39.79	39.92	1029968.0
2014-05-02 12:00:00	MSFT	Stock	39.92	39.926	39.83	39.867	634204.0
2014-05-02 12:30:00	MSFT	Stock	39.86	39.97	39.85	39.91	832313.0
2014-05-02 13:00:00	MSFT	Stock	39.911	39.945	39.82	39.82	3179749.0
2014-05-02 13:30:00	MSFT	Stock	39.832	39.832	39.76	39.79	2016217.0
2014-05-02 14:00:00	MSFT	Stock	39.796	39.82	39.66	39.68	4749013.0
2014-05-02 14:30:00	MSFT	Stock	39.69	39.82	39.685	39.756	3826730.0
2014-05-02 15:00:00	MSFT	Stock	39.76	39.815	39.75	39.76	3557060.0
2014-05-02 15:30:00	MSFT	Stock	39.76	39.8	39.67	39.69	7987389.0
2014-05-02 16:00:00	MSFT	Stock	39.69	39.836	39.68	39.73	2326953.0
2014-05-02 16:30:00	MSFT	Stock	39.73	39.913	39.69	39.73	41910.0
2014-05-02 17:00:00	MSFT	Stock	39.73	39.88	39.73	39.75	13431.0
2014-05-02 17:30:00	MSFT	Stock	39.7	39.7	39.7	39.7	1800.0

> showing 50 of 80,217 rows — these rows as CSV

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