PREVIEW / stock_1min / 2013-05-24

all stock 1-min files

  file:    by_date/stock_1min/2013/2013-05-24.parquet
  size:    12.5 MB
  rows:    919,007
  symbols: 2,842

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
2013-05-24 05:06:00	AAPL	Stock	15.8246	15.8246	15.8246	15.8246	3864.0
2013-05-24 06:08:00	AAPL	Stock	15.7907	15.7907	15.7907	15.7907	17864.0
2013-05-24 06:14:00	AAPL	Stock	15.7714	15.7714	15.7714	15.7714	2800.0
2013-05-24 06:59:00	AAPL	Stock	15.7714	15.7714	15.7714	15.7714	2800.0
2013-05-24 07:09:00	AAPL	Stock	15.7857	15.7857	15.7857	15.7857	4200.0
2013-05-24 07:10:00	AAPL	Stock	15.7804	15.7804	15.7714	15.7714	9016.0
2013-05-24 07:14:00	AAPL	Stock	15.7854	15.7854	15.7854	15.7854	5600.0
2013-05-24 07:15:00	AAPL	Stock	15.7857	15.7857	15.7857	15.7857	5600.0
2013-05-24 07:16:00	AAPL	Stock	15.75	15.75	15.75	15.75	5600.0
2013-05-24 07:29:00	AAPL	Stock	15.7857	15.7857	15.7857	15.7857	8400.0
2013-05-24 07:30:00	AAPL	Stock	15.7857	15.7857	15.7857	15.7857	6776.0
2013-05-24 07:37:00	AAPL	Stock	15.8071	15.8107	15.8071	15.8107	19600.0
2013-05-24 07:38:00	AAPL	Stock	15.8107	15.8143	15.8107	15.8143	10080.0
2013-05-24 07:39:00	AAPL	Stock	15.8214	15.825	15.8125	15.8204	39620.0
2013-05-24 07:40:00	AAPL	Stock	15.8193	15.8343	15.8193	15.8343	43680.0
2013-05-24 07:41:00	AAPL	Stock	15.8254	15.8286	15.8254	15.8261	8400.0
2013-05-24 07:42:00	AAPL	Stock	15.8325	15.8325	15.8325	15.8325	2800.0
2013-05-24 07:46:00	AAPL	Stock	15.8564	15.8564	15.8393	15.8393	8400.0
2013-05-24 07:50:00	AAPL	Stock	15.8393	15.8504	15.8393	15.8504	11200.0
2013-05-24 07:51:00	AAPL	Stock	15.8532	15.855	15.8532	15.855	8400.0
2013-05-24 07:52:00	AAPL	Stock	15.8607	15.8607	15.8607	15.8607	5600.0
2013-05-24 07:58:00	AAPL	Stock	15.8643	15.8643	15.8643	15.8643	2800.0
2013-05-24 07:59:00	AAPL	Stock	15.8714	15.8929	15.8714	15.8929	39200.0
2013-05-24 08:00:00	AAPL	Stock	15.8593	15.8929	15.7857	15.8525	78400.0
2013-05-24 08:01:00	AAPL	Stock	15.8454	15.8454	15.8454	15.8454	2800.0
2013-05-24 08:02:00	AAPL	Stock	15.8471	15.8471	15.8243	15.8243	98000.0
2013-05-24 08:03:00	AAPL	Stock	15.8571	15.8571	15.8393	15.8514	36372.0
2013-05-24 08:04:00	AAPL	Stock	15.8529	15.855	15.8339	15.8379	28056.0
2013-05-24 08:05:00	AAPL	Stock	15.7432	15.8421	15.7432	15.8393	32200.0
2013-05-24 08:07:00	AAPL	Stock	15.8529	15.8529	15.8357	15.8357	49140.0
2013-05-24 08:08:00	AAPL	Stock	15.8429	15.8507	15.8357	15.8357	35560.0
2013-05-24 08:09:00	AAPL	Stock	15.8357	15.8357	15.825	15.825	38080.0
2013-05-24 08:10:00	AAPL	Stock	15.8232	15.8232	15.8036	15.8186	145880.0
2013-05-24 08:11:00	AAPL	Stock	15.8057	15.8057	15.7907	15.8004	53200.0
2013-05-24 08:12:00	AAPL	Stock	15.7914	15.7914	15.7493	15.75	118832.0
2013-05-24 08:13:00	AAPL	Stock	15.76	15.7604	15.75	15.75	85960.0
2013-05-24 08:14:00	AAPL	Stock	15.7486	15.75	15.7411	15.75	14000.0
2013-05-24 08:15:00	AAPL	Stock	15.7475	15.7871	15.7475	15.7721	33600.0
2013-05-24 08:16:00	AAPL	Stock	15.7707	15.7804	15.7707	15.7736	16800.0
2013-05-24 08:17:00	AAPL	Stock	15.7768	15.7821	15.7721	15.7721	33460.0
2013-05-24 08:18:00	AAPL	Stock	15.7993	15.7996	15.7961	15.7982	11200.0
2013-05-24 08:19:00	AAPL	Stock	15.8	15.8107	15.7982	15.8107	41440.0
2013-05-24 08:20:00	AAPL	Stock	15.8086	15.8093	15.8086	15.8093	5600.0
2013-05-24 08:21:00	AAPL	Stock	15.8107	15.8107	15.7961	15.7964	58576.0
2013-05-24 08:22:00	AAPL	Stock	15.7911	15.7911	15.7857	15.7857	31920.0
2013-05-24 08:23:00	AAPL	Stock	15.7857	15.7911	15.7857	15.7911	25200.0
2013-05-24 08:24:00	AAPL	Stock	15.7893	15.7946	15.7893	15.7946	8400.0
2013-05-24 08:25:00	AAPL	Stock	15.8014	15.8029	15.7964	15.8029	16800.0
2013-05-24 08:28:00	AAPL	Stock	15.8104	15.8118	15.8039	15.8118	14000.0
2013-05-24 08:29:00	AAPL	Stock	15.8125	15.8132	15.8125	15.8132	28000.0

> showing 50 of 919,007 rows — these rows as CSV

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