PREVIEW / stock_1min / 2010-06-23

all stock 1-min files

  file:    by_date/stock_1min/2010/2010-06-23.parquet
  size:    12.9 MB
  rows:    996,557
  symbols: 2,788

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
2010-06-23 04:15:00	AAPL	Stock	9.8393	9.8393	9.8393	9.8393	2800.0
2010-06-23 05:01:00	AAPL	Stock	9.8393	9.8393	9.8393	9.8393	21000.0
2010-06-23 05:24:00	AAPL	Stock	9.8571	9.8571	9.8571	9.8571	2800.0
2010-06-23 05:35:00	AAPL	Stock	9.8571	9.8571	9.8571	9.8571	2800.0
2010-06-23 05:51:00	AAPL	Stock	9.8911	9.8911	9.8911	9.8911	14000.0
2010-06-23 05:58:00	AAPL	Stock	9.8929	9.8929	9.8929	9.8929	16968.0
2010-06-23 06:17:00	AAPL	Stock	9.8929	9.8929	9.8929	9.8929	8400.0
2010-06-23 06:37:00	AAPL	Stock	9.8857	9.8857	9.8857	9.8857	2800.0
2010-06-23 06:38:00	AAPL	Stock	9.8857	9.8929	9.8857	9.8929	11200.0
2010-06-23 07:00:00	AAPL	Stock	9.8575	9.8575	9.8539	9.8539	115892.0
2010-06-23 07:01:00	AAPL	Stock	9.8571	9.8571	9.8518	9.8518	37240.0
2010-06-23 07:02:00	AAPL	Stock	9.85	9.85	9.8482	9.8482	39200.0
2010-06-23 07:03:00	AAPL	Stock	9.8464	9.8486	9.8393	9.845	76104.0
2010-06-23 07:04:00	AAPL	Stock	9.8429	9.8429	9.8271	9.8425	14000.0
2010-06-23 07:05:00	AAPL	Stock	9.8425	9.8429	9.8371	9.8429	18200.0
2010-06-23 07:06:00	AAPL	Stock	9.8339	9.8339	9.8304	9.8304	16632.0
2010-06-23 07:07:00	AAPL	Stock	9.8386	9.8386	9.8386	9.8386	8400.0
2010-06-23 07:08:00	AAPL	Stock	9.8271	9.8271	9.8204	9.8207	84000.0
2010-06-23 07:09:00	AAPL	Stock	9.8207	9.8207	9.8132	9.8132	22400.0
2010-06-23 07:10:00	AAPL	Stock	9.8143	9.8143	9.8143	9.8143	26292.0
2010-06-23 07:11:00	AAPL	Stock	9.825	9.825	9.8214	9.8218	11732.0
2010-06-23 07:12:00	AAPL	Stock	9.8246	9.8246	9.8232	9.8232	8400.0
2010-06-23 07:13:00	AAPL	Stock	9.8225	9.8232	9.8225	9.8232	5600.0
2010-06-23 07:14:00	AAPL	Stock	9.8218	9.8218	9.8214	9.8214	42000.0
2010-06-23 07:15:00	AAPL	Stock	9.8218	9.8218	9.8132	9.8132	15400.0
2010-06-23 07:16:00	AAPL	Stock	9.8125	9.8125	9.8125	9.8125	5600.0
2010-06-23 07:17:00	AAPL	Stock	9.8211	9.8211	9.8107	9.8107	11200.0
2010-06-23 07:18:00	AAPL	Stock	9.8096	9.81	9.8	9.8086	75320.0
2010-06-23 07:19:00	AAPL	Stock	9.8093	9.815	9.8093	9.8125	11704.0
2010-06-23 07:21:00	AAPL	Stock	9.8193	9.8193	9.8193	9.8193	2800.0
2010-06-23 07:24:00	AAPL	Stock	9.8132	9.8132	9.8132	9.8132	2800.0
2010-06-23 07:25:00	AAPL	Stock	9.8179	9.8179	9.8179	9.8179	30800.0
2010-06-23 07:26:00	AAPL	Stock	9.8179	9.8304	9.8179	9.8214	159320.0
2010-06-23 07:27:00	AAPL	Stock	9.8211	9.8211	9.8211	9.8211	2800.0
2010-06-23 07:28:00	AAPL	Stock	9.8214	9.8214	9.8214	9.8214	2800.0
2010-06-23 07:29:00	AAPL	Stock	9.8207	9.8304	9.8207	9.8304	37800.0
2010-06-23 07:30:00	AAPL	Stock	9.8243	9.8243	9.8129	9.8129	25200.0
2010-06-23 07:31:00	AAPL	Stock	9.8132	9.8139	9.8132	9.8139	5600.0
2010-06-23 07:32:00	AAPL	Stock	9.8207	9.8207	9.8207	9.8207	2800.0
2010-06-23 07:33:00	AAPL	Stock	9.8232	9.8232	9.8214	9.8214	11200.0
2010-06-23 07:34:00	AAPL	Stock	9.8282	9.8286	9.8282	9.8286	8400.0
2010-06-23 07:35:00	AAPL	Stock	9.8286	9.8286	9.8286	9.8286	54544.0
2010-06-23 07:36:00	AAPL	Stock	9.8286	9.8286	9.8286	9.8286	27636.0
2010-06-23 07:37:00	AAPL	Stock	9.8286	9.8296	9.8286	9.8286	29400.0
2010-06-23 07:38:00	AAPL	Stock	9.8321	9.8346	9.8321	9.8346	13720.0
2010-06-23 07:39:00	AAPL	Stock	9.8354	9.8354	9.8354	9.8354	2800.0
2010-06-23 07:41:00	AAPL	Stock	9.8296	9.8296	9.8268	9.8268	36400.0
2010-06-23 07:44:00	AAPL	Stock	9.8232	9.8232	9.8214	9.8214	26600.0
2010-06-23 07:45:00	AAPL	Stock	9.835	9.8357	9.8257	9.83	95200.0
2010-06-23 07:46:00	AAPL	Stock	9.8286	9.8321	9.8286	9.8286	33600.0

> showing 50 of 996,557 rows — these rows as CSV

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