PREVIEW / stock_1min / 2014-03-20

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-03-20.parquet
  size:    14.3 MB
  rows:    1,045,548
  symbols: 2,861

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
2014-03-20 06:00:00	AAPL	Stock	18.9114	18.9114	18.9114	18.9114	8400.0
2014-03-20 06:10:00	AAPL	Stock	18.9032	18.9032	18.9032	18.9032	5600.0
2014-03-20 06:19:00	AAPL	Stock	18.9061	18.9061	18.9061	18.9061	11200.0
2014-03-20 06:22:00	AAPL	Stock	18.9132	18.9132	18.9132	18.9132	2800.0
2014-03-20 06:24:00	AAPL	Stock	18.9132	18.9132	18.9132	18.9132	2800.0
2014-03-20 07:18:00	AAPL	Stock	18.9061	18.9061	18.9061	18.9061	2800.0
2014-03-20 07:30:00	AAPL	Stock	18.9107	18.9107	18.9107	18.9107	5600.0
2014-03-20 07:35:00	AAPL	Stock	18.9214	18.9214	18.9214	18.9214	2800.0
2014-03-20 07:44:00	AAPL	Stock	18.9218	18.9218	18.9214	18.9214	8400.0
2014-03-20 07:45:00	AAPL	Stock	18.9282	18.9286	18.9282	18.9286	14000.0
2014-03-20 07:50:00	AAPL	Stock	18.9446	18.9554	18.9446	18.9554	16800.0
2014-03-20 07:53:00	AAPL	Stock	18.9554	18.9554	18.9554	18.9554	2800.0
2014-03-20 07:55:00	AAPL	Stock	18.9643	18.965	18.9643	18.965	8400.0
2014-03-20 08:00:00	AAPL	Stock	18.88	18.9643	18.8789	18.9643	91000.0
2014-03-20 08:04:00	AAPL	Stock	18.9464	18.9464	18.9464	18.9464	2800.0
2014-03-20 08:05:00	AAPL	Stock	18.9464	18.9464	18.9464	18.9464	5600.0
2014-03-20 08:06:00	AAPL	Stock	18.9643	18.9643	18.9629	18.9643	61600.0
2014-03-20 08:10:00	AAPL	Stock	18.9471	18.9471	18.9471	18.9471	5600.0
2014-03-20 08:12:00	AAPL	Stock	18.9464	18.9464	18.9464	18.9464	5600.0
2014-03-20 08:13:00	AAPL	Stock	18.9639	18.9639	18.9639	18.9639	7000.0
2014-03-20 08:25:00	AAPL	Stock	18.9357	18.9357	18.9357	18.9357	5600.0
2014-03-20 08:30:00	AAPL	Stock	18.9375	18.9375	18.9354	18.9354	32004.0
2014-03-20 08:31:00	AAPL	Stock	18.9557	18.9571	18.9464	18.9571	34328.0
2014-03-20 08:33:00	AAPL	Stock	18.9375	18.9375	18.9286	18.9286	11200.0
2014-03-20 08:34:00	AAPL	Stock	18.9286	18.9286	18.9286	18.9286	8400.0
2014-03-20 08:37:00	AAPL	Stock	18.925	18.925	18.925	18.925	2800.0
2014-03-20 08:38:00	AAPL	Stock	18.9286	18.9286	18.9286	18.9286	7280.0
2014-03-20 08:55:00	AAPL	Stock	18.9393	18.9393	18.9393	18.9393	2800.0
2014-03-20 09:00:00	AAPL	Stock	18.9464	18.9571	18.9436	18.9571	16800.0
2014-03-20 09:02:00	AAPL	Stock	18.9482	18.9482	18.9268	18.9268	78960.0
2014-03-20 09:03:00	AAPL	Stock	18.9204	18.9207	18.9204	18.9204	29484.0
2014-03-20 09:04:00	AAPL	Stock	18.9214	18.9307	18.9204	18.9307	55944.0
2014-03-20 09:05:00	AAPL	Stock	18.9268	18.9268	18.9268	18.9268	4788.0
2014-03-20 09:07:00	AAPL	Stock	18.9393	18.9393	18.9393	18.9393	2800.0
2014-03-20 09:13:00	AAPL	Stock	18.9428	18.9428	18.9428	18.9428	8400.0
2014-03-20 09:14:00	AAPL	Stock	18.93	18.93	18.9286	18.9286	19600.0
2014-03-20 09:19:00	AAPL	Stock	18.9286	18.9293	18.9286	18.9293	46172.0
2014-03-20 09:23:00	AAPL	Stock	18.9429	18.9429	18.9429	18.9429	8400.0
2014-03-20 09:24:00	AAPL	Stock	18.9296	18.9296	18.9286	18.9286	11200.0
2014-03-20 09:25:00	AAPL	Stock	18.9296	18.9296	18.9289	18.9289	5600.0
2014-03-20 09:26:00	AAPL	Stock	18.9286	18.9286	18.9286	18.9286	143920.0
2014-03-20 09:27:00	AAPL	Stock	18.9436	18.9436	18.9421	18.9421	8400.0
2014-03-20 09:28:00	AAPL	Stock	18.9296	18.9296	18.9286	18.9286	43400.0
2014-03-20 09:29:00	AAPL	Stock	18.9286	18.9286	18.9096	18.9229	285124.0
2014-03-20 09:30:00	AAPL	Stock	18.9246	18.9643	18.9089	18.9507	4014920.0
2014-03-20 09:31:00	AAPL	Stock	18.9536	19.0029	18.9468	19.0005	3199084.0
2014-03-20 09:32:00	AAPL	Stock	19.0014	19.0239	18.9993	19.0014	2377200.0
2014-03-20 09:33:00	AAPL	Stock	19.0021	19.0214	18.9921	19.0125	1178520.0
2014-03-20 09:34:00	AAPL	Stock	19.0161	19.0186	18.9871	18.9943	1058428.0
2014-03-20 09:35:00	AAPL	Stock	18.9925	18.9946	18.975	18.9814	1053164.0

> showing 50 of 1,045,548 rows — these rows as CSV

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