PREVIEW / stock_1min / 2017-09-20

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-20.parquet
  size:    14.4 MB
  rows:    1,036,736
  symbols: 2,446

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
2017-09-20 04:00:00	AAPL	Stock	39.605	39.605	39.605	39.605	1408.0
2017-09-20 04:02:00	AAPL	Stock	39.7	39.7	39.7	39.7	492.0
2017-09-20 04:03:00	AAPL	Stock	39.7475	39.7475	39.7475	39.7475	1900.0
2017-09-20 04:16:00	AAPL	Stock	39.7575	39.7575	39.7575	39.7575	400.0
2017-09-20 04:28:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-20 04:47:00	AAPL	Stock	39.725	39.725	39.725	39.725	400.0
2017-09-20 04:50:00	AAPL	Stock	39.725	39.725	39.725	39.725	400.0
2017-09-20 04:51:00	AAPL	Stock	39.725	39.725	39.725	39.725	884.0
2017-09-20 05:29:00	AAPL	Stock	39.7275	39.7275	39.7275	39.7275	800.0
2017-09-20 05:40:00	AAPL	Stock	39.7575	39.7575	39.7575	39.7575	400.0
2017-09-20 05:42:00	AAPL	Stock	39.7575	39.7575	39.7575	39.7575	400.0
2017-09-20 05:45:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-20 05:57:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-20 06:00:00	AAPL	Stock	39.7875	39.7875	39.7875	39.7875	1152.0
2017-09-20 06:09:00	AAPL	Stock	39.725	39.725	39.725	39.725	400.0
2017-09-20 06:13:00	AAPL	Stock	39.7175	39.7175	39.7175	39.7175	400.0
2017-09-20 06:16:00	AAPL	Stock	39.7175	39.7175	39.7175	39.7175	400.0
2017-09-20 06:17:00	AAPL	Stock	39.7175	39.7175	39.7175	39.7175	440.0
2017-09-20 06:22:00	AAPL	Stock	39.7175	39.7175	39.7175	39.7175	400.0
2017-09-20 06:44:00	AAPL	Stock	39.715	39.715	39.715	39.715	400.0
2017-09-20 06:55:00	AAPL	Stock	39.6975	39.6975	39.6975	39.6975	400.0
2017-09-20 06:56:00	AAPL	Stock	39.6975	39.6975	39.6975	39.6975	400.0
2017-09-20 06:57:00	AAPL	Stock	39.685	39.685	39.685	39.685	400.0
2017-09-20 07:00:00	AAPL	Stock	39.6975	39.7125	39.6975	39.7125	1592.0
2017-09-20 07:01:00	AAPL	Stock	39.7025	39.7025	39.7025	39.7025	1600.0
2017-09-20 07:02:00	AAPL	Stock	39.7175	39.725	39.7175	39.725	19528.0
2017-09-20 07:08:00	AAPL	Stock	39.74	39.74	39.725	39.725	8000.0
2017-09-20 07:14:00	AAPL	Stock	39.7225	39.725	39.7225	39.725	2792.0
2017-09-20 07:15:00	AAPL	Stock	39.75	39.75	39.75	39.75	3600.0
2017-09-20 07:25:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-20 07:32:00	AAPL	Stock	39.75	39.75	39.75	39.75	1200.0
2017-09-20 07:33:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-20 07:34:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-20 07:35:00	AAPL	Stock	39.7275	39.7275	39.7275	39.7275	2800.0
2017-09-20 07:40:00	AAPL	Stock	39.7275	39.7275	39.7275	39.7275	400.0
2017-09-20 07:41:00	AAPL	Stock	39.725	39.7275	39.725	39.725	7352.0
2017-09-20 07:42:00	AAPL	Stock	39.725	39.725	39.7225	39.7225	9600.0
2017-09-20 07:43:00	AAPL	Stock	39.735	39.735	39.7275	39.7275	800.0
2017-09-20 07:47:00	AAPL	Stock	39.7125	39.7125	39.7	39.7	12000.0
2017-09-20 07:50:00	AAPL	Stock	39.715	39.715	39.715	39.715	400.0
2017-09-20 07:53:00	AAPL	Stock	39.71	39.71	39.71	39.71	600.0
2017-09-20 07:56:00	AAPL	Stock	39.6875	39.7	39.685	39.6875	4800.0
2017-09-20 07:57:00	AAPL	Stock	39.6875	39.6875	39.685	39.685	10800.0
2017-09-20 07:58:00	AAPL	Stock	39.685	39.685	39.635	39.64	6796.0
2017-09-20 07:59:00	AAPL	Stock	39.6825	39.6825	39.6825	39.6825	400.0
2017-09-20 08:00:00	AAPL	Stock	39.7	39.75	39.675	39.675	14376.0
2017-09-20 08:01:00	AAPL	Stock	39.68	39.68	39.68	39.68	400.0
2017-09-20 08:02:00	AAPL	Stock	39.6625	39.6625	39.65	39.65	1876.0
2017-09-20 08:03:00	AAPL	Stock	39.6475	39.65	39.6475	39.65	1000.0
2017-09-20 08:04:00	AAPL	Stock	39.65	39.65	39.65	39.65	9380.0

> showing 50 of 1,036,736 rows — these rows as CSV

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