PREVIEW / stock_1min / 2012-05-22

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-05-22.parquet
  size:    13.3 MB
  rows:    992,051
  symbols: 2,848

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-05-22 04:00:00	AAPL	Stock	20.1786	20.25	20.1786	20.25	43848.0
2012-05-22 04:01:00	AAPL	Stock	20.2496	20.4286	20.2496	20.4286	36848.0
2012-05-22 04:10:00	AAPL	Stock	20.2589	20.2589	20.2589	20.2589	2800.0
2012-05-22 04:18:00	AAPL	Stock	20.2286	20.2286	20.2286	20.2286	11228.0
2012-05-22 04:19:00	AAPL	Stock	20.2364	20.2364	20.2364	20.2364	2800.0
2012-05-22 04:26:00	AAPL	Stock	20.2589	20.2589	20.2589	20.2589	5600.0
2012-05-22 04:31:00	AAPL	Stock	20.2586	20.2586	20.2586	20.2586	2800.0
2012-05-22 04:43:00	AAPL	Stock	20.2314	20.2314	20.2314	20.2314	2800.0
2012-05-22 04:44:00	AAPL	Stock	20.2293	20.2293	20.2268	20.2268	8400.0
2012-05-22 04:50:00	AAPL	Stock	20.1821	20.1821	20.1821	20.1821	5600.0
2012-05-22 04:51:00	AAPL	Stock	20.2036	20.2036	20.2036	20.2036	8400.0
2012-05-22 04:52:00	AAPL	Stock	20.2036	20.2036	20.1964	20.1964	11200.0
2012-05-22 04:57:00	AAPL	Stock	20.1904	20.1904	20.1786	20.1786	73836.0
2012-05-22 04:58:00	AAPL	Stock	20.1786	20.1786	20.1786	20.1786	8400.0
2012-05-22 05:08:00	AAPL	Stock	20.1643	20.1643	20.1643	20.1643	8400.0
2012-05-22 05:09:00	AAPL	Stock	20.1393	20.1393	20.1393	20.1393	2800.0
2012-05-22 05:11:00	AAPL	Stock	20.1261	20.1261	20.1261	20.1261	5600.0
2012-05-22 05:12:00	AAPL	Stock	20.1261	20.1261	20.1261	20.1261	2940.0
2012-05-22 05:13:00	AAPL	Stock	20.1261	20.1261	20.1261	20.1261	5600.0
2012-05-22 05:18:00	AAPL	Stock	20.1111	20.1111	20.1107	20.1107	5600.0
2012-05-22 05:19:00	AAPL	Stock	20.1393	20.1393	20.1393	20.1393	4480.0
2012-05-22 05:36:00	AAPL	Stock	20.1593	20.1593	20.1593	20.1593	2800.0
2012-05-22 06:02:00	AAPL	Stock	20.1321	20.1321	20.1321	20.1321	14000.0
2012-05-22 06:32:00	AAPL	Stock	20.1111	20.1111	20.1111	20.1111	2800.0
2012-05-22 06:45:00	AAPL	Stock	20.125	20.125	20.125	20.125	5320.0
2012-05-22 06:50:00	AAPL	Stock	20.1429	20.1429	20.1429	20.1429	2800.0
2012-05-22 07:00:00	AAPL	Stock	20.1561	20.16	20.1429	20.1429	36680.0
2012-05-22 07:01:00	AAPL	Stock	20.1425	20.1429	20.1425	20.1429	52080.0
2012-05-22 07:02:00	AAPL	Stock	20.1429	20.1429	20.1429	20.1429	8400.0
2012-05-22 07:03:00	AAPL	Stock	20.1429	20.1429	20.1339	20.1339	39200.0
2012-05-22 07:04:00	AAPL	Stock	20.1254	20.1254	20.0975	20.0975	69972.0
2012-05-22 07:05:00	AAPL	Stock	20.125	20.125	20.125	20.125	2800.0
2012-05-22 07:06:00	AAPL	Stock	20.1304	20.1304	20.1304	20.1304	2800.0
2012-05-22 07:07:00	AAPL	Stock	20.1361	20.1368	20.1361	20.1368	5600.0
2012-05-22 07:11:00	AAPL	Stock	20.1429	20.1429	20.1368	20.1429	15596.0
2012-05-22 07:12:00	AAPL	Stock	20.1561	20.1561	20.1536	20.1536	5600.0
2012-05-22 07:13:00	AAPL	Stock	20.1536	20.1607	20.1536	20.1607	53200.0
2012-05-22 07:14:00	AAPL	Stock	20.1729	20.1739	20.1725	20.1725	23660.0
2012-05-22 07:15:00	AAPL	Stock	20.1621	20.1621	20.1621	20.1621	2800.0
2012-05-22 07:18:00	AAPL	Stock	20.1607	20.1707	20.1607	20.1707	8400.0
2012-05-22 07:19:00	AAPL	Stock	20.1714	20.1714	20.1714	20.1714	2800.0
2012-05-22 07:20:00	AAPL	Stock	20.1729	20.1786	20.1729	20.1786	33600.0
2012-05-22 07:21:00	AAPL	Stock	20.1782	20.1957	20.1743	20.1857	89376.0
2012-05-22 07:22:00	AAPL	Stock	20.1957	20.1964	20.1875	20.1875	50400.0
2012-05-22 07:23:00	AAPL	Stock	20.1821	20.1821	20.1786	20.1786	32200.0
2012-05-22 07:24:00	AAPL	Stock	20.1786	20.1868	20.1786	20.1868	11200.0
2012-05-22 07:25:00	AAPL	Stock	20.1904	20.1904	20.1875	20.1875	11200.0
2012-05-22 07:26:00	AAPL	Stock	20.1875	20.1875	20.1846	20.1846	8400.0
2012-05-22 07:27:00	AAPL	Stock	20.1893	20.1893	20.1875	20.1875	11200.0
2012-05-22 07:28:00	AAPL	Stock	20.1875	20.1875	20.1875	20.1875	19600.0

> showing 50 of 992,051 rows — these rows as CSV

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