PREVIEW / stock_5min / 2013-01-25

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-01-25.parquet
  size:    4.9 MB
  rows:    332,445
  symbols: 3,469

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-01-25 04:00:00	AAPL	Stock	16.0711	16.1929	16.0711	16.15	114576.0
2013-01-25 04:05:00	AAPL	Stock	16.15	16.1554	16.1479	16.1554	46200.0
2013-01-25 04:10:00	AAPL	Stock	16.155	16.1607	16.1429	16.1429	52780.0
2013-01-25 04:15:00	AAPL	Stock	16.1568	16.175	16.1554	16.175	114800.0
2013-01-25 04:35:00	AAPL	Stock	16.1786	16.1786	16.1786	16.1786	2800.0
2013-01-25 04:40:00	AAPL	Stock	16.1786	16.1786	16.1786	16.1786	5600.0
2013-01-25 04:45:00	AAPL	Stock	16.1911	16.1911	16.1786	16.1786	5600.0
2013-01-25 04:55:00	AAPL	Stock	16.1964	16.1964	16.1964	16.1964	56000.0
2013-01-25 05:00:00	AAPL	Stock	16.1839	16.1839	16.1839	16.1839	2800.0
2013-01-25 05:05:00	AAPL	Stock	16.1786	16.1786	16.1786	16.1786	5740.0
2013-01-25 05:10:00	AAPL	Stock	16.1786	16.1786	16.1786	16.1786	2800.0
2013-01-25 05:20:00	AAPL	Stock	16.1911	16.1911	16.1911	16.1911	2800.0
2013-01-25 05:25:00	AAPL	Stock	16.1839	16.1911	16.1657	16.1893	16800.0
2013-01-25 05:30:00	AAPL	Stock	16.1857	16.1857	16.1786	16.1786	22400.0
2013-01-25 05:35:00	AAPL	Stock	16.1696	16.1714	16.1696	16.1714	8400.0
2013-01-25 05:40:00	AAPL	Stock	16.1625	16.1625	16.1557	16.1557	6720.0
2013-01-25 05:45:00	AAPL	Stock	16.1607	16.1607	16.1429	16.1429	37240.0
2013-01-25 05:55:00	AAPL	Stock	16.125	16.1429	16.125	16.1429	35560.0
2013-01-25 06:00:00	AAPL	Stock	16.1493	16.15	16.1429	16.15	21000.0
2013-01-25 06:05:00	AAPL	Stock	16.1482	16.1482	16.1429	16.1429	36120.0
2013-01-25 06:10:00	AAPL	Stock	16.1429	16.1429	16.1421	16.1429	26124.0
2013-01-25 06:20:00	AAPL	Stock	16.1421	16.1429	16.1421	16.1429	5600.0
2013-01-25 06:25:00	AAPL	Stock	16.1425	16.1425	16.1357	16.1357	5600.0
2013-01-25 06:30:00	AAPL	Stock	16.1514	16.1518	16.125	16.1518	33600.0
2013-01-25 06:35:00	AAPL	Stock	16.1596	16.1646	16.1596	16.1646	19600.0
2013-01-25 06:40:00	AAPL	Stock	16.1679	16.1679	16.1429	16.1429	8400.0
2013-01-25 07:00:00	AAPL	Stock	16.1307	16.1429	16.1221	16.1421	151144.0
2013-01-25 07:05:00	AAPL	Stock	16.1429	16.1639	16.1429	16.1571	96600.0
2013-01-25 07:10:00	AAPL	Stock	16.1504	16.1775	16.15	16.1575	134876.0
2013-01-25 07:15:00	AAPL	Stock	16.1643	16.1668	16.1446	16.1514	74228.0
2013-01-25 07:20:00	AAPL	Stock	16.1604	16.1652	16.1504	16.1554	38920.0
2013-01-25 07:25:00	AAPL	Stock	16.1596	16.1607	16.1429	16.1486	178500.0
2013-01-25 07:30:00	AAPL	Stock	16.1486	16.1779	16.1486	16.1746	87416.0
2013-01-25 07:35:00	AAPL	Stock	16.1696	16.1964	16.1643	16.1964	294952.0
2013-01-25 07:40:00	AAPL	Stock	16.195	16.1964	16.1829	16.1907	293272.0
2013-01-25 07:45:00	AAPL	Stock	16.1875	16.1875	16.1725	16.1775	148400.0
2013-01-25 07:50:00	AAPL	Stock	16.1746	16.1996	16.1739	16.1964	287140.0
2013-01-25 07:55:00	AAPL	Stock	16.1964	16.1964	16.1793	16.1821	164892.0
2013-01-25 08:00:00	AAPL	Stock	16.1871	16.1964	16.1218	16.1339	1014048.0
2013-01-25 08:05:00	AAPL	Stock	16.1325	16.1711	16.1161	16.1711	616112.0
2013-01-25 08:10:00	AAPL	Stock	16.1736	16.1993	16.1714	16.1879	731472.0
2013-01-25 08:15:00	AAPL	Stock	16.1889	16.1975	16.1825	16.1882	783748.0
2013-01-25 08:20:00	AAPL	Stock	16.1875	16.2118	16.1843	16.2071	822220.0
2013-01-25 08:25:00	AAPL	Stock	16.2039	16.2043	16.1621	16.1621	657916.0
2013-01-25 08:30:00	AAPL	Stock	16.1704	16.1714	16.1621	16.1704	147084.0
2013-01-25 08:35:00	AAPL	Stock	16.1661	16.1661	16.15	16.1518	307776.0
2013-01-25 08:40:00	AAPL	Stock	16.1571	16.1786	16.1571	16.1732	316232.0
2013-01-25 08:45:00	AAPL	Stock	16.1746	16.1775	16.1639	16.1725	199472.0
2013-01-25 08:50:00	AAPL	Stock	16.1704	16.1743	16.1671	16.1743	98560.0
2013-01-25 08:55:00	AAPL	Stock	16.1746	16.1782	16.1682	16.1696	204596.0

> showing 50 of 332,445 rows — these rows as CSV

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