PREVIEW / stock_1min / 2018-03-20

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-03-20.parquet
  size:    14.6 MB
  rows:    1,058,756
  symbols: 2,398

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
2018-03-20 04:45:00	AAPL	Stock	43.8775	43.8775	43.875	43.875	1200.0
2018-03-20 05:46:00	AAPL	Stock	43.8675	43.8725	43.8675	43.8725	5196.0
2018-03-20 06:04:00	AAPL	Stock	43.835	43.835	43.835	43.835	420.0
2018-03-20 06:42:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	1200.0
2018-03-20 06:54:00	AAPL	Stock	43.875	43.895	43.875	43.895	1804.0
2018-03-20 07:00:00	AAPL	Stock	43.85	43.87	43.85	43.87	4288.0
2018-03-20 07:01:00	AAPL	Stock	43.925	43.925	43.925	43.925	1200.0
2018-03-20 07:11:00	AAPL	Stock	43.9025	43.9025	43.9025	43.9025	400.0
2018-03-20 07:21:00	AAPL	Stock	43.925	43.925	43.925	43.925	800.0
2018-03-20 07:22:00	AAPL	Stock	43.9125	43.925	43.9125	43.9175	3556.0
2018-03-20 07:24:00	AAPL	Stock	43.925	43.9275	43.925	43.9275	3804.0
2018-03-20 07:25:00	AAPL	Stock	43.9275	43.9275	43.9275	43.9275	4400.0
2018-03-20 07:26:00	AAPL	Stock	43.9375	43.975	43.9375	43.975	21496.0
2018-03-20 07:27:00	AAPL	Stock	43.9875	44.02	43.9875	44.0125	3300.0
2018-03-20 07:28:00	AAPL	Stock	44.0125	44.0425	44.0125	44.04	22380.0
2018-03-20 07:29:00	AAPL	Stock	44.04	44.04	44.04	44.04	400.0
2018-03-20 07:30:00	AAPL	Stock	44.0425	44.0425	44.0425	44.0425	400.0
2018-03-20 07:32:00	AAPL	Stock	44.045	44.045	44.045	44.045	560.0
2018-03-20 07:34:00	AAPL	Stock	44.05	44.0525	44.05	44.0525	7728.0
2018-03-20 07:36:00	AAPL	Stock	44.04	44.04	44.0325	44.0325	3008.0
2018-03-20 07:40:00	AAPL	Stock	44.0525	44.0525	44.0525	44.0525	1704.0
2018-03-20 07:41:00	AAPL	Stock	44.03	44.0575	44.0275	44.0575	5564.0
2018-03-20 07:42:00	AAPL	Stock	44.055	44.0575	44.055	44.0575	1600.0
2018-03-20 07:44:00	AAPL	Stock	44.04	44.04	44.04	44.04	4000.0
2018-03-20 07:45:00	AAPL	Stock	44.0575	44.0575	44.0575	44.0575	832.0
2018-03-20 07:50:00	AAPL	Stock	44.02	44.02	44.02	44.02	400.0
2018-03-20 07:51:00	AAPL	Stock	44.01	44.01	44.0075	44.0075	4000.0
2018-03-20 07:55:00	AAPL	Stock	44.0	44.005	44.0	44.0025	2780.0
2018-03-20 07:56:00	AAPL	Stock	44.005	44.0075	44.005	44.0075	3096.0
2018-03-20 07:58:00	AAPL	Stock	44.0	44.0	44.0	44.0	400.0
2018-03-20 08:00:00	AAPL	Stock	44.045	44.0625	43.835	44.005	53860.0
2018-03-20 08:01:00	AAPL	Stock	43.995	44.0175	43.995	44.0175	5752.0
2018-03-20 08:02:00	AAPL	Stock	44.0125	44.0125	44.0125	44.0125	1000.0
2018-03-20 08:03:00	AAPL	Stock	44.0	44.04	44.0	44.04	18560.0
2018-03-20 08:04:00	AAPL	Stock	44.035	44.035	44.035	44.035	3816.0
2018-03-20 08:05:00	AAPL	Stock	44.015	44.015	44.01	44.01	800.0
2018-03-20 08:06:00	AAPL	Stock	44.01	44.015	44.01	44.01	20328.0
2018-03-20 08:07:00	AAPL	Stock	44.0075	44.01	44.0075	44.01	6632.0
2018-03-20 08:09:00	AAPL	Stock	44.0	44.0	44.0	44.0	800.0
2018-03-20 08:10:00	AAPL	Stock	43.985	43.985	43.9775	43.9775	2800.0
2018-03-20 08:11:00	AAPL	Stock	43.98	43.98	43.98	43.98	11600.0
2018-03-20 08:12:00	AAPL	Stock	43.9725	43.9725	43.9675	43.9725	5200.0
2018-03-20 08:13:00	AAPL	Stock	43.9625	43.9625	43.9625	43.9625	1000.0
2018-03-20 08:14:00	AAPL	Stock	43.9875	43.9875	43.9875	43.9875	544.0
2018-03-20 08:15:00	AAPL	Stock	43.985	43.985	43.965	43.965	1200.0
2018-03-20 08:16:00	AAPL	Stock	43.9675	43.9675	43.9675	43.9675	400.0
2018-03-20 08:18:00	AAPL	Stock	43.9975	43.9975	43.975	43.975	4500.0
2018-03-20 08:20:00	AAPL	Stock	43.9625	43.9875	43.9625	43.9875	14444.0
2018-03-20 08:21:00	AAPL	Stock	43.9875	43.9875	43.9875	43.9875	400.0
2018-03-20 08:23:00	AAPL	Stock	44.005	44.0125	44.005	44.0125	1200.0

> showing 50 of 1,058,756 rows — these rows as CSV

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