PREVIEW / stock_1min / 2009-04-03

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-04-03.parquet
  size:    12.3 MB
  rows:    940,471
  symbols: 2,703

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-03 06:35:00	AAPL	Stock	4.1032	4.1032	4.1032	4.1032	17752.0
2009-04-03 06:39:00	AAPL	Stock	4.1243	4.1243	4.1243	4.1243	14000.0
2009-04-03 06:43:00	AAPL	Stock	4.1246	4.1246	4.1246	4.1246	2800.0
2009-04-03 07:01:00	AAPL	Stock	4.1079	4.1079	4.1079	4.1079	2800.0
2009-04-03 07:02:00	AAPL	Stock	4.1232	4.1246	4.1232	4.1246	16520.0
2009-04-03 07:05:00	AAPL	Stock	4.1161	4.1196	4.1161	4.1196	44800.0
2009-04-03 07:06:00	AAPL	Stock	4.1196	4.1196	4.1196	4.1196	10920.0
2009-04-03 07:12:00	AAPL	Stock	4.1157	4.1157	4.1157	4.1157	2800.0
2009-04-03 07:18:00	AAPL	Stock	4.1243	4.1243	4.1243	4.1243	8400.0
2009-04-03 07:22:00	AAPL	Stock	4.1161	4.1161	4.1161	4.1161	15428.0
2009-04-03 07:23:00	AAPL	Stock	4.1171	4.1171	4.1171	4.1171	8764.0
2009-04-03 07:26:00	AAPL	Stock	4.1157	4.1157	4.1157	4.1157	5600.0
2009-04-03 07:27:00	AAPL	Stock	4.1157	4.1179	4.1157	4.1179	14000.0
2009-04-03 07:28:00	AAPL	Stock	4.1179	4.1179	4.1179	4.1179	14000.0
2009-04-03 07:29:00	AAPL	Stock	4.1268	4.1268	4.1268	4.1268	14000.0
2009-04-03 07:37:00	AAPL	Stock	4.125	4.125	4.125	4.125	7000.0
2009-04-03 07:39:00	AAPL	Stock	4.1382	4.1382	4.1382	4.1382	2800.0
2009-04-03 07:41:00	AAPL	Stock	4.125	4.125	4.125	4.125	40572.0
2009-04-03 07:49:00	AAPL	Stock	4.125	4.125	4.125	4.125	56000.0
2009-04-03 07:52:00	AAPL	Stock	4.1171	4.1171	4.1171	4.1171	2800.0
2009-04-03 07:56:00	AAPL	Stock	4.125	4.125	4.125	4.125	112000.0
2009-04-03 08:00:00	AAPL	Stock	4.1171	4.125	4.1171	4.125	140000.0
2009-04-03 08:01:00	AAPL	Stock	4.1246	4.125	4.1218	4.1232	39200.0
2009-04-03 08:02:00	AAPL	Stock	4.1218	4.1243	4.1218	4.1243	7700.0
2009-04-03 08:03:00	AAPL	Stock	4.125	4.125	4.1239	4.1239	156800.0
2009-04-03 08:04:00	AAPL	Stock	4.1246	4.125	4.1225	4.1225	36400.0
2009-04-03 08:05:00	AAPL	Stock	4.125	4.125	4.1236	4.1236	22120.0
2009-04-03 08:06:00	AAPL	Stock	4.1246	4.1246	4.1246	4.1246	4900.0
2009-04-03 08:07:00	AAPL	Stock	4.1221	4.1221	4.1214	4.1214	67200.0
2009-04-03 08:08:00	AAPL	Stock	4.1207	4.125	4.1161	4.1161	18200.0
2009-04-03 08:09:00	AAPL	Stock	4.1161	4.1186	4.1161	4.1186	8400.0
2009-04-03 08:11:00	AAPL	Stock	4.1157	4.1157	4.1129	4.1129	21448.0
2009-04-03 08:12:00	AAPL	Stock	4.1075	4.1079	4.1064	4.1079	25200.0
2009-04-03 08:13:00	AAPL	Stock	4.1079	4.1079	4.0	4.0914	132692.0
2009-04-03 08:14:00	AAPL	Stock	4.0921	4.0982	4.0914	4.0918	32480.0
2009-04-03 08:16:00	AAPL	Stock	4.0982	4.0982	4.0946	4.0946	24920.0
2009-04-03 08:17:00	AAPL	Stock	4.0982	4.0982	4.095	4.095	7700.0
2009-04-03 08:18:00	AAPL	Stock	4.095	4.1011	4.095	4.1011	11200.0
2009-04-03 08:19:00	AAPL	Stock	4.0996	4.1018	4.0996	4.1018	14280.0
2009-04-03 08:20:00	AAPL	Stock	4.0961	4.0961	4.0961	4.0961	2800.0
2009-04-03 08:21:00	AAPL	Stock	4.0996	4.1011	4.0996	4.1011	6440.0
2009-04-03 08:24:00	AAPL	Stock	4.1071	4.1071	4.1036	4.1036	8400.0
2009-04-03 08:25:00	AAPL	Stock	4.1071	4.1139	4.1071	4.1139	14000.0
2009-04-03 08:26:00	AAPL	Stock	4.1068	4.1071	4.1068	4.1068	82544.0
2009-04-03 08:27:00	AAPL	Stock	4.1068	4.1068	4.1036	4.1036	8400.0
2009-04-03 08:28:00	AAPL	Stock	4.1054	4.1068	4.1054	4.1054	30240.0
2009-04-03 08:29:00	AAPL	Stock	4.1068	4.1068	4.1054	4.1068	58800.0
2009-04-03 08:30:00	AAPL	Stock	4.1068	4.1214	4.1068	4.1132	129220.0
2009-04-03 08:31:00	AAPL	Stock	4.1082	4.1143	4.1079	4.1125	66500.0
2009-04-03 08:32:00	AAPL	Stock	4.1139	4.1161	4.1125	4.1161	42000.0

> showing 50 of 940,471 rows — these rows as CSV

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