PREVIEW / stock_1min / 2017-04-06

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-04-06.parquet
  size:    14.5 MB
  rows:    1,059,084
  symbols: 2,522

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-06 04:18:00	AAPL	Stock	35.9075	35.9075	35.9075	35.9075	744.0
2017-04-06 04:22:00	AAPL	Stock	35.925	35.925	35.925	35.925	3840.0
2017-04-06 04:26:00	AAPL	Stock	35.9225	35.9225	35.9225	35.9225	400.0
2017-04-06 04:29:00	AAPL	Stock	35.92	35.92	35.92	35.92	568.0
2017-04-06 04:37:00	AAPL	Stock	35.9225	35.9375	35.9225	35.9375	7056.0
2017-04-06 04:38:00	AAPL	Stock	35.9375	35.9375	35.9375	35.9375	800.0
2017-04-06 05:46:00	AAPL	Stock	35.965	35.9725	35.965	35.9725	2400.0
2017-04-06 05:47:00	AAPL	Stock	35.975	35.975	35.975	35.975	2268.0
2017-04-06 05:50:00	AAPL	Stock	35.975	35.975	35.975	35.975	1200.0
2017-04-06 05:52:00	AAPL	Stock	36.0	36.0	36.0	36.0	400.0
2017-04-06 06:14:00	AAPL	Stock	35.9925	35.9925	35.99	35.99	7600.0
2017-04-06 06:34:00	AAPL	Stock	35.98	36.0	35.98	36.0	4392.0
2017-04-06 06:35:00	AAPL	Stock	36.0	36.0	36.0	36.0	800.0
2017-04-06 06:40:00	AAPL	Stock	36.0075	36.0075	36.0075	36.0075	3892.0
2017-04-06 06:42:00	AAPL	Stock	36.0125	36.0125	36.0125	36.0125	4000.0
2017-04-06 06:43:00	AAPL	Stock	36.015	36.025	36.015	36.025	7888.0
2017-04-06 06:44:00	AAPL	Stock	36.025	36.0325	36.025	36.0325	2408.0
2017-04-06 06:46:00	AAPL	Stock	36.035	36.0375	36.035	36.0375	1328.0
2017-04-06 06:47:00	AAPL	Stock	36.0475	36.05	36.0475	36.05	4788.0
2017-04-06 06:50:00	AAPL	Stock	36.05	36.05	36.05	36.05	1084.0
2017-04-06 06:57:00	AAPL	Stock	36.05	36.05	36.05	36.05	2000.0
2017-04-06 06:58:00	AAPL	Stock	36.05	36.05	36.05	36.05	800.0
2017-04-06 07:01:00	AAPL	Stock	36.04	36.05	36.04	36.05	5308.0
2017-04-06 07:02:00	AAPL	Stock	36.06	36.06	36.06	36.06	800.0
2017-04-06 07:03:00	AAPL	Stock	36.05	36.05	36.05	36.05	800.0
2017-04-06 07:04:00	AAPL	Stock	36.05	36.0575	36.05	36.0575	1480.0
2017-04-06 07:05:00	AAPL	Stock	36.05	36.05	36.05	36.05	1200.0
2017-04-06 07:06:00	AAPL	Stock	36.05	36.0575	36.05	36.0575	1104.0
2017-04-06 07:08:00	AAPL	Stock	36.0475	36.05	36.0475	36.05	1228.0
2017-04-06 07:09:00	AAPL	Stock	36.0375	36.0375	36.0375	36.0375	1192.0
2017-04-06 07:10:00	AAPL	Stock	36.0375	36.0375	36.0375	36.0375	2332.0
2017-04-06 07:15:00	AAPL	Stock	36.035	36.035	36.035	36.035	1200.0
2017-04-06 07:16:00	AAPL	Stock	36.035	36.0375	36.035	36.0375	4068.0
2017-04-06 07:17:00	AAPL	Stock	36.045	36.0475	36.045	36.0475	12000.0
2017-04-06 07:18:00	AAPL	Stock	36.045	36.045	36.045	36.045	2400.0
2017-04-06 07:19:00	AAPL	Stock	36.045	36.05	36.045	36.05	5600.0
2017-04-06 07:23:00	AAPL	Stock	36.0325	36.0325	36.0325	36.0325	1600.0
2017-04-06 07:34:00	AAPL	Stock	36.03	36.03	36.03	36.03	800.0
2017-04-06 07:39:00	AAPL	Stock	36.0475	36.0475	36.0475	36.0475	400.0
2017-04-06 07:40:00	AAPL	Stock	36.0475	36.0475	36.0475	36.0475	4000.0
2017-04-06 07:43:00	AAPL	Stock	36.045	36.0475	36.045	36.0475	5084.0
2017-04-06 07:44:00	AAPL	Stock	36.0475	36.0475	36.0475	36.0475	544.0
2017-04-06 07:45:00	AAPL	Stock	36.0475	36.0475	36.035	36.035	2400.0
2017-04-06 07:49:00	AAPL	Stock	36.0375	36.0375	36.0375	36.0375	800.0
2017-04-06 07:54:00	AAPL	Stock	36.035	36.035	36.025	36.025	22372.0
2017-04-06 07:59:00	AAPL	Stock	36.025	36.025	36.025	36.025	8000.0
2017-04-06 08:00:00	AAPL	Stock	36.025	36.06	36.025	36.025	26320.0
2017-04-06 08:01:00	AAPL	Stock	36.01	36.0125	36.0075	36.0125	8308.0
2017-04-06 08:02:00	AAPL	Stock	36.0175	36.0175	36.0125	36.0125	6400.0
2017-04-06 08:03:00	AAPL	Stock	36.0075	36.0075	36.0075	36.0075	560.0

> showing 50 of 1,059,084 rows — these rows as CSV

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