PREVIEW / stock_5min / 2012-05-25

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-05-25.parquet
  size:    4.6 MB
  rows:    316,079
  symbols: 3,513

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-05-25 04:00:00	AAPL	Stock	20.25	20.2857	20.25	20.2857	51800.0
2012-05-25 04:10:00	AAPL	Stock	20.3357	20.3357	20.3357	20.3357	2800.0
2012-05-25 04:15:00	AAPL	Stock	20.3357	20.3357	20.3357	20.3357	2800.0
2012-05-25 04:20:00	AAPL	Stock	20.3214	20.3214	20.3214	20.3214	14000.0
2012-05-25 04:40:00	AAPL	Stock	20.3143	20.3143	20.3143	20.3143	7000.0
2012-05-25 04:55:00	AAPL	Stock	20.3	20.3	20.3	20.3	2800.0
2012-05-25 06:10:00	AAPL	Stock	20.3104	20.3104	20.3104	20.3104	5600.0
2012-05-25 06:25:00	AAPL	Stock	20.3036	20.3036	20.3036	20.3036	2800.0
2012-05-25 06:30:00	AAPL	Stock	20.3036	20.3036	20.3036	20.3036	2800.0
2012-05-25 06:45:00	AAPL	Stock	20.2857	20.2857	20.2857	20.2857	2800.0
2012-05-25 06:50:00	AAPL	Stock	20.2321	20.2321	20.2321	20.2321	36400.0
2012-05-25 07:00:00	AAPL	Stock	20.2857	20.2857	20.2643	20.2643	16800.0
2012-05-25 07:05:00	AAPL	Stock	20.2807	20.2807	20.2679	20.2679	9800.0
2012-05-25 07:10:00	AAPL	Stock	20.2846	20.2846	20.2607	20.2607	6860.0
2012-05-25 07:15:00	AAPL	Stock	20.2679	20.2679	20.2679	20.2679	6720.0
2012-05-25 07:20:00	AAPL	Stock	20.25	20.2857	20.2357	20.2711	85260.0
2012-05-25 07:30:00	AAPL	Stock	20.2429	20.2439	20.2429	20.2439	5600.0
2012-05-25 07:40:00	AAPL	Stock	20.2464	20.2479	20.2464	20.2479	5600.0
2012-05-25 07:45:00	AAPL	Stock	20.2468	20.2468	20.2468	20.2468	2800.0
2012-05-25 07:50:00	AAPL	Stock	20.2589	20.2589	20.2321	20.2321	53200.0
2012-05-25 07:55:00	AAPL	Stock	20.2454	20.275	20.2436	20.2436	84840.0
2012-05-25 08:00:00	AAPL	Stock	20.25	20.2946	20.2375	20.25	249732.0
2012-05-25 08:05:00	AAPL	Stock	20.25	20.2564	20.2161	20.2179	100100.0
2012-05-25 08:10:00	AAPL	Stock	20.2229	20.2232	20.1643	20.1643	341516.0
2012-05-25 08:15:00	AAPL	Stock	20.1521	20.2043	20.1346	20.1964	131600.0
2012-05-25 08:20:00	AAPL	Stock	20.1961	20.2046	20.1689	20.1689	267428.0
2012-05-25 08:25:00	AAPL	Stock	20.1782	20.1875	20.1507	20.1507	100044.0
2012-05-25 08:30:00	AAPL	Stock	20.1507	20.1782	20.1507	20.1536	142744.0
2012-05-25 08:35:00	AAPL	Stock	20.1518	20.1564	20.0911	20.1189	299656.0
2012-05-25 08:40:00	AAPL	Stock	20.1179	20.1661	20.1143	20.1489	208264.0
2012-05-25 08:45:00	AAPL	Stock	20.1489	20.1679	20.1471	20.1511	260820.0
2012-05-25 08:50:00	AAPL	Stock	20.1554	20.1693	20.1425	20.1446	151900.0
2012-05-25 08:55:00	AAPL	Stock	20.1425	20.1464	20.1343	20.1429	68068.0
2012-05-25 09:00:00	AAPL	Stock	20.1361	20.1361	20.1343	20.1357	50484.0
2012-05-25 09:05:00	AAPL	Stock	20.1393	20.1393	20.1182	20.1214	51744.0
2012-05-25 09:10:00	AAPL	Stock	20.1218	20.16	20.1218	20.1521	505512.0
2012-05-25 09:15:00	AAPL	Stock	20.1596	20.1596	20.1332	20.1339	56000.0
2012-05-25 09:20:00	AAPL	Stock	20.1254	20.1429	20.1218	20.1429	198520.0
2012-05-25 09:25:00	AAPL	Stock	20.1636	20.1661	20.1379	20.1607	335272.0
2012-05-25 09:30:00	AAPL	Stock	20.1643	20.2089	20.0679	20.1031	15573012.0
2012-05-25 09:35:00	AAPL	Stock	20.0996	20.1393	20.0736	20.0766	9527700.0
2012-05-25 09:40:00	AAPL	Stock	20.0758	20.0939	19.9679	19.9929	16432108.0
2012-05-25 09:45:00	AAPL	Stock	19.9896	20.0625	19.9807	20.0375	10376604.0
2012-05-25 09:50:00	AAPL	Stock	20.0336	20.0836	20.0232	20.0714	7750008.0
2012-05-25 09:55:00	AAPL	Stock	20.0739	20.1243	20.0554	20.0632	8163568.0
2012-05-25 10:00:00	AAPL	Stock	20.0604	20.0779	20.0129	20.0586	5874904.0
2012-05-25 10:05:00	AAPL	Stock	20.0589	20.0614	20.0179	20.0314	4916996.0
2012-05-25 10:10:00	AAPL	Stock	20.0364	20.0464	19.9911	20.0184	6371316.0
2012-05-25 10:15:00	AAPL	Stock	20.0136	20.0429	19.9832	20.0275	4665108.0
2012-05-25 10:20:00	AAPL	Stock	20.0236	20.0557	20.0121	20.0536	4240600.0

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

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