PREVIEW / stock_5min / 2013-01-23

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-01-23.parquet
  size:    4.9 MB
  rows:    331,381
  symbols: 3,489

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-01-23 04:00:00	AAPL	Stock	18.1143	18.1143	18.1143	18.1143	5600.0
2013-01-23 04:05:00	AAPL	Stock	18.1071	18.1071	18.0939	18.0939	5600.0
2013-01-23 04:20:00	AAPL	Stock	18.1211	18.125	18.1211	18.1225	8400.0
2013-01-23 04:25:00	AAPL	Stock	18.1225	18.1225	18.1225	18.1225	2800.0
2013-01-23 05:00:00	AAPL	Stock	18.1164	18.1164	18.1164	18.1164	2800.0
2013-01-23 05:20:00	AAPL	Stock	18.1429	18.1429	18.125	18.125	8400.0
2013-01-23 05:35:00	AAPL	Stock	18.1264	18.1264	18.1264	18.1264	10080.0
2013-01-23 05:40:00	AAPL	Stock	18.1268	18.1268	18.1268	18.1268	2800.0
2013-01-23 05:45:00	AAPL	Stock	18.125	18.125	18.125	18.125	2800.0
2013-01-23 05:50:00	AAPL	Stock	18.1246	18.1268	18.1246	18.125	18200.0
2013-01-23 06:00:00	AAPL	Stock	18.1268	18.1268	18.125	18.125	8400.0
2013-01-23 06:05:00	AAPL	Stock	18.125	18.125	18.125	18.125	5600.0
2013-01-23 06:10:00	AAPL	Stock	18.1268	18.1268	18.1268	18.1268	2800.0
2013-01-23 06:20:00	AAPL	Stock	18.1275	18.1275	18.1275	18.1275	6300.0
2013-01-23 06:30:00	AAPL	Stock	18.1307	18.1307	18.1307	18.1307	2800.0
2013-01-23 06:35:00	AAPL	Stock	18.1429	18.1429	18.1429	18.1429	2800.0
2013-01-23 06:45:00	AAPL	Stock	18.1429	18.1429	18.1429	18.1429	2800.0
2013-01-23 06:50:00	AAPL	Stock	18.1429	18.1429	18.1429	18.1429	2800.0
2013-01-23 06:55:00	AAPL	Stock	18.1393	18.1393	18.1393	18.1393	2800.0
2013-01-23 07:00:00	AAPL	Stock	18.1571	18.1775	18.1429	18.1429	25200.0
2013-01-23 07:05:00	AAPL	Stock	18.1429	18.1593	18.1429	18.1536	70140.0
2013-01-23 07:10:00	AAPL	Stock	18.1436	18.1436	18.1396	18.1429	37940.0
2013-01-23 07:15:00	AAPL	Stock	18.1336	18.1589	18.1336	18.1536	43820.0
2013-01-23 07:20:00	AAPL	Stock	18.1582	18.1589	18.1454	18.1521	25200.0
2013-01-23 07:25:00	AAPL	Stock	18.1521	18.1589	18.1471	18.1589	99624.0
2013-01-23 07:30:00	AAPL	Stock	18.1586	18.1596	18.1443	18.1443	69804.0
2013-01-23 07:35:00	AAPL	Stock	18.1471	18.1571	18.1429	18.1571	72576.0
2013-01-23 07:40:00	AAPL	Stock	18.1571	18.1571	18.1464	18.1464	42000.0
2013-01-23 07:45:00	AAPL	Stock	18.1439	18.1439	18.1286	18.1286	88228.0
2013-01-23 07:50:00	AAPL	Stock	18.125	18.125	18.1161	18.1161	52612.0
2013-01-23 07:55:00	AAPL	Stock	18.1146	18.1146	18.0918	18.0918	69692.0
2013-01-23 08:00:00	AAPL	Stock	18.0993	18.1811	18.0604	18.0604	630196.0
2013-01-23 08:05:00	AAPL	Stock	18.0604	18.0714	18.0214	18.0575	569100.0
2013-01-23 08:10:00	AAPL	Stock	18.0696	18.0939	18.0607	18.0657	194684.0
2013-01-23 08:15:00	AAPL	Stock	18.0679	18.0914	18.0679	18.0914	84644.0
2013-01-23 08:20:00	AAPL	Stock	18.0836	18.0925	18.0714	18.0714	230412.0
2013-01-23 08:25:00	AAPL	Stock	18.0679	18.0739	18.0571	18.0739	277816.0
2013-01-23 08:30:00	AAPL	Stock	18.0786	18.0893	18.0604	18.0893	250656.0
2013-01-23 08:35:00	AAPL	Stock	18.0882	18.1	18.0746	18.0954	179228.0
2013-01-23 08:40:00	AAPL	Stock	18.0982	18.0982	18.0857	18.0964	82740.0
2013-01-23 08:45:00	AAPL	Stock	18.0893	18.1071	18.0893	18.1054	101192.0
2013-01-23 08:50:00	AAPL	Stock	18.1064	18.1143	18.1014	18.1132	277564.0
2013-01-23 08:55:00	AAPL	Stock	18.1132	18.1232	18.1036	18.1182	413700.0
2013-01-23 09:00:00	AAPL	Stock	18.1179	18.1371	18.1179	18.1182	334824.0
2013-01-23 09:05:00	AAPL	Stock	18.1182	18.1318	18.1179	18.1311	134428.0
2013-01-23 09:10:00	AAPL	Stock	18.1304	18.1304	18.1229	18.1286	114912.0
2013-01-23 09:15:00	AAPL	Stock	18.1286	18.1504	18.1286	18.1468	209860.0
2013-01-23 09:20:00	AAPL	Stock	18.15	18.1604	18.1429	18.1511	305312.0
2013-01-23 09:25:00	AAPL	Stock	18.1564	18.1929	18.1321	18.1714	1083152.0
2013-01-23 09:30:00	AAPL	Stock	18.1693	18.2429	18.1	18.1246	25473364.0

> showing 50 of 331,381 rows — these rows as CSV

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