PREVIEW / stock_5min / 2013-11-27

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-11-27.parquet
  size:    5.2 MB
  rows:    346,686
  symbols: 3,550

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-11-27 05:10:00	AAPL	Stock	19.0971	19.0971	19.0971	19.0971	2800.0
2013-11-27 06:00:00	AAPL	Stock	19.0996	19.0996	19.0936	19.0936	5600.0
2013-11-27 06:10:00	AAPL	Stock	19.1071	19.1071	19.1071	19.1071	30800.0
2013-11-27 06:30:00	AAPL	Stock	19.1068	19.1071	19.1068	19.1071	38360.0
2013-11-27 06:35:00	AAPL	Stock	19.1225	19.1229	19.1225	19.1229	28000.0
2013-11-27 06:40:00	AAPL	Stock	19.1214	19.1214	19.1214	19.1214	2800.0
2013-11-27 06:45:00	AAPL	Stock	19.1214	19.1239	19.1214	19.1239	15792.0
2013-11-27 06:50:00	AAPL	Stock	19.1239	19.1239	19.1239	19.1239	2800.0
2013-11-27 06:55:00	AAPL	Stock	19.1093	19.1093	19.1071	19.1071	34804.0
2013-11-27 07:00:00	AAPL	Stock	19.1157	19.1243	19.1071	19.1243	90944.0
2013-11-27 07:05:00	AAPL	Stock	19.1114	19.1118	19.1107	19.1107	13300.0
2013-11-27 07:10:00	AAPL	Stock	19.1075	19.1161	19.1071	19.1161	28840.0
2013-11-27 07:15:00	AAPL	Stock	19.1164	19.13	19.1164	19.1293	132412.0
2013-11-27 07:20:00	AAPL	Stock	19.1311	19.1546	19.1311	19.1518	105140.0
2013-11-27 07:25:00	AAPL	Stock	19.1586	19.1639	19.1429	19.1429	111300.0
2013-11-27 07:30:00	AAPL	Stock	19.1518	19.1564	19.1464	19.1464	58436.0
2013-11-27 07:35:00	AAPL	Stock	19.1429	19.1429	19.1429	19.1429	2800.0
2013-11-27 07:40:00	AAPL	Stock	19.1429	19.1643	19.1429	19.1643	149100.0
2013-11-27 07:45:00	AAPL	Stock	19.1664	19.1789	19.1664	19.1743	324716.0
2013-11-27 07:50:00	AAPL	Stock	19.1714	19.1714	19.1571	19.1671	117460.0
2013-11-27 07:55:00	AAPL	Stock	19.1614	19.1618	19.155	19.1589	53900.0
2013-11-27 08:00:00	AAPL	Stock	19.1607	19.1846	19.0679	19.1671	1271396.0
2013-11-27 08:05:00	AAPL	Stock	19.1436	19.1611	19.1429	19.1604	221760.0
2013-11-27 08:10:00	AAPL	Stock	19.1571	19.1661	19.1571	19.1621	60760.0
2013-11-27 08:15:00	AAPL	Stock	19.1607	19.1621	19.1464	19.16	124600.0
2013-11-27 08:20:00	AAPL	Stock	19.1468	19.1586	19.1429	19.1429	188496.0
2013-11-27 08:25:00	AAPL	Stock	19.1429	19.1639	19.1429	19.1639	156240.0
2013-11-27 08:30:00	AAPL	Stock	19.1621	19.1661	19.1546	19.1546	59080.0
2013-11-27 08:35:00	AAPL	Stock	19.1554	19.1604	19.1507	19.1604	113568.0
2013-11-27 08:40:00	AAPL	Stock	19.1568	19.1679	19.1561	19.1679	114520.0
2013-11-27 08:45:00	AAPL	Stock	19.1679	19.1679	19.1589	19.1589	131180.0
2013-11-27 08:50:00	AAPL	Stock	19.1539	19.1611	19.1532	19.1611	67900.0
2013-11-27 08:55:00	AAPL	Stock	19.1607	19.1646	19.1607	19.1643	78820.0
2013-11-27 09:00:00	AAPL	Stock	19.1625	19.17	19.1607	19.17	423808.0
2013-11-27 09:05:00	AAPL	Stock	19.1711	19.1739	19.1646	19.1689	329476.0
2013-11-27 09:10:00	AAPL	Stock	19.1689	19.1707	19.1643	19.1707	163884.0
2013-11-27 09:15:00	AAPL	Stock	19.1707	19.1714	19.1696	19.1696	65072.0
2013-11-27 09:20:00	AAPL	Stock	19.17	19.17	19.1625	19.1625	57400.0
2013-11-27 09:25:00	AAPL	Stock	19.1625	19.1679	19.1429	19.1507	405552.0
2013-11-27 09:30:00	AAPL	Stock	19.1525	19.2768	19.1489	19.2545	25798976.0
2013-11-27 09:35:00	AAPL	Stock	19.2564	19.3018	19.2311	19.2879	19576900.0
2013-11-27 09:40:00	AAPL	Stock	19.2918	19.34	19.2689	19.3375	11918396.0
2013-11-27 09:45:00	AAPL	Stock	19.3332	19.3964	19.3221	19.3286	19875660.0
2013-11-27 09:50:00	AAPL	Stock	19.3262	19.3929	19.3182	19.3718	11870012.0
2013-11-27 09:55:00	AAPL	Stock	19.3689	19.3957	19.3432	19.3711	12138728.0
2013-11-27 10:00:00	AAPL	Stock	19.3714	19.3821	19.3393	19.3393	9096080.0
2013-11-27 10:05:00	AAPL	Stock	19.3396	19.3607	19.3279	19.3564	7494704.0
2013-11-27 10:10:00	AAPL	Stock	19.3562	19.3857	19.35	19.3776	5952156.0
2013-11-27 10:15:00	AAPL	Stock	19.3775	19.4086	19.3775	19.3929	9509556.0
2013-11-27 10:20:00	AAPL	Stock	19.3929	19.4211	19.3877	19.4196	7994840.0

> showing 50 of 346,686 rows — these rows as CSV

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