PREVIEW / stock_5min / 2012-11-23

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-11-23.parquet
  size:    2.7 MB
  rows:    172,944
  symbols: 3,325

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-11-23 04:05:00	AAPL	Stock	20.125	20.125	20.125	20.125	14000.0
2012-11-23 04:25:00	AAPL	Stock	20.125	20.125	20.125	20.125	2800.0
2012-11-23 04:55:00	AAPL	Stock	20.1429	20.1429	20.1429	20.1429	5600.0
2012-11-23 06:05:00	AAPL	Stock	20.1625	20.1625	20.1429	20.1429	11200.0
2012-11-23 06:10:00	AAPL	Stock	20.1786	20.1786	20.1732	20.1732	25200.0
2012-11-23 06:15:00	AAPL	Stock	20.175	20.1786	20.175	20.1786	33600.0
2012-11-23 06:30:00	AAPL	Stock	20.1793	20.2479	20.1793	20.2479	33180.0
2012-11-23 07:00:00	AAPL	Stock	20.1875	20.1875	20.1875	20.1875	5600.0
2012-11-23 07:05:00	AAPL	Stock	20.1875	20.1929	20.1418	20.1429	123648.0
2012-11-23 07:10:00	AAPL	Stock	20.1321	20.1407	20.1239	20.1286	47936.0
2012-11-23 07:15:00	AAPL	Stock	20.1268	20.1429	20.1268	20.1429	12236.0
2012-11-23 07:20:00	AAPL	Stock	20.1429	20.1461	20.1429	20.1461	8400.0
2012-11-23 07:25:00	AAPL	Stock	20.1604	20.1607	20.1604	20.1607	5600.0
2012-11-23 07:35:00	AAPL	Stock	20.1607	20.1661	20.1446	20.1661	14000.0
2012-11-23 07:40:00	AAPL	Stock	20.1643	20.1707	20.1643	20.1646	14000.0
2012-11-23 07:45:00	AAPL	Stock	20.1643	20.1643	20.1518	20.1518	22400.0
2012-11-23 07:50:00	AAPL	Stock	20.1518	20.1518	20.1518	20.1518	8260.0
2012-11-23 07:55:00	AAPL	Stock	20.1493	20.1493	20.1489	20.1489	25816.0
2012-11-23 08:00:00	AAPL	Stock	20.16	20.1775	20.1504	20.1607	167384.0
2012-11-23 08:05:00	AAPL	Stock	20.1546	20.1654	20.1493	20.165	110460.0
2012-11-23 08:10:00	AAPL	Stock	20.1643	20.1675	20.1607	20.1607	40040.0
2012-11-23 08:15:00	AAPL	Stock	20.1607	20.1661	20.1554	20.1571	100800.0
2012-11-23 08:20:00	AAPL	Stock	20.1571	20.1625	20.1521	20.1625	71512.0
2012-11-23 08:25:00	AAPL	Stock	20.1629	20.1839	20.1571	20.1779	345744.0
2012-11-23 08:30:00	AAPL	Stock	20.1786	20.1964	20.1782	20.1864	183568.0
2012-11-23 08:35:00	AAPL	Stock	20.1893	20.205	20.1879	20.2	110180.0
2012-11-23 08:40:00	AAPL	Stock	20.1996	20.2036	20.1875	20.2004	135072.0
2012-11-23 08:45:00	AAPL	Stock	20.2036	20.21	20.2004	20.2054	126000.0
2012-11-23 08:50:00	AAPL	Stock	20.2054	20.2057	20.1821	20.1832	131740.0
2012-11-23 08:55:00	AAPL	Stock	20.1832	20.1925	20.1786	20.1893	130396.0
2012-11-23 09:00:00	AAPL	Stock	20.1807	20.1821	20.1646	20.1686	145320.0
2012-11-23 09:05:00	AAPL	Stock	20.1711	20.1711	20.1489	20.1607	211652.0
2012-11-23 09:10:00	AAPL	Stock	20.1607	20.1782	20.1582	20.1746	342524.0
2012-11-23 09:15:00	AAPL	Stock	20.1732	20.1775	20.1661	20.1775	67956.0
2012-11-23 09:20:00	AAPL	Stock	20.1775	20.1782	20.1729	20.175	174720.0
2012-11-23 09:25:00	AAPL	Stock	20.1779	20.2743	20.1718	20.2593	1640212.0
2012-11-23 09:30:00	AAPL	Stock	20.2561	20.2696	20.1846	20.1871	16485112.0
2012-11-23 09:35:00	AAPL	Stock	20.1875	20.2011	20.1429	20.1486	9286732.0
2012-11-23 09:40:00	AAPL	Stock	20.1468	20.1632	20.1086	20.1421	9207184.0
2012-11-23 09:45:00	AAPL	Stock	20.1368	20.1889	20.1161	20.1729	7524188.0
2012-11-23 09:50:00	AAPL	Stock	20.1771	20.1829	20.1479	20.1661	4824316.0
2012-11-23 09:55:00	AAPL	Stock	20.1657	20.1657	20.1043	20.1089	6278356.0
2012-11-23 10:00:00	AAPL	Stock	20.1086	20.1357	20.0929	20.1146	5693296.0
2012-11-23 10:05:00	AAPL	Stock	20.115	20.1439	20.0993	20.1429	4826360.0
2012-11-23 10:10:00	AAPL	Stock	20.1418	20.1686	20.1418	20.1511	5446560.0
2012-11-23 10:15:00	AAPL	Stock	20.1557	20.1725	20.1268	20.1344	4716432.0
2012-11-23 10:20:00	AAPL	Stock	20.1293	20.1571	20.115	20.1539	4344256.0
2012-11-23 10:25:00	AAPL	Stock	20.1518	20.1754	20.1429	20.1504	4091612.0
2012-11-23 10:30:00	AAPL	Stock	20.1507	20.1821	20.1479	20.1757	4768932.0
2012-11-23 10:35:00	AAPL	Stock	20.17	20.1729	20.1475	20.1546	2883048.0

> showing 50 of 172,944 rows — these rows as CSV

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