PREVIEW / stock_5min / 2013-08-20

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-08-20.parquet
  size:    5.2 MB
  rows:    343,815
  symbols: 3,533

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-08-20 04:00:00	AAPL	Stock	18.2143	18.2143	18.2143	18.2143	12600.0
2013-08-20 04:05:00	AAPL	Stock	18.1857	18.1857	18.1857	18.1857	8400.0
2013-08-20 04:10:00	AAPL	Stock	18.0821	18.0821	18.0821	18.0821	5600.0
2013-08-20 04:15:00	AAPL	Stock	18.1229	18.1229	18.0714	18.0714	14000.0
2013-08-20 04:30:00	AAPL	Stock	18.08	18.08	18.0357	18.0357	33600.0
2013-08-20 04:40:00	AAPL	Stock	17.9839	17.9839	17.9839	17.9839	8400.0
2013-08-20 04:45:00	AAPL	Stock	17.9957	17.9957	17.9957	17.9957	2800.0
2013-08-20 04:50:00	AAPL	Stock	18.0125	18.0182	18.0125	18.0182	8400.0
2013-08-20 04:55:00	AAPL	Stock	18.0146	18.0146	18.0	18.0146	11200.0
2013-08-20 05:00:00	AAPL	Stock	18.0146	18.0268	18.0146	18.0268	5600.0
2013-08-20 05:10:00	AAPL	Stock	18.0214	18.0214	18.0214	18.0214	5600.0
2013-08-20 05:25:00	AAPL	Stock	18.0793	18.08	18.0793	18.08	11200.0
2013-08-20 05:35:00	AAPL	Stock	18.0786	18.0786	18.0786	18.0786	3024.0
2013-08-20 05:40:00	AAPL	Stock	18.0782	18.0782	18.0782	18.0782	2800.0
2013-08-20 05:45:00	AAPL	Stock	18.0632	18.0754	18.0632	18.0754	27132.0
2013-08-20 05:50:00	AAPL	Stock	18.08	18.08	18.08	18.08	2800.0
2013-08-20 05:55:00	AAPL	Stock	18.0714	18.08	18.0714	18.08	5600.0
2013-08-20 06:00:00	AAPL	Stock	18.08	18.0896	18.08	18.0896	16128.0
2013-08-20 06:05:00	AAPL	Stock	18.1071	18.1071	18.1071	18.1071	2800.0
2013-08-20 06:10:00	AAPL	Stock	18.1107	18.1107	18.1107	18.1107	2800.0
2013-08-20 06:20:00	AAPL	Stock	18.1071	18.1071	18.1071	18.1071	14000.0
2013-08-20 06:35:00	AAPL	Stock	18.1086	18.1086	18.1086	18.1086	5600.0
2013-08-20 06:40:00	AAPL	Stock	18.1357	18.1357	18.1357	18.1357	2800.0
2013-08-20 07:00:00	AAPL	Stock	18.1339	18.1475	18.11	18.1464	78232.0
2013-08-20 07:05:00	AAPL	Stock	18.1618	18.1625	18.1536	18.1536	44380.0
2013-08-20 07:10:00	AAPL	Stock	18.1486	18.1486	18.1486	18.1486	2800.0
2013-08-20 07:15:00	AAPL	Stock	18.1464	18.1618	18.1436	18.1618	48776.0
2013-08-20 07:20:00	AAPL	Stock	18.1618	18.1875	18.1618	18.1875	60900.0
2013-08-20 07:25:00	AAPL	Stock	18.1896	18.2032	18.1896	18.1929	62860.0
2013-08-20 07:30:00	AAPL	Stock	18.2	18.2179	18.2	18.2107	32200.0
2013-08-20 07:35:00	AAPL	Stock	18.2096	18.2214	18.2	18.2214	62804.0
2013-08-20 07:40:00	AAPL	Stock	18.2318	18.25	18.225	18.2411	127400.0
2013-08-20 07:45:00	AAPL	Stock	18.2393	18.2529	18.2393	18.2443	104020.0
2013-08-20 07:50:00	AAPL	Stock	18.2414	18.2464	18.2411	18.2443	35560.0
2013-08-20 07:55:00	AAPL	Stock	18.2393	18.2393	18.2268	18.2268	17080.0
2013-08-20 08:00:00	AAPL	Stock	18.2357	18.2457	18.1429	18.2336	221704.0
2013-08-20 08:05:00	AAPL	Stock	18.2254	18.2321	18.2129	18.2179	351400.0
2013-08-20 08:10:00	AAPL	Stock	18.2239	18.2421	18.2218	18.2393	202076.0
2013-08-20 08:15:00	AAPL	Stock	18.2393	18.2393	18.2143	18.225	232176.0
2013-08-20 08:20:00	AAPL	Stock	18.225	18.2357	18.2214	18.2214	313852.0
2013-08-20 08:25:00	AAPL	Stock	18.2214	18.2286	18.2175	18.2221	105560.0
2013-08-20 08:30:00	AAPL	Stock	18.2232	18.2321	18.2214	18.2275	97048.0
2013-08-20 08:35:00	AAPL	Stock	18.225	18.2286	18.2054	18.2054	282884.0
2013-08-20 08:40:00	AAPL	Stock	18.2043	18.2232	18.1964	18.22	305620.0
2013-08-20 08:45:00	AAPL	Stock	18.2182	18.2261	18.2175	18.2175	179256.0
2013-08-20 08:50:00	AAPL	Stock	18.2168	18.2168	18.2125	18.2125	27132.0
2013-08-20 08:55:00	AAPL	Stock	18.2143	18.2143	18.2107	18.2118	239680.0
2013-08-20 09:00:00	AAPL	Stock	18.2143	18.2143	18.2125	18.2143	235760.0
2013-08-20 09:05:00	AAPL	Stock	18.2143	18.2239	18.2125	18.2143	594608.0
2013-08-20 09:10:00	AAPL	Stock	18.2139	18.2143	18.2086	18.2143	526400.0

> showing 50 of 343,815 rows — these rows as CSV

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