PREVIEW / stock_5min / 2013-04-05

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-04-05.parquet
  size:    4.9 MB
  rows:    330,054
  symbols: 3,474

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-04-05 04:00:00	AAPL	Stock	15.2643	15.2643	15.2643	15.2643	2800.0
2013-04-05 04:30:00	AAPL	Stock	15.2857	15.2857	15.2857	15.2857	4928.0
2013-04-05 04:45:00	AAPL	Stock	15.2857	15.2857	15.2857	15.2857	5600.0
2013-04-05 05:15:00	AAPL	Stock	15.2736	15.2736	15.2714	15.2714	16800.0
2013-04-05 05:20:00	AAPL	Stock	15.2679	15.2679	15.2589	15.2589	16800.0
2013-04-05 05:25:00	AAPL	Stock	15.2589	15.2589	15.2589	15.2589	10332.0
2013-04-05 05:50:00	AAPL	Stock	15.2525	15.2525	15.2482	15.2482	39704.0
2013-04-05 06:50:00	AAPL	Stock	15.2268	15.2268	15.2268	15.2268	2800.0
2013-04-05 07:00:00	AAPL	Stock	15.2007	15.2007	15.2	15.2	29400.0
2013-04-05 07:05:00	AAPL	Stock	15.1946	15.2575	15.1946	15.25	58800.0
2013-04-05 07:10:00	AAPL	Stock	15.2357	15.2357	15.2357	15.2357	3052.0
2013-04-05 07:15:00	AAPL	Stock	15.2046	15.2096	15.1996	15.2096	76608.0
2013-04-05 07:20:00	AAPL	Stock	15.2014	15.2014	15.1786	15.1796	86324.0
2013-04-05 07:25:00	AAPL	Stock	15.1857	15.1964	15.1786	15.1804	99960.0
2013-04-05 07:30:00	AAPL	Stock	15.1882	15.1882	15.1882	15.1882	3360.0
2013-04-05 07:35:00	AAPL	Stock	15.2	15.2	15.2	15.2	5600.0
2013-04-05 07:40:00	AAPL	Stock	15.195	15.2054	15.1886	15.2054	29904.0
2013-04-05 07:45:00	AAPL	Stock	15.2079	15.2143	15.2079	15.2143	8400.0
2013-04-05 07:50:00	AAPL	Stock	15.2254	15.2254	15.2232	15.2232	8400.0
2013-04-05 07:55:00	AAPL	Stock	15.2189	15.2189	15.2189	15.2189	18592.0
2013-04-05 08:00:00	AAPL	Stock	15.2261	15.2325	15.2036	15.2218	82628.0
2013-04-05 08:05:00	AAPL	Stock	15.225	15.225	15.2079	15.2086	124320.0
2013-04-05 08:10:00	AAPL	Stock	15.2139	15.2307	15.2139	15.2179	44380.0
2013-04-05 08:15:00	AAPL	Stock	15.225	15.2393	15.225	15.2332	36400.0
2013-04-05 08:20:00	AAPL	Stock	15.2332	15.2457	15.2321	15.2321	58912.0
2013-04-05 08:25:00	AAPL	Stock	15.2368	15.2368	15.225	15.2296	49000.0
2013-04-05 08:30:00	AAPL	Stock	15.2261	15.2357	15.1325	15.145	1091916.0
2013-04-05 08:35:00	AAPL	Stock	15.1446	15.1864	15.1446	15.1714	371756.0
2013-04-05 08:40:00	AAPL	Stock	15.1721	15.1764	15.1625	15.175	174524.0
2013-04-05 08:45:00	AAPL	Stock	15.1704	15.1704	15.1371	15.1371	355124.0
2013-04-05 08:50:00	AAPL	Stock	15.1361	15.1482	15.1339	15.1379	250376.0
2013-04-05 08:55:00	AAPL	Stock	15.1461	15.1546	15.125	15.135	260176.0
2013-04-05 09:00:00	AAPL	Stock	15.1361	15.1464	15.1325	15.1393	218960.0
2013-04-05 09:05:00	AAPL	Stock	15.1439	15.165	15.1439	15.1618	300160.0
2013-04-05 09:10:00	AAPL	Stock	15.1621	15.1661	15.1518	15.1621	265664.0
2013-04-05 09:15:00	AAPL	Stock	15.1654	15.1675	15.1536	15.1607	283220.0
2013-04-05 09:20:00	AAPL	Stock	15.1582	15.1679	15.1571	15.1593	242508.0
2013-04-05 09:25:00	AAPL	Stock	15.1629	15.1718	15.1507	15.1564	604828.0
2013-04-05 09:30:00	AAPL	Stock	15.1546	15.1654	15.0774	15.1143	22115464.0
2013-04-05 09:35:00	AAPL	Stock	15.1157	15.1361	15.0868	15.1079	9597168.0
2013-04-05 09:40:00	AAPL	Stock	15.1079	15.1207	15.0714	15.1091	12146512.0
2013-04-05 09:45:00	AAPL	Stock	15.1064	15.1103	15.0607	15.0657	8740592.0
2013-04-05 09:50:00	AAPL	Stock	15.0622	15.085	15.0482	15.0711	8660260.0
2013-04-05 09:55:00	AAPL	Stock	15.0702	15.0982	15.0643	15.0718	5370848.0
2013-04-05 10:00:00	AAPL	Stock	15.075	15.0768	15.0546	15.0714	5743304.0
2013-04-05 10:05:00	AAPL	Stock	15.0668	15.1157	15.0582	15.1143	5309780.0
2013-04-05 10:10:00	AAPL	Stock	15.1143	15.1143	15.0714	15.0859	4542216.0
2013-04-05 10:15:00	AAPL	Stock	15.0864	15.0887	15.0639	15.0839	4710636.0
2013-04-05 10:20:00	AAPL	Stock	15.0854	15.1032	15.08	15.0982	4207616.0
2013-04-05 10:25:00	AAPL	Stock	15.0991	15.1536	15.0925	15.1243	8621816.0

> showing 50 of 330,054 rows — these rows as CSV

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