PREVIEW / stock_5min / 2009-09-10

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-09-10.parquet
  size:    4.7 MB
  rows:    322,317
  symbols: 3,381

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
2009-09-10 05:45:00	AAPL	Stock	6.1429	6.1429	6.1429	6.1429	11200.0
2009-09-10 05:50:00	AAPL	Stock	6.1432	6.1432	6.1429	6.1429	56000.0
2009-09-10 06:35:00	AAPL	Stock	6.1329	6.1329	6.1329	6.1329	14000.0
2009-09-10 06:55:00	AAPL	Stock	6.1429	6.1429	6.1429	6.1429	28000.0
2009-09-10 07:00:00	AAPL	Stock	6.1339	6.1429	6.1339	6.1429	28000.0
2009-09-10 07:05:00	AAPL	Stock	6.1429	6.1429	6.1429	6.1429	8400.0
2009-09-10 07:10:00	AAPL	Stock	6.1329	6.1425	6.1329	6.1425	22400.0
2009-09-10 07:15:00	AAPL	Stock	6.1254	6.1254	6.1254	6.1254	28000.0
2009-09-10 07:20:00	AAPL	Stock	6.125	6.125	6.125	6.125	5600.0
2009-09-10 07:25:00	AAPL	Stock	6.0986	6.0986	6.0986	6.0986	5600.0
2009-09-10 07:30:00	AAPL	Stock	6.1246	6.125	6.1246	6.1246	18060.0
2009-09-10 07:35:00	AAPL	Stock	6.1204	6.125	6.1196	6.125	14000.0
2009-09-10 07:45:00	AAPL	Stock	6.1354	6.145	6.1339	6.1429	302652.0
2009-09-10 07:50:00	AAPL	Stock	6.1436	6.1436	6.1436	6.1436	2800.0
2009-09-10 08:00:00	AAPL	Stock	6.1393	6.1454	6.1339	6.1443	367752.0
2009-09-10 08:05:00	AAPL	Stock	6.1421	6.1421	6.1339	6.1339	105000.0
2009-09-10 08:10:00	AAPL	Stock	6.1339	6.1339	6.1286	6.1304	184800.0
2009-09-10 08:15:00	AAPL	Stock	6.1339	6.1339	6.1339	6.1339	26600.0
2009-09-10 08:20:00	AAPL	Stock	6.1336	6.1343	6.1286	6.1329	57484.0
2009-09-10 08:25:00	AAPL	Stock	6.1304	6.1336	6.1286	6.1325	96180.0
2009-09-10 08:30:00	AAPL	Stock	6.1354	6.1404	6.1339	6.1404	133700.0
2009-09-10 08:35:00	AAPL	Stock	6.1404	6.1429	6.1396	6.1396	143360.0
2009-09-10 08:40:00	AAPL	Stock	6.1429	6.1429	6.1389	6.1404	43008.0
2009-09-10 08:45:00	AAPL	Stock	6.1404	6.1446	6.1404	6.1443	152824.0
2009-09-10 08:50:00	AAPL	Stock	6.1429	6.1482	6.1429	6.1436	335104.0
2009-09-10 08:55:00	AAPL	Stock	6.145	6.1475	6.1411	6.1411	282772.0
2009-09-10 09:00:00	AAPL	Stock	6.1439	6.1482	6.1429	6.1482	210000.0
2009-09-10 09:05:00	AAPL	Stock	6.1482	6.1514	6.1446	6.1482	848652.0
2009-09-10 09:10:00	AAPL	Stock	6.15	6.1507	6.1482	6.15	554960.0
2009-09-10 09:15:00	AAPL	Stock	6.1493	6.1493	6.1482	6.1482	398300.0
2009-09-10 09:20:00	AAPL	Stock	6.145	6.1482	6.145	6.1464	93800.0
2009-09-10 09:25:00	AAPL	Stock	6.1464	6.1507	6.1375	6.1429	1051820.0
2009-09-10 09:30:00	AAPL	Stock	6.1446	6.1682	6.1221	6.1621	28096012.0
2009-09-10 09:35:00	AAPL	Stock	6.1625	6.1782	6.1539	6.1604	21882224.0
2009-09-10 09:40:00	AAPL	Stock	6.1593	6.1779	6.1429	6.15	13373584.0
2009-09-10 09:45:00	AAPL	Stock	6.1496	6.1654	6.1439	6.1654	12744676.0
2009-09-10 09:50:00	AAPL	Stock	6.1657	6.1771	6.1586	6.1768	11356380.0
2009-09-10 09:55:00	AAPL	Stock	6.1761	6.1875	6.1668	6.1686	13690208.0
2009-09-10 10:00:00	AAPL	Stock	6.1693	6.1786	6.1651	6.1686	9133124.0
2009-09-10 10:05:00	AAPL	Stock	6.1682	6.17	6.1554	6.1621	8379532.0
2009-09-10 10:10:00	AAPL	Stock	6.1621	6.1689	6.1386	6.1389	10505628.0
2009-09-10 10:15:00	AAPL	Stock	6.1396	6.1446	6.1339	6.1357	9232160.0
2009-09-10 10:20:00	AAPL	Stock	6.1346	6.1357	6.1018	6.1104	17617852.0
2009-09-10 10:25:00	AAPL	Stock	6.1114	6.1214	6.1064	6.1186	8171940.0
2009-09-10 10:30:00	AAPL	Stock	6.1185	6.1243	6.1086	6.115	6437592.0
2009-09-10 10:35:00	AAPL	Stock	6.1161	6.1421	6.1161	6.1371	10165652.0
2009-09-10 10:40:00	AAPL	Stock	6.1368	6.1382	6.1286	6.1336	4287080.0
2009-09-10 10:45:00	AAPL	Stock	6.1343	6.1375	6.1261	6.1374	6466992.0
2009-09-10 10:50:00	AAPL	Stock	6.1368	6.1507	6.1343	6.1471	6976928.0
2009-09-10 10:55:00	AAPL	Stock	6.1471	6.1561	6.1436	6.1439	5322996.0

> showing 50 of 322,317 rows — these rows as CSV

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