PREVIEW / stock_1min / 2012-11-09

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-11-09.parquet
  size:    12.8 MB
  rows:    945,698
  symbols: 2,800

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-11-09 04:00:00	AAPL	Stock	19.2054	19.2054	19.2054	19.2054	2800.0
2012-11-09 04:01:00	AAPL	Stock	19.175	19.175	19.175	19.175	3416.0
2012-11-09 04:02:00	AAPL	Stock	19.1607	19.1607	19.1607	19.1607	2800.0
2012-11-09 04:22:00	AAPL	Stock	19.1564	19.1571	19.1564	19.1571	6328.0
2012-11-09 04:23:00	AAPL	Stock	19.1607	19.1607	19.1607	19.1607	25200.0
2012-11-09 04:28:00	AAPL	Stock	19.1679	19.1679	19.1679	19.1679	2800.0
2012-11-09 04:30:00	AAPL	Stock	19.1696	19.1786	19.1696	19.1786	5600.0
2012-11-09 04:32:00	AAPL	Stock	19.1786	19.1821	19.1432	19.1432	58800.0
2012-11-09 04:33:00	AAPL	Stock	19.1839	19.1857	19.1786	19.1786	33600.0
2012-11-09 04:37:00	AAPL	Stock	19.1875	19.1875	19.1875	19.1875	16800.0
2012-11-09 04:38:00	AAPL	Stock	19.1957	19.1957	19.1957	19.1957	2800.0
2012-11-09 04:43:00	AAPL	Stock	19.1607	19.2143	19.1607	19.2143	28000.0
2012-11-09 04:45:00	AAPL	Stock	19.2143	19.2143	19.2143	19.2143	2800.0
2012-11-09 04:46:00	AAPL	Stock	19.2107	19.2143	19.2107	19.2143	11200.0
2012-11-09 04:47:00	AAPL	Stock	19.2214	19.25	19.2214	19.25	19600.0
2012-11-09 04:48:00	AAPL	Stock	19.2321	19.2321	19.2321	19.2321	2800.0
2012-11-09 04:49:00	AAPL	Stock	19.2318	19.2318	19.2318	19.2318	4200.0
2012-11-09 04:55:00	AAPL	Stock	19.2214	19.2214	19.2214	19.2214	2800.0
2012-11-09 04:58:00	AAPL	Stock	19.2214	19.2214	19.2214	19.2214	2800.0
2012-11-09 05:03:00	AAPL	Stock	19.2214	19.23	19.2214	19.23	6076.0
2012-11-09 05:06:00	AAPL	Stock	19.2321	19.2321	19.2321	19.2321	2800.0
2012-11-09 05:07:00	AAPL	Stock	19.2321	19.2321	19.2321	19.2321	2800.0
2012-11-09 05:11:00	AAPL	Stock	19.2411	19.2411	19.2411	19.2411	2800.0
2012-11-09 05:13:00	AAPL	Stock	19.2321	19.2321	19.2321	19.2321	2800.0
2012-11-09 05:15:00	AAPL	Stock	19.2457	19.25	19.2457	19.25	36652.0
2012-11-09 05:21:00	AAPL	Stock	19.2321	19.2321	19.2321	19.2321	2800.0
2012-11-09 05:22:00	AAPL	Stock	19.2214	19.2214	19.2214	19.2214	5600.0
2012-11-09 05:44:00	AAPL	Stock	19.2214	19.2214	19.2214	19.2214	5600.0
2012-11-09 05:45:00	AAPL	Stock	19.2214	19.2214	19.2214	19.2214	2800.0
2012-11-09 05:48:00	AAPL	Stock	19.2214	19.2214	19.2214	19.2214	2800.0
2012-11-09 05:51:00	AAPL	Stock	19.2214	19.2214	19.2214	19.2214	5600.0
2012-11-09 05:54:00	AAPL	Stock	19.2214	19.2286	19.2214	19.2286	11200.0
2012-11-09 05:55:00	AAPL	Stock	19.2357	19.2357	19.2357	19.2357	16800.0
2012-11-09 05:56:00	AAPL	Stock	19.2375	19.2375	19.2375	19.2375	25032.0
2012-11-09 05:58:00	AAPL	Stock	19.2214	19.2214	19.2143	19.2143	30800.0
2012-11-09 05:59:00	AAPL	Stock	19.2143	19.2143	19.2143	19.2143	42000.0
2012-11-09 06:13:00	AAPL	Stock	19.2036	19.2036	19.1789	19.1789	46648.0
2012-11-09 06:18:00	AAPL	Stock	19.1789	19.1789	19.1789	19.1789	14000.0
2012-11-09 06:27:00	AAPL	Stock	19.1661	19.1661	19.1661	19.1661	2800.0
2012-11-09 06:29:00	AAPL	Stock	19.1661	19.1661	19.1661	19.1661	11200.0
2012-11-09 06:38:00	AAPL	Stock	19.1836	19.1836	19.1518	19.1518	6300.0
2012-11-09 06:39:00	AAPL	Stock	19.1518	19.1518	19.1518	19.1518	19600.0
2012-11-09 06:40:00	AAPL	Stock	19.1518	19.1518	19.1432	19.1436	30800.0
2012-11-09 06:43:00	AAPL	Stock	19.1518	19.1518	19.1518	19.1518	7700.0
2012-11-09 06:50:00	AAPL	Stock	19.1432	19.1432	19.1432	19.1432	2800.0
2012-11-09 06:52:00	AAPL	Stock	19.1511	19.1511	19.1511	19.1511	2800.0
2012-11-09 06:53:00	AAPL	Stock	19.1446	19.1518	19.1432	19.1518	47852.0
2012-11-09 06:55:00	AAPL	Stock	19.1786	19.1786	19.1786	19.1786	2800.0
2012-11-09 07:00:00	AAPL	Stock	19.1571	19.1571	19.1432	19.1432	14112.0
2012-11-09 07:01:00	AAPL	Stock	19.1596	19.1596	19.1596	19.1596	2800.0

> showing 50 of 945,698 rows — these rows as CSV

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