PREVIEW / stock_5min / 2010-11-23

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-11-23.parquet
  size:    4.7 MB
  rows:    326,627
  symbols: 3,498

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
2010-11-23 04:00:00	AAPL	Stock	11.1071	11.1071	11.1071	11.1071	2800.0
2010-11-23 04:05:00	AAPL	Stock	11.1011	11.1071	11.1011	11.1071	14000.0
2010-11-23 04:20:00	AAPL	Stock	11.1161	11.1161	11.1071	11.1071	5600.0
2010-11-23 04:30:00	AAPL	Stock	11.1171	11.1171	11.1171	11.1171	2800.0
2010-11-23 04:40:00	AAPL	Stock	11.1143	11.1143	11.1143	11.1143	5600.0
2010-11-23 04:50:00	AAPL	Stock	11.1307	11.1307	11.1307	11.1307	14000.0
2010-11-23 05:00:00	AAPL	Stock	11.1071	11.1071	11.1071	11.1071	28000.0
2010-11-23 05:15:00	AAPL	Stock	11.1071	11.1071	11.1071	11.1071	5600.0
2010-11-23 06:10:00	AAPL	Stock	11.125	11.1321	11.125	11.1321	8400.0
2010-11-23 06:40:00	AAPL	Stock	11.125	11.125	11.125	11.125	2800.0
2010-11-23 06:55:00	AAPL	Stock	11.1071	11.1071	11.0982	11.1071	22400.0
2010-11-23 07:00:00	AAPL	Stock	11.1071	11.1071	11.0893	11.0893	16800.0
2010-11-23 07:05:00	AAPL	Stock	11.0971	11.1071	11.0925	11.0929	56000.0
2010-11-23 07:10:00	AAPL	Stock	11.1071	11.1071	11.0921	11.1071	37688.0
2010-11-23 07:15:00	AAPL	Stock	11.1029	11.1039	11.1029	11.1039	5600.0
2010-11-23 07:20:00	AAPL	Stock	11.0925	11.0936	11.0925	11.0936	16520.0
2010-11-23 07:25:00	AAPL	Stock	11.0929	11.0929	11.0893	11.0893	31920.0
2010-11-23 07:30:00	AAPL	Stock	11.0857	11.0929	11.08	11.08	64400.0
2010-11-23 07:35:00	AAPL	Stock	11.0796	11.0939	11.0789	11.0821	67200.0
2010-11-23 07:45:00	AAPL	Stock	11.0857	11.0939	11.0857	11.0929	16548.0
2010-11-23 07:50:00	AAPL	Stock	11.0929	11.0929	11.0929	11.0929	2800.0
2010-11-23 07:55:00	AAPL	Stock	11.0982	11.0982	11.0893	11.0896	57820.0
2010-11-23 08:00:00	AAPL	Stock	11.0929	11.1071	11.0893	11.1071	424256.0
2010-11-23 08:05:00	AAPL	Stock	11.1054	11.1061	11.0911	11.0996	342356.0
2010-11-23 08:10:00	AAPL	Stock	11.0996	11.1232	11.0946	11.12	453964.0
2010-11-23 08:15:00	AAPL	Stock	11.1214	11.1293	11.1086	11.1214	334740.0
2010-11-23 08:20:00	AAPL	Stock	11.1214	11.1286	11.1129	11.1243	237496.0
2010-11-23 08:25:00	AAPL	Stock	11.1243	11.1429	11.1243	11.1368	587524.0
2010-11-23 08:30:00	AAPL	Stock	11.1368	11.1582	11.125	11.1429	687008.0
2010-11-23 08:35:00	AAPL	Stock	11.1429	11.1607	11.1311	11.1311	939652.0
2010-11-23 08:40:00	AAPL	Stock	11.1321	11.1436	11.1321	11.1382	182000.0
2010-11-23 08:45:00	AAPL	Stock	11.1389	11.1393	11.1229	11.1296	537320.0
2010-11-23 08:50:00	AAPL	Stock	11.1282	11.1304	11.1279	11.1304	82600.0
2010-11-23 08:55:00	AAPL	Stock	11.1318	11.1357	11.1286	11.1296	456932.0
2010-11-23 09:00:00	AAPL	Stock	11.1286	11.1286	11.1243	11.125	251860.0
2010-11-23 09:05:00	AAPL	Stock	11.125	11.1307	11.1243	11.1261	234164.0
2010-11-23 09:10:00	AAPL	Stock	11.1246	11.1246	11.1132	11.1132	300440.0
2010-11-23 09:15:00	AAPL	Stock	11.1143	11.1196	11.1071	11.1125	237860.0
2010-11-23 09:20:00	AAPL	Stock	11.1107	11.1139	11.0979	11.1032	619752.0
2010-11-23 09:25:00	AAPL	Stock	11.1057	11.1068	11.0875	11.0875	377636.0
2010-11-23 09:30:00	AAPL	Stock	11.0893	11.1339	11.0768	11.1036	18126416.0
2010-11-23 09:35:00	AAPL	Stock	11.1075	11.125	11.0818	11.0896	11066916.0
2010-11-23 09:40:00	AAPL	Stock	11.0875	11.1125	11.0714	11.105	12429396.0
2010-11-23 09:45:00	AAPL	Stock	11.105	11.1254	11.0946	11.1075	7894740.0
2010-11-23 09:50:00	AAPL	Stock	11.1075	11.1087	11.0368	11.0368	14669872.0
2010-11-23 09:55:00	AAPL	Stock	11.0371	11.06	11.0286	11.0382	12522776.0
2010-11-23 10:00:00	AAPL	Stock	11.0382	11.0593	11.0229	11.0321	14908992.0
2010-11-23 10:05:00	AAPL	Stock	11.0321	11.0439	11.0071	11.0385	11830840.0
2010-11-23 10:10:00	AAPL	Stock	11.0384	11.0439	11.0161	11.0432	8884988.0
2010-11-23 10:15:00	AAPL	Stock	11.0436	11.0643	11.035	11.0404	9624944.0

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

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