PREVIEW / stock_1min / 2018-08-03

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-08-03.parquet
  size:    14.6 MB
  rows:    1,054,934
  symbols: 2,322

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-08-03 04:00:00	AAPL	Stock	51.65	51.75	51.625	51.75	9452.0
2018-08-03 04:05:00	AAPL	Stock	51.71	51.71	51.71	51.71	800.0
2018-08-03 04:13:00	AAPL	Stock	51.72	51.72	51.72	51.72	400.0
2018-08-03 04:14:00	AAPL	Stock	51.7125	51.7125	51.7125	51.7125	4400.0
2018-08-03 04:15:00	AAPL	Stock	51.7125	51.7125	51.7125	51.7125	400.0
2018-08-03 04:17:00	AAPL	Stock	51.7125	51.7125	51.7125	51.7125	2580.0
2018-08-03 04:20:00	AAPL	Stock	51.7125	51.7125	51.7125	51.7125	400.0
2018-08-03 04:23:00	AAPL	Stock	51.7125	51.7125	51.7125	51.7125	800.0
2018-08-03 04:24:00	AAPL	Stock	51.7025	51.7025	51.7025	51.7025	2800.0
2018-08-03 04:25:00	AAPL	Stock	51.7025	51.7025	51.7025	51.7025	1200.0
2018-08-03 04:29:00	AAPL	Stock	51.67	51.67	51.665	51.665	1900.0
2018-08-03 04:31:00	AAPL	Stock	51.67	51.67	51.665	51.665	7700.0
2018-08-03 04:36:00	AAPL	Stock	51.655	51.655	51.655	51.655	1660.0
2018-08-03 04:38:00	AAPL	Stock	51.66	51.66	51.655	51.655	2800.0
2018-08-03 04:39:00	AAPL	Stock	51.655	51.655	51.655	51.655	4400.0
2018-08-03 04:40:00	AAPL	Stock	51.655	51.655	51.655	51.655	1000.0
2018-08-03 05:16:00	AAPL	Stock	51.66	51.66	51.66	51.66	568.0
2018-08-03 05:40:00	AAPL	Stock	51.7	51.7	51.7	51.7	400.0
2018-08-03 05:48:00	AAPL	Stock	51.7075	51.7075	51.7075	51.7075	400.0
2018-08-03 05:53:00	AAPL	Stock	51.665	51.665	51.665	51.665	876.0
2018-08-03 05:59:00	AAPL	Stock	51.685	51.685	51.685	51.685	2816.0
2018-08-03 06:00:00	AAPL	Stock	51.685	51.685	51.685	51.685	800.0
2018-08-03 06:04:00	AAPL	Stock	51.67	51.67	51.6625	51.6625	1660.0
2018-08-03 06:29:00	AAPL	Stock	51.675	51.675	51.675	51.675	520.0
2018-08-03 06:35:00	AAPL	Stock	51.6625	51.6625	51.6625	51.6625	2000.0
2018-08-03 06:37:00	AAPL	Stock	51.675	51.675	51.675	51.675	6400.0
2018-08-03 06:52:00	AAPL	Stock	51.7	51.725	51.7	51.725	6412.0
2018-08-03 06:53:00	AAPL	Stock	51.7375	51.7425	51.7375	51.7425	1600.0
2018-08-03 06:59:00	AAPL	Stock	51.725	51.725	51.725	51.725	400.0
2018-08-03 07:00:00	AAPL	Stock	51.74	51.7425	51.74	51.7425	1192.0
2018-08-03 07:01:00	AAPL	Stock	51.7425	51.7425	51.7425	51.7425	400.0
2018-08-03 07:02:00	AAPL	Stock	51.7475	51.765	51.7475	51.765	18388.0
2018-08-03 07:03:00	AAPL	Stock	51.77	51.7775	51.77	51.7775	1200.0
2018-08-03 07:04:00	AAPL	Stock	51.7825	51.7875	51.775	51.775	3100.0
2018-08-03 07:05:00	AAPL	Stock	51.765	51.765	51.765	51.765	400.0
2018-08-03 07:06:00	AAPL	Stock	51.7875	51.8	51.7875	51.8	7704.0
2018-08-03 07:07:00	AAPL	Stock	51.79	51.8	51.7875	51.7975	19412.0
2018-08-03 07:08:00	AAPL	Stock	51.8025	51.8025	51.8	51.8	8000.0
2018-08-03 07:09:00	AAPL	Stock	51.8	51.8	51.7875	51.8	4684.0
2018-08-03 07:10:00	AAPL	Stock	51.7975	51.8225	51.7975	51.8225	29388.0
2018-08-03 07:12:00	AAPL	Stock	51.8225	51.8225	51.82	51.82	800.0
2018-08-03 07:13:00	AAPL	Stock	51.8125	51.8225	51.81	51.8225	4400.0
2018-08-03 07:14:00	AAPL	Stock	51.81	51.8375	51.81	51.8375	8128.0
2018-08-03 07:15:00	AAPL	Stock	51.835	51.8375	51.835	51.8375	7600.0
2018-08-03 07:17:00	AAPL	Stock	51.845	51.8475	51.84	51.84	3600.0
2018-08-03 07:18:00	AAPL	Stock	51.825	51.825	51.825	51.825	1200.0
2018-08-03 07:19:00	AAPL	Stock	51.8375	51.8375	51.785	51.785	28356.0
2018-08-03 07:20:00	AAPL	Stock	51.785	51.8075	51.785	51.785	15600.0
2018-08-03 07:21:00	AAPL	Stock	51.7975	51.7975	51.7975	51.7975	400.0
2018-08-03 07:22:00	AAPL	Stock	51.7975	51.8	51.78	51.78	21472.0

> showing 50 of 1,054,934 rows — these rows as CSV

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