PREVIEW / stock_5min / 2011-02-01

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-02-01.parquet
  size:    5.1 MB
  rows:    343,328
  symbols: 3,524

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
2011-02-01 04:00:00	AAPL	Stock	12.1332	12.1332	12.1332	12.1332	5600.0
2011-02-01 04:10:00	AAPL	Stock	12.1696	12.1696	12.1696	12.1696	2800.0
2011-02-01 04:20:00	AAPL	Stock	12.1607	12.1607	12.1607	12.1607	2800.0
2011-02-01 04:25:00	AAPL	Stock	12.1568	12.1575	12.1536	12.1536	14000.0
2011-02-01 04:45:00	AAPL	Stock	12.1607	12.1607	12.1607	12.1607	2800.0
2011-02-01 04:50:00	AAPL	Stock	12.1668	12.1668	12.1607	12.1607	5600.0
2011-02-01 04:55:00	AAPL	Stock	12.1404	12.1404	12.1404	12.1404	2800.0
2011-02-01 05:05:00	AAPL	Stock	12.1554	12.1554	12.1554	12.1554	2800.0
2011-02-01 05:40:00	AAPL	Stock	12.1529	12.1529	12.1529	12.1529	2800.0
2011-02-01 06:00:00	AAPL	Stock	12.16	12.16	12.1393	12.1393	8400.0
2011-02-01 06:30:00	AAPL	Stock	12.1696	12.1696	12.1696	12.1696	4900.0
2011-02-01 06:40:00	AAPL	Stock	12.1696	12.1696	12.1696	12.1696	2800.0
2011-02-01 06:50:00	AAPL	Stock	12.1696	12.1696	12.1696	12.1696	5600.0
2011-02-01 07:00:00	AAPL	Stock	12.1696	12.1696	12.1693	12.1696	36400.0
2011-02-01 07:05:00	AAPL	Stock	12.1696	12.1714	12.1696	12.1711	29400.0
2011-02-01 07:10:00	AAPL	Stock	12.1625	12.1657	12.1625	12.1657	22400.0
2011-02-01 07:15:00	AAPL	Stock	12.1693	12.1693	12.1661	12.1693	31920.0
2011-02-01 07:20:00	AAPL	Stock	12.1707	12.1732	12.1707	12.1732	34020.0
2011-02-01 07:25:00	AAPL	Stock	12.1757	12.1764	12.175	12.175	30632.0
2011-02-01 07:30:00	AAPL	Stock	12.1739	12.1775	12.1739	12.1775	19600.0
2011-02-01 07:35:00	AAPL	Stock	12.1736	12.1736	12.1714	12.1714	37800.0
2011-02-01 07:40:00	AAPL	Stock	12.1607	12.1607	12.16	12.16	11200.0
2011-02-01 07:45:00	AAPL	Stock	12.1571	12.1675	12.1554	12.1675	14000.0
2011-02-01 07:50:00	AAPL	Stock	12.1675	12.1675	12.1675	12.1675	7700.0
2011-02-01 07:55:00	AAPL	Stock	12.1571	12.1625	12.1571	12.1625	8400.0
2011-02-01 08:00:00	AAPL	Stock	12.1582	12.1675	12.1186	12.1604	389928.0
2011-02-01 08:05:00	AAPL	Stock	12.1604	12.175	12.1604	12.1646	157808.0
2011-02-01 08:10:00	AAPL	Stock	12.1707	12.1818	12.1707	12.1779	286888.0
2011-02-01 08:15:00	AAPL	Stock	12.1796	12.1818	12.1786	12.1807	61040.0
2011-02-01 08:20:00	AAPL	Stock	12.1846	12.1893	12.1186	12.1893	142380.0
2011-02-01 08:25:00	AAPL	Stock	12.1893	12.1943	12.1893	12.1921	108640.0
2011-02-01 08:30:00	AAPL	Stock	12.1921	12.1925	12.1879	12.1907	119336.0
2011-02-01 08:35:00	AAPL	Stock	12.1882	12.1882	12.1832	12.1832	64400.0
2011-02-01 08:40:00	AAPL	Stock	12.1821	12.1854	12.1818	12.1854	102480.0
2011-02-01 08:45:00	AAPL	Stock	12.1854	12.1889	12.1839	12.1854	93436.0
2011-02-01 08:50:00	AAPL	Stock	12.1843	12.1843	12.1732	12.1732	187936.0
2011-02-01 08:55:00	AAPL	Stock	12.17	12.175	12.1186	12.175	132860.0
2011-02-01 09:00:00	AAPL	Stock	12.1768	12.1782	12.1186	12.1186	308420.0
2011-02-01 09:05:00	AAPL	Stock	12.1746	12.1746	12.1186	12.1668	60816.0
2011-02-01 09:10:00	AAPL	Stock	12.1693	12.1786	12.1671	12.1786	123760.0
2011-02-01 09:15:00	AAPL	Stock	12.1804	12.1893	12.1782	12.1875	166012.0
2011-02-01 09:20:00	AAPL	Stock	12.1871	12.1882	12.1857	12.1857	118804.0
2011-02-01 09:25:00	AAPL	Stock	12.1864	12.1961	12.1825	12.1957	437976.0
2011-02-01 09:30:00	AAPL	Stock	12.1893	12.225	12.1779	12.2232	16098236.0
2011-02-01 09:35:00	AAPL	Stock	12.2243	12.2496	12.21	12.2211	13630176.0
2011-02-01 09:40:00	AAPL	Stock	12.2211	12.2411	12.2154	12.2312	7691404.0
2011-02-01 09:45:00	AAPL	Stock	12.2318	12.2475	12.2225	12.2289	7138292.0
2011-02-01 09:50:00	AAPL	Stock	12.2271	12.2411	12.2186	12.225	5510148.0
2011-02-01 09:55:00	AAPL	Stock	12.225	12.2318	12.2214	12.2296	3775380.0
2011-02-01 10:00:00	AAPL	Stock	12.2277	12.2468	12.2	12.2229	9155524.0

> showing 50 of 343,328 rows — these rows as CSV

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