PREVIEW / stock_1min / 2017-04-25

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-04-25.parquet
  size:    15.2 MB
  rows:    1,094,169
  symbols: 2,538

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-04-25 04:21:00	AAPL	Stock	35.985	35.985	35.985	35.985	4000.0
2017-04-25 05:06:00	AAPL	Stock	35.975	35.975	35.975	35.975	800.0
2017-04-25 05:28:00	AAPL	Stock	35.975	35.975	35.9625	35.9625	5616.0
2017-04-25 07:20:00	AAPL	Stock	35.975	35.975	35.975	35.975	4000.0
2017-04-25 07:26:00	AAPL	Stock	35.975	35.975	35.975	35.975	6000.0
2017-04-25 07:27:00	AAPL	Stock	35.97	35.97	35.9675	35.9675	800.0
2017-04-25 07:28:00	AAPL	Stock	35.97	35.97	35.965	35.9675	1600.0
2017-04-25 07:32:00	AAPL	Stock	35.985	35.985	35.985	35.985	5400.0
2017-04-25 07:33:00	AAPL	Stock	35.985	35.985	35.985	35.985	400.0
2017-04-25 07:34:00	AAPL	Stock	35.975	35.975	35.975	35.975	400.0
2017-04-25 07:35:00	AAPL	Stock	35.985	35.9875	35.985	35.9875	7600.0
2017-04-25 07:43:00	AAPL	Stock	35.9875	35.9875	35.9875	35.9875	2000.0
2017-04-25 07:57:00	AAPL	Stock	35.99	35.99	35.99	35.99	4772.0
2017-04-25 08:00:00	AAPL	Stock	35.99	35.9925	35.98	35.99	11492.0
2017-04-25 08:01:00	AAPL	Stock	35.99	35.99	35.99	35.99	600.0
2017-04-25 08:02:00	AAPL	Stock	35.99	35.99	35.99	35.99	2000.0
2017-04-25 08:04:00	AAPL	Stock	35.99	35.99	35.99	35.99	1320.0
2017-04-25 08:05:00	AAPL	Stock	35.99	35.99	35.99	35.99	400.0
2017-04-25 08:06:00	AAPL	Stock	35.99	35.99	35.99	35.99	1600.0
2017-04-25 08:08:00	AAPL	Stock	35.995	35.995	35.9875	35.9875	3200.0
2017-04-25 08:09:00	AAPL	Stock	35.995	35.995	35.995	35.995	3348.0
2017-04-25 08:10:00	AAPL	Stock	35.995	36.0	35.995	36.0	12640.0
2017-04-25 08:11:00	AAPL	Stock	36.005	36.005	36.005	36.005	1200.0
2017-04-25 08:13:00	AAPL	Stock	36.0075	36.01	36.005	36.01	2800.0
2017-04-25 08:14:00	AAPL	Stock	36.0125	36.015	36.0125	36.015	6300.0
2017-04-25 08:15:00	AAPL	Stock	36.015	36.0225	36.015	36.015	2400.0
2017-04-25 08:17:00	AAPL	Stock	36.02	36.02	36.02	36.02	600.0
2017-04-25 08:21:00	AAPL	Stock	36.015	36.015	36.015	36.015	800.0
2017-04-25 08:23:00	AAPL	Stock	36.015	36.015	36.01	36.015	7920.0
2017-04-25 08:24:00	AAPL	Stock	36.0225	36.0225	36.0225	36.0225	580.0
2017-04-25 08:26:00	AAPL	Stock	36.0225	36.0225	36.0225	36.0225	3180.0
2017-04-25 08:27:00	AAPL	Stock	36.0225	36.0225	36.0225	36.0225	3276.0
2017-04-25 08:28:00	AAPL	Stock	36.0225	36.0225	36.0225	36.0225	400.0
2017-04-25 08:29:00	AAPL	Stock	36.025	36.025	36.0225	36.0225	4268.0
2017-04-25 08:30:00	AAPL	Stock	36.025	36.025	36.025	36.025	10000.0
2017-04-25 08:31:00	AAPL	Stock	36.025	36.025	36.0225	36.025	11600.0
2017-04-25 08:32:00	AAPL	Stock	36.015	36.015	36.015	36.015	400.0
2017-04-25 08:36:00	AAPL	Stock	36.035	36.035	36.035	36.035	400.0
2017-04-25 08:37:00	AAPL	Stock	36.035	36.0375	36.0325	36.0375	2400.0
2017-04-25 08:38:00	AAPL	Stock	36.03	36.03	36.03	36.03	832.0
2017-04-25 08:39:00	AAPL	Stock	36.0375	36.0375	36.0375	36.0375	944.0
2017-04-25 08:42:00	AAPL	Stock	36.0325	36.0325	36.0325	36.0325	400.0
2017-04-25 08:43:00	AAPL	Stock	36.035	36.035	36.0325	36.0325	800.0
2017-04-25 08:44:00	AAPL	Stock	36.0375	36.0375	36.0375	36.0375	2016.0
2017-04-25 08:45:00	AAPL	Stock	36.0425	36.0425	36.035	36.035	4000.0
2017-04-25 08:46:00	AAPL	Stock	36.025	36.0375	36.025	36.0375	1640.0
2017-04-25 08:47:00	AAPL	Stock	36.0375	36.0425	36.0375	36.0425	1360.0
2017-04-25 08:48:00	AAPL	Stock	36.04	36.04	36.04	36.04	2000.0
2017-04-25 08:49:00	AAPL	Stock	36.04	36.04	36.04	36.04	1000.0
2017-04-25 08:50:00	AAPL	Stock	36.05	36.05	36.05	36.05	3336.0

> showing 50 of 1,094,169 rows — these rows as CSV

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