PREVIEW / stock_5min / 2012-01-20

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-01-20.parquet
  size:    4.7 MB
  rows:    316,074
  symbols: 3,506

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-01-20 04:00:00	AAPL	Stock	15.2107	15.2107	15.1821	15.1821	6440.0
2012-01-20 04:25:00	AAPL	Stock	15.2082	15.2082	15.2082	15.2082	5600.0
2012-01-20 05:00:00	AAPL	Stock	15.155	15.155	15.1518	15.1518	28000.0
2012-01-20 05:35:00	AAPL	Stock	15.2143	15.2143	15.2143	15.2143	11200.0
2012-01-20 06:05:00	AAPL	Stock	15.2225	15.2225	15.2225	15.2225	2800.0
2012-01-20 06:30:00	AAPL	Stock	15.2143	15.2143	15.2143	15.2143	2800.0
2012-01-20 07:00:00	AAPL	Stock	15.2096	15.225	15.2096	15.225	12656.0
2012-01-20 07:05:00	AAPL	Stock	15.2254	15.2461	15.2146	15.2461	29260.0
2012-01-20 07:10:00	AAPL	Stock	15.2321	15.2364	15.2214	15.2214	34048.0
2012-01-20 07:15:00	AAPL	Stock	15.2321	15.2321	15.2229	15.2229	19600.0
2012-01-20 07:20:00	AAPL	Stock	15.2321	15.2325	15.2321	15.2321	33600.0
2012-01-20 07:30:00	AAPL	Stock	15.2357	15.2357	15.2357	15.2357	14000.0
2012-01-20 07:35:00	AAPL	Stock	15.2357	15.2643	15.2357	15.2643	37380.0
2012-01-20 07:40:00	AAPL	Stock	15.2643	15.275	15.2496	15.2732	61600.0
2012-01-20 07:45:00	AAPL	Stock	15.2521	15.2521	15.2504	15.2504	5600.0
2012-01-20 07:50:00	AAPL	Stock	15.2636	15.2636	15.2636	15.2636	2800.0
2012-01-20 07:55:00	AAPL	Stock	15.2529	15.2529	15.2411	15.2411	47600.0
2012-01-20 08:00:00	AAPL	Stock	15.2536	15.2536	15.2307	15.2343	72044.0
2012-01-20 08:05:00	AAPL	Stock	15.2411	15.2411	15.2232	15.2232	84448.0
2012-01-20 08:10:00	AAPL	Stock	15.2214	15.2304	15.2157	15.2304	14000.0
2012-01-20 08:15:00	AAPL	Stock	15.2268	15.23	15.225	15.2268	17220.0
2012-01-20 08:20:00	AAPL	Stock	15.2236	15.2371	15.2236	15.2371	11200.0
2012-01-20 08:30:00	AAPL	Stock	15.2321	15.2321	15.2214	15.2268	77112.0
2012-01-20 08:35:00	AAPL	Stock	15.2268	15.2325	15.2214	15.2325	50232.0
2012-01-20 08:40:00	AAPL	Stock	15.2339	15.2339	15.2261	15.2261	47600.0
2012-01-20 08:45:00	AAPL	Stock	15.2329	15.2346	15.2264	15.2339	31080.0
2012-01-20 08:50:00	AAPL	Stock	15.2321	15.2339	15.2289	15.2314	57400.0
2012-01-20 08:55:00	AAPL	Stock	15.2304	15.2304	15.2304	15.2304	2800.0
2012-01-20 09:00:00	AAPL	Stock	15.2321	15.235	15.2314	15.2336	59920.0
2012-01-20 09:05:00	AAPL	Stock	15.2314	15.2314	15.2254	15.2254	8400.0
2012-01-20 09:10:00	AAPL	Stock	15.2311	15.2311	15.2311	15.2311	5600.0
2012-01-20 09:15:00	AAPL	Stock	15.2271	15.2271	15.2257	15.2257	16800.0
2012-01-20 09:20:00	AAPL	Stock	15.2261	15.2261	15.2257	15.2257	5600.0
2012-01-20 09:25:00	AAPL	Stock	15.2318	15.2682	15.2318	15.2571	1029028.0
2012-01-20 09:30:00	AAPL	Stock	15.2571	15.2679	15.2054	15.2318	34150928.0
2012-01-20 09:35:00	AAPL	Stock	15.2282	15.2354	15.2089	15.2111	6841492.0
2012-01-20 09:40:00	AAPL	Stock	15.2111	15.2193	15.2064	15.2132	6246548.0
2012-01-20 09:45:00	AAPL	Stock	15.2129	15.2161	15.1682	15.1736	9500540.0
2012-01-20 09:50:00	AAPL	Stock	15.1725	15.1764	15.1257	15.1289	11895828.0
2012-01-20 09:55:00	AAPL	Stock	15.1289	15.1725	15.1114	15.1625	13296640.0
2012-01-20 10:00:00	AAPL	Stock	15.16	15.1736	15.1489	15.1725	6427764.0
2012-01-20 10:05:00	AAPL	Stock	15.1718	15.1786	15.1632	15.1725	4724272.0
2012-01-20 10:10:00	AAPL	Stock	15.1729	15.1764	15.1668	15.1693	3040352.0
2012-01-20 10:15:00	AAPL	Stock	15.1686	15.1732	15.1636	15.1668	3040660.0
2012-01-20 10:20:00	AAPL	Stock	15.1675	15.175	15.1625	15.1711	3091676.0
2012-01-20 10:25:00	AAPL	Stock	15.1686	15.175	15.1661	15.1729	1700608.0
2012-01-20 10:30:00	AAPL	Stock	15.1729	15.1768	15.1696	15.1743	2522072.0
2012-01-20 10:35:00	AAPL	Stock	15.1741	15.175	15.1679	15.1707	2410716.0
2012-01-20 10:40:00	AAPL	Stock	15.1714	15.1732	15.1668	15.1693	2662548.0
2012-01-20 10:45:00	AAPL	Stock	15.1704	15.1711	15.1468	15.1554	3720556.0

> showing 50 of 316,074 rows — these rows as CSV

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