PREVIEW / stock_1min / 2017-01-18

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-18.parquet
  size:    14.1 MB
  rows:    1,028,857
  symbols: 2,581

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-18 04:06:00	AAPL	Stock	30.0	30.0	30.0	30.0	1200.0
2017-01-18 04:14:00	AAPL	Stock	30.0	30.0	30.0	30.0	1432.0
2017-01-18 05:41:00	AAPL	Stock	30.0	30.0	30.0	30.0	628.0
2017-01-18 05:44:00	AAPL	Stock	30.0325	30.0325	30.0325	30.0325	1248.0
2017-01-18 05:45:00	AAPL	Stock	30.0325	30.0325	30.0325	30.0325	1600.0
2017-01-18 06:23:00	AAPL	Stock	29.9775	29.9775	29.975	29.975	4052.0
2017-01-18 06:27:00	AAPL	Stock	30.0475	30.05	30.0475	30.05	3664.0
2017-01-18 06:30:00	AAPL	Stock	30.0475	30.0475	30.0475	30.0475	4000.0
2017-01-18 06:33:00	AAPL	Stock	30.025	30.025	30.025	30.025	4000.0
2017-01-18 06:35:00	AAPL	Stock	30.025	30.025	30.025	30.025	400.0
2017-01-18 06:36:00	AAPL	Stock	30.025	30.025	30.025	30.025	3200.0
2017-01-18 06:46:00	AAPL	Stock	30.025	30.025	30.025	30.025	2400.0
2017-01-18 06:52:00	AAPL	Stock	30.0025	30.0025	30.0025	30.0025	800.0
2017-01-18 07:00:00	AAPL	Stock	30.0025	30.0025	30.0	30.0	1600.0
2017-01-18 07:03:00	AAPL	Stock	30.0	30.0	30.0	30.0	8800.0
2017-01-18 07:06:00	AAPL	Stock	30.0	30.0	30.0	30.0	4448.0
2017-01-18 07:09:00	AAPL	Stock	29.9825	29.9825	29.98	29.9825	2800.0
2017-01-18 07:16:00	AAPL	Stock	30.025	30.025	30.025	30.025	400.0
2017-01-18 07:23:00	AAPL	Stock	29.9825	29.99	29.975	29.975	10800.0
2017-01-18 07:58:00	AAPL	Stock	29.9975	30.0125	29.9975	30.0125	3784.0
2017-01-18 07:59:00	AAPL	Stock	30.015	30.015	30.015	30.015	1200.0
2017-01-18 08:00:00	AAPL	Stock	30.0175	30.0175	29.9975	30.0	11564.0
2017-01-18 08:01:00	AAPL	Stock	30.0025	30.0025	30.0	30.0	4400.0
2017-01-18 08:02:00	AAPL	Stock	30.0	30.0	30.0	30.0	400.0
2017-01-18 08:04:00	AAPL	Stock	30.02	30.02	30.02	30.02	400.0
2017-01-18 08:05:00	AAPL	Stock	30.0025	30.0025	30.0025	30.0025	400.0
2017-01-18 08:07:00	AAPL	Stock	30.0125	30.0125	30.0	30.0	11124.0
2017-01-18 08:08:00	AAPL	Stock	30.0125	30.0125	30.0125	30.0125	400.0
2017-01-18 08:10:00	AAPL	Stock	30.02	30.02	30.0025	30.0025	2940.0
2017-01-18 08:11:00	AAPL	Stock	30.025	30.03	30.025	30.03	4400.0
2017-01-18 08:12:00	AAPL	Stock	30.0025	30.03	30.0025	30.005	3000.0
2017-01-18 08:15:00	AAPL	Stock	30.02	30.02	30.02	30.02	1200.0
2017-01-18 08:16:00	AAPL	Stock	30.02	30.02	30.02	30.02	800.0
2017-01-18 08:21:00	AAPL	Stock	30.03	30.03	30.03	30.03	1004.0
2017-01-18 08:23:00	AAPL	Stock	30.01	30.01	30.0	30.0	10144.0
2017-01-18 08:27:00	AAPL	Stock	30.025	30.025	30.025	30.025	1740.0
2017-01-18 08:31:00	AAPL	Stock	30.0375	30.0375	30.0375	30.0375	800.0
2017-01-18 08:33:00	AAPL	Stock	30.0125	30.025	30.0125	30.025	10400.0
2017-01-18 08:34:00	AAPL	Stock	30.025	30.025	30.025	30.025	4000.0
2017-01-18 08:36:00	AAPL	Stock	30.025	30.025	30.025	30.025	2400.0
2017-01-18 08:37:00	AAPL	Stock	30.025	30.025	30.025	30.025	1200.0
2017-01-18 08:38:00	AAPL	Stock	30.03	30.03	30.03	30.03	2000.0
2017-01-18 08:39:00	AAPL	Stock	30.03	30.035	30.03	30.035	1600.0
2017-01-18 08:43:00	AAPL	Stock	30.0375	30.0375	30.025	30.0375	6400.0
2017-01-18 08:45:00	AAPL	Stock	30.0375	30.0375	30.035	30.0375	3800.0
2017-01-18 08:46:00	AAPL	Stock	30.04	30.04	30.04	30.04	4000.0
2017-01-18 08:48:00	AAPL	Stock	30.035	30.035	30.0325	30.0325	2800.0
2017-01-18 08:50:00	AAPL	Stock	30.0275	30.0275	30.0275	30.0275	656.0
2017-01-18 08:51:00	AAPL	Stock	30.03	30.03	30.03	30.03	1344.0
2017-01-18 08:52:00	AAPL	Stock	30.025	30.03	30.025	30.03	8400.0

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

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