PREVIEW / stock_1min / 2017-12-18

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-12-18.parquet
  size:    16.3 MB
  rows:    1,144,456
  symbols: 2,448

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-12-18 04:00:00	AAPL	Stock	43.56	43.595	43.56	43.595	7800.0
2017-12-18 04:13:00	AAPL	Stock	43.7125	43.7425	43.7125	43.7425	1864.0
2017-12-18 04:14:00	AAPL	Stock	43.7375	43.7375	43.7375	43.7375	5720.0
2017-12-18 04:19:00	AAPL	Stock	43.7	43.7	43.7	43.7	464.0
2017-12-18 04:24:00	AAPL	Stock	43.6975	43.7	43.6975	43.7	1444.0
2017-12-18 04:25:00	AAPL	Stock	43.7225	43.725	43.7225	43.725	1840.0
2017-12-18 04:26:00	AAPL	Stock	43.745	43.745	43.745	43.745	800.0
2017-12-18 04:27:00	AAPL	Stock	43.75	43.75	43.75	43.75	1200.0
2017-12-18 04:33:00	AAPL	Stock	43.76	43.7675	43.76	43.7675	5684.0
2017-12-18 04:43:00	AAPL	Stock	43.7675	43.7675	43.7675	43.7675	1200.0
2017-12-18 04:49:00	AAPL	Stock	43.7075	43.7075	43.7075	43.7075	400.0
2017-12-18 05:37:00	AAPL	Stock	43.7275	43.7275	43.7275	43.7275	400.0
2017-12-18 05:41:00	AAPL	Stock	43.73	43.73	43.73	43.73	800.0
2017-12-18 05:42:00	AAPL	Stock	43.75	43.75	43.75	43.75	400.0
2017-12-18 05:43:00	AAPL	Stock	43.75	43.75	43.75	43.75	400.0
2017-12-18 05:46:00	AAPL	Stock	43.7675	43.7675	43.7675	43.7675	800.0
2017-12-18 05:50:00	AAPL	Stock	43.76	43.7625	43.76	43.7625	2044.0
2017-12-18 06:01:00	AAPL	Stock	43.78	43.78	43.78	43.78	2000.0
2017-12-18 06:02:00	AAPL	Stock	43.78	43.78	43.78	43.78	2024.0
2017-12-18 06:03:00	AAPL	Stock	43.7925	43.8075	43.7925	43.8075	5200.0
2017-12-18 06:04:00	AAPL	Stock	43.8175	43.975	43.8175	43.975	63096.0
2017-12-18 06:05:00	AAPL	Stock	43.8125	43.8125	43.8125	43.8125	400.0
2017-12-18 06:12:00	AAPL	Stock	43.85	43.85	43.85	43.85	400.0
2017-12-18 06:14:00	AAPL	Stock	43.8525	43.8525	43.8525	43.8525	400.0
2017-12-18 06:15:00	AAPL	Stock	43.855	43.855	43.855	43.855	2872.0
2017-12-18 06:29:00	AAPL	Stock	43.85	43.85	43.85	43.85	400.0
2017-12-18 06:35:00	AAPL	Stock	43.85	43.8625	43.85	43.8625	2900.0
2017-12-18 06:51:00	AAPL	Stock	43.8575	43.8575	43.8575	43.8575	400.0
2017-12-18 06:58:00	AAPL	Stock	43.8375	43.8375	43.83	43.83	2000.0
2017-12-18 07:00:00	AAPL	Stock	43.8175	43.8175	43.7875	43.7875	39536.0
2017-12-18 07:01:00	AAPL	Stock	43.8	43.84	43.8	43.84	7704.0
2017-12-18 07:02:00	AAPL	Stock	43.8375	43.8375	43.825	43.825	5276.0
2017-12-18 07:03:00	AAPL	Stock	43.8375	43.8375	43.8375	43.8375	800.0
2017-12-18 07:04:00	AAPL	Stock	43.825	43.825	43.8	43.8	3160.0
2017-12-18 07:05:00	AAPL	Stock	43.825	43.825	43.825	43.825	1200.0
2017-12-18 07:06:00	AAPL	Stock	43.8025	43.8025	43.75	43.75	12000.0
2017-12-18 07:08:00	AAPL	Stock	43.775	43.775	43.725	43.725	11756.0
2017-12-18 07:09:00	AAPL	Stock	43.725	43.7425	43.725	43.7425	2652.0
2017-12-18 07:11:00	AAPL	Stock	43.75	43.7625	43.75	43.7625	800.0
2017-12-18 07:12:00	AAPL	Stock	43.75	43.75	43.75	43.75	1600.0
2017-12-18 07:13:00	AAPL	Stock	43.7375	43.7375	43.7375	43.7375	400.0
2017-12-18 07:14:00	AAPL	Stock	43.75	43.75	43.7375	43.7375	2180.0
2017-12-18 07:15:00	AAPL	Stock	43.7375	43.7375	43.7375	43.7375	800.0
2017-12-18 07:16:00	AAPL	Stock	43.7525	43.7525	43.7525	43.7525	400.0
2017-12-18 07:17:00	AAPL	Stock	43.7525	43.7525	43.7525	43.7525	640.0
2017-12-18 07:18:00	AAPL	Stock	43.775	43.775	43.75	43.75	2160.0
2017-12-18 07:21:00	AAPL	Stock	43.75	43.75	43.7375	43.7375	1676.0
2017-12-18 07:22:00	AAPL	Stock	43.7375	43.7375	43.7375	43.7375	1452.0
2017-12-18 07:24:00	AAPL	Stock	43.7425	43.7425	43.7425	43.7425	1200.0
2017-12-18 07:26:00	AAPL	Stock	43.75	43.78	43.75	43.78	1600.0

> showing 50 of 1,144,456 rows — these rows as CSV

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