PREVIEW / stock_5min / 2013-05-14

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-05-14.parquet
  size:    5.1 MB
  rows:    340,362
  symbols: 3,522

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-05-14 05:00:00	AAPL	Stock	16.1929	16.1929	16.1929	16.1929	3920.0
2013-05-14 05:55:00	AAPL	Stock	16.1871	16.1871	16.1871	16.1871	7364.0
2013-05-14 06:00:00	AAPL	Stock	16.1804	16.1804	16.1804	16.1804	2800.0
2013-05-14 07:10:00	AAPL	Stock	16.1982	16.1982	16.1982	16.1982	3192.0
2013-05-14 07:20:00	AAPL	Stock	16.2143	16.2143	16.2143	16.2143	8400.0
2013-05-14 07:25:00	AAPL	Stock	16.2143	16.2143	16.2143	16.2143	5600.0
2013-05-14 07:30:00	AAPL	Stock	16.2018	16.2054	16.2018	16.2054	8400.0
2013-05-14 07:35:00	AAPL	Stock	16.2054	16.2054	16.1646	16.1786	60368.0
2013-05-14 07:40:00	AAPL	Stock	16.1964	16.1964	16.1964	16.1964	11200.0
2013-05-14 07:45:00	AAPL	Stock	16.2121	16.2143	16.2121	16.2121	17332.0
2013-05-14 07:50:00	AAPL	Stock	16.2243	16.2643	16.2232	16.25	54600.0
2013-05-14 07:55:00	AAPL	Stock	16.2507	16.2675	16.25	16.2675	36400.0
2013-05-14 08:00:00	AAPL	Stock	16.2589	16.2904	16.1786	16.2771	226268.0
2013-05-14 08:05:00	AAPL	Stock	16.1786	16.2843	16.1786	16.2843	36428.0
2013-05-14 08:10:00	AAPL	Stock	16.2821	16.2821	16.26	16.2679	91840.0
2013-05-14 08:15:00	AAPL	Stock	16.2589	16.2761	16.2471	16.25	254268.0
2013-05-14 08:20:00	AAPL	Stock	16.2414	16.25	16.2325	16.25	77000.0
2013-05-14 08:25:00	AAPL	Stock	16.25	16.2671	16.2143	16.2232	130788.0
2013-05-14 08:30:00	AAPL	Stock	16.2161	16.2218	16.2054	16.2071	60424.0
2013-05-14 08:35:00	AAPL	Stock	16.1964	16.2054	16.1864	16.1886	187180.0
2013-05-14 08:40:00	AAPL	Stock	16.1889	16.2	16.1875	16.2	285012.0
2013-05-14 08:45:00	AAPL	Stock	16.2068	16.2143	16.2043	16.2054	78428.0
2013-05-14 08:50:00	AAPL	Stock	16.2107	16.2132	16.2036	16.2107	101836.0
2013-05-14 08:55:00	AAPL	Stock	16.2043	16.2071	16.2032	16.2032	57120.0
2013-05-14 09:00:00	AAPL	Stock	16.2018	16.2018	16.1879	16.1893	131180.0
2013-05-14 09:05:00	AAPL	Stock	16.1961	16.1964	16.1932	16.1961	31080.0
2013-05-14 09:10:00	AAPL	Stock	16.1982	16.2018	16.1982	16.2018	33656.0
2013-05-14 09:15:00	AAPL	Stock	16.2136	16.2136	16.2054	16.2054	30800.0
2013-05-14 09:20:00	AAPL	Stock	16.2118	16.2161	16.2071	16.2071	28000.0
2013-05-14 09:25:00	AAPL	Stock	16.2089	16.2139	16.2036	16.2104	186172.0
2013-05-14 09:30:00	AAPL	Stock	16.2089	16.2571	16.1821	16.2304	10876432.0
2013-05-14 09:35:00	AAPL	Stock	16.2318	16.2375	16.1643	16.2235	9395064.0
2013-05-14 09:40:00	AAPL	Stock	16.2243	16.2371	16.1511	16.1818	10947272.0
2013-05-14 09:45:00	AAPL	Stock	16.1821	16.2029	16.1489	16.1646	7927948.0
2013-05-14 09:50:00	AAPL	Stock	16.1657	16.1729	16.1304	16.1332	8386280.0
2013-05-14 09:55:00	AAPL	Stock	16.1325	16.1657	16.13	16.1414	5155640.0
2013-05-14 10:00:00	AAPL	Stock	16.1436	16.1764	16.1204	16.1686	7373604.0
2013-05-14 10:05:00	AAPL	Stock	16.1686	16.1729	16.1429	16.1696	4276776.0
2013-05-14 10:10:00	AAPL	Stock	16.1697	16.205	16.1682	16.1946	7343448.0
2013-05-14 10:15:00	AAPL	Stock	16.1977	16.2	16.1518	16.1571	6082636.0
2013-05-14 10:20:00	AAPL	Stock	16.1577	16.1854	16.1482	16.1779	3390044.0
2013-05-14 10:25:00	AAPL	Stock	16.1764	16.1946	16.1696	16.1868	4020520.0
2013-05-14 10:30:00	AAPL	Stock	16.1868	16.1954	16.1811	16.1829	2425528.0
2013-05-14 10:35:00	AAPL	Stock	16.1836	16.1871	16.1668	16.1679	4335296.0
2013-05-14 10:40:00	AAPL	Stock	16.1679	16.1764	16.1607	16.1693	2141720.0
2013-05-14 10:45:00	AAPL	Stock	16.1693	16.1932	16.1639	16.1861	3349584.0
2013-05-14 10:50:00	AAPL	Stock	16.1875	16.19	16.1702	16.1864	2769844.0
2013-05-14 10:55:00	AAPL	Stock	16.1875	16.1989	16.1786	16.1869	3995712.0
2013-05-14 11:00:00	AAPL	Stock	16.1856	16.1964	16.1721	16.1765	3758748.0
2013-05-14 11:05:00	AAPL	Stock	16.1768	16.1786	16.1621	16.1621	2458596.0

> showing 50 of 340,362 rows — these rows as CSV

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