PREVIEW / stock_1min / 2019-09-03

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-09-03.parquet
  size:    15.9 MB
  rows:    1,126,325
  symbols: 2,173

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
2019-09-03 04:00:00	AAPL	Stock	51.425	51.425	51.365	51.365	2364.0
2019-09-03 04:01:00	AAPL	Stock	51.4625	51.67	51.4625	51.67	2000.0
2019-09-03 04:02:00	AAPL	Stock	51.5025	51.5275	51.5025	51.515	1600.0
2019-09-03 04:06:00	AAPL	Stock	51.575	51.575	51.575	51.575	1200.0
2019-09-03 04:14:00	AAPL	Stock	51.6875	51.7275	51.6875	51.7275	1600.0
2019-09-03 04:15:00	AAPL	Stock	51.8475	51.8475	51.7975	51.7975	960.0
2019-09-03 04:20:00	AAPL	Stock	51.6875	51.725	51.6875	51.725	2400.0
2019-09-03 04:21:00	AAPL	Stock	51.675	51.68	51.675	51.675	1200.0
2019-09-03 04:26:00	AAPL	Stock	51.68	51.68	51.68	51.68	404.0
2019-09-03 04:30:00	AAPL	Stock	51.68	51.68	51.66	51.66	5224.0
2019-09-03 04:31:00	AAPL	Stock	51.6525	51.6525	51.6525	51.6525	400.0
2019-09-03 04:32:00	AAPL	Stock	51.635	51.635	51.635	51.635	400.0
2019-09-03 04:33:00	AAPL	Stock	51.6275	51.6275	51.6275	51.6275	1200.0
2019-09-03 04:38:00	AAPL	Stock	51.6675	51.6675	51.6675	51.6675	4472.0
2019-09-03 04:53:00	AAPL	Stock	51.6275	51.6275	51.6275	51.6275	400.0
2019-09-03 05:04:00	AAPL	Stock	51.7325	51.75	51.7	51.7	9560.0
2019-09-03 05:05:00	AAPL	Stock	51.7	51.7525	51.7	51.7525	2000.0
2019-09-03 05:06:00	AAPL	Stock	51.7625	51.7625	51.7625	51.7625	7200.0
2019-09-03 05:15:00	AAPL	Stock	51.75	51.775	51.75	51.75	11800.0
2019-09-03 05:19:00	AAPL	Stock	51.75	51.75	51.75	51.75	11200.0
2019-09-03 05:25:00	AAPL	Stock	51.7575	51.7575	51.7575	51.7575	692.0
2019-09-03 05:27:00	AAPL	Stock	51.6275	51.6275	51.625	51.625	2400.0
2019-09-03 05:29:00	AAPL	Stock	51.63	51.63	51.63	51.63	400.0
2019-09-03 05:42:00	AAPL	Stock	51.55	51.55	51.5275	51.5275	1700.0
2019-09-03 05:43:00	AAPL	Stock	51.5275	51.5275	51.5275	51.5275	2400.0
2019-09-03 05:56:00	AAPL	Stock	51.49	51.49	51.49	51.49	2400.0
2019-09-03 05:57:00	AAPL	Stock	51.525	51.525	51.525	51.525	400.0
2019-09-03 05:59:00	AAPL	Stock	51.475	51.475	51.45	51.45	1680.0
2019-09-03 06:00:00	AAPL	Stock	51.45	51.45	51.425	51.425	1200.0
2019-09-03 06:01:00	AAPL	Stock	51.45	51.45	51.45	51.45	1200.0
2019-09-03 06:02:00	AAPL	Stock	51.4975	51.4975	51.4975	51.4975	1200.0
2019-09-03 06:04:00	AAPL	Stock	51.5875	51.5875	51.5875	51.5875	400.0
2019-09-03 06:05:00	AAPL	Stock	51.5875	51.5875	51.5875	51.5875	400.0
2019-09-03 06:09:00	AAPL	Stock	51.5	51.5	51.5	51.5	452.0
2019-09-03 06:19:00	AAPL	Stock	51.5425	51.5425	51.5425	51.5425	400.0
2019-09-03 06:35:00	AAPL	Stock	51.575	51.575	51.575	51.575	800.0
2019-09-03 06:45:00	AAPL	Stock	51.595	51.595	51.565	51.565	800.0
2019-09-03 06:48:00	AAPL	Stock	51.5675	51.675	51.5675	51.675	3200.0
2019-09-03 06:49:00	AAPL	Stock	51.565	51.565	51.565	51.565	1976.0
2019-09-03 06:53:00	AAPL	Stock	51.565	51.565	51.565	51.565	800.0
2019-09-03 06:54:00	AAPL	Stock	51.625	51.625	51.625	51.625	400.0
2019-09-03 07:00:00	AAPL	Stock	51.575	51.75	51.575	51.6975	8788.0
2019-09-03 07:02:00	AAPL	Stock	51.6925	51.6925	51.6925	51.6925	400.0
2019-09-03 07:05:00	AAPL	Stock	51.625	51.625	51.6	51.6	1200.0
2019-09-03 07:08:00	AAPL	Stock	51.575	51.575	51.5625	51.5625	800.0
2019-09-03 07:09:00	AAPL	Stock	51.6	51.6	51.6	51.6	2800.0
2019-09-03 07:10:00	AAPL	Stock	51.6	51.625	51.6	51.625	1600.0
2019-09-03 07:13:00	AAPL	Stock	51.62	51.625	51.62	51.625	5020.0
2019-09-03 07:14:00	AAPL	Stock	51.625	51.625	51.625	51.625	3576.0
2019-09-03 07:20:00	AAPL	Stock	51.6625	51.6725	51.6625	51.6725	2444.0

> showing 50 of 1,126,325 rows — these rows as CSV

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