PREVIEW / stock_1min / 2015-04-23

all stock 1-min files

  file:    by_date/stock_1min/2015/2015-04-23.parquet
  size:    14.5 MB
  rows:    1,057,740
  symbols: 2,869

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
2015-04-23 04:00:00	AAPL	Stock	32.0025	32.0025	31.965	31.965	800.0
2015-04-23 04:01:00	AAPL	Stock	31.9325	31.9325	31.9325	31.9325	1200.0
2015-04-23 04:04:00	AAPL	Stock	31.9975	31.9975	31.9975	31.9975	604.0
2015-04-23 04:10:00	AAPL	Stock	31.9375	31.9375	31.9375	31.9375	14796.0
2015-04-23 04:13:00	AAPL	Stock	31.9775	31.9775	31.9775	31.9775	400.0
2015-04-23 04:24:00	AAPL	Stock	31.9675	31.9675	31.9675	31.9675	400.0
2015-04-23 04:25:00	AAPL	Stock	31.9675	31.9675	31.9675	31.9675	400.0
2015-04-23 04:33:00	AAPL	Stock	31.93	31.93	31.93	31.93	532.0
2015-04-23 04:40:00	AAPL	Stock	31.9325	31.9325	31.9325	31.9325	1200.0
2015-04-23 04:55:00	AAPL	Stock	31.9375	31.9375	31.9375	31.9375	400.0
2015-04-23 04:56:00	AAPL	Stock	31.955	31.955	31.955	31.955	3192.0
2015-04-23 04:57:00	AAPL	Stock	31.955	31.955	31.955	31.955	800.0
2015-04-23 05:05:00	AAPL	Stock	31.975	31.975	31.975	31.975	400.0
2015-04-23 05:10:00	AAPL	Stock	31.9875	31.9875	31.9875	31.9875	800.0
2015-04-23 05:21:00	AAPL	Stock	32.0225	32.0225	32.0225	32.0225	1040.0
2015-04-23 05:25:00	AAPL	Stock	32.0125	32.0125	32.0125	32.0125	400.0
2015-04-23 05:32:00	AAPL	Stock	31.9825	31.9825	31.9825	31.9825	1600.0
2015-04-23 06:03:00	AAPL	Stock	32.08	32.08	32.08	32.08	16000.0
2015-04-23 06:04:00	AAPL	Stock	32.0475	32.0475	32.0475	32.0475	2000.0
2015-04-23 06:05:00	AAPL	Stock	32.075	32.0875	32.045	32.045	18320.0
2015-04-23 06:06:00	AAPL	Stock	32.075	32.075	32.075	32.075	1200.0
2015-04-23 06:09:00	AAPL	Stock	32.075	32.075	32.075	32.075	4400.0
2015-04-23 06:28:00	AAPL	Stock	32.0425	32.0425	32.0375	32.0375	7788.0
2015-04-23 06:30:00	AAPL	Stock	32.025	32.025	32.0225	32.0225	6000.0
2015-04-23 06:41:00	AAPL	Stock	32.01	32.01	32.01	32.01	6760.0
2015-04-23 06:45:00	AAPL	Stock	32.02	32.025	32.02	32.025	3668.0
2015-04-23 06:59:00	AAPL	Stock	32.0475	32.05	32.0475	32.05	3092.0
2015-04-23 07:00:00	AAPL	Stock	32.0475	32.0475	32.0475	32.0475	400.0
2015-04-23 07:02:00	AAPL	Stock	32.07	32.0725	32.07	32.0725	2000.0
2015-04-23 07:03:00	AAPL	Stock	32.0725	32.075	32.0725	32.075	5000.0
2015-04-23 07:04:00	AAPL	Stock	32.075	32.075	32.0725	32.075	11560.0
2015-04-23 07:05:00	AAPL	Stock	32.0625	32.0875	32.055	32.075	7240.0
2015-04-23 07:06:00	AAPL	Stock	32.085	32.085	32.085	32.085	800.0
2015-04-23 07:07:00	AAPL	Stock	32.085	32.0925	32.085	32.0925	11200.0
2015-04-23 07:09:00	AAPL	Stock	32.085	32.0875	32.085	32.0875	8000.0
2015-04-23 07:10:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	400.0
2015-04-23 07:25:00	AAPL	Stock	32.0825	32.0875	32.0825	32.0825	13160.0
2015-04-23 07:26:00	AAPL	Stock	32.0825	32.0825	32.0825	32.0825	2740.0
2015-04-23 07:32:00	AAPL	Stock	32.07	32.07	32.0575	32.0575	20800.0
2015-04-23 07:33:00	AAPL	Stock	32.0525	32.0625	32.05	32.0625	4176.0
2015-04-23 07:34:00	AAPL	Stock	32.0625	32.0675	32.0625	32.0675	800.0
2015-04-23 07:35:00	AAPL	Stock	32.0525	32.0525	32.0525	32.0525	800.0
2015-04-23 07:36:00	AAPL	Stock	32.05	32.05	32.05	32.05	2400.0
2015-04-23 07:37:00	AAPL	Stock	32.055	32.055	32.055	32.055	1600.0
2015-04-23 07:39:00	AAPL	Stock	32.0625	32.0625	32.0625	32.0625	508.0
2015-04-23 07:40:00	AAPL	Stock	32.07	32.07	32.07	32.07	1600.0
2015-04-23 07:41:00	AAPL	Stock	32.0675	32.0675	32.0675	32.0675	1200.0
2015-04-23 07:42:00	AAPL	Stock	32.08	32.08	32.08	32.08	2000.0
2015-04-23 07:45:00	AAPL	Stock	32.0725	32.075	32.0725	32.075	1200.0
2015-04-23 07:46:00	AAPL	Stock	32.0775	32.0775	32.0775	32.0775	1440.0

> showing 50 of 1,057,740 rows — these rows as CSV

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