PREVIEW / stock_1min / 2017-06-15

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-06-15.parquet
  size:    14.2 MB
  rows:    1,041,594
  symbols: 2,499

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-06-15 04:00:00	AAPL	Stock	35.975	35.975	35.975	35.975	1000.0
2017-06-15 04:01:00	AAPL	Stock	35.9325	35.9325	35.91	35.91	2400.0
2017-06-15 04:03:00	AAPL	Stock	35.9	35.9	35.9	35.9	480.0
2017-06-15 04:04:00	AAPL	Stock	35.8575	35.8575	35.8125	35.8125	8808.0
2017-06-15 04:06:00	AAPL	Stock	35.9275	35.9275	35.9275	35.9275	3920.0
2017-06-15 04:07:00	AAPL	Stock	35.885	35.885	35.885	35.885	1200.0
2017-06-15 04:10:00	AAPL	Stock	35.8875	35.8875	35.8875	35.8875	400.0
2017-06-15 04:22:00	AAPL	Stock	35.9375	35.9375	35.93	35.93	3212.0
2017-06-15 04:26:00	AAPL	Stock	35.9025	35.9025	35.9025	35.9025	1200.0
2017-06-15 04:40:00	AAPL	Stock	35.9375	35.9375	35.9375	35.9375	1600.0
2017-06-15 04:46:00	AAPL	Stock	35.875	35.875	35.875	35.875	400.0
2017-06-15 04:49:00	AAPL	Stock	35.9	35.9	35.9	35.9	4000.0
2017-06-15 04:50:00	AAPL	Stock	35.905	35.905	35.905	35.905	400.0
2017-06-15 04:52:00	AAPL	Stock	35.8875	35.8875	35.8875	35.8875	400.0
2017-06-15 04:53:00	AAPL	Stock	35.8875	35.8875	35.8875	35.8875	3600.0
2017-06-15 04:55:00	AAPL	Stock	35.9325	35.9325	35.9325	35.9325	400.0
2017-06-15 04:56:00	AAPL	Stock	35.9325	35.9325	35.8825	35.8825	3820.0
2017-06-15 04:57:00	AAPL	Stock	35.9	35.9	35.9	35.9	8000.0
2017-06-15 05:02:00	AAPL	Stock	35.86	35.86	35.855	35.855	5972.0
2017-06-15 05:12:00	AAPL	Stock	35.8475	35.8475	35.8475	35.8475	1600.0
2017-06-15 05:13:00	AAPL	Stock	35.8475	35.8475	35.8475	35.8475	800.0
2017-06-15 05:16:00	AAPL	Stock	35.8475	35.8475	35.8475	35.8475	456.0
2017-06-15 05:18:00	AAPL	Stock	35.86	35.9	35.86	35.9	1600.0
2017-06-15 05:25:00	AAPL	Stock	35.8625	35.8625	35.8625	35.8625	2400.0
2017-06-15 05:35:00	AAPL	Stock	35.8725	35.8725	35.8725	35.8725	420.0
2017-06-15 05:40:00	AAPL	Stock	35.8725	35.8725	35.8725	35.8725	400.0
2017-06-15 05:42:00	AAPL	Stock	35.85	35.85	35.85	35.85	3600.0
2017-06-15 05:44:00	AAPL	Stock	35.875	35.875	35.875	35.875	400.0
2017-06-15 05:45:00	AAPL	Stock	35.875	35.875	35.875	35.875	800.0
2017-06-15 05:47:00	AAPL	Stock	35.875	35.875	35.875	35.875	7992.0
2017-06-15 05:48:00	AAPL	Stock	35.875	35.875	35.875	35.875	800.0
2017-06-15 05:52:00	AAPL	Stock	35.85	35.85	35.85	35.85	2400.0
2017-06-15 05:56:00	AAPL	Stock	35.85	35.85	35.85	35.85	4208.0
2017-06-15 05:57:00	AAPL	Stock	35.845	35.845	35.845	35.845	400.0
2017-06-15 06:01:00	AAPL	Stock	35.8275	35.8275	35.8275	35.8275	1808.0
2017-06-15 06:05:00	AAPL	Stock	35.825	35.825	35.825	35.825	1600.0
2017-06-15 06:07:00	AAPL	Stock	35.825	35.825	35.825	35.825	1292.0
2017-06-15 06:08:00	AAPL	Stock	35.8825	35.8825	35.8375	35.8375	1468.0
2017-06-15 06:09:00	AAPL	Stock	35.83	35.83	35.8275	35.8275	824.0
2017-06-15 06:11:00	AAPL	Stock	35.825	35.825	35.825	35.825	856.0
2017-06-15 06:13:00	AAPL	Stock	35.835	35.835	35.835	35.835	2400.0
2017-06-15 06:14:00	AAPL	Stock	35.825	35.825	35.8	35.8	12232.0
2017-06-15 06:16:00	AAPL	Stock	35.8575	35.8625	35.8575	35.86	4928.0
2017-06-15 06:17:00	AAPL	Stock	35.855	35.86	35.8125	35.8125	8400.0
2017-06-15 06:18:00	AAPL	Stock	35.79	35.79	35.7875	35.7875	2400.0
2017-06-15 06:20:00	AAPL	Stock	35.805	35.805	35.805	35.805	400.0
2017-06-15 06:21:00	AAPL	Stock	35.805	35.805	35.805	35.805	3828.0
2017-06-15 06:22:00	AAPL	Stock	35.805	35.805	35.805	35.805	2324.0
2017-06-15 06:25:00	AAPL	Stock	35.795	35.795	35.795	35.795	792.0
2017-06-15 06:29:00	AAPL	Stock	35.85	35.85	35.85	35.85	3624.0

> showing 50 of 1,041,594 rows — these rows as CSV

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