PREVIEW / stock_5min / 2012-04-24

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-04-24.parquet
  size:    4.8 MB
  rows:    326,158
  symbols: 3,553

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-04-24 04:00:00	AAPL	Stock	20.4896	20.5357	20.4896	20.5179	19600.0
2012-04-24 04:05:00	AAPL	Stock	20.5304	20.5304	20.5304	20.5304	5600.0
2012-04-24 04:10:00	AAPL	Stock	20.5357	20.5357	20.5357	20.5357	2800.0
2012-04-24 04:15:00	AAPL	Stock	20.5357	20.5357	20.5357	20.5357	5600.0
2012-04-24 04:20:00	AAPL	Stock	20.5625	20.5714	20.5625	20.5714	8400.0
2012-04-24 04:25:00	AAPL	Stock	20.5743	20.5743	20.5714	20.5714	5600.0
2012-04-24 04:30:00	AAPL	Stock	20.5786	20.5786	20.5786	20.5786	2800.0
2012-04-24 04:40:00	AAPL	Stock	20.6014	20.6607	20.6014	20.6607	16800.0
2012-04-24 05:05:00	AAPL	Stock	20.6293	20.6732	20.6293	20.6732	21084.0
2012-04-24 05:10:00	AAPL	Stock	20.6754	20.6754	20.6754	20.6754	2800.0
2012-04-24 05:15:00	AAPL	Stock	20.6786	20.6786	20.6786	20.6786	5600.0
2012-04-24 05:20:00	AAPL	Stock	20.6857	20.6857	20.6857	20.6857	2800.0
2012-04-24 05:30:00	AAPL	Stock	20.7	20.7071	20.7	20.7071	12012.0
2012-04-24 05:35:00	AAPL	Stock	20.7143	20.7143	20.7143	20.7143	2800.0
2012-04-24 05:45:00	AAPL	Stock	20.7075	20.7075	20.7	20.7	22148.0
2012-04-24 05:50:00	AAPL	Stock	20.7	20.7	20.6964	20.7	33600.0
2012-04-24 05:55:00	AAPL	Stock	20.6821	20.6821	20.6821	20.6821	8400.0
2012-04-24 06:00:00	AAPL	Stock	20.7139	20.7139	20.7129	20.7129	10052.0
2012-04-24 06:05:00	AAPL	Stock	20.6789	20.6789	20.6786	20.6786	14000.0
2012-04-24 06:15:00	AAPL	Stock	20.65	20.65	20.65	20.65	5600.0
2012-04-24 06:20:00	AAPL	Stock	20.6464	20.6464	20.6464	20.6464	2800.0
2012-04-24 06:30:00	AAPL	Stock	20.6486	20.6486	20.6486	20.6486	2800.0
2012-04-24 06:35:00	AAPL	Stock	20.6536	20.6536	20.6429	20.6429	22400.0
2012-04-24 06:40:00	AAPL	Stock	20.6257	20.6257	20.6254	20.6254	5600.0
2012-04-24 06:45:00	AAPL	Stock	20.6293	20.6429	20.6293	20.6429	25200.0
2012-04-24 06:50:00	AAPL	Stock	20.6386	20.6386	20.6386	20.6386	11200.0
2012-04-24 06:55:00	AAPL	Stock	20.6168	20.6429	20.6071	20.6429	56000.0
2012-04-24 07:00:00	AAPL	Stock	20.625	20.6429	20.625	20.6321	112196.0
2012-04-24 07:05:00	AAPL	Stock	20.6357	20.6357	20.6071	20.6236	165088.0
2012-04-24 07:10:00	AAPL	Stock	20.625	20.6261	20.6071	20.6079	127400.0
2012-04-24 07:15:00	AAPL	Stock	20.6111	20.6111	20.5721	20.5775	163492.0
2012-04-24 07:20:00	AAPL	Stock	20.585	20.5961	20.5536	20.5929	116032.0
2012-04-24 07:25:00	AAPL	Stock	20.5825	20.5825	20.2996	20.3393	1060220.0
2012-04-24 07:30:00	AAPL	Stock	20.3564	20.4507	20.3393	20.3532	966616.0
2012-04-24 07:35:00	AAPL	Stock	20.3532	20.4107	20.3532	20.3636	260848.0
2012-04-24 07:40:00	AAPL	Stock	20.3682	20.3682	20.2036	20.2839	806204.0
2012-04-24 07:45:00	AAPL	Stock	20.2857	20.2921	20.1964	20.2857	671916.0
2012-04-24 07:50:00	AAPL	Stock	20.2929	20.3032	20.1786	20.1786	542192.0
2012-04-24 07:55:00	AAPL	Stock	20.1946	20.2568	20.1189	20.1443	951468.0
2012-04-24 08:00:00	AAPL	Stock	20.15	20.25	20.15	20.2186	1732584.0
2012-04-24 08:05:00	AAPL	Stock	20.2314	20.3214	20.2143	20.2575	964544.0
2012-04-24 08:10:00	AAPL	Stock	20.2539	20.2575	20.1646	20.1796	1078700.0
2012-04-24 08:15:00	AAPL	Stock	20.1868	20.2	20.1204	20.1754	934864.0
2012-04-24 08:20:00	AAPL	Stock	20.1754	20.1964	20.1482	20.1643	701624.0
2012-04-24 08:25:00	AAPL	Stock	20.1607	20.1782	20.1321	20.1425	943796.0
2012-04-24 08:30:00	AAPL	Stock	20.1307	20.1386	20.0714	20.1114	1042244.0
2012-04-24 08:35:00	AAPL	Stock	20.1411	20.1429	20.0357	20.0839	1539832.0
2012-04-24 08:40:00	AAPL	Stock	20.0811	20.1043	20.0504	20.0518	760004.0
2012-04-24 08:45:00	AAPL	Stock	20.0618	20.1357	20.0518	20.125	824180.0
2012-04-24 08:50:00	AAPL	Stock	20.1254	20.1254	20.0564	20.0571	928424.0

> showing 50 of 326,158 rows — these rows as CSV

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