PREVIEW / stock_5min / 2011-09-19

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-09-19.parquet
  size:    4.7 MB
  rows:    322,639
  symbols: 3,507

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-09-19 04:00:00	AAPL	Stock	14.1786	14.1786	14.1254	14.1254	8400.0
2011-09-19 04:10:00	AAPL	Stock	14.1454	14.1454	14.145	14.145	5600.0
2011-09-19 04:15:00	AAPL	Stock	14.1429	14.1429	14.1429	14.1429	2800.0
2011-09-19 04:20:00	AAPL	Stock	14.1493	14.1493	14.1421	14.1421	5600.0
2011-09-19 04:25:00	AAPL	Stock	14.1432	14.1432	14.1414	14.1414	8400.0
2011-09-19 04:35:00	AAPL	Stock	14.1593	14.1596	14.1339	14.1339	33600.0
2011-09-19 04:55:00	AAPL	Stock	14.1071	14.1071	14.1071	14.1071	2800.0
2011-09-19 05:05:00	AAPL	Stock	14.1071	14.1071	14.1071	14.1071	10640.0
2011-09-19 05:10:00	AAPL	Stock	14.1214	14.1218	14.1111	14.1125	42000.0
2011-09-19 05:15:00	AAPL	Stock	14.1204	14.1264	14.1204	14.1264	5600.0
2011-09-19 05:20:00	AAPL	Stock	14.1554	14.1554	14.1554	14.1554	2800.0
2011-09-19 05:25:00	AAPL	Stock	14.1229	14.1229	14.1229	14.1229	2800.0
2011-09-19 06:00:00	AAPL	Stock	14.1289	14.1289	14.1289	14.1289	2800.0
2011-09-19 06:05:00	AAPL	Stock	14.1311	14.1321	14.1286	14.1321	13860.0
2011-09-19 06:10:00	AAPL	Stock	14.1418	14.1418	14.1418	14.1418	2800.0
2011-09-19 06:20:00	AAPL	Stock	14.1464	14.1464	14.1429	14.1429	16800.0
2011-09-19 06:40:00	AAPL	Stock	14.1404	14.1461	14.1404	14.1443	25200.0
2011-09-19 06:45:00	AAPL	Stock	14.1471	14.15	14.1471	14.15	68600.0
2011-09-19 06:50:00	AAPL	Stock	14.1514	14.1514	14.1514	14.1514	2800.0
2011-09-19 06:55:00	AAPL	Stock	14.15	14.15	14.1411	14.1411	14000.0
2011-09-19 07:00:00	AAPL	Stock	14.1454	14.1607	14.1411	14.1607	64092.0
2011-09-19 07:05:00	AAPL	Stock	14.1575	14.1796	14.1575	14.1796	59640.0
2011-09-19 07:10:00	AAPL	Stock	14.18	14.2029	14.18	14.2014	45360.0
2011-09-19 07:15:00	AAPL	Stock	14.195	14.1964	14.1786	14.1857	126924.0
2011-09-19 07:20:00	AAPL	Stock	14.1857	14.1857	14.1604	14.1668	37548.0
2011-09-19 07:25:00	AAPL	Stock	14.1679	14.1714	14.1679	14.1714	31080.0
2011-09-19 07:30:00	AAPL	Stock	14.1764	14.1964	14.1764	14.1804	177100.0
2011-09-19 07:35:00	AAPL	Stock	14.1914	14.2054	14.1914	14.1957	115696.0
2011-09-19 07:40:00	AAPL	Stock	14.1964	14.1964	14.19	14.1946	81200.0
2011-09-19 07:45:00	AAPL	Stock	14.195	14.195	14.1829	14.1829	19600.0
2011-09-19 07:50:00	AAPL	Stock	14.1875	14.1921	14.1786	14.1821	201712.0
2011-09-19 07:55:00	AAPL	Stock	14.1843	14.1886	14.1786	14.1786	129136.0
2011-09-19 08:00:00	AAPL	Stock	14.1736	14.1993	14.1732	14.1732	652288.0
2011-09-19 08:05:00	AAPL	Stock	14.1779	14.1807	14.15	14.1607	648928.0
2011-09-19 08:10:00	AAPL	Stock	14.1571	14.1732	14.1571	14.1611	382480.0
2011-09-19 08:15:00	AAPL	Stock	14.1657	14.1839	14.1607	14.175	474460.0
2011-09-19 08:20:00	AAPL	Stock	14.1786	14.1793	14.1679	14.175	425824.0
2011-09-19 08:25:00	AAPL	Stock	14.1771	14.1886	14.175	14.1882	235648.0
2011-09-19 08:30:00	AAPL	Stock	14.1804	14.1893	14.1789	14.1886	99400.0
2011-09-19 08:35:00	AAPL	Stock	14.1864	14.1929	14.1818	14.1929	282632.0
2011-09-19 08:40:00	AAPL	Stock	14.1929	14.1936	14.1814	14.1875	242144.0
2011-09-19 08:45:00	AAPL	Stock	14.1879	14.1993	14.1696	14.195	375396.0
2011-09-19 08:50:00	AAPL	Stock	14.1964	14.1964	14.1829	14.1843	423640.0
2011-09-19 08:55:00	AAPL	Stock	14.1825	14.1875	14.1786	14.1811	425824.0
2011-09-19 09:00:00	AAPL	Stock	14.1807	14.1964	14.1718	14.1786	518252.0
2011-09-19 09:05:00	AAPL	Stock	14.1786	14.1879	14.1714	14.1875	447244.0
2011-09-19 09:10:00	AAPL	Stock	14.1879	14.1893	14.1796	14.1804	590604.0
2011-09-19 09:15:00	AAPL	Stock	14.1836	14.1839	14.1782	14.1807	557228.0
2011-09-19 09:20:00	AAPL	Stock	14.1796	14.1814	14.1754	14.1789	218400.0
2011-09-19 09:25:00	AAPL	Stock	14.1811	14.1811	14.1714	14.1786	371196.0

> showing 50 of 322,639 rows — these rows as CSV

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