PREVIEW / stock_1min / 2017-09-26

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-26.parquet
  size:    14.2 MB
  rows:    1,028,127
  symbols: 2,438

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-26 04:00:00	AAPL	Stock	37.6475	37.6475	37.6475	37.6475	504.0
2017-09-26 04:01:00	AAPL	Stock	37.6625	37.6625	37.6625	37.6625	1536.0
2017-09-26 04:16:00	AAPL	Stock	37.6625	37.6625	37.6625	37.6625	3604.0
2017-09-26 04:19:00	AAPL	Stock	37.675	37.675	37.675	37.675	3600.0
2017-09-26 04:24:00	AAPL	Stock	37.72	37.72	37.72	37.72	800.0
2017-09-26 04:35:00	AAPL	Stock	37.735	37.735	37.735	37.735	400.0
2017-09-26 04:46:00	AAPL	Stock	37.745	37.745	37.745	37.745	800.0
2017-09-26 04:55:00	AAPL	Stock	37.7925	37.8	37.7925	37.8	2736.0
2017-09-26 04:58:00	AAPL	Stock	37.8	37.8	37.7925	37.7925	4400.0
2017-09-26 05:06:00	AAPL	Stock	37.795	37.795	37.795	37.795	400.0
2017-09-26 05:08:00	AAPL	Stock	37.795	37.795	37.795	37.795	400.0
2017-09-26 05:11:00	AAPL	Stock	37.775	37.775	37.775	37.775	1800.0
2017-09-26 05:17:00	AAPL	Stock	37.8025	37.8025	37.8025	37.8025	400.0
2017-09-26 05:24:00	AAPL	Stock	37.8075	37.8375	37.8075	37.8375	19060.0
2017-09-26 05:34:00	AAPL	Stock	37.8375	37.8375	37.8375	37.8375	400.0
2017-09-26 05:46:00	AAPL	Stock	37.8325	37.8325	37.8325	37.8325	1200.0
2017-09-26 05:49:00	AAPL	Stock	37.85	37.875	37.845	37.85	25228.0
2017-09-26 05:52:00	AAPL	Stock	37.8675	37.885	37.8675	37.885	1600.0
2017-09-26 05:54:00	AAPL	Stock	37.885	37.885	37.885	37.885	800.0
2017-09-26 05:58:00	AAPL	Stock	37.8625	37.8625	37.8625	37.8625	800.0
2017-09-26 05:59:00	AAPL	Stock	37.8625	37.8625	37.8625	37.8625	4800.0
2017-09-26 06:00:00	AAPL	Stock	37.86	37.86	37.86	37.86	400.0
2017-09-26 06:01:00	AAPL	Stock	37.845	37.845	37.845	37.845	2000.0
2017-09-26 06:14:00	AAPL	Stock	37.8175	37.8175	37.8175	37.8175	400.0
2017-09-26 06:18:00	AAPL	Stock	37.825	37.8325	37.825	37.8325	2000.0
2017-09-26 06:22:00	AAPL	Stock	37.8325	37.8325	37.8325	37.8325	1200.0
2017-09-26 06:23:00	AAPL	Stock	37.8475	37.8475	37.8475	37.8475	400.0
2017-09-26 06:24:00	AAPL	Stock	37.8475	37.8475	37.8475	37.8475	5040.0
2017-09-26 06:25:00	AAPL	Stock	37.8475	37.8475	37.8475	37.8475	3308.0
2017-09-26 06:26:00	AAPL	Stock	37.8475	37.8475	37.8475	37.8475	800.0
2017-09-26 06:33:00	AAPL	Stock	37.8475	37.8475	37.8475	37.8475	800.0
2017-09-26 06:37:00	AAPL	Stock	37.8725	37.8725	37.8725	37.8725	2120.0
2017-09-26 06:39:00	AAPL	Stock	37.8725	37.88	37.8725	37.88	7060.0
2017-09-26 06:40:00	AAPL	Stock	37.8875	37.8875	37.8875	37.8875	400.0
2017-09-26 06:41:00	AAPL	Stock	37.885	37.885	37.875	37.875	6240.0
2017-09-26 06:42:00	AAPL	Stock	37.875	37.875	37.875	37.875	2000.0
2017-09-26 06:43:00	AAPL	Stock	37.875	37.875	37.875	37.875	11200.0
2017-09-26 06:47:00	AAPL	Stock	37.8775	37.8775	37.8775	37.8775	400.0
2017-09-26 06:48:00	AAPL	Stock	37.88	37.88	37.875	37.875	7600.0
2017-09-26 06:49:00	AAPL	Stock	37.875	37.8925	37.875	37.8875	3200.0
2017-09-26 06:50:00	AAPL	Stock	37.895	37.895	37.895	37.895	400.0
2017-09-26 06:51:00	AAPL	Stock	37.8875	37.8875	37.88	37.88	2000.0
2017-09-26 06:52:00	AAPL	Stock	37.8875	37.8875	37.8875	37.8875	2400.0
2017-09-26 06:55:00	AAPL	Stock	37.895	37.895	37.8825	37.8825	2620.0
2017-09-26 06:56:00	AAPL	Stock	37.88	37.88	37.88	37.88	6768.0
2017-09-26 06:57:00	AAPL	Stock	37.88	37.895	37.875	37.895	7204.0
2017-09-26 06:58:00	AAPL	Stock	37.875	37.875	37.875	37.875	480.0
2017-09-26 07:00:00	AAPL	Stock	37.88	37.8875	37.8525	37.8525	15252.0
2017-09-26 07:01:00	AAPL	Stock	37.8525	37.8625	37.83	37.8625	4800.0
2017-09-26 07:02:00	AAPL	Stock	37.83	37.83	37.8275	37.8275	1240.0

> showing 50 of 1,028,127 rows — these rows as CSV

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