PREVIEW / stock_1min / 2006-06-27

all stock 1-min files

  file:    by_date/stock_1min/2006/2006-06-27.parquet
  size:    8.5 MB
  rows:    697,158
  symbols: 1,874

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
2006-06-27 07:10:00	AAPL	Stock	2.0946	2.0946	2.0893	2.0893	28000.0
2006-06-27 08:03:00	AAPL	Stock	2.1007	2.1007	2.1	2.1	7756.0
2006-06-27 08:05:00	AAPL	Stock	2.1	2.1	2.1	2.1	16800.0
2006-06-27 08:06:00	AAPL	Stock	2.1029	2.1029	2.1029	2.1029	28000.0
2006-06-27 08:10:00	AAPL	Stock	2.0982	2.0986	2.0982	2.0986	26600.0
2006-06-27 08:16:00	AAPL	Stock	2.1018	2.1018	2.1	2.1	42000.0
2006-06-27 08:17:00	AAPL	Stock	2.1	2.1	2.1	2.1	28000.0
2006-06-27 08:19:00	AAPL	Stock	2.0989	2.0989	2.0971	2.0971	19600.0
2006-06-27 08:20:00	AAPL	Stock	2.0986	2.0986	2.0986	2.0986	11200.0
2006-06-27 08:23:00	AAPL	Stock	2.1	2.1	2.1	2.1	71400.0
2006-06-27 08:24:00	AAPL	Stock	2.1	2.1	2.1	2.1	120344.0
2006-06-27 08:25:00	AAPL	Stock	2.1	2.1	2.1	2.1	33600.0
2006-06-27 08:30:00	AAPL	Stock	2.1004	2.1004	2.1004	2.1004	8400.0
2006-06-27 08:34:00	AAPL	Stock	2.1004	2.1004	2.1004	2.1004	11200.0
2006-06-27 08:41:00	AAPL	Stock	2.1036	2.1036	2.1036	2.1036	2800.0
2006-06-27 08:43:00	AAPL	Stock	2.1036	2.1036	2.1036	2.1036	2800.0
2006-06-27 08:47:00	AAPL	Stock	2.1032	2.1032	2.1032	2.1032	2800.0
2006-06-27 08:48:00	AAPL	Stock	2.1004	2.1004	2.1004	2.1004	2800.0
2006-06-27 08:54:00	AAPL	Stock	2.1018	2.1018	2.1018	2.1018	28000.0
2006-06-27 08:55:00	AAPL	Stock	2.1029	2.1029	2.1029	2.1029	2800.0
2006-06-27 08:56:00	AAPL	Stock	2.1029	2.1032	2.1029	2.1029	53200.0
2006-06-27 09:02:00	AAPL	Stock	2.1039	2.1043	2.1039	2.1043	21000.0
2006-06-27 09:05:00	AAPL	Stock	2.1054	2.1054	2.1054	2.1054	2800.0
2006-06-27 09:07:00	AAPL	Stock	2.1054	2.1071	2.1054	2.1071	64400.0
2006-06-27 09:09:00	AAPL	Stock	2.1086	2.1086	2.1086	2.1086	14000.0
2006-06-27 09:10:00	AAPL	Stock	2.1071	2.1071	2.1071	2.1071	28000.0
2006-06-27 09:11:00	AAPL	Stock	2.1071	2.1071	2.1071	2.1071	2800.0
2006-06-27 09:12:00	AAPL	Stock	2.1071	2.1071	2.1071	2.1071	2800.0
2006-06-27 09:14:00	AAPL	Stock	2.1082	2.1082	2.1079	2.1079	14000.0
2006-06-27 09:15:00	AAPL	Stock	2.1071	2.1071	2.1071	2.1071	56000.0
2006-06-27 09:18:00	AAPL	Stock	2.1071	2.1071	2.1068	2.1068	14000.0
2006-06-27 09:22:00	AAPL	Stock	2.1071	2.1071	2.1071	2.1071	14000.0
2006-06-27 09:26:00	AAPL	Stock	2.1046	2.1046	2.1018	2.1032	203868.0
2006-06-27 09:27:00	AAPL	Stock	2.1036	2.1036	2.1036	2.1036	35000.0
2006-06-27 09:28:00	AAPL	Stock	2.1036	2.1107	2.1036	2.1079	150864.0
2006-06-27 09:29:00	AAPL	Stock	2.1075	2.1125	2.1075	2.11	78400.0
2006-06-27 09:30:00	AAPL	Stock	2.1104	2.1121	2.1071	2.1089	4639460.0
2006-06-27 09:31:00	AAPL	Stock	2.1089	2.1118	2.1082	2.1118	1214584.0
2006-06-27 09:32:00	AAPL	Stock	2.1121	2.1143	2.1121	2.1125	2589076.0
2006-06-27 09:33:00	AAPL	Stock	2.1129	2.115	2.1086	2.1093	2509808.0
2006-06-27 09:34:00	AAPL	Stock	2.1089	2.1118	2.1054	2.1064	1647268.0
2006-06-27 09:35:00	AAPL	Stock	2.1064	2.1068	2.1036	2.1057	1572340.0
2006-06-27 09:36:00	AAPL	Stock	2.1054	2.1064	2.1054	2.1057	594384.0
2006-06-27 09:37:00	AAPL	Stock	2.1054	2.1064	2.1018	2.1043	1661072.0
2006-06-27 09:38:00	AAPL	Stock	2.1043	2.1082	2.1043	2.1054	1125152.0
2006-06-27 09:39:00	AAPL	Stock	2.1054	2.1068	2.1054	2.1061	463064.0
2006-06-27 09:40:00	AAPL	Stock	2.1061	2.1068	2.1	2.1029	1741964.0
2006-06-27 09:41:00	AAPL	Stock	2.1025	2.1029	2.0993	2.1011	2049096.0
2006-06-27 09:42:00	AAPL	Stock	2.1014	2.1036	2.1007	2.1036	839412.0
2006-06-27 09:43:00	AAPL	Stock	2.1036	2.1068	2.1025	2.1068	1435924.0

> showing 50 of 697,158 rows — these rows as CSV

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