PREVIEW / stock_1min / 2008-07-17

all stock 1-min files

  file:    by_date/stock_1min/2008/2008-07-17.parquet
  size:    13.4 MB
  rows:    1,059,376
  symbols: 2,719

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
2008-07-17 05:01:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-07-17 06:51:00	AAPL	Stock	6.1929	6.1929	6.1929	6.1929	2800.0
2008-07-17 07:01:00	AAPL	Stock	6.1964	6.1964	6.1964	6.1964	2800.0
2008-07-17 07:02:00	AAPL	Stock	6.2004	6.2004	6.2004	6.2004	7000.0
2008-07-17 07:08:00	AAPL	Stock	6.2157	6.2207	6.2146	6.2207	106400.0
2008-07-17 07:09:00	AAPL	Stock	6.2207	6.2232	6.2207	6.2232	35000.0
2008-07-17 07:10:00	AAPL	Stock	6.2296	6.2568	6.2296	6.2568	41160.0
2008-07-17 07:11:00	AAPL	Stock	6.2321	6.2321	6.2321	6.2321	67200.0
2008-07-17 07:13:00	AAPL	Stock	6.225	6.225	6.225	6.225	28000.0
2008-07-17 07:14:00	AAPL	Stock	6.2314	6.2321	6.2304	6.2304	25200.0
2008-07-17 07:16:00	AAPL	Stock	6.2321	6.2321	6.2321	6.2321	2800.0
2008-07-17 07:17:00	AAPL	Stock	6.2261	6.2261	6.2261	6.2261	2800.0
2008-07-17 07:18:00	AAPL	Stock	6.2268	6.2286	6.2261	6.2286	9800.0
2008-07-17 07:19:00	AAPL	Stock	6.2314	6.2314	6.2314	6.2314	2800.0
2008-07-17 07:23:00	AAPL	Stock	6.2236	6.2236	6.2236	6.2236	4200.0
2008-07-17 07:24:00	AAPL	Stock	6.2232	6.2232	6.2232	6.2232	56000.0
2008-07-17 07:30:00	AAPL	Stock	6.2282	6.2282	6.2282	6.2282	2800.0
2008-07-17 07:31:00	AAPL	Stock	6.2214	6.2214	6.2214	6.2214	25256.0
2008-07-17 07:34:00	AAPL	Stock	6.2275	6.2275	6.2275	6.2275	5600.0
2008-07-17 07:35:00	AAPL	Stock	6.2268	6.2268	6.2264	6.2264	8400.0
2008-07-17 07:36:00	AAPL	Stock	6.2257	6.2257	6.2257	6.2257	7000.0
2008-07-17 07:37:00	AAPL	Stock	6.225	6.225	6.225	6.225	2800.0
2008-07-17 07:38:00	AAPL	Stock	6.2043	6.2043	6.2036	6.2036	42000.0
2008-07-17 07:40:00	AAPL	Stock	6.2107	6.2107	6.2107	6.2107	2800.0
2008-07-17 07:45:00	AAPL	Stock	6.2143	6.2143	6.2143	6.2143	2800.0
2008-07-17 07:53:00	AAPL	Stock	6.2089	6.2089	6.2089	6.2089	2800.0
2008-07-17 07:54:00	AAPL	Stock	6.2143	6.2143	6.2143	6.2143	14000.0
2008-07-17 07:56:00	AAPL	Stock	6.2143	6.2143	6.2143	6.2143	12600.0
2008-07-17 07:57:00	AAPL	Stock	6.2143	6.2143	6.2139	6.2139	23800.0
2008-07-17 07:58:00	AAPL	Stock	6.2093	6.2093	6.2071	6.2071	29960.0
2008-07-17 07:59:00	AAPL	Stock	6.2136	6.2136	6.2136	6.2136	5600.0
2008-07-17 08:00:00	AAPL	Stock	6.2125	6.2204	6.2071	6.21	173068.0
2008-07-17 08:01:00	AAPL	Stock	6.2107	6.2139	6.2061	6.2071	84728.0
2008-07-17 08:02:00	AAPL	Stock	6.2071	6.2071	6.2036	6.2036	19600.0
2008-07-17 08:03:00	AAPL	Stock	6.2036	6.2107	6.2036	6.2071	28000.0
2008-07-17 08:04:00	AAPL	Stock	6.2071	6.2071	6.2036	6.2036	11200.0
2008-07-17 08:05:00	AAPL	Stock	6.2054	6.2107	6.2054	6.2107	82712.0
2008-07-17 08:06:00	AAPL	Stock	6.2107	6.2125	6.2107	6.2111	43456.0
2008-07-17 08:07:00	AAPL	Stock	6.2107	6.2139	6.2107	6.2107	29064.0
2008-07-17 08:08:00	AAPL	Stock	6.2107	6.2161	6.2107	6.2161	25200.0
2008-07-17 08:09:00	AAPL	Stock	6.2146	6.2157	6.2146	6.2157	8400.0
2008-07-17 08:10:00	AAPL	Stock	6.2143	6.2161	6.2139	6.2161	20636.0
2008-07-17 08:12:00	AAPL	Stock	6.2143	6.2161	6.2143	6.2161	19600.0
2008-07-17 08:13:00	AAPL	Stock	6.2143	6.2161	6.2107	6.2107	73668.0
2008-07-17 08:14:00	AAPL	Stock	6.2129	6.2132	6.2129	6.2132	22400.0
2008-07-17 08:15:00	AAPL	Stock	6.2129	6.2139	6.2129	6.2139	12208.0
2008-07-17 08:16:00	AAPL	Stock	6.2107	6.2136	6.2075	6.2136	109200.0
2008-07-17 08:17:00	AAPL	Stock	6.2107	6.2107	6.1964	6.1964	134736.0
2008-07-17 08:18:00	AAPL	Stock	6.2004	6.2004	6.1964	6.1964	22400.0
2008-07-17 08:19:00	AAPL	Stock	6.1946	6.1946	6.1936	6.1943	19600.0

> showing 50 of 1,059,376 rows — these rows as CSV

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