PREVIEW / stock_1min / 2009-07-09

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-07-09.parquet
  size:    12.1 MB
  rows:    932,158
  symbols: 2,701

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-07-09 07:47:00	AAPL	Stock	4.9286	4.9286	4.9286	4.9286	5936.0
2009-07-09 07:49:00	AAPL	Stock	4.9318	4.9318	4.9318	4.9318	2800.0
2009-07-09 07:50:00	AAPL	Stock	4.9286	4.9286	4.9286	4.9286	2800.0
2009-07-09 07:53:00	AAPL	Stock	4.9286	4.9286	4.9286	4.9286	3864.0
2009-07-09 08:00:00	AAPL	Stock	4.9089	4.9111	4.9089	4.9111	16800.0
2009-07-09 08:03:00	AAPL	Stock	4.9179	4.9179	4.9179	4.9179	4200.0
2009-07-09 08:04:00	AAPL	Stock	4.9161	4.9161	4.9161	4.9161	4200.0
2009-07-09 08:05:00	AAPL	Stock	4.9171	4.9214	4.9171	4.9214	78400.0
2009-07-09 08:06:00	AAPL	Stock	4.9214	4.9232	4.9214	4.9232	19684.0
2009-07-09 08:07:00	AAPL	Stock	4.9261	4.9268	4.9232	4.9232	49980.0
2009-07-09 08:08:00	AAPL	Stock	4.9204	4.9204	4.9204	4.9204	11200.0
2009-07-09 08:10:00	AAPL	Stock	4.9229	4.9229	4.9229	4.9229	32620.0
2009-07-09 08:14:00	AAPL	Stock	4.9229	4.9229	4.9229	4.9229	28000.0
2009-07-09 08:15:00	AAPL	Stock	4.9207	4.9232	4.9207	4.9232	5600.0
2009-07-09 08:17:00	AAPL	Stock	4.9207	4.9207	4.9207	4.9207	14000.0
2009-07-09 08:18:00	AAPL	Stock	4.9239	4.9239	4.9214	4.9214	31192.0
2009-07-09 08:21:00	AAPL	Stock	4.9214	4.9214	4.9214	4.9214	16800.0
2009-07-09 08:23:00	AAPL	Stock	4.9214	4.9214	4.9214	4.9214	11200.0
2009-07-09 08:24:00	AAPL	Stock	4.9214	4.9214	4.9214	4.9214	13720.0
2009-07-09 08:25:00	AAPL	Stock	4.92	4.92	4.9196	4.9196	16100.0
2009-07-09 08:26:00	AAPL	Stock	4.9246	4.9246	4.9246	4.9246	3024.0
2009-07-09 08:28:00	AAPL	Stock	4.9243	4.925	4.9243	4.925	24080.0
2009-07-09 08:29:00	AAPL	Stock	4.9286	4.9286	4.925	4.9268	29680.0
2009-07-09 08:30:00	AAPL	Stock	4.9286	4.9339	4.9286	4.9329	112000.0
2009-07-09 08:31:00	AAPL	Stock	4.9325	4.9325	4.9268	4.9268	81200.0
2009-07-09 08:32:00	AAPL	Stock	4.9321	4.9321	4.9321	4.9321	2800.0
2009-07-09 08:33:00	AAPL	Stock	4.9321	4.9321	4.9321	4.9321	12600.0
2009-07-09 08:35:00	AAPL	Stock	4.9286	4.9286	4.9268	4.9268	47600.0
2009-07-09 08:36:00	AAPL	Stock	4.9257	4.9268	4.925	4.9268	8400.0
2009-07-09 08:37:00	AAPL	Stock	4.9268	4.9286	4.9268	4.9286	75684.0
2009-07-09 08:40:00	AAPL	Stock	4.9286	4.9286	4.9286	4.9286	14000.0
2009-07-09 08:41:00	AAPL	Stock	4.9286	4.9321	4.9282	4.9321	47124.0
2009-07-09 08:42:00	AAPL	Stock	4.9354	4.9389	4.9289	4.9357	231616.0
2009-07-09 08:43:00	AAPL	Stock	4.9375	4.9375	4.9357	4.9357	111300.0
2009-07-09 08:44:00	AAPL	Stock	4.9318	4.9329	4.9307	4.9307	16800.0
2009-07-09 08:46:00	AAPL	Stock	4.9357	4.9357	4.9357	4.9357	2800.0
2009-07-09 08:48:00	AAPL	Stock	4.9357	4.9375	4.9357	4.9375	16800.0
2009-07-09 08:49:00	AAPL	Stock	4.9368	4.9393	4.9368	4.9393	85904.0
2009-07-09 08:50:00	AAPL	Stock	4.9393	4.9414	4.9386	4.9411	79940.0
2009-07-09 08:51:00	AAPL	Stock	4.9411	4.9429	4.9411	4.9429	16800.0
2009-07-09 08:52:00	AAPL	Stock	4.9429	4.9429	4.9411	4.9411	62496.0
2009-07-09 08:53:00	AAPL	Stock	4.9425	4.9436	4.9425	4.9436	94640.0
2009-07-09 08:54:00	AAPL	Stock	4.9446	4.9457	4.9436	4.9436	24780.0
2009-07-09 08:55:00	AAPL	Stock	4.9436	4.945	4.9425	4.945	57876.0
2009-07-09 08:56:00	AAPL	Stock	4.9396	4.9396	4.9396	4.9396	2800.0
2009-07-09 08:57:00	AAPL	Stock	4.9407	4.9407	4.9407	4.9407	2800.0
2009-07-09 08:59:00	AAPL	Stock	4.945	4.9464	4.9404	4.9404	103600.0
2009-07-09 09:00:00	AAPL	Stock	4.9446	4.9446	4.9393	4.9393	49224.0
2009-07-09 09:01:00	AAPL	Stock	4.9393	4.9393	4.9357	4.9357	33600.0
2009-07-09 09:02:00	AAPL	Stock	4.9346	4.9357	4.9346	4.9357	5600.0

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

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