PREVIEW / stock_5min / 2007-01-25

all stock 5-min files

  file:    by_date/stock_5min/2007/2007-01-25.parquet
  size:    3.4 MB
  rows:    245,415
  symbols: 2,499

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
2007-01-25 05:45:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	11200.0
2007-01-25 06:05:00	AAPL	Stock	3.1004	3.1004	3.1004	3.1004	2800.0
2007-01-25 06:10:00	AAPL	Stock	3.1025	3.1025	3.1025	3.1025	16800.0
2007-01-25 06:20:00	AAPL	Stock	3.1	3.1	3.1	3.1	14000.0
2007-01-25 06:40:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	28000.0
2007-01-25 07:05:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	16800.0
2007-01-25 07:15:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	11200.0
2007-01-25 07:20:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	28840.0
2007-01-25 07:25:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	36400.0
2007-01-25 07:35:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	64400.0
2007-01-25 07:40:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	8400.0
2007-01-25 07:45:00	AAPL	Stock	3.1107	3.1111	3.1107	3.1111	29064.0
2007-01-25 07:55:00	AAPL	Stock	3.1107	3.1107	3.1107	3.1107	14000.0
2007-01-25 08:00:00	AAPL	Stock	3.1011	3.1071	3.0982	3.1071	82600.0
2007-01-25 08:05:00	AAPL	Stock	3.1068	3.1071	3.1007	3.1029	234920.0
2007-01-25 08:10:00	AAPL	Stock	3.1029	3.1036	3.1011	3.1036	200564.0
2007-01-25 08:15:00	AAPL	Stock	3.1054	3.1054	3.1021	3.1021	68684.0
2007-01-25 08:20:00	AAPL	Stock	3.1036	3.1036	3.1014	3.1025	95200.0
2007-01-25 08:25:00	AAPL	Stock	3.1014	3.1014	3.0964	3.0964	292768.0
2007-01-25 08:30:00	AAPL	Stock	3.0968	3.1	3.0961	3.0964	354060.0
2007-01-25 08:35:00	AAPL	Stock	3.0996	3.0996	3.0964	3.0996	78400.0
2007-01-25 08:40:00	AAPL	Stock	3.0993	3.1043	3.0993	3.0996	42224.0
2007-01-25 08:45:00	AAPL	Stock	3.1036	3.1036	3.0993	3.1018	46452.0
2007-01-25 08:50:00	AAPL	Stock	3.1018	3.1018	3.0982	3.1	129024.0
2007-01-25 08:55:00	AAPL	Stock	3.1014	3.1018	3.1014	3.1018	24360.0
2007-01-25 09:00:00	AAPL	Stock	3.1014	3.1043	3.1004	3.1036	211176.0
2007-01-25 09:05:00	AAPL	Stock	3.1029	3.1036	3.1011	3.1029	79744.0
2007-01-25 09:10:00	AAPL	Stock	3.1018	3.1029	3.1018	3.1025	73416.0
2007-01-25 09:15:00	AAPL	Stock	3.1036	3.1036	3.1032	3.1032	57540.0
2007-01-25 09:20:00	AAPL	Stock	3.1025	3.1036	3.1025	3.1036	58800.0
2007-01-25 09:25:00	AAPL	Stock	3.1036	3.1125	3.1025	3.1125	1551480.0
2007-01-25 09:30:00	AAPL	Stock	3.1111	3.12	3.1036	3.1096	28427560.0
2007-01-25 09:35:00	AAPL	Stock	3.1096	3.1268	3.1086	3.12	27549620.0
2007-01-25 09:40:00	AAPL	Stock	3.1196	3.1393	3.1193	3.1325	27754188.0
2007-01-25 09:45:00	AAPL	Stock	3.1329	3.1486	3.125	3.1479	33526948.0
2007-01-25 09:50:00	AAPL	Stock	3.1482	3.1607	3.1464	3.1486	40890304.0
2007-01-25 09:55:00	AAPL	Stock	3.1486	3.1496	3.1436	3.1464	25533144.0
2007-01-25 10:00:00	AAPL	Stock	3.1464	3.1536	3.1343	3.1396	30604924.0
2007-01-25 10:05:00	AAPL	Stock	3.1396	3.1461	3.13	3.1361	21316204.0
2007-01-25 10:10:00	AAPL	Stock	3.1357	3.1393	3.1268	3.1364	17744664.0
2007-01-25 10:15:00	AAPL	Stock	3.1357	3.1418	3.1243	3.1279	19814480.0
2007-01-25 10:20:00	AAPL	Stock	3.1286	3.1318	3.1196	3.125	18224864.0
2007-01-25 10:25:00	AAPL	Stock	3.1254	3.13	3.1186	3.1254	16778776.0
2007-01-25 10:30:00	AAPL	Stock	3.1256	3.1346	3.125	3.13	13166076.0
2007-01-25 10:35:00	AAPL	Stock	3.1293	3.1343	3.1236	3.1261	12479124.0
2007-01-25 10:40:00	AAPL	Stock	3.1264	3.1268	3.1139	3.1243	16219224.0
2007-01-25 10:45:00	AAPL	Stock	3.1243	3.1314	3.12	3.1297	9271108.0
2007-01-25 10:50:00	AAPL	Stock	3.1296	3.1375	3.1246	3.1367	10765440.0
2007-01-25 10:55:00	AAPL	Stock	3.1364	3.1371	3.1229	3.125	12454820.0
2007-01-25 11:00:00	AAPL	Stock	3.1254	3.1296	3.1239	3.1268	6861428.0

> showing 50 of 245,415 rows — these rows as CSV

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