PREVIEW / stock_1min / 2009-01-21

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-01-21.parquet
  size:    12.5 MB
  rows:    962,072
  symbols: 2,687

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-01-21 06:40:00	AAPL	Stock	2.8375	2.8375	2.8375	2.8375	18200.0
2009-01-21 07:01:00	AAPL	Stock	2.8375	2.8375	2.8375	2.8375	5600.0
2009-01-21 07:03:00	AAPL	Stock	2.8489	2.8489	2.8489	2.8489	5600.0
2009-01-21 07:06:00	AAPL	Stock	2.8375	2.8375	2.8375	2.8375	9744.0
2009-01-21 07:07:00	AAPL	Stock	2.8375	2.8375	2.8375	2.8375	72800.0
2009-01-21 07:08:00	AAPL	Stock	2.8371	2.8371	2.8371	2.8371	2800.0
2009-01-21 07:15:00	AAPL	Stock	2.8371	2.8375	2.8371	2.8375	12880.0
2009-01-21 07:21:00	AAPL	Stock	2.8375	2.8375	2.8375	2.8375	70000.0
2009-01-21 07:22:00	AAPL	Stock	2.8339	2.8339	2.8339	2.8339	2800.0
2009-01-21 07:26:00	AAPL	Stock	2.8304	2.8304	2.8304	2.8304	12600.0
2009-01-21 07:28:00	AAPL	Stock	2.8239	2.8239	2.8239	2.8239	2800.0
2009-01-21 08:00:00	AAPL	Stock	2.8282	2.8357	2.8243	2.8357	75264.0
2009-01-21 08:01:00	AAPL	Stock	2.8261	2.8304	2.8261	2.8304	23100.0
2009-01-21 08:02:00	AAPL	Stock	2.8314	2.8354	2.8314	2.8354	21000.0
2009-01-21 08:03:00	AAPL	Stock	2.8354	2.8357	2.8304	2.8304	49700.0
2009-01-21 08:04:00	AAPL	Stock	2.8293	2.8293	2.8286	2.8286	8400.0
2009-01-21 08:05:00	AAPL	Stock	2.8275	2.8282	2.8239	2.8239	17444.0
2009-01-21 08:06:00	AAPL	Stock	2.8279	2.8279	2.8239	2.8239	51688.0
2009-01-21 08:07:00	AAPL	Stock	2.8275	2.8275	2.8275	2.8275	2800.0
2009-01-21 08:08:00	AAPL	Stock	2.8282	2.8282	2.8282	2.8282	2800.0
2009-01-21 08:09:00	AAPL	Stock	2.8279	2.8286	2.8268	2.8268	57400.0
2009-01-21 08:10:00	AAPL	Stock	2.8264	2.8304	2.8264	2.8304	113400.0
2009-01-21 08:12:00	AAPL	Stock	2.8286	2.8286	2.8286	2.8286	22400.0
2009-01-21 08:13:00	AAPL	Stock	2.83	2.83	2.8271	2.8271	30604.0
2009-01-21 08:15:00	AAPL	Stock	2.8279	2.8286	2.8279	2.8286	27720.0
2009-01-21 08:16:00	AAPL	Stock	2.8279	2.8286	2.8279	2.8286	8680.0
2009-01-21 08:17:00	AAPL	Stock	2.8257	2.8275	2.8246	2.8275	42000.0
2009-01-21 08:18:00	AAPL	Stock	2.8279	2.8279	2.8275	2.8275	11900.0
2009-01-21 08:19:00	AAPL	Stock	2.8264	2.8264	2.8264	2.8264	39200.0
2009-01-21 08:25:00	AAPL	Stock	2.8282	2.8286	2.8282	2.8286	58800.0
2009-01-21 08:26:00	AAPL	Stock	2.8286	2.8286	2.8286	2.8286	76160.0
2009-01-21 08:27:00	AAPL	Stock	2.8286	2.8304	2.8286	2.83	61600.0
2009-01-21 08:28:00	AAPL	Stock	2.8304	2.8304	2.8286	2.8286	12600.0
2009-01-21 08:29:00	AAPL	Stock	2.8304	2.8304	2.8304	2.8304	26348.0
2009-01-21 08:30:00	AAPL	Stock	2.8304	2.8304	2.8286	2.8286	16800.0
2009-01-21 08:32:00	AAPL	Stock	2.8304	2.8332	2.8293	2.8332	271152.0
2009-01-21 08:33:00	AAPL	Stock	2.8336	2.8336	2.8332	2.8332	6160.0
2009-01-21 08:34:00	AAPL	Stock	2.8329	2.8379	2.8329	2.8379	137452.0
2009-01-21 08:35:00	AAPL	Stock	2.8357	2.8357	2.8332	2.8332	35700.0
2009-01-21 08:36:00	AAPL	Stock	2.8371	2.8411	2.8332	2.8393	145180.0
2009-01-21 08:37:00	AAPL	Stock	2.8414	2.8446	2.8389	2.8421	28196.0
2009-01-21 08:38:00	AAPL	Stock	2.8425	2.8429	2.8425	2.8425	26600.0
2009-01-21 08:39:00	AAPL	Stock	2.8429	2.8429	2.8425	2.8429	34300.0
2009-01-21 08:40:00	AAPL	Stock	2.8443	2.8464	2.8429	2.8464	86800.0
2009-01-21 08:41:00	AAPL	Stock	2.8446	2.845	2.8411	2.8411	154000.0
2009-01-21 08:42:00	AAPL	Stock	2.8407	2.8411	2.8393	2.8411	16800.0
2009-01-21 08:43:00	AAPL	Stock	2.84	2.84	2.8393	2.8393	35700.0
2009-01-21 08:44:00	AAPL	Stock	2.8396	2.8396	2.8375	2.8375	40908.0
2009-01-21 08:45:00	AAPL	Stock	2.8393	2.8393	2.8393	2.8393	28000.0
2009-01-21 08:46:00	AAPL	Stock	2.8375	2.8396	2.8375	2.8393	63532.0

> showing 50 of 962,072 rows — these rows as CSV

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