PREVIEW / stock_1min / 2012-09-05

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-09-05.parquet
  size:    12.6 MB
  rows:    946,445
  symbols: 2,801

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-09-05 04:00:00	AAPL	Stock	24.1061	24.1061	24.1061	24.1061	2800.0
2012-09-05 04:01:00	AAPL	Stock	24.0671	24.0671	24.0671	24.0671	7812.0
2012-09-05 04:03:00	AAPL	Stock	24.0857	24.0857	24.0857	24.0857	14000.0
2012-09-05 04:06:00	AAPL	Stock	24.075	24.075	24.075	24.075	8400.0
2012-09-05 04:08:00	AAPL	Stock	24.075	24.075	24.075	24.075	8400.0
2012-09-05 04:16:00	AAPL	Stock	24.0571	24.0571	24.0571	24.0571	8400.0
2012-09-05 04:17:00	AAPL	Stock	24.0571	24.0571	24.0571	24.0571	2800.0
2012-09-05 04:18:00	AAPL	Stock	24.0571	24.0571	24.0571	24.0571	14000.0
2012-09-05 04:22:00	AAPL	Stock	24.0539	24.0539	24.0536	24.0536	8400.0
2012-09-05 04:27:00	AAPL	Stock	24.0421	24.0421	24.0421	24.0421	2800.0
2012-09-05 04:28:00	AAPL	Stock	24.0496	24.0496	24.0496	24.0496	5600.0
2012-09-05 04:36:00	AAPL	Stock	24.0411	24.0411	24.0411	24.0411	5600.0
2012-09-05 04:38:00	AAPL	Stock	24.0411	24.0414	24.0411	24.0411	14000.0
2012-09-05 04:39:00	AAPL	Stock	24.0411	24.0411	24.0411	24.0411	5600.0
2012-09-05 04:41:00	AAPL	Stock	24.0379	24.0379	24.0368	24.0368	8400.0
2012-09-05 05:07:00	AAPL	Stock	24.05	24.05	24.05	24.05	2800.0
2012-09-05 05:08:00	AAPL	Stock	24.0496	24.05	24.0496	24.05	8400.0
2012-09-05 05:09:00	AAPL	Stock	24.0532	24.0532	24.0532	24.0532	15400.0
2012-09-05 05:11:00	AAPL	Stock	24.0607	24.0607	24.0607	24.0607	21336.0
2012-09-05 05:20:00	AAPL	Stock	24.0464	24.0464	24.0464	24.0464	7000.0
2012-09-05 05:23:00	AAPL	Stock	24.0589	24.0589	24.0589	24.0589	4900.0
2012-09-05 05:27:00	AAPL	Stock	24.0607	24.0607	24.0607	24.0607	6664.0
2012-09-05 05:38:00	AAPL	Stock	24.0714	24.0804	24.0714	24.0804	33600.0
2012-09-05 05:39:00	AAPL	Stock	24.0804	24.0804	24.0804	24.0804	5600.0
2012-09-05 05:48:00	AAPL	Stock	24.0893	24.0893	24.0893	24.0893	2800.0
2012-09-05 05:57:00	AAPL	Stock	24.1029	24.1029	24.1029	24.1029	2800.0
2012-09-05 06:10:00	AAPL	Stock	24.0982	24.0982	24.0982	24.0982	3500.0
2012-09-05 06:20:00	AAPL	Stock	24.1375	24.1425	24.1375	24.1425	8400.0
2012-09-05 06:32:00	AAPL	Stock	24.1496	24.1496	24.1429	24.1429	5600.0
2012-09-05 06:59:00	AAPL	Stock	24.1429	24.1429	24.1429	24.1429	10108.0
2012-09-05 07:00:00	AAPL	Stock	24.1339	24.1554	24.1339	24.1432	22400.0
2012-09-05 07:01:00	AAPL	Stock	24.1429	24.1429	24.1429	24.1429	12740.0
2012-09-05 07:06:00	AAPL	Stock	24.1429	24.1429	24.1429	24.1429	2800.0
2012-09-05 07:07:00	AAPL	Stock	24.1439	24.15	24.1404	24.15	27832.0
2012-09-05 07:10:00	AAPL	Stock	24.1339	24.1339	24.1339	24.1339	4200.0
2012-09-05 07:11:00	AAPL	Stock	24.1254	24.1254	24.125	24.125	17360.0
2012-09-05 07:14:00	AAPL	Stock	24.1111	24.1111	24.1071	24.1071	11200.0
2012-09-05 07:15:00	AAPL	Stock	24.1111	24.1111	24.1071	24.1071	8400.0
2012-09-05 07:16:00	AAPL	Stock	24.1071	24.1143	24.1071	24.1143	65884.0
2012-09-05 07:19:00	AAPL	Stock	24.1232	24.1232	24.1232	24.1232	2800.0
2012-09-05 07:20:00	AAPL	Stock	24.1232	24.1321	24.1143	24.1143	25200.0
2012-09-05 07:25:00	AAPL	Stock	24.1282	24.1282	24.1282	24.1282	2800.0
2012-09-05 07:27:00	AAPL	Stock	24.1275	24.1286	24.1275	24.1286	25200.0
2012-09-05 07:28:00	AAPL	Stock	24.1321	24.1386	24.1321	24.1386	11200.0
2012-09-05 07:30:00	AAPL	Stock	24.1161	24.1321	24.1161	24.1321	14000.0
2012-09-05 07:34:00	AAPL	Stock	24.14	24.14	24.1393	24.1393	14000.0
2012-09-05 07:36:00	AAPL	Stock	24.1421	24.1421	24.1421	24.1421	2800.0
2012-09-05 07:37:00	AAPL	Stock	24.1425	24.1425	24.1425	24.1425	28000.0
2012-09-05 07:38:00	AAPL	Stock	24.1393	24.1393	24.1393	24.1393	5040.0
2012-09-05 07:39:00	AAPL	Stock	24.1393	24.1393	24.125	24.125	25200.0

> showing 50 of 946,445 rows — these rows as CSV

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