PREVIEW / stock_5min / 2012-09-05

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-09-05.parquet
  size:    4.8 MB
  rows:    325,013
  symbols: 3,470

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-09-05 04:00:00	AAPL	Stock	24.1061	24.1061	24.0671	24.0857	24612.0
2012-09-05 04:05:00	AAPL	Stock	24.075	24.075	24.075	24.075	16800.0
2012-09-05 04:15:00	AAPL	Stock	24.0571	24.0571	24.0571	24.0571	25200.0
2012-09-05 04:20:00	AAPL	Stock	24.0539	24.0539	24.0536	24.0536	8400.0
2012-09-05 04:25:00	AAPL	Stock	24.0421	24.0496	24.0421	24.0496	8400.0
2012-09-05 04:35:00	AAPL	Stock	24.0411	24.0414	24.0411	24.0411	25200.0
2012-09-05 04:40:00	AAPL	Stock	24.0379	24.0379	24.0368	24.0368	8400.0
2012-09-05 05:05:00	AAPL	Stock	24.05	24.0532	24.0496	24.0532	26600.0
2012-09-05 05:10:00	AAPL	Stock	24.0607	24.0607	24.0607	24.0607	21336.0
2012-09-05 05:20:00	AAPL	Stock	24.0464	24.0589	24.0464	24.0589	11900.0
2012-09-05 05:25:00	AAPL	Stock	24.0607	24.0607	24.0607	24.0607	6664.0
2012-09-05 05:35:00	AAPL	Stock	24.0714	24.0804	24.0714	24.0804	39200.0
2012-09-05 05:45:00	AAPL	Stock	24.0893	24.0893	24.0893	24.0893	2800.0
2012-09-05 05:55:00	AAPL	Stock	24.1029	24.1029	24.1029	24.1029	2800.0
2012-09-05 06:10:00	AAPL	Stock	24.0982	24.0982	24.0982	24.0982	3500.0
2012-09-05 06:20:00	AAPL	Stock	24.1375	24.1425	24.1375	24.1425	8400.0
2012-09-05 06:30:00	AAPL	Stock	24.1496	24.1496	24.1429	24.1429	5600.0
2012-09-05 06:55:00	AAPL	Stock	24.1429	24.1429	24.1429	24.1429	10108.0
2012-09-05 07:00:00	AAPL	Stock	24.1339	24.1554	24.1339	24.1429	35140.0
2012-09-05 07:05:00	AAPL	Stock	24.1429	24.15	24.1404	24.15	30632.0
2012-09-05 07:10:00	AAPL	Stock	24.1339	24.1339	24.1071	24.1071	32760.0
2012-09-05 07:15:00	AAPL	Stock	24.1111	24.1232	24.1071	24.1232	77084.0
2012-09-05 07:20:00	AAPL	Stock	24.1232	24.1321	24.1143	24.1143	25200.0
2012-09-05 07:25:00	AAPL	Stock	24.1282	24.1386	24.1275	24.1386	39200.0
2012-09-05 07:30:00	AAPL	Stock	24.1161	24.14	24.1161	24.1393	28000.0
2012-09-05 07:35:00	AAPL	Stock	24.1421	24.1425	24.125	24.125	61040.0
2012-09-05 07:40:00	AAPL	Stock	24.125	24.1421	24.125	24.1421	8400.0
2012-09-05 07:45:00	AAPL	Stock	24.1307	24.1407	24.1243	24.1407	79296.0
2012-09-05 07:50:00	AAPL	Stock	24.1268	24.1382	24.125	24.125	151396.0
2012-09-05 07:55:00	AAPL	Stock	24.125	24.1254	24.125	24.125	40908.0
2012-09-05 08:00:00	AAPL	Stock	24.1243	24.1579	24.0532	24.155	541324.0
2012-09-05 08:05:00	AAPL	Stock	24.1582	24.1657	24.1307	24.1393	447552.0
2012-09-05 08:10:00	AAPL	Stock	24.1386	24.1386	24.1132	24.125	320432.0
2012-09-05 08:15:00	AAPL	Stock	24.1232	24.125	24.0821	24.0879	297416.0
2012-09-05 08:20:00	AAPL	Stock	24.0893	24.095	24.0846	24.0946	98000.0
2012-09-05 08:25:00	AAPL	Stock	24.0896	24.09	24.0357	24.0786	189924.0
2012-09-05 08:30:00	AAPL	Stock	24.0779	24.1039	24.0771	24.0964	350168.0
2012-09-05 08:35:00	AAPL	Stock	24.1014	24.1196	24.0996	24.1071	129696.0
2012-09-05 08:40:00	AAPL	Stock	24.1039	24.1182	24.0964	24.0989	154924.0
2012-09-05 08:45:00	AAPL	Stock	24.0993	24.1096	24.0946	24.1036	280700.0
2012-09-05 08:50:00	AAPL	Stock	24.1043	24.1204	24.1014	24.1154	184940.0
2012-09-05 08:55:00	AAPL	Stock	24.1139	24.1207	24.1071	24.1075	243460.0
2012-09-05 09:00:00	AAPL	Stock	24.1079	24.1214	24.1046	24.1046	199472.0
2012-09-05 09:05:00	AAPL	Stock	24.1061	24.1125	24.1054	24.1125	67760.0
2012-09-05 09:10:00	AAPL	Stock	24.11	24.1139	24.0964	24.1	245336.0
2012-09-05 09:15:00	AAPL	Stock	24.0964	24.1071	24.0964	24.1071	25536.0
2012-09-05 09:20:00	AAPL	Stock	24.1107	24.1129	24.0982	24.1036	65492.0
2012-09-05 09:25:00	AAPL	Stock	24.0986	24.1257	24.0986	24.1257	214760.0
2012-09-05 09:30:00	AAPL	Stock	24.1314	24.1554	24.0446	24.0643	23144464.0
2012-09-05 09:35:00	AAPL	Stock	24.0654	24.0871	24.0	24.0357	12681312.0

> showing 50 of 325,013 rows — these rows as CSV

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