PREVIEW / stock_5min / 2011-05-18

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-05-18.parquet
  size:    4.9 MB
  rows:    334,067
  symbols: 3,559

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
2011-05-18 04:00:00	AAPL	Stock	12.0714	12.0714	12.0714	12.0714	2800.0
2011-05-18 07:00:00	AAPL	Stock	12.0404	12.0404	12.0357	12.0357	6104.0
2011-05-18 07:05:00	AAPL	Stock	12.0379	12.0379	12.0225	12.0229	35980.0
2011-05-18 07:10:00	AAPL	Stock	12.025	12.0268	12.025	12.0268	25200.0
2011-05-18 07:15:00	AAPL	Stock	12.0268	12.0268	12.0143	12.0196	30800.0
2011-05-18 07:20:00	AAPL	Stock	12.0132	12.0132	12.0046	12.005	36400.0
2011-05-18 07:30:00	AAPL	Stock	12.0146	12.0146	12.0146	12.0146	22400.0
2011-05-18 07:35:00	AAPL	Stock	12.0179	12.0179	12.0089	12.0089	33600.0
2011-05-18 07:40:00	AAPL	Stock	12.0179	12.0179	12.0175	12.0175	5600.0
2011-05-18 07:45:00	AAPL	Stock	12.0161	12.0161	11.9964	11.9964	39200.0
2011-05-18 07:50:00	AAPL	Stock	12.0	12.0	12.0	12.0	28000.0
2011-05-18 07:55:00	AAPL	Stock	11.9893	11.9918	11.9893	11.9911	15400.0
2011-05-18 08:00:00	AAPL	Stock	12.0	12.0071	11.9982	12.0	274260.0
2011-05-18 08:05:00	AAPL	Stock	12.0	12.0	11.98	11.9821	77000.0
2011-05-18 08:10:00	AAPL	Stock	11.9796	11.9857	11.9796	11.9857	11200.0
2011-05-18 08:15:00	AAPL	Stock	11.9857	11.9857	11.9714	11.9771	103740.0
2011-05-18 08:20:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	2800.0
2011-05-18 08:25:00	AAPL	Stock	11.9768	11.9857	11.9768	11.9857	56532.0
2011-05-18 08:30:00	AAPL	Stock	11.9857	11.9946	11.9857	11.9946	22204.0
2011-05-18 08:35:00	AAPL	Stock	11.9825	11.9857	11.9825	11.9825	36988.0
2011-05-18 08:40:00	AAPL	Stock	11.9832	11.9832	11.9779	11.9779	49420.0
2011-05-18 08:45:00	AAPL	Stock	11.9779	11.9818	11.9775	11.9818	74172.0
2011-05-18 08:50:00	AAPL	Stock	11.9811	11.9857	11.9775	11.9775	49112.0
2011-05-18 08:55:00	AAPL	Stock	11.9786	11.9986	11.9786	11.9979	113876.0
2011-05-18 09:00:00	AAPL	Stock	11.9968	12.0071	11.9968	12.0046	356048.0
2011-05-18 09:05:00	AAPL	Stock	12.0046	12.0046	11.9968	11.9996	124852.0
2011-05-18 09:10:00	AAPL	Stock	12.0	12.0029	11.9946	12.0029	439320.0
2011-05-18 09:15:00	AAPL	Stock	12.0046	12.0129	12.0046	12.0096	169456.0
2011-05-18 09:20:00	AAPL	Stock	12.0096	12.0164	12.0096	12.0161	169960.0
2011-05-18 09:25:00	AAPL	Stock	12.0161	12.0268	12.0125	12.0179	559692.0
2011-05-18 09:30:00	AAPL	Stock	12.0168	12.0496	12.0	12.0471	17117296.0
2011-05-18 09:35:00	AAPL	Stock	12.0486	12.0511	12.0082	12.0191	11590992.0
2011-05-18 09:40:00	AAPL	Stock	12.0191	12.0393	12.0143	12.0343	7251440.0
2011-05-18 09:45:00	AAPL	Stock	12.035	12.0586	12.0327	12.0579	8974924.0
2011-05-18 09:50:00	AAPL	Stock	12.0586	12.0704	12.0546	12.0666	7585256.0
2011-05-18 09:55:00	AAPL	Stock	12.0671	12.0857	12.0668	12.0743	10824520.0
2011-05-18 10:00:00	AAPL	Stock	12.0746	12.0836	12.0657	12.0804	5950308.0
2011-05-18 10:05:00	AAPL	Stock	12.0836	12.1204	12.0802	12.118	10351404.0
2011-05-18 10:10:00	AAPL	Stock	12.1182	12.1186	12.0964	12.1025	8206884.0
2011-05-18 10:15:00	AAPL	Stock	12.1021	12.1121	12.0946	12.1022	6417208.0
2011-05-18 10:20:00	AAPL	Stock	12.1025	12.1075	12.0929	12.0986	4332048.0
2011-05-18 10:25:00	AAPL	Stock	12.0987	12.11	12.095	12.1089	3419332.0
2011-05-18 10:30:00	AAPL	Stock	12.1082	12.1218	12.1078	12.1154	6215720.0
2011-05-18 10:35:00	AAPL	Stock	12.1157	12.13	12.1146	12.1285	7542024.0
2011-05-18 10:40:00	AAPL	Stock	12.1282	12.135	12.1232	12.1286	6519940.0
2011-05-18 10:45:00	AAPL	Stock	12.1296	12.1411	12.1296	12.1321	6055588.0
2011-05-18 10:50:00	AAPL	Stock	12.1329	12.1368	12.1257	12.1257	4599952.0
2011-05-18 10:55:00	AAPL	Stock	12.1257	12.1371	12.1246	12.1336	4266584.0
2011-05-18 11:00:00	AAPL	Stock	12.1339	12.1407	12.133	12.1396	4364220.0
2011-05-18 11:05:00	AAPL	Stock	12.14	12.1486	12.1339	12.1437	9801456.0

> showing 50 of 334,067 rows — these rows as CSV

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