PREVIEW / stock_1min / 2017-01-20

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-20.parquet
  size:    13.9 MB
  rows:    1,019,895
  symbols: 2,544

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-01-20 04:12:00	AAPL	Stock	29.9475	29.9475	29.945	29.945	1600.0
2017-01-20 05:49:00	AAPL	Stock	29.995	30.0	29.995	30.0	1924.0
2017-01-20 06:16:00	AAPL	Stock	30.035	30.035	30.0225	30.0225	1952.0
2017-01-20 06:21:00	AAPL	Stock	30.0225	30.0425	30.0225	30.0425	1852.0
2017-01-20 06:54:00	AAPL	Stock	30.0325	30.0375	30.0325	30.0375	1200.0
2017-01-20 07:03:00	AAPL	Stock	30.0425	30.0425	30.0425	30.0425	400.0
2017-01-20 07:07:00	AAPL	Stock	30.035	30.035	30.035	30.035	4000.0
2017-01-20 07:10:00	AAPL	Stock	30.035	30.035	30.035	30.035	16000.0
2017-01-20 07:15:00	AAPL	Stock	30.035	30.035	30.035	30.035	4000.0
2017-01-20 07:17:00	AAPL	Stock	30.035	30.035	30.035	30.035	400.0
2017-01-20 07:23:00	AAPL	Stock	30.0375	30.04	30.0375	30.04	800.0
2017-01-20 07:28:00	AAPL	Stock	30.0375	30.0375	30.0375	30.0375	1200.0
2017-01-20 07:30:00	AAPL	Stock	30.035	30.035	30.035	30.035	400.0
2017-01-20 07:33:00	AAPL	Stock	30.03	30.03	30.025	30.025	4252.0
2017-01-20 07:37:00	AAPL	Stock	30.0225	30.0225	30.02	30.02	4000.0
2017-01-20 07:39:00	AAPL	Stock	30.02	30.02	30.02	30.02	880.0
2017-01-20 07:42:00	AAPL	Stock	30.02	30.02	30.02	30.02	17504.0
2017-01-20 07:43:00	AAPL	Stock	30.02	30.02	30.02	30.02	4000.0
2017-01-20 07:55:00	AAPL	Stock	30.025	30.025	30.025	30.025	400.0
2017-01-20 07:56:00	AAPL	Stock	30.0375	30.04	30.0275	30.0275	6352.0
2017-01-20 07:57:00	AAPL	Stock	30.0425	30.05	30.0425	30.045	13052.0
2017-01-20 07:59:00	AAPL	Stock	30.05	30.05	30.05	30.05	920.0
2017-01-20 08:00:00	AAPL	Stock	30.05	30.05	30.035	30.0475	24956.0
2017-01-20 08:01:00	AAPL	Stock	30.045	30.045	30.045	30.045	400.0
2017-01-20 08:02:00	AAPL	Stock	29.875	30.045	29.875	30.045	9340.0
2017-01-20 08:03:00	AAPL	Stock	30.0375	30.0375	30.0375	30.0375	4000.0
2017-01-20 08:05:00	AAPL	Stock	30.0425	30.0425	30.0375	30.0375	2400.0
2017-01-20 08:06:00	AAPL	Stock	30.0275	30.03	30.025	30.025	4000.0
2017-01-20 08:09:00	AAPL	Stock	30.025	30.025	30.025	30.025	2000.0
2017-01-20 08:10:00	AAPL	Stock	30.025	30.025	30.025	30.025	1200.0
2017-01-20 08:11:00	AAPL	Stock	30.035	30.0375	30.0325	30.0325	4800.0
2017-01-20 08:15:00	AAPL	Stock	30.025	30.025	30.025	30.025	2400.0
2017-01-20 08:18:00	AAPL	Stock	30.0275	30.0275	30.0275	30.0275	800.0
2017-01-20 08:19:00	AAPL	Stock	30.0475	30.0525	30.0475	30.0525	6400.0
2017-01-20 08:20:00	AAPL	Stock	30.0275	30.035	30.0275	30.035	4400.0
2017-01-20 08:21:00	AAPL	Stock	30.035	30.035	30.0275	30.035	8764.0
2017-01-20 08:22:00	AAPL	Stock	30.0325	30.05	30.0325	30.0325	1600.0
2017-01-20 08:26:00	AAPL	Stock	30.0375	30.0375	30.0375	30.0375	2864.0
2017-01-20 08:28:00	AAPL	Stock	30.0375	30.0375	30.0325	30.0375	7152.0
2017-01-20 08:30:00	AAPL	Stock	30.035	30.035	30.035	30.035	400.0
2017-01-20 08:31:00	AAPL	Stock	30.0375	30.0375	30.0375	30.0375	5800.0
2017-01-20 08:33:00	AAPL	Stock	30.05	30.05	30.0125	30.0125	1916.0
2017-01-20 08:35:00	AAPL	Stock	30.04	30.04	30.04	30.04	6000.0
2017-01-20 08:36:00	AAPL	Stock	30.0475	30.05	30.0475	30.05	2400.0
2017-01-20 08:37:00	AAPL	Stock	30.05	30.055	30.05	30.05	10924.0
2017-01-20 08:38:00	AAPL	Stock	30.055	30.055	30.055	30.055	2000.0
2017-01-20 08:39:00	AAPL	Stock	30.05	30.055	30.05	30.055	4096.0
2017-01-20 08:40:00	AAPL	Stock	30.055	30.055	30.055	30.055	2000.0
2017-01-20 08:41:00	AAPL	Stock	30.0575	30.06	30.055	30.055	3596.0
2017-01-20 08:42:00	AAPL	Stock	30.0575	30.06	30.0575	30.06	800.0

> showing 50 of 1,019,895 rows — these rows as CSV

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