PREVIEW / stock_1min / 2015-08-17

all stock 1-min files

  file:    by_date/stock_1min/2015/2015-08-17.parquet
  size:    14.3 MB
  rows:    1,050,601
  symbols: 2,825

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-08-17 04:08:00	AAPL	Stock	28.9925	28.9925	28.9925	28.9925	3200.0
2015-08-17 04:20:00	AAPL	Stock	29.05	29.05	29.05	29.05	400.0
2015-08-17 04:21:00	AAPL	Stock	29.0625	29.0625	29.0625	29.0625	400.0
2015-08-17 04:42:00	AAPL	Stock	29.035	29.0875	29.035	29.0875	9200.0
2015-08-17 05:45:00	AAPL	Stock	29.1	29.1	29.1	29.1	400.0
2015-08-17 05:59:00	AAPL	Stock	29.0925	29.0925	29.0925	29.0925	580.0
2015-08-17 06:03:00	AAPL	Stock	29.0975	29.0975	29.095	29.0975	6600.0
2015-08-17 06:04:00	AAPL	Stock	29.095	29.095	29.095	29.095	400.0
2015-08-17 06:05:00	AAPL	Stock	29.095	29.095	29.095	29.095	1600.0
2015-08-17 06:06:00	AAPL	Stock	29.0975	29.0975	29.0975	29.0975	15400.0
2015-08-17 06:07:00	AAPL	Stock	29.105	29.105	29.105	29.105	400.0
2015-08-17 06:08:00	AAPL	Stock	29.0975	29.0975	29.0975	29.0975	4600.0
2015-08-17 06:13:00	AAPL	Stock	29.1	29.1	29.1	29.1	800.0
2015-08-17 06:15:00	AAPL	Stock	29.1	29.1	29.1	29.1	1228.0
2015-08-17 06:27:00	AAPL	Stock	29.095	29.095	29.095	29.095	1332.0
2015-08-17 06:32:00	AAPL	Stock	29.0775	29.0775	29.075	29.0775	1928.0
2015-08-17 06:33:00	AAPL	Stock	29.0975	29.1025	29.0975	29.1025	4400.0
2015-08-17 06:36:00	AAPL	Stock	29.105	29.105	29.105	29.105	4000.0
2015-08-17 06:37:00	AAPL	Stock	29.0775	29.0775	29.075	29.075	3416.0
2015-08-17 06:38:00	AAPL	Stock	29.0625	29.0625	29.05	29.05	11420.0
2015-08-17 06:43:00	AAPL	Stock	29.05	29.05	29.05	29.05	900.0
2015-08-17 07:02:00	AAPL	Stock	29.09	29.09	29.09	29.09	400.0
2015-08-17 07:03:00	AAPL	Stock	29.0625	29.0625	29.0525	29.0525	1600.0
2015-08-17 07:08:00	AAPL	Stock	29.0375	29.0375	29.0375	29.0375	3628.0
2015-08-17 07:10:00	AAPL	Stock	29.0475	29.0475	29.0475	29.0475	2400.0
2015-08-17 07:14:00	AAPL	Stock	29.035	29.035	29.035	29.035	2156.0
2015-08-17 07:19:00	AAPL	Stock	29.005	29.005	29.0	29.0	3592.0
2015-08-17 07:20:00	AAPL	Stock	28.9925	29.025	28.99	29.0175	13992.0
2015-08-17 07:23:00	AAPL	Stock	28.9975	28.9975	28.9875	28.9875	5836.0
2015-08-17 07:26:00	AAPL	Stock	28.9725	28.9725	28.9725	28.9725	400.0
2015-08-17 07:27:00	AAPL	Stock	28.975	28.9875	28.975	28.9875	3200.0
2015-08-17 07:34:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	800.0
2015-08-17 07:35:00	AAPL	Stock	29.0225	29.03	29.0	29.015	21860.0
2015-08-17 07:37:00	AAPL	Stock	29.025	29.025	29.025	29.025	2800.0
2015-08-17 07:38:00	AAPL	Stock	29.025	29.025	29.025	29.025	1180.0
2015-08-17 07:39:00	AAPL	Stock	29.045	29.045	29.045	29.045	2020.0
2015-08-17 07:41:00	AAPL	Stock	29.035	29.035	29.035	29.035	400.0
2015-08-17 07:44:00	AAPL	Stock	29.025	29.025	29.025	29.025	1200.0
2015-08-17 07:56:00	AAPL	Stock	29.015	29.025	29.015	29.025	2400.0
2015-08-17 07:57:00	AAPL	Stock	29.025	29.025	29.025	29.025	400.0
2015-08-17 07:59:00	AAPL	Stock	29.025	29.025	29.025	29.025	17672.0
2015-08-17 08:00:00	AAPL	Stock	29.025	29.0875	28.995	29.0325	75176.0
2015-08-17 08:01:00	AAPL	Stock	29.0318	29.0318	29.0318	29.0318	480.0
2015-08-17 08:02:00	AAPL	Stock	29.0325	29.0325	29.0325	29.0325	400.0
2015-08-17 08:03:00	AAPL	Stock	29.0175	29.025	29.0125	29.0125	18800.0
2015-08-17 08:04:00	AAPL	Stock	29.0125	29.0275	29.0125	29.0275	14316.0
2015-08-17 08:05:00	AAPL	Stock	29.0125	29.0325	29.0125	29.03	19208.0
2015-08-17 08:06:00	AAPL	Stock	29.035	29.0475	29.025	29.0475	21460.0
2015-08-17 08:07:00	AAPL	Stock	29.0375	29.0375	29.0375	29.0375	18800.0
2015-08-17 08:08:00	AAPL	Stock	29.0375	29.0375	29.0175	29.0175	61352.0

> showing 50 of 1,050,601 rows — these rows as CSV

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