PREVIEW / stock_1min / 2013-06-27

all stock 1-min files

  file:    by_date/stock_1min/2013/2013-06-27.parquet
  size:    13.8 MB
  rows:    1,026,065
  symbols: 2,860

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
2013-06-27 05:14:00	AAPL	Stock	14.2054	14.2054	14.2054	14.2054	2800.0
2013-06-27 05:37:00	AAPL	Stock	14.2018	14.2018	14.2	14.2	14000.0
2013-06-27 06:45:00	AAPL	Stock	14.2143	14.2143	14.2143	14.2143	2800.0
2013-06-27 07:04:00	AAPL	Stock	14.2232	14.2232	14.2232	14.2232	18312.0
2013-06-27 07:13:00	AAPL	Stock	14.2143	14.2143	14.2143	14.2143	2800.0
2013-06-27 07:18:00	AAPL	Stock	14.2143	14.2143	14.2143	14.2143	2800.0
2013-06-27 07:19:00	AAPL	Stock	14.1914	14.1914	14.1914	14.1914	2800.0
2013-06-27 07:21:00	AAPL	Stock	14.1946	14.1946	14.1868	14.1868	30800.0
2013-06-27 07:22:00	AAPL	Stock	14.1868	14.1868	14.1868	14.1868	2800.0
2013-06-27 07:31:00	AAPL	Stock	14.1868	14.1875	14.1786	14.1786	10528.0
2013-06-27 07:35:00	AAPL	Stock	14.1779	14.1779	14.1779	14.1779	2800.0
2013-06-27 07:40:00	AAPL	Stock	14.1786	14.1786	14.1786	14.1786	4060.0
2013-06-27 07:42:00	AAPL	Stock	14.1811	14.1821	14.1732	14.1732	16800.0
2013-06-27 07:45:00	AAPL	Stock	14.1957	14.2161	14.1957	14.2161	47600.0
2013-06-27 07:46:00	AAPL	Stock	14.2264	14.2264	14.2264	14.2264	11200.0
2013-06-27 07:47:00	AAPL	Stock	14.2304	14.2321	14.2304	14.2321	8400.0
2013-06-27 07:48:00	AAPL	Stock	14.2304	14.2304	14.2304	14.2304	2800.0
2013-06-27 07:50:00	AAPL	Stock	14.2204	14.2218	14.2143	14.2214	30800.0
2013-06-27 07:51:00	AAPL	Stock	14.2232	14.2232	14.2232	14.2232	2800.0
2013-06-27 07:52:00	AAPL	Stock	14.2168	14.2168	14.2107	14.2107	30576.0
2013-06-27 07:56:00	AAPL	Stock	14.2229	14.2429	14.2229	14.2429	63840.0
2013-06-27 08:00:00	AAPL	Stock	14.2321	14.2368	14.1929	14.2146	40040.0
2013-06-27 08:01:00	AAPL	Stock	14.2311	14.2311	14.2143	14.2157	40040.0
2013-06-27 08:02:00	AAPL	Stock	14.2304	14.2311	14.2304	14.2311	5600.0
2013-06-27 08:05:00	AAPL	Stock	14.2286	14.2286	14.2286	14.2286	2800.0
2013-06-27 08:07:00	AAPL	Stock	14.2311	14.2393	14.2311	14.2393	14000.0
2013-06-27 08:08:00	AAPL	Stock	14.2382	14.2411	14.2382	14.2411	14700.0
2013-06-27 08:09:00	AAPL	Stock	14.2411	14.2464	14.2407	14.2464	172060.0
2013-06-27 08:10:00	AAPL	Stock	14.2339	14.2407	14.2311	14.2339	43960.0
2013-06-27 08:11:00	AAPL	Stock	14.2439	14.2454	14.2439	14.2454	8400.0
2013-06-27 08:13:00	AAPL	Stock	14.2457	14.2471	14.2375	14.2471	67200.0
2013-06-27 08:14:00	AAPL	Stock	14.25	14.2568	14.25	14.2543	27524.0
2013-06-27 08:15:00	AAPL	Stock	14.25	14.25	14.2496	14.2496	8400.0
2013-06-27 08:16:00	AAPL	Stock	14.25	14.25	14.2496	14.2496	5600.0
2013-06-27 08:17:00	AAPL	Stock	14.2529	14.2607	14.2529	14.2607	28000.0
2013-06-27 08:19:00	AAPL	Stock	14.2621	14.2696	14.2529	14.2571	67228.0
2013-06-27 08:20:00	AAPL	Stock	14.2679	14.2714	14.2571	14.2714	54152.0
2013-06-27 08:21:00	AAPL	Stock	14.2714	14.2714	14.2714	14.2714	2800.0
2013-06-27 08:22:00	AAPL	Stock	14.2643	14.2643	14.2643	14.2643	12600.0
2013-06-27 08:23:00	AAPL	Stock	14.2575	14.2575	14.2575	14.2575	5600.0
2013-06-27 08:24:00	AAPL	Stock	14.2589	14.2589	14.2521	14.2589	46200.0
2013-06-27 08:25:00	AAPL	Stock	14.2636	14.2636	14.26	14.26	8400.0
2013-06-27 08:29:00	AAPL	Stock	14.2536	14.2643	14.2536	14.2643	11256.0
2013-06-27 08:30:00	AAPL	Stock	14.2675	14.2696	14.2675	14.2696	13020.0
2013-06-27 08:32:00	AAPL	Stock	14.2593	14.2625	14.2554	14.2582	91280.0
2013-06-27 08:33:00	AAPL	Stock	14.2564	14.2564	14.255	14.2554	14000.0
2013-06-27 08:34:00	AAPL	Stock	14.255	14.255	14.2464	14.2536	39200.0
2013-06-27 08:35:00	AAPL	Stock	14.25	14.2554	14.25	14.2554	15960.0
2013-06-27 08:36:00	AAPL	Stock	14.2536	14.2571	14.2536	14.2571	11200.0
2013-06-27 08:37:00	AAPL	Stock	14.2589	14.2589	14.2511	14.2511	196000.0

> showing 50 of 1,026,065 rows — these rows as CSV

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