PREVIEW / stock_5min / 2012-01-17

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-01-17.parquet
  size:    4.8 MB
  rows:    327,057
  symbols: 3,528

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-01-17 04:00:00	AAPL	Stock	15.1429	15.1689	15.1429	15.1689	15400.0
2012-01-17 04:10:00	AAPL	Stock	15.1657	15.1657	15.1657	15.1657	2800.0
2012-01-17 04:30:00	AAPL	Stock	15.1782	15.1782	15.1782	15.1782	5600.0
2012-01-17 04:40:00	AAPL	Stock	15.1743	15.1743	15.1743	15.1743	5600.0
2012-01-17 05:00:00	AAPL	Stock	15.1782	15.1786	15.1743	15.1786	25200.0
2012-01-17 05:10:00	AAPL	Stock	15.1786	15.1786	15.1786	15.1786	2800.0
2012-01-17 05:20:00	AAPL	Stock	15.1607	15.1607	15.1607	15.1607	2800.0
2012-01-17 05:30:00	AAPL	Stock	15.1525	15.1525	15.1429	15.1429	42000.0
2012-01-17 06:20:00	AAPL	Stock	15.1154	15.1154	15.1154	15.1154	2800.0
2012-01-17 06:25:00	AAPL	Stock	15.1146	15.1146	15.0907	15.0907	23800.0
2012-01-17 06:40:00	AAPL	Stock	15.1079	15.1079	15.1079	15.1079	24640.0
2012-01-17 07:00:00	AAPL	Stock	15.125	15.125	15.1071	15.1071	20804.0
2012-01-17 07:05:00	AAPL	Stock	15.1079	15.1079	15.0896	15.0896	19600.0
2012-01-17 07:10:00	AAPL	Stock	15.1068	15.1071	15.1068	15.1071	42280.0
2012-01-17 07:15:00	AAPL	Stock	15.1229	15.1229	15.1207	15.1214	32200.0
2012-01-17 07:20:00	AAPL	Stock	15.1286	15.1293	15.125	15.125	18060.0
2012-01-17 07:25:00	AAPL	Stock	15.1214	15.1321	15.1214	15.1321	37408.0
2012-01-17 07:30:00	AAPL	Stock	15.1382	15.1382	15.125	15.125	27608.0
2012-01-17 07:35:00	AAPL	Stock	15.1214	15.125	15.1214	15.125	38220.0
2012-01-17 07:45:00	AAPL	Stock	15.1111	15.1111	15.1071	15.1075	71820.0
2012-01-17 07:50:00	AAPL	Stock	15.1086	15.1111	15.1086	15.1111	9380.0
2012-01-17 07:55:00	AAPL	Stock	15.1111	15.1136	15.0904	15.0904	63560.0
2012-01-17 08:00:00	AAPL	Stock	15.1061	15.1239	15.0893	15.1014	211456.0
2012-01-17 08:05:00	AAPL	Stock	15.1029	15.1061	15.0964	15.1061	167552.0
2012-01-17 08:10:00	AAPL	Stock	15.1054	15.1054	15.0993	15.1	89460.0
2012-01-17 08:15:00	AAPL	Stock	15.1	15.1	15.095	15.0964	114296.0
2012-01-17 08:20:00	AAPL	Stock	15.1014	15.1014	15.0814	15.0814	125384.0
2012-01-17 08:25:00	AAPL	Stock	15.0954	15.0964	15.0929	15.0929	70560.0
2012-01-17 08:30:00	AAPL	Stock	15.0929	15.1068	15.0929	15.0971	198688.0
2012-01-17 08:35:00	AAPL	Stock	15.105	15.1064	15.0914	15.0929	137200.0
2012-01-17 08:40:00	AAPL	Stock	15.1021	15.1025	15.0929	15.0929	86100.0
2012-01-17 08:45:00	AAPL	Stock	15.0929	15.0929	15.0875	15.0893	68320.0
2012-01-17 08:50:00	AAPL	Stock	15.0886	15.1025	15.0857	15.0993	77896.0
2012-01-17 08:55:00	AAPL	Stock	15.1	15.1071	15.0982	15.1054	73080.0
2012-01-17 09:00:00	AAPL	Stock	15.1036	15.1143	15.1036	15.1075	139832.0
2012-01-17 09:05:00	AAPL	Stock	15.1075	15.1143	15.1071	15.1071	52696.0
2012-01-17 09:10:00	AAPL	Stock	15.1161	15.1161	15.1011	15.1104	210756.0
2012-01-17 09:15:00	AAPL	Stock	15.1143	15.1161	15.1071	15.1071	168896.0
2012-01-17 09:20:00	AAPL	Stock	15.1107	15.1139	15.1107	15.1129	30100.0
2012-01-17 09:25:00	AAPL	Stock	15.1125	15.1554	15.1036	15.1514	1376872.0
2012-01-17 09:30:00	AAPL	Stock	15.15	15.1746	15.1214	15.1368	17567620.0
2012-01-17 09:35:00	AAPL	Stock	15.1396	15.165	15.1286	15.1599	6858684.0
2012-01-17 09:40:00	AAPL	Stock	15.1629	15.1736	15.1464	15.1672	6063932.0
2012-01-17 09:45:00	AAPL	Stock	15.1664	15.185	15.1546	15.1821	9264668.0
2012-01-17 09:50:00	AAPL	Stock	15.1826	15.1854	15.1714	15.1729	3823540.0
2012-01-17 09:55:00	AAPL	Stock	15.1725	15.1771	15.1629	15.1757	3602312.0
2012-01-17 10:00:00	AAPL	Stock	15.1757	15.1818	15.1679	15.1807	4620672.0
2012-01-17 10:05:00	AAPL	Stock	15.1775	15.1814	15.1714	15.1714	2660560.0
2012-01-17 10:10:00	AAPL	Stock	15.1714	15.1771	15.1689	15.1739	2444204.0
2012-01-17 10:15:00	AAPL	Stock	15.1737	15.1786	15.1571	15.1704	3886400.0

> showing 50 of 327,057 rows — these rows as CSV

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