PREVIEW / stock_5min / 2012-01-10

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-01-10.parquet
  size:    4.8 MB
  rows:    328,116
  symbols: 3,538

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
2012-01-10 04:00:00	AAPL	Stock	15.1264	15.16	15.1264	15.16	19600.0
2012-01-10 04:05:00	AAPL	Stock	15.1625	15.1625	15.1529	15.1571	8400.0
2012-01-10 04:20:00	AAPL	Stock	15.1821	15.1821	15.1718	15.1718	11200.0
2012-01-10 04:25:00	AAPL	Stock	15.1714	15.1714	15.1714	15.1714	22400.0
2012-01-10 04:30:00	AAPL	Stock	15.1821	15.1821	15.1821	15.1821	8400.0
2012-01-10 04:35:00	AAPL	Stock	15.1821	15.1857	15.1821	15.1821	30800.0
2012-01-10 04:55:00	AAPL	Stock	15.1821	15.1821	15.1821	15.1821	5600.0
2012-01-10 05:05:00	AAPL	Stock	15.1857	15.1857	15.1857	15.1857	8400.0
2012-01-10 05:45:00	AAPL	Stock	15.2136	15.2136	15.2136	15.2136	14000.0
2012-01-10 06:20:00	AAPL	Stock	15.2036	15.2036	15.2036	15.2036	2800.0
2012-01-10 06:50:00	AAPL	Stock	15.1786	15.1786	15.1786	15.1786	2800.0
2012-01-10 07:00:00	AAPL	Stock	15.1786	15.1786	15.1786	15.1786	6720.0
2012-01-10 07:05:00	AAPL	Stock	15.1821	15.1954	15.1714	15.1714	34300.0
2012-01-10 07:10:00	AAPL	Stock	15.1782	15.1782	15.1614	15.1643	46508.0
2012-01-10 07:15:00	AAPL	Stock	15.1607	15.1679	15.1607	15.1679	21224.0
2012-01-10 07:20:00	AAPL	Stock	15.1693	15.1964	15.1693	15.1964	90720.0
2012-01-10 07:25:00	AAPL	Stock	15.1875	15.2125	15.1875	15.1914	124684.0
2012-01-10 07:30:00	AAPL	Stock	15.2075	15.2182	15.2029	15.21	171780.0
2012-01-10 07:35:00	AAPL	Stock	15.2046	15.2236	15.2036	15.2139	145488.0
2012-01-10 07:40:00	AAPL	Stock	15.2061	15.2061	15.2061	15.2061	2800.0
2012-01-10 07:45:00	AAPL	Stock	15.2089	15.2268	15.2057	15.2057	33460.0
2012-01-10 07:50:00	AAPL	Stock	15.2082	15.2082	15.2054	15.2054	12236.0
2012-01-10 07:55:00	AAPL	Stock	15.205	15.2104	15.2	15.2	38500.0
2012-01-10 08:00:00	AAPL	Stock	15.2054	15.2229	15.1789	15.1875	439908.0
2012-01-10 08:05:00	AAPL	Stock	15.1807	15.1943	15.1786	15.1807	182700.0
2012-01-10 08:10:00	AAPL	Stock	15.1857	15.1936	15.18	15.1875	85512.0
2012-01-10 08:15:00	AAPL	Stock	15.195	15.2032	15.1882	15.1982	88676.0
2012-01-10 08:20:00	AAPL	Stock	15.1989	15.2071	15.1968	15.2071	90468.0
2012-01-10 08:25:00	AAPL	Stock	15.2071	15.2143	15.2036	15.2143	177212.0
2012-01-10 08:30:00	AAPL	Stock	15.2139	15.2179	15.2107	15.2164	235256.0
2012-01-10 08:35:00	AAPL	Stock	15.215	15.2161	15.2129	15.2154	169792.0
2012-01-10 08:40:00	AAPL	Stock	15.2161	15.2182	15.2107	15.2161	94752.0
2012-01-10 08:45:00	AAPL	Stock	15.2143	15.2143	15.2089	15.2104	44380.0
2012-01-10 08:50:00	AAPL	Stock	15.2104	15.2125	15.1964	15.2014	272216.0
2012-01-10 08:55:00	AAPL	Stock	15.2014	15.2043	15.2014	15.2043	14280.0
2012-01-10 09:00:00	AAPL	Stock	15.2039	15.2143	15.2039	15.2089	124880.0
2012-01-10 09:05:00	AAPL	Stock	15.2082	15.2082	15.2036	15.2036	70000.0
2012-01-10 09:10:00	AAPL	Stock	15.2071	15.2071	15.2018	15.2018	129724.0
2012-01-10 09:15:00	AAPL	Stock	15.2039	15.2179	15.2039	15.2161	300832.0
2012-01-10 09:20:00	AAPL	Stock	15.2136	15.2275	15.2129	15.215	426832.0
2012-01-10 09:25:00	AAPL	Stock	15.2125	15.2193	15.2068	15.2139	504672.0
2012-01-10 09:30:00	AAPL	Stock	15.2114	15.2143	15.1607	15.1829	15587264.0
2012-01-10 09:35:00	AAPL	Stock	15.1825	15.1907	15.1521	15.1718	7171752.0
2012-01-10 09:40:00	AAPL	Stock	15.1707	15.1911	15.1657	15.1829	5864068.0
2012-01-10 09:45:00	AAPL	Stock	15.1814	15.1889	15.1504	15.1668	5514992.0
2012-01-10 09:50:00	AAPL	Stock	15.1646	15.1779	15.1396	15.1568	5486068.0
2012-01-10 09:55:00	AAPL	Stock	15.1579	15.1625	15.1286	15.1575	7057820.0
2012-01-10 10:00:00	AAPL	Stock	15.1604	15.1875	15.1575	15.1849	5167624.0
2012-01-10 10:05:00	AAPL	Stock	15.185	15.1875	15.1544	15.1832	5639788.0
2012-01-10 10:10:00	AAPL	Stock	15.185	15.1993	15.1786	15.1832	6274044.0

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

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