PREVIEW / stock_1min / 2008-09-23

all stock 1-min files

  file:    by_date/stock_1min/2008/2008-09-23.parquet
  size:    12.5 MB
  rows:    995,265
  symbols: 2,720

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
2008-09-23 06:49:00	AAPL	Stock	4.6786	4.6786	4.6786	4.6786	5600.0
2008-09-23 07:48:00	AAPL	Stock	4.6857	4.6857	4.6857	4.6857	2800.0
2008-09-23 08:00:00	AAPL	Stock	4.6821	4.7018	4.6768	4.6793	29400.0
2008-09-23 08:02:00	AAPL	Stock	4.6875	4.6964	4.6875	4.6964	18620.0
2008-09-23 08:03:00	AAPL	Stock	4.6929	4.6964	4.6929	4.6964	22400.0
2008-09-23 08:04:00	AAPL	Stock	4.7032	4.7032	4.6896	4.6964	52640.0
2008-09-23 08:05:00	AAPL	Stock	4.6964	4.6964	4.6929	4.6929	81200.0
2008-09-23 08:06:00	AAPL	Stock	4.7021	4.7021	4.7021	4.7021	2800.0
2008-09-23 08:07:00	AAPL	Stock	4.6925	4.6925	4.6914	4.6914	21000.0
2008-09-23 08:08:00	AAPL	Stock	4.6914	4.6914	4.6811	4.6821	72548.0
2008-09-23 08:09:00	AAPL	Stock	4.6814	4.6814	4.6743	4.6743	120540.0
2008-09-23 08:10:00	AAPL	Stock	4.6754	4.6818	4.6754	4.6818	6300.0
2008-09-23 08:11:00	AAPL	Stock	4.6757	4.6757	4.6682	4.675	137200.0
2008-09-23 08:12:00	AAPL	Stock	4.6732	4.6782	4.6732	4.6782	103656.0
2008-09-23 08:14:00	AAPL	Stock	4.6818	4.6914	4.6754	4.6754	100800.0
2008-09-23 08:15:00	AAPL	Stock	4.6814	4.6818	4.6814	4.6814	14000.0
2008-09-23 08:16:00	AAPL	Stock	4.6814	4.6814	4.6814	4.6814	2800.0
2008-09-23 08:18:00	AAPL	Stock	4.6814	4.6821	4.6814	4.6821	31500.0
2008-09-23 08:19:00	AAPL	Stock	4.6886	4.6886	4.6886	4.6886	2800.0
2008-09-23 08:20:00	AAPL	Stock	4.6886	4.6893	4.6875	4.6875	42980.0
2008-09-23 08:21:00	AAPL	Stock	4.6832	4.6836	4.6829	4.6836	16800.0
2008-09-23 08:22:00	AAPL	Stock	4.6839	4.6839	4.6829	4.6829	15400.0
2008-09-23 08:23:00	AAPL	Stock	4.6821	4.6821	4.6811	4.6811	7140.0
2008-09-23 08:24:00	AAPL	Stock	4.6804	4.6807	4.6796	4.6796	16800.0
2008-09-23 08:25:00	AAPL	Stock	4.6793	4.6843	4.6793	4.6804	57400.0
2008-09-23 08:26:00	AAPL	Stock	4.6804	4.6804	4.6804	4.6804	19600.0
2008-09-23 08:27:00	AAPL	Stock	4.6807	4.6807	4.6807	4.6807	2800.0
2008-09-23 08:28:00	AAPL	Stock	4.68	4.68	4.6746	4.6746	60508.0
2008-09-23 08:29:00	AAPL	Stock	4.6746	4.6793	4.6714	4.6729	47600.0
2008-09-23 08:30:00	AAPL	Stock	4.6739	4.6739	4.6625	4.6625	43820.0
2008-09-23 08:31:00	AAPL	Stock	4.6671	4.6786	4.6646	4.6786	41860.0
2008-09-23 08:32:00	AAPL	Stock	4.68	4.6854	4.68	4.6854	24808.0
2008-09-23 08:34:00	AAPL	Stock	4.6854	4.6854	4.6782	4.6782	15400.0
2008-09-23 08:35:00	AAPL	Stock	4.6786	4.6857	4.6786	4.6789	46228.0
2008-09-23 08:37:00	AAPL	Stock	4.6829	4.6829	4.6829	4.6829	11200.0
2008-09-23 08:38:00	AAPL	Stock	4.685	4.6857	4.6804	4.6804	80640.0
2008-09-23 08:39:00	AAPL	Stock	4.6804	4.6961	4.6804	4.6961	45080.0
2008-09-23 08:40:00	AAPL	Stock	4.6961	4.6961	4.6886	4.6929	27440.0
2008-09-23 08:41:00	AAPL	Stock	4.6921	4.6929	4.6921	4.6929	30800.0
2008-09-23 08:42:00	AAPL	Stock	4.6929	4.7	4.6925	4.7	129612.0
2008-09-23 08:43:00	AAPL	Stock	4.7018	4.7061	4.7018	4.7061	16800.0
2008-09-23 08:44:00	AAPL	Stock	4.7036	4.7061	4.7	4.7061	57372.0
2008-09-23 08:45:00	AAPL	Stock	4.7036	4.7036	4.7036	4.7036	2800.0
2008-09-23 08:46:00	AAPL	Stock	4.7032	4.7036	4.7004	4.7029	22400.0
2008-09-23 08:47:00	AAPL	Stock	4.7007	4.7036	4.7007	4.7036	5600.0
2008-09-23 08:48:00	AAPL	Stock	4.7	4.7029	4.6982	4.6982	30800.0
2008-09-23 08:49:00	AAPL	Stock	4.6993	4.6993	4.6968	4.6993	30800.0
2008-09-23 08:50:00	AAPL	Stock	4.7011	4.7032	4.7007	4.7007	72800.0
2008-09-23 08:51:00	AAPL	Stock	4.6993	4.6993	4.6836	4.6864	181944.0
2008-09-23 08:52:00	AAPL	Stock	4.6893	4.6918	4.6893	4.6914	8400.0

> showing 50 of 995,265 rows — these rows as CSV

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