PREVIEW / stock_1min / 2012-01-17

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-01-17.parquet
  size:    12.8 MB
  rows:    953,059
  symbols: 2,859

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:02:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	11200.0
2012-01-17 04:03:00	AAPL	Stock	15.1689	15.1689	15.1689	15.1689	4200.0
2012-01-17 04:14:00	AAPL	Stock	15.1657	15.1657	15.1657	15.1657	2800.0
2012-01-17 04:33:00	AAPL	Stock	15.1782	15.1782	15.1782	15.1782	5600.0
2012-01-17 04:42:00	AAPL	Stock	15.1743	15.1743	15.1743	15.1743	5600.0
2012-01-17 05:01:00	AAPL	Stock	15.1782	15.1786	15.1743	15.1786	25200.0
2012-01-17 05:13:00	AAPL	Stock	15.1786	15.1786	15.1786	15.1786	2800.0
2012-01-17 05:24:00	AAPL	Stock	15.1607	15.1607	15.1607	15.1607	2800.0
2012-01-17 05:31:00	AAPL	Stock	15.1525	15.1525	15.1429	15.1429	28000.0
2012-01-17 05:32:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	14000.0
2012-01-17 06:24: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.1146	15.1146	14000.0
2012-01-17 06:26:00	AAPL	Stock	15.0907	15.0907	15.0907	15.0907	9800.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.125	15.125	2800.0
2012-01-17 07:01:00	AAPL	Stock	15.1079	15.1079	15.1071	15.1071	5600.0
2012-01-17 07:02:00	AAPL	Stock	15.1071	15.1071	15.1071	15.1071	12404.0
2012-01-17 07:05:00	AAPL	Stock	15.1079	15.1079	15.1079	15.1079	2800.0
2012-01-17 07:06:00	AAPL	Stock	15.1004	15.1004	15.1004	15.1004	11200.0
2012-01-17 07:07:00	AAPL	Stock	15.0896	15.0896	15.0896	15.0896	5600.0
2012-01-17 07:12:00	AAPL	Stock	15.1068	15.1068	15.1068	15.1068	2800.0
2012-01-17 07:13:00	AAPL	Stock	15.1068	15.1068	15.1068	15.1068	2800.0
2012-01-17 07:14:00	AAPL	Stock	15.1068	15.1071	15.1068	15.1071	36680.0
2012-01-17 07:15:00	AAPL	Stock	15.1229	15.1229	15.1229	15.1229	2800.0
2012-01-17 07:17:00	AAPL	Stock	15.1207	15.1211	15.1207	15.1211	16800.0
2012-01-17 07:18:00	AAPL	Stock	15.1214	15.1214	15.1214	15.1214	7000.0
2012-01-17 07:19:00	AAPL	Stock	15.1214	15.1214	15.1214	15.1214	5600.0
2012-01-17 07:21:00	AAPL	Stock	15.1286	15.1286	15.125	15.125	8400.0
2012-01-17 07:23:00	AAPL	Stock	15.1293	15.1293	15.1293	15.1293	5460.0
2012-01-17 07:24:00	AAPL	Stock	15.125	15.125	15.125	15.125	4200.0
2012-01-17 07:26:00	AAPL	Stock	15.1214	15.1214	15.1214	15.1214	2800.0
2012-01-17 07:27:00	AAPL	Stock	15.1282	15.1286	15.1282	15.1286	26208.0
2012-01-17 07:28:00	AAPL	Stock	15.1321	15.1321	15.1321	15.1321	8400.0
2012-01-17 07:30:00	AAPL	Stock	15.1382	15.1382	15.125	15.125	27608.0
2012-01-17 07:36:00	AAPL	Stock	15.1214	15.125	15.1214	15.125	38220.0
2012-01-17 07:46:00	AAPL	Stock	15.1111	15.1111	15.1071	15.1071	56000.0
2012-01-17 07:47:00	AAPL	Stock	15.1107	15.1111	15.1107	15.1111	5600.0
2012-01-17 07:48:00	AAPL	Stock	15.1107	15.1107	15.1075	15.1075	5600.0
2012-01-17 07:49:00	AAPL	Stock	15.1075	15.1075	15.1075	15.1075	4620.0
2012-01-17 07:54: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.1111	15.1136	57960.0
2012-01-17 07:59:00	AAPL	Stock	15.1014	15.1014	15.0904	15.0904	5600.0
2012-01-17 08:00:00	AAPL	Stock	15.1061	15.1239	15.0893	15.0982	162176.0
2012-01-17 08:01:00	AAPL	Stock	15.1032	15.1032	15.1032	15.1032	2800.0
2012-01-17 08:02:00	AAPL	Stock	15.0982	15.0982	15.095	15.095	5600.0
2012-01-17 08:03:00	AAPL	Stock	15.1068	15.1068	15.095	15.1054	29680.0
2012-01-17 08:04:00	AAPL	Stock	15.1032	15.1032	15.0968	15.1014	11200.0
2012-01-17 08:05:00	AAPL	Stock	15.1029	15.1036	15.1029	15.1029	25200.0
2012-01-17 08:06:00	AAPL	Stock	15.1029	15.1061	15.0968	15.0968	63224.0
2012-01-17 08:07:00	AAPL	Stock	15.0971	15.0982	15.0964	15.0982	28000.0

> showing 50 of 953,059 rows — these rows as CSV

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