PREVIEW / stock_1min / 2009-08-27

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-08-27.parquet
  size:    12.3 MB
  rows:    920,757
  symbols: 2,726

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-08-27 06:46:00	AAPL	Stock	5.9993	5.9993	5.9993	5.9993	2800.0
2009-08-27 07:20:00	AAPL	Stock	5.9961	5.9964	5.9961	5.9964	14308.0
2009-08-27 07:22:00	AAPL	Stock	5.9929	5.9929	5.9929	5.9929	4620.0
2009-08-27 07:24:00	AAPL	Stock	5.9982	6.0007	5.9982	6.0007	7000.0
2009-08-27 07:26:00	AAPL	Stock	6.0036	6.0036	6.0036	6.0036	2800.0
2009-08-27 07:30:00	AAPL	Stock	6.0082	6.0082	6.0082	6.0082	2800.0
2009-08-27 07:36:00	AAPL	Stock	6.0071	6.0071	6.0071	6.0071	2800.0
2009-08-27 07:38:00	AAPL	Stock	6.0071	6.0071	6.0071	6.0071	8400.0
2009-08-27 07:43:00	AAPL	Stock	6.0071	6.0071	6.0071	6.0071	28000.0
2009-08-27 07:44:00	AAPL	Stock	6.0125	6.0125	6.0	6.0	29400.0
2009-08-27 07:45:00	AAPL	Stock	6.0268	6.0268	6.0004	6.0004	14000.0
2009-08-27 07:56:00	AAPL	Stock	6.0057	6.0057	6.0036	6.0036	21000.0
2009-08-27 07:57:00	AAPL	Stock	6.0036	6.0036	6.0036	6.0036	2800.0
2009-08-27 08:00:00	AAPL	Stock	6.005	6.0089	6.0	6.0007	62468.0
2009-08-27 08:01:00	AAPL	Stock	6.0007	6.0007	6.0	6.0007	47600.0
2009-08-27 08:02:00	AAPL	Stock	6.0043	6.005	6.0043	6.005	12180.0
2009-08-27 08:03:00	AAPL	Stock	6.005	6.005	6.0018	6.005	33432.0
2009-08-27 08:06:00	AAPL	Stock	6.005	6.005	6.005	6.005	7980.0
2009-08-27 08:07:00	AAPL	Stock	6.0071	6.0093	6.0071	6.0093	8400.0
2009-08-27 08:08:00	AAPL	Stock	6.0089	6.0143	6.0071	6.0143	64988.0
2009-08-27 08:09:00	AAPL	Stock	6.0168	6.0243	6.0168	6.0243	26740.0
2009-08-27 08:10:00	AAPL	Stock	6.0246	6.0246	6.02	6.02	52640.0
2009-08-27 08:11:00	AAPL	Stock	6.0229	6.0232	6.0229	6.0232	31332.0
2009-08-27 08:12:00	AAPL	Stock	6.025	6.025	6.0229	6.0229	16800.0
2009-08-27 08:13:00	AAPL	Stock	6.025	6.0261	6.025	6.0261	14000.0
2009-08-27 08:14:00	AAPL	Stock	6.0261	6.0264	6.0261	6.0261	25228.0
2009-08-27 08:15:00	AAPL	Stock	6.0261	6.0268	6.0257	6.0257	25200.0
2009-08-27 08:16:00	AAPL	Stock	6.0257	6.0261	6.0257	6.0261	16800.0
2009-08-27 08:17:00	AAPL	Stock	6.0268	6.0268	6.0261	6.0261	30772.0
2009-08-27 08:18:00	AAPL	Stock	6.0264	6.0264	6.0236	6.0264	23800.0
2009-08-27 08:19:00	AAPL	Stock	6.0239	6.0239	6.0236	6.0236	8400.0
2009-08-27 08:21:00	AAPL	Stock	6.0264	6.0264	6.025	6.025	11200.0
2009-08-27 08:23:00	AAPL	Stock	6.025	6.025	6.0236	6.0236	44800.0
2009-08-27 08:24:00	AAPL	Stock	6.0232	6.0232	6.0232	6.0232	12600.0
2009-08-27 08:25:00	AAPL	Stock	6.0257	6.0257	6.025	6.0257	15960.0
2009-08-27 08:26:00	AAPL	Stock	6.0254	6.0254	6.025	6.025	25200.0
2009-08-27 08:27:00	AAPL	Stock	6.025	6.0268	6.025	6.0268	13748.0
2009-08-27 08:28:00	AAPL	Stock	6.0264	6.0264	6.025	6.025	7140.0
2009-08-27 08:29:00	AAPL	Stock	6.0236	6.025	6.0236	6.025	5600.0
2009-08-27 08:30:00	AAPL	Stock	6.0232	6.0236	6.0196	6.0232	73192.0
2009-08-27 08:31:00	AAPL	Stock	6.0246	6.025	6.0232	6.0232	33852.0
2009-08-27 08:32:00	AAPL	Stock	6.0232	6.0232	6.0232	6.0232	2800.0
2009-08-27 08:33:00	AAPL	Stock	6.0186	6.0186	6.0182	6.0182	8400.0
2009-08-27 08:34:00	AAPL	Stock	6.0182	6.0246	6.0182	6.0246	22540.0
2009-08-27 08:36:00	AAPL	Stock	6.0236	6.0236	6.0236	6.0236	2800.0
2009-08-27 08:37:00	AAPL	Stock	6.0221	6.0221	6.0204	6.0204	5600.0
2009-08-27 08:38:00	AAPL	Stock	6.0207	6.0243	6.02	6.0243	11200.0
2009-08-27 08:39:00	AAPL	Stock	6.0236	6.0261	6.0232	6.025	73640.0
2009-08-27 08:40:00	AAPL	Stock	6.0261	6.0354	6.0261	6.0354	182280.0
2009-08-27 08:41:00	AAPL	Stock	6.0321	6.0357	6.0321	6.0357	152600.0

> showing 50 of 920,757 rows — these rows as CSV

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