PREVIEW / stock_1min / 2011-07-21

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-07-21.parquet
  size:    13.3 MB
  rows:    995,887
  symbols: 2,864

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
2011-07-21 04:00:00	AAPL	Stock	13.8071	13.8071	13.8057	13.8057	16800.0
2011-07-21 04:15:00	AAPL	Stock	13.7857	13.7857	13.7857	13.7857	2800.0
2011-07-21 04:27:00	AAPL	Stock	13.7857	13.7857	13.7857	13.7857	11200.0
2011-07-21 04:38:00	AAPL	Stock	13.7746	13.7746	13.7746	13.7746	2800.0
2011-07-21 04:59:00	AAPL	Stock	13.7754	13.7754	13.7754	13.7754	2800.0
2011-07-21 05:02:00	AAPL	Stock	13.7736	13.7736	13.7718	13.7718	5600.0
2011-07-21 05:03:00	AAPL	Stock	13.7657	13.7657	13.7657	13.7657	2800.0
2011-07-21 05:04:00	AAPL	Stock	13.7564	13.7564	13.7564	13.7564	2800.0
2011-07-21 05:13:00	AAPL	Stock	13.7461	13.7461	13.7461	13.7461	2800.0
2011-07-21 05:15:00	AAPL	Stock	13.7393	13.7393	13.7393	13.7393	14000.0
2011-07-21 05:23:00	AAPL	Stock	13.7143	13.7143	13.7	13.7	11200.0
2011-07-21 05:28:00	AAPL	Stock	13.705	13.7089	13.705	13.7089	5600.0
2011-07-21 05:34:00	AAPL	Stock	13.7143	13.7143	13.7143	13.7143	2800.0
2011-07-21 05:35:00	AAPL	Stock	13.7071	13.7071	13.7071	13.7071	2800.0
2011-07-21 05:44:00	AAPL	Stock	13.7107	13.7107	13.7107	13.7107	2800.0
2011-07-21 05:50:00	AAPL	Stock	13.7107	13.7107	13.7107	13.7107	2800.0
2011-07-21 05:53:00	AAPL	Stock	13.7143	13.7143	13.7071	13.7071	11200.0
2011-07-21 05:56:00	AAPL	Stock	13.6911	13.6911	13.6911	13.6911	6020.0
2011-07-21 05:57:00	AAPL	Stock	13.7143	13.7143	13.7143	13.7143	14000.0
2011-07-21 06:11:00	AAPL	Stock	13.6993	13.6993	13.6993	13.6993	2800.0
2011-07-21 06:12:00	AAPL	Stock	13.6982	13.6982	13.6982	13.6982	2800.0
2011-07-21 06:18:00	AAPL	Stock	13.7	13.7	13.7	13.7	2800.0
2011-07-21 06:23:00	AAPL	Stock	13.7	13.7	13.7	13.7	13720.0
2011-07-21 06:24:00	AAPL	Stock	13.7	13.7	13.7	13.7	11200.0
2011-07-21 06:32:00	AAPL	Stock	13.7039	13.7039	13.7039	13.7039	2800.0
2011-07-21 06:33:00	AAPL	Stock	13.705	13.705	13.705	13.705	2800.0
2011-07-21 06:36:00	AAPL	Stock	13.7096	13.7096	13.7096	13.7096	2800.0
2011-07-21 06:38:00	AAPL	Stock	13.7075	13.7075	13.7075	13.7075	2800.0
2011-07-21 06:39:00	AAPL	Stock	13.7107	13.7107	13.7107	13.7107	2800.0
2011-07-21 06:43:00	AAPL	Stock	13.7079	13.7093	13.7079	13.7093	11200.0
2011-07-21 06:46:00	AAPL	Stock	13.7014	13.7014	13.7014	13.7014	2800.0
2011-07-21 06:47:00	AAPL	Stock	13.7107	13.7107	13.7107	13.7107	2800.0
2011-07-21 06:54:00	AAPL	Stock	13.7321	13.7321	13.7321	13.7321	5600.0
2011-07-21 07:00:00	AAPL	Stock	13.7696	13.7696	13.7696	13.7696	5600.0
2011-07-21 07:01:00	AAPL	Stock	13.7696	13.7754	13.7561	13.7561	35448.0
2011-07-21 07:05:00	AAPL	Stock	13.7732	13.7732	13.7732	13.7732	2800.0
2011-07-21 07:06:00	AAPL	Stock	13.7789	13.8018	13.7789	13.8018	8400.0
2011-07-21 07:07:00	AAPL	Stock	13.7857	13.7857	13.7857	13.7857	2800.0
2011-07-21 07:13:00	AAPL	Stock	13.8061	13.8061	13.8061	13.8061	2800.0
2011-07-21 07:14:00	AAPL	Stock	13.8071	13.8071	13.8071	13.8071	2800.0
2011-07-21 07:18:00	AAPL	Stock	13.8132	13.8132	13.8132	13.8132	2800.0
2011-07-21 07:19:00	AAPL	Stock	13.8136	13.8136	13.8136	13.8136	5600.0
2011-07-21 07:21:00	AAPL	Stock	13.8075	13.8075	13.7875	13.7875	53200.0
2011-07-21 07:22:00	AAPL	Stock	13.7857	13.7857	13.7857	13.7857	8400.0
2011-07-21 07:24:00	AAPL	Stock	13.7964	13.7964	13.7964	13.7964	2800.0
2011-07-21 07:25:00	AAPL	Stock	13.7996	13.7996	13.7996	13.7996	2800.0
2011-07-21 07:27:00	AAPL	Stock	13.8021	13.8036	13.8021	13.8036	43008.0
2011-07-21 07:32:00	AAPL	Stock	13.8054	13.8107	13.8046	13.8107	8400.0
2011-07-21 07:36:00	AAPL	Stock	13.8143	13.8154	13.7964	13.7964	44800.0
2011-07-21 07:37:00	AAPL	Stock	13.8086	13.81	13.8086	13.81	5600.0

> showing 50 of 995,887 rows — these rows as CSV

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