PREVIEW / stock_5min / 2011-11-09

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-11-09.parquet
  size:    4.9 MB
  rows:    330,466
  symbols: 3,500

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
2011-11-09 04:00:00	AAPL	Stock	14.4643	14.4643	14.4486	14.4486	39200.0
2011-11-09 04:05:00	AAPL	Stock	14.4143	14.4214	14.4143	14.4214	58800.0
2011-11-09 04:10:00	AAPL	Stock	14.4286	14.4286	14.4204	14.4204	25200.0
2011-11-09 04:20:00	AAPL	Stock	14.4071	14.4164	14.3925	14.3925	11200.0
2011-11-09 04:30:00	AAPL	Stock	14.3929	14.3929	14.3929	14.3929	11200.0
2011-11-09 04:40:00	AAPL	Stock	14.3975	14.3975	14.3929	14.3929	19460.0
2011-11-09 04:50:00	AAPL	Stock	14.3571	14.3571	14.3571	14.3571	2800.0
2011-11-09 05:00:00	AAPL	Stock	14.3804	14.3804	14.3786	14.3786	12600.0
2011-11-09 05:05:00	AAPL	Stock	14.3704	14.3704	14.3429	14.3429	61404.0
2011-11-09 05:10:00	AAPL	Stock	14.325	14.325	14.3214	14.3214	22960.0
2011-11-09 05:15:00	AAPL	Stock	14.3214	14.3214	14.3214	14.3214	8400.0
2011-11-09 05:25:00	AAPL	Stock	14.2929	14.2929	14.25	14.2857	16800.0
2011-11-09 05:35:00	AAPL	Stock	14.2875	14.2875	14.2507	14.2507	35280.0
2011-11-09 05:40:00	AAPL	Stock	14.2507	14.2507	14.2143	14.2143	23576.0
2011-11-09 06:05:00	AAPL	Stock	14.25	14.25	14.25	14.25	5600.0
2011-11-09 06:50:00	AAPL	Stock	14.2293	14.25	14.2293	14.25	16800.0
2011-11-09 06:55:00	AAPL	Stock	14.2343	14.2343	14.2254	14.2343	82600.0
2011-11-09 07:00:00	AAPL	Stock	14.2486	14.2946	14.2486	14.2946	95900.0
2011-11-09 07:05:00	AAPL	Stock	14.2989	14.3132	14.2982	14.3014	130592.0
2011-11-09 07:10:00	AAPL	Stock	14.2954	14.3054	14.2921	14.2986	46788.0
2011-11-09 07:15:00	AAPL	Stock	14.3107	14.3107	14.2679	14.2679	351092.0
2011-11-09 07:20:00	AAPL	Stock	14.2593	14.2607	14.2143	14.25	271544.0
2011-11-09 07:25:00	AAPL	Stock	14.2518	14.2518	14.2214	14.2214	224420.0
2011-11-09 07:30:00	AAPL	Stock	14.2232	14.2243	14.1864	14.2143	202496.0
2011-11-09 07:35:00	AAPL	Stock	14.2143	14.2214	14.2	14.2054	284368.0
2011-11-09 07:40:00	AAPL	Stock	14.2089	14.2089	14.1946	14.2	368312.0
2011-11-09 07:45:00	AAPL	Stock	14.1968	14.2071	14.1964	14.2029	157780.0
2011-11-09 07:50:00	AAPL	Stock	14.2054	14.2071	14.1932	14.1968	1041152.0
2011-11-09 07:55:00	AAPL	Stock	14.2	14.2143	14.1936	14.2107	626416.0
2011-11-09 08:00:00	AAPL	Stock	14.2139	14.3014	14.2004	14.2546	1638140.0
2011-11-09 08:05:00	AAPL	Stock	14.2593	14.2593	14.2286	14.25	1079904.0
2011-11-09 08:10:00	AAPL	Stock	14.25	14.2589	14.2361	14.2446	926968.0
2011-11-09 08:15:00	AAPL	Stock	14.2446	14.2554	14.2321	14.2321	507108.0
2011-11-09 08:20:00	AAPL	Stock	14.2425	14.2425	14.2218	14.2229	309960.0
2011-11-09 08:25:00	AAPL	Stock	14.225	14.2254	14.2018	14.2143	1272124.0
2011-11-09 08:30:00	AAPL	Stock	14.2161	14.2264	14.21	14.2179	357952.0
2011-11-09 08:35:00	AAPL	Stock	14.2189	14.2321	14.2036	14.2096	810096.0
2011-11-09 08:40:00	AAPL	Stock	14.2093	14.2607	14.2093	14.2514	1048124.0
2011-11-09 08:45:00	AAPL	Stock	14.2504	14.2514	14.225	14.2321	511588.0
2011-11-09 08:50:00	AAPL	Stock	14.2268	14.2429	14.2254	14.2346	292936.0
2011-11-09 08:55:00	AAPL	Stock	14.2318	14.2468	14.2318	14.2411	298480.0
2011-11-09 09:00:00	AAPL	Stock	14.2439	14.2536	14.2004	14.2018	1463364.0
2011-11-09 09:05:00	AAPL	Stock	14.2014	14.2014	14.18	14.1836	1404704.0
2011-11-09 09:10:00	AAPL	Stock	14.1821	14.2064	14.1793	14.1846	665840.0
2011-11-09 09:15:00	AAPL	Stock	14.1893	14.1946	14.1843	14.1943	345016.0
2011-11-09 09:20:00	AAPL	Stock	14.1929	14.1929	14.15	14.1571	1268652.0
2011-11-09 09:25:00	AAPL	Stock	14.1604	14.1929	14.1582	14.1721	790692.0
2011-11-09 09:30:00	AAPL	Stock	14.1746	14.2214	14.1607	14.2064	32014332.0
2011-11-09 09:35:00	AAPL	Stock	14.203	14.2318	14.2004	14.2171	18002880.0
2011-11-09 09:40:00	AAPL	Stock	14.2196	14.2304	14.1964	14.2207	15146544.0

> showing 50 of 330,466 rows — these rows as CSV

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