PREVIEW / stock_5min / 2009-04-08

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-08.parquet
  size:    4.2 MB
  rows:    295,739
  symbols: 3,299

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-04-08 04:15:00	AAPL	Stock	4.0954	4.0954	4.0954	4.0954	2800.0
2009-04-08 04:25:00	AAPL	Stock	4.0579	4.0579	4.0579	4.0579	13160.0
2009-04-08 05:40:00	AAPL	Stock	4.0643	4.0704	4.0643	4.0704	14000.0
2009-04-08 06:35:00	AAPL	Stock	4.0786	4.0786	4.0786	4.0786	14000.0
2009-04-08 07:05:00	AAPL	Stock	4.0954	4.0964	4.0954	4.0964	19600.0
2009-04-08 07:10:00	AAPL	Stock	4.1036	4.1036	4.1036	4.1036	14000.0
2009-04-08 07:25:00	AAPL	Stock	4.1032	4.1071	4.0982	4.0982	78400.0
2009-04-08 08:00:00	AAPL	Stock	4.0982	4.1	4.0982	4.1	28756.0
2009-04-08 08:05:00	AAPL	Stock	4.1036	4.1107	4.1036	4.1107	29820.0
2009-04-08 08:10:00	AAPL	Stock	4.12	4.1279	4.12	4.1211	192360.0
2009-04-08 08:15:00	AAPL	Stock	4.1207	4.1246	4.1207	4.1232	16800.0
2009-04-08 08:20:00	AAPL	Stock	4.1268	4.135	4.1257	4.135	38752.0
2009-04-08 08:25:00	AAPL	Stock	4.1286	4.1321	4.1286	4.1321	193760.0
2009-04-08 08:30:00	AAPL	Stock	4.1321	4.1321	4.1321	4.1321	77868.0
2009-04-08 08:35:00	AAPL	Stock	4.1271	4.1286	4.125	4.1286	96880.0
2009-04-08 08:40:00	AAPL	Stock	4.1318	4.1321	4.1318	4.1321	11200.0
2009-04-08 08:45:00	AAPL	Stock	4.1304	4.1321	4.1293	4.1321	21224.0
2009-04-08 08:50:00	AAPL	Stock	4.1304	4.1343	4.1293	4.1321	194656.0
2009-04-08 08:55:00	AAPL	Stock	4.1321	4.1321	4.1321	4.1321	97860.0
2009-04-08 09:00:00	AAPL	Stock	4.1325	4.1325	4.1318	4.1318	129080.0
2009-04-08 09:05:00	AAPL	Stock	4.1318	4.1321	4.1314	4.1321	84000.0
2009-04-08 09:10:00	AAPL	Stock	4.1318	4.1343	4.1279	4.1279	608384.0
2009-04-08 09:15:00	AAPL	Stock	4.1279	4.1289	4.1232	4.1286	73920.0
2009-04-08 09:20:00	AAPL	Stock	4.1314	4.1339	4.1311	4.1336	161364.0
2009-04-08 09:25:00	AAPL	Stock	4.1346	4.1375	4.1171	4.1171	228872.0
2009-04-08 09:30:00	AAPL	Stock	4.1225	4.1661	4.1164	4.1631	19728436.0
2009-04-08 09:35:00	AAPL	Stock	4.1625	4.165	4.1554	4.1571	12368776.0
2009-04-08 09:40:00	AAPL	Stock	4.1579	4.1696	4.1529	4.1639	10444000.0
2009-04-08 09:45:00	AAPL	Stock	4.1639	4.1711	4.1571	4.1589	6455316.0
2009-04-08 09:50:00	AAPL	Stock	4.1589	4.1607	4.1521	4.156	4984476.0
2009-04-08 09:55:00	AAPL	Stock	4.155	4.1671	4.155	4.1575	4521244.0
2009-04-08 10:00:00	AAPL	Stock	4.1575	4.1596	4.1332	4.1343	10738700.0
2009-04-08 10:05:00	AAPL	Stock	4.1343	4.1379	4.1268	4.1339	5154688.0
2009-04-08 10:10:00	AAPL	Stock	4.1333	4.1379	4.125	4.1339	6738816.0
2009-04-08 10:15:00	AAPL	Stock	4.1341	4.1375	4.1071	4.11	10672592.0
2009-04-08 10:20:00	AAPL	Stock	4.11	4.1107	4.0921	4.1029	11258772.0
2009-04-08 10:25:00	AAPL	Stock	4.1032	4.1078	4.0929	4.1054	7432152.0
2009-04-08 10:30:00	AAPL	Stock	4.1061	4.1179	4.1039	4.1096	5733028.0
2009-04-08 10:35:00	AAPL	Stock	4.1096	4.1143	4.0943	4.1036	6046068.0
2009-04-08 10:40:00	AAPL	Stock	4.1043	4.1111	4.1011	4.1102	5314092.0
2009-04-08 10:45:00	AAPL	Stock	4.1107	4.1139	4.1054	4.1057	4903752.0
2009-04-08 10:50:00	AAPL	Stock	4.1057	4.1107	4.0943	4.1057	7079380.0
2009-04-08 10:55:00	AAPL	Stock	4.1057	4.1132	4.1052	4.1129	4940488.0
2009-04-08 11:00:00	AAPL	Stock	4.1121	4.1193	4.1071	4.1086	7103404.0
2009-04-08 11:05:00	AAPL	Stock	4.1086	4.1129	4.1046	4.1064	4010636.0
2009-04-08 11:10:00	AAPL	Stock	4.1064	4.1082	4.1011	4.1071	3434368.0
2009-04-08 11:15:00	AAPL	Stock	4.1071	4.1179	4.1071	4.1082	5468064.0
2009-04-08 11:20:00	AAPL	Stock	4.1086	4.1236	4.1082	4.1207	4459140.0
2009-04-08 11:25:00	AAPL	Stock	4.1214	4.1304	4.1191	4.1196	8026284.0
2009-04-08 11:30:00	AAPL	Stock	4.1196	4.1225	4.1121	4.1179	4552212.0

> showing 50 of 295,739 rows — these rows as CSV

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