PREVIEW / stock_1min / 2009-10-06

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-10-06.parquet
  size:    12.9 MB
  rows:    969,388
  symbols: 2,761

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-10-06 04:33:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	11200.0
2009-10-06 05:09:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	4200.0
2009-10-06 05:10:00	AAPL	Stock	6.6911	6.6911	6.6911	6.6911	5600.0
2009-10-06 06:26:00	AAPL	Stock	6.6875	6.6875	6.6875	6.6875	5600.0
2009-10-06 06:45:00	AAPL	Stock	6.6789	6.6789	6.6711	6.6711	27804.0
2009-10-06 06:46:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	5600.0
2009-10-06 06:56:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	5404.0
2009-10-06 07:05:00	AAPL	Stock	6.6904	6.6904	6.6893	6.6893	5600.0
2009-10-06 07:07:00	AAPL	Stock	6.6893	6.6893	6.6893	6.6893	5600.0
2009-10-06 07:10:00	AAPL	Stock	6.6918	6.6918	6.6857	6.6857	16800.0
2009-10-06 07:11:00	AAPL	Stock	6.6804	6.6804	6.6793	6.6793	72884.0
2009-10-06 07:12:00	AAPL	Stock	6.675	6.675	6.675	6.675	5600.0
2009-10-06 07:14:00	AAPL	Stock	6.6725	6.6725	6.6725	6.6725	19516.0
2009-10-06 07:15:00	AAPL	Stock	6.6721	6.6721	6.6721	6.6721	14000.0
2009-10-06 07:16:00	AAPL	Stock	6.6732	6.6732	6.6643	6.6643	16604.0
2009-10-06 07:26:00	AAPL	Stock	6.6714	6.6714	6.6714	6.6714	8400.0
2009-10-06 07:27:00	AAPL	Stock	6.6714	6.6714	6.6714	6.6714	2800.0
2009-10-06 07:32:00	AAPL	Stock	6.6804	6.6804	6.6804	6.6804	8400.0
2009-10-06 07:35:00	AAPL	Stock	6.6804	6.6804	6.6804	6.6804	5600.0
2009-10-06 07:37:00	AAPL	Stock	6.6804	6.6804	6.6804	6.6804	2800.0
2009-10-06 07:38:00	AAPL	Stock	6.675	6.675	6.675	6.675	2800.0
2009-10-06 07:46:00	AAPL	Stock	6.6839	6.6839	6.6786	6.6786	44800.0
2009-10-06 07:54:00	AAPL	Stock	6.6821	6.6839	6.6821	6.6839	13300.0
2009-10-06 07:57:00	AAPL	Stock	6.6821	6.6821	6.6821	6.6821	2800.0
2009-10-06 07:58:00	AAPL	Stock	6.6839	6.6839	6.6839	6.6839	5740.0
2009-10-06 07:59:00	AAPL	Stock	6.6871	6.6871	6.6871	6.6871	2800.0
2009-10-06 08:00:00	AAPL	Stock	6.6875	6.6875	6.6786	6.6868	231000.0
2009-10-06 08:01:00	AAPL	Stock	6.6871	6.6893	6.6857	6.6893	232764.0
2009-10-06 08:03:00	AAPL	Stock	6.6889	6.6893	6.6889	6.6893	59416.0
2009-10-06 08:04:00	AAPL	Stock	6.6911	6.6925	6.6911	6.6925	35000.0
2009-10-06 08:05:00	AAPL	Stock	6.6925	6.6964	6.6925	6.6961	97300.0
2009-10-06 08:06:00	AAPL	Stock	6.6929	6.6929	6.6911	6.6911	62720.0
2009-10-06 08:07:00	AAPL	Stock	6.6896	6.6896	6.6871	6.6882	106400.0
2009-10-06 08:08:00	AAPL	Stock	6.6882	6.6882	6.6882	6.6882	19600.0
2009-10-06 08:09:00	AAPL	Stock	6.6889	6.6896	6.6875	6.6896	96852.0
2009-10-06 08:10:00	AAPL	Stock	6.6893	6.6921	6.6893	6.6918	77000.0
2009-10-06 08:11:00	AAPL	Stock	6.6914	6.6918	6.6914	6.6918	16800.0
2009-10-06 08:12:00	AAPL	Stock	6.6918	6.695	6.6918	6.695	46088.0
2009-10-06 08:13:00	AAPL	Stock	6.6961	6.6989	6.6961	6.6964	251496.0
2009-10-06 08:14:00	AAPL	Stock	6.6964	6.7014	6.6964	6.6982	69020.0
2009-10-06 08:15:00	AAPL	Stock	6.6996	6.7025	6.6996	6.7018	31920.0
2009-10-06 08:16:00	AAPL	Stock	6.7018	6.7036	6.7018	6.7025	37016.0
2009-10-06 08:17:00	AAPL	Stock	6.7039	6.7039	6.7	6.7	25200.0
2009-10-06 08:18:00	AAPL	Stock	6.7025	6.7029	6.6996	6.6996	80080.0
2009-10-06 08:21:00	AAPL	Stock	6.7	6.7	6.7	6.7	5600.0
2009-10-06 08:22:00	AAPL	Stock	6.7014	6.7043	6.7014	6.7043	76300.0
2009-10-06 08:23:00	AAPL	Stock	6.7039	6.7039	6.7039	6.7039	5600.0
2009-10-06 08:24:00	AAPL	Stock	6.7036	6.7039	6.7036	6.7039	17500.0
2009-10-06 08:25:00	AAPL	Stock	6.7039	6.7043	6.7036	6.7036	14000.0
2009-10-06 08:26:00	AAPL	Stock	6.7043	6.7071	6.7039	6.7071	223804.0

> showing 50 of 969,388 rows — these rows as CSV

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