PREVIEW / stock_5min / 2014-04-25

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-04-25.parquet
  size:    5.4 MB
  rows:    359,056
  symbols: 3,525

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
2014-04-25 04:00:00	AAPL	Stock	20.1857	20.1857	20.1539	20.1539	14000.0
2014-04-25 04:15:00	AAPL	Stock	20.15	20.15	20.15	20.15	2800.0
2014-04-25 04:20:00	AAPL	Stock	20.1607	20.1607	20.1607	20.1607	2800.0
2014-04-25 04:30:00	AAPL	Stock	20.1607	20.1607	20.1607	20.1607	2800.0
2014-04-25 04:45:00	AAPL	Stock	20.1593	20.1593	20.15	20.15	27020.0
2014-04-25 04:55:00	AAPL	Stock	20.1468	20.1468	20.1429	20.1429	5600.0
2014-04-25 05:05:00	AAPL	Stock	20.1429	20.1429	20.1429	20.1429	8400.0
2014-04-25 05:10:00	AAPL	Stock	20.1464	20.1618	20.1464	20.1614	13440.0
2014-04-25 05:40:00	AAPL	Stock	20.1593	20.1593	20.1593	20.1593	2800.0
2014-04-25 06:05:00	AAPL	Stock	20.15	20.15	20.15	20.15	4984.0
2014-04-25 06:25:00	AAPL	Stock	20.1661	20.1743	20.1661	20.1743	5880.0
2014-04-25 06:30:00	AAPL	Stock	20.1661	20.1679	20.1661	20.1679	8400.0
2014-04-25 06:35:00	AAPL	Stock	20.1679	20.1679	20.1075	20.1075	47992.0
2014-04-25 06:40:00	AAPL	Stock	20.1425	20.1425	20.1425	20.1425	2800.0
2014-04-25 06:45:00	AAPL	Stock	20.1246	20.1246	20.1246	20.1246	5600.0
2014-04-25 06:55:00	AAPL	Stock	20.125	20.1318	20.0754	20.0754	78484.0
2014-04-25 07:00:00	AAPL	Stock	20.1318	20.1318	20.0714	20.1075	15120.0
2014-04-25 07:05:00	AAPL	Stock	20.1071	20.1154	20.1071	20.1154	8400.0
2014-04-25 07:15:00	AAPL	Stock	20.1161	20.1161	20.1125	20.1161	18200.0
2014-04-25 07:20:00	AAPL	Stock	20.1161	20.1161	20.0982	20.0996	150304.0
2014-04-25 07:25:00	AAPL	Stock	20.1068	20.1071	20.1068	20.1071	19600.0
2014-04-25 07:30:00	AAPL	Stock	20.1161	20.1164	20.1	20.1	93856.0
2014-04-25 07:35:00	AAPL	Stock	20.1	20.1	20.0929	20.0929	40264.0
2014-04-25 07:40:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	2800.0
2014-04-25 07:45:00	AAPL	Stock	20.1214	20.1375	20.12	20.1375	26180.0
2014-04-25 07:50:00	AAPL	Stock	20.1357	20.1607	20.1357	20.1425	116116.0
2014-04-25 07:55:00	AAPL	Stock	20.1432	20.15	20.1421	20.1432	47432.0
2014-04-25 08:00:00	AAPL	Stock	20.1429	20.1564	20.1	20.1375	266252.0
2014-04-25 08:05:00	AAPL	Stock	20.1425	20.1429	20.1354	20.1429	137564.0
2014-04-25 08:10:00	AAPL	Stock	20.1425	20.1429	20.1357	20.1357	36400.0
2014-04-25 08:15:00	AAPL	Stock	20.1361	20.1429	20.1357	20.1389	37940.0
2014-04-25 08:20:00	AAPL	Stock	20.1389	20.1482	20.1386	20.1429	265272.0
2014-04-25 08:25:00	AAPL	Stock	20.1429	20.1493	20.1429	20.1429	152740.0
2014-04-25 08:30:00	AAPL	Stock	20.145	20.1739	20.1429	20.1718	206752.0
2014-04-25 08:35:00	AAPL	Stock	20.1732	20.1811	20.1632	20.1789	178444.0
2014-04-25 08:40:00	AAPL	Stock	20.1836	20.1839	20.1746	20.175	42168.0
2014-04-25 08:45:00	AAPL	Stock	20.1732	20.1786	20.1604	20.1786	149744.0
2014-04-25 08:50:00	AAPL	Stock	20.1779	20.1839	20.1604	20.1682	140560.0
2014-04-25 08:55:00	AAPL	Stock	20.1689	20.1839	20.1618	20.1736	201040.0
2014-04-25 09:00:00	AAPL	Stock	20.1782	20.2029	20.1782	20.1961	305284.0
2014-04-25 09:05:00	AAPL	Stock	20.1964	20.1982	20.1789	20.1789	237804.0
2014-04-25 09:10:00	AAPL	Stock	20.1793	20.1875	20.1546	20.1546	128296.0
2014-04-25 09:15:00	AAPL	Stock	20.1561	20.1561	20.1439	20.1439	40964.0
2014-04-25 09:20:00	AAPL	Stock	20.1446	20.1571	20.1429	20.1571	92092.0
2014-04-25 09:25:00	AAPL	Stock	20.1557	20.165	20.1379	20.1464	523460.0
2014-04-25 09:30:00	AAPL	Stock	20.1618	20.2104	20.1414	20.2	13805512.0
2014-04-25 09:35:00	AAPL	Stock	20.1986	20.2143	20.1846	20.1997	6209224.0
2014-04-25 09:40:00	AAPL	Stock	20.1943	20.2607	20.1896	20.2607	8258152.0
2014-04-25 09:45:00	AAPL	Stock	20.2607	20.2817	20.2386	20.2432	8602664.0
2014-04-25 09:50:00	AAPL	Stock	20.2418	20.2436	20.1986	20.2204	6276564.0

> showing 50 of 359,056 rows — these rows as CSV

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