PREVIEW / stock_1min / 2014-04-25

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-04-25.parquet
  size:    14.5 MB
  rows:    1,067,789
  symbols: 2,864

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-04-25 04:00:00	AAPL	Stock	20.1857	20.1857	20.1857	20.1857	2800.0
2014-04-25 04:02:00	AAPL	Stock	20.1804	20.1804	20.1804	20.1804	8400.0
2014-04-25 04:03:00	AAPL	Stock	20.1539	20.1539	20.1539	20.1539	2800.0
2014-04-25 04:15:00	AAPL	Stock	20.15	20.15	20.15	20.15	2800.0
2014-04-25 04:23:00	AAPL	Stock	20.1607	20.1607	20.1607	20.1607	2800.0
2014-04-25 04:30:00	AAPL	Stock	20.1607	20.1607	20.1607	20.1607	2800.0
2014-04-25 04:47:00	AAPL	Stock	20.1593	20.1593	20.1593	20.1593	2800.0
2014-04-25 04:49:00	AAPL	Stock	20.15	20.15	20.15	20.15	24220.0
2014-04-25 04:56:00	AAPL	Stock	20.1468	20.1468	20.1468	20.1468	2800.0
2014-04-25 04:59:00	AAPL	Stock	20.1429	20.1429	20.1429	20.1429	2800.0
2014-04-25 05:06:00	AAPL	Stock	20.1429	20.1429	20.1429	20.1429	2800.0
2014-04-25 05:08:00	AAPL	Stock	20.1429	20.1429	20.1429	20.1429	5600.0
2014-04-25 05:11:00	AAPL	Stock	20.1464	20.1618	20.1464	20.1618	10640.0
2014-04-25 05:12:00	AAPL	Stock	20.1614	20.1614	20.1614	20.1614	2800.0
2014-04-25 05:40:00	AAPL	Stock	20.1593	20.1593	20.1593	20.1593	2800.0
2014-04-25 06:06:00	AAPL	Stock	20.15	20.15	20.15	20.15	4984.0
2014-04-25 06:28:00	AAPL	Stock	20.1661	20.1743	20.1661	20.1743	5880.0
2014-04-25 06:31:00	AAPL	Stock	20.1661	20.1661	20.1661	20.1661	2800.0
2014-04-25 06:34:00	AAPL	Stock	20.1679	20.1679	20.1679	20.1679	5600.0
2014-04-25 06:37:00	AAPL	Stock	20.1679	20.1679	20.1429	20.1429	7000.0
2014-04-25 06:38:00	AAPL	Stock	20.1375	20.1375	20.1075	20.1075	40992.0
2014-04-25 06:44:00	AAPL	Stock	20.1425	20.1425	20.1425	20.1425	2800.0
2014-04-25 06:49:00	AAPL	Stock	20.1246	20.1246	20.1246	20.1246	5600.0
2014-04-25 06:57:00	AAPL	Stock	20.125	20.125	20.125	20.125	2800.0
2014-04-25 06:59:00	AAPL	Stock	20.1318	20.1318	20.0754	20.0754	75684.0
2014-04-25 07:00:00	AAPL	Stock	20.1318	20.1318	20.1318	20.1318	2800.0
2014-04-25 07:02:00	AAPL	Stock	20.0864	20.0864	20.0714	20.0714	9520.0
2014-04-25 07:03:00	AAPL	Stock	20.1075	20.1075	20.1075	20.1075	2800.0
2014-04-25 07:05:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	5600.0
2014-04-25 07:07:00	AAPL	Stock	20.1154	20.1154	20.1154	20.1154	2800.0
2014-04-25 07:15:00	AAPL	Stock	20.1161	20.1161	20.1125	20.1125	15400.0
2014-04-25 07:19:00	AAPL	Stock	20.1161	20.1161	20.1161	20.1161	2800.0
2014-04-25 07:20:00	AAPL	Stock	20.1161	20.1161	20.1161	20.1161	10360.0
2014-04-25 07:21:00	AAPL	Stock	20.1161	20.1161	20.1161	20.1161	28000.0
2014-04-25 07:22:00	AAPL	Stock	20.1071	20.1071	20.0996	20.0996	41440.0
2014-04-25 07:23:00	AAPL	Stock	20.0996	20.0996	20.0996	20.0996	58800.0
2014-04-25 07:24:00	AAPL	Stock	20.0996	20.0996	20.0982	20.0996	11704.0
2014-04-25 07:25:00	AAPL	Stock	20.1068	20.1071	20.1068	20.1071	16800.0
2014-04-25 07:27:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	2800.0
2014-04-25 07:30:00	AAPL	Stock	20.1161	20.1164	20.1161	20.1164	31584.0
2014-04-25 07:31:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	4536.0
2014-04-25 07:32:00	AAPL	Stock	20.1125	20.1125	20.1071	20.1071	12936.0
2014-04-25 07:33:00	AAPL	Stock	20.1125	20.1125	20.1071	20.1071	33600.0
2014-04-25 07:34:00	AAPL	Stock	20.1	20.1	20.1	20.1	11200.0
2014-04-25 07:36:00	AAPL	Stock	20.1	20.1	20.1	20.1	20804.0
2014-04-25 07:37:00	AAPL	Stock	20.1	20.1	20.0929	20.0929	19460.0
2014-04-25 07:40:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	2800.0
2014-04-25 07:45:00	AAPL	Stock	20.1214	20.1225	20.12	20.1225	9800.0
2014-04-25 07:47:00	AAPL	Stock	20.1282	20.135	20.1282	20.135	10780.0
2014-04-25 07:49:00	AAPL	Stock	20.1357	20.1375	20.1357	20.1375	5600.0

> showing 50 of 1,067,789 rows — these rows as CSV

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