PREVIEW / stock_1min / 2007-07-18

all stock 1-min files

  file:    by_date/stock_1min/2007/2007-07-18.parquet
  size:    11.6 MB
  rows:    950,441
  symbols: 2,518

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-07-18 09:30:00	AAPL	Stock	4.9354	4.9357	4.9236	4.9236	10394636.0
2007-07-18 09:31:00	AAPL	Stock	4.9236	4.9286	4.9107	4.9114	6116908.0
2007-07-18 09:32:00	AAPL	Stock	4.9121	4.9232	4.8939	4.9118	8672468.0
2007-07-18 09:33:00	AAPL	Stock	4.9118	4.9257	4.8951	4.9218	6743436.0
2007-07-18 09:34:00	AAPL	Stock	4.9214	4.9254	4.8954	4.9215	4424672.0
2007-07-18 09:35:00	AAPL	Stock	4.9214	4.9241	4.9179	4.9221	5442192.0
2007-07-18 09:36:00	AAPL	Stock	4.9221	4.9229	4.8946	4.9036	11261824.0
2007-07-18 09:37:00	AAPL	Stock	4.9036	4.9089	4.8962	4.9043	5082084.0
2007-07-18 09:38:00	AAPL	Stock	4.9043	4.9154	4.9007	4.9146	3899980.0
2007-07-18 09:39:00	AAPL	Stock	4.9146	4.9182	4.9129	4.9161	2990988.0
2007-07-18 09:40:00	AAPL	Stock	4.9161	4.9211	4.9143	4.9207	2608116.0
2007-07-18 09:41:00	AAPL	Stock	4.9207	4.9286	4.9189	4.9279	4008312.0
2007-07-18 09:42:00	AAPL	Stock	4.9261	4.9318	4.9207	4.9211	5126380.0
2007-07-18 09:43:00	AAPL	Stock	4.9214	4.925	4.9207	4.925	2848104.0
2007-07-18 09:44:00	AAPL	Stock	4.9239	4.9329	4.9239	4.9325	3309992.0
2007-07-18 09:45:00	AAPL	Stock	4.9329	4.9368	4.9221	4.93	5762792.0
2007-07-18 09:46:00	AAPL	Stock	4.93	4.9314	4.9243	4.9271	3116456.0
2007-07-18 09:47:00	AAPL	Stock	4.9275	4.9329	4.9199	4.93	3220000.0
2007-07-18 09:48:00	AAPL	Stock	4.9311	4.94	4.9296	4.9354	3922968.0
2007-07-18 09:49:00	AAPL	Stock	4.9357	4.9357	4.9286	4.9311	2752736.0
2007-07-18 09:50:00	AAPL	Stock	4.9314	4.9343	4.9307	4.9325	2379300.0
2007-07-18 09:51:00	AAPL	Stock	4.9318	4.9343	4.9239	4.9264	2748816.0
2007-07-18 09:52:00	AAPL	Stock	4.9264	4.9311	4.9236	4.9289	2341024.0
2007-07-18 09:53:00	AAPL	Stock	4.9296	4.93	4.9257	4.9268	1787912.0
2007-07-18 09:54:00	AAPL	Stock	4.9264	4.9275	4.9232	4.9257	1581860.0
2007-07-18 09:55:00	AAPL	Stock	4.9264	4.9325	4.9232	4.9236	3030804.0
2007-07-18 09:56:00	AAPL	Stock	4.9239	4.9271	4.9236	4.9243	1899660.0
2007-07-18 09:57:00	AAPL	Stock	4.9239	4.925	4.9221	4.9243	3543148.0
2007-07-18 09:58:00	AAPL	Stock	4.925	4.9364	4.9246	4.9361	3004932.0
2007-07-18 09:59:00	AAPL	Stock	4.9364	4.9382	4.9329	4.9346	3673236.0
2007-07-18 10:00:00	AAPL	Stock	4.935	4.9432	4.9343	4.9432	4864804.0
2007-07-18 10:01:00	AAPL	Stock	4.9432	4.9443	4.9364	4.9375	4489716.0
2007-07-18 10:02:00	AAPL	Stock	4.9368	4.9421	4.9243	4.9371	3697120.0
2007-07-18 10:03:00	AAPL	Stock	4.9364	4.9371	4.9325	4.9332	1985200.0
2007-07-18 10:04:00	AAPL	Stock	4.9325	4.9357	4.9261	4.9301	3636108.0
2007-07-18 10:05:00	AAPL	Stock	4.929	4.9339	4.9268	4.9282	1997436.0
2007-07-18 10:06:00	AAPL	Stock	4.9275	4.9321	4.9232	4.9304	2871624.0
2007-07-18 10:07:00	AAPL	Stock	4.9303	4.9336	4.9257	4.9268	1797572.0
2007-07-18 10:08:00	AAPL	Stock	4.9268	4.9314	4.9221	4.9239	3164000.0
2007-07-18 10:09:00	AAPL	Stock	4.9239	4.9244	4.9207	4.9211	2500624.0
2007-07-18 10:10:00	AAPL	Stock	4.9211	4.9243	4.9207	4.9243	2458232.0
2007-07-18 10:11:00	AAPL	Stock	4.9239	4.9268	4.9229	4.9243	1785924.0
2007-07-18 10:12:00	AAPL	Stock	4.9239	4.9264	4.9232	4.9236	3020416.0
2007-07-18 10:13:00	AAPL	Stock	4.9236	4.9321	4.9229	4.9232	3693760.0
2007-07-18 10:14:00	AAPL	Stock	4.9232	4.9264	4.9232	4.9254	1490692.0
2007-07-18 10:15:00	AAPL	Stock	4.9254	4.9275	4.9232	4.9232	1585836.0
2007-07-18 10:16:00	AAPL	Stock	4.9232	4.93	4.9232	4.9293	1835372.0
2007-07-18 10:17:00	AAPL	Stock	4.9293	4.9311	4.9239	4.925	1275708.0
2007-07-18 10:18:00	AAPL	Stock	4.9254	4.9254	4.9193	4.92	2798320.0
2007-07-18 10:19:00	AAPL	Stock	4.9204	4.925	4.9171	4.9243	1787240.0

> showing 50 of 950,441 rows — these rows as CSV

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