PREVIEW / stock_1min / 2017-08-23

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-23.parquet
  size:    13.6 MB
  rows:    997,416
  symbols: 2,449

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-08-23 05:03:00	AAPL	Stock	39.965	39.965	39.965	39.965	800.0
2017-08-23 05:18:00	AAPL	Stock	39.9375	39.9375	39.9375	39.9375	3728.0
2017-08-23 06:10:00	AAPL	Stock	39.8875	39.8875	39.8875	39.8875	1200.0
2017-08-23 06:11:00	AAPL	Stock	39.8875	39.8875	39.8875	39.8875	400.0
2017-08-23 06:44:00	AAPL	Stock	39.8275	39.8275	39.805	39.805	1600.0
2017-08-23 07:02:00	AAPL	Stock	39.8625	39.8625	39.8625	39.8625	400.0
2017-08-23 07:03:00	AAPL	Stock	39.85	39.85	39.85	39.85	904.0
2017-08-23 07:04:00	AAPL	Stock	39.87	39.87	39.865	39.87	3552.0
2017-08-23 07:05:00	AAPL	Stock	39.8725	39.875	39.8725	39.875	6760.0
2017-08-23 07:06:00	AAPL	Stock	39.875	39.9	39.875	39.9	13840.0
2017-08-23 07:07:00	AAPL	Stock	39.9	39.9	39.9	39.9	1200.0
2017-08-23 07:08:00	AAPL	Stock	39.8875	39.91	39.8875	39.91	4672.0
2017-08-23 07:14:00	AAPL	Stock	39.8875	39.8875	39.8875	39.8875	1472.0
2017-08-23 07:15:00	AAPL	Stock	39.8725	39.8725	39.8725	39.8725	1920.0
2017-08-23 07:16:00	AAPL	Stock	39.855	39.855	39.855	39.855	3132.0
2017-08-23 07:17:00	AAPL	Stock	39.855	39.855	39.855	39.855	400.0
2017-08-23 07:19:00	AAPL	Stock	39.855	39.855	39.855	39.855	2104.0
2017-08-23 07:21:00	AAPL	Stock	39.855	39.855	39.855	39.855	2676.0
2017-08-23 07:22:00	AAPL	Stock	39.86	39.86	39.86	39.86	1400.0
2017-08-23 07:23:00	AAPL	Stock	39.86	39.86	39.86	39.86	1392.0
2017-08-23 07:24:00	AAPL	Stock	39.8725	39.8725	39.8725	39.8725	2000.0
2017-08-23 07:25:00	AAPL	Stock	39.8725	39.8725	39.8725	39.8725	1200.0
2017-08-23 07:35:00	AAPL	Stock	39.8575	39.8575	39.8575	39.8575	600.0
2017-08-23 07:36:00	AAPL	Stock	39.855	39.855	39.835	39.835	4104.0
2017-08-23 07:37:00	AAPL	Stock	39.835	39.835	39.835	39.835	660.0
2017-08-23 07:40:00	AAPL	Stock	39.835	39.835	39.835	39.835	400.0
2017-08-23 07:41:00	AAPL	Stock	39.835	39.835	39.835	39.835	2400.0
2017-08-23 07:42:00	AAPL	Stock	39.835	39.835	39.835	39.835	2836.0
2017-08-23 07:45:00	AAPL	Stock	39.825	39.825	39.825	39.825	4000.0
2017-08-23 07:46:00	AAPL	Stock	39.825	39.825	39.825	39.825	20000.0
2017-08-23 07:47:00	AAPL	Stock	39.8125	39.8125	39.8125	39.8125	1596.0
2017-08-23 07:49:00	AAPL	Stock	39.8125	39.8125	39.8125	39.8125	1736.0
2017-08-23 07:50:00	AAPL	Stock	39.8125	39.8125	39.8125	39.8125	400.0
2017-08-23 07:55:00	AAPL	Stock	39.8225	39.8225	39.8025	39.8025	3600.0
2017-08-23 07:56:00	AAPL	Stock	39.8025	39.8025	39.8025	39.8025	2800.0
2017-08-23 07:58:00	AAPL	Stock	39.8025	39.8025	39.8025	39.8025	5192.0
2017-08-23 08:00:00	AAPL	Stock	39.8125	39.8725	39.8025	39.815	48324.0
2017-08-23 08:01:00	AAPL	Stock	39.825	39.825	39.8125	39.8125	8000.0
2017-08-23 08:02:00	AAPL	Stock	39.8025	39.8125	39.8025	39.8125	16304.0
2017-08-23 08:03:00	AAPL	Stock	39.805	39.825	39.805	39.825	26992.0
2017-08-23 08:04:00	AAPL	Stock	39.835	39.835	39.83	39.83	1200.0
2017-08-23 08:05:00	AAPL	Stock	39.83	39.8375	39.83	39.8375	8656.0
2017-08-23 08:06:00	AAPL	Stock	39.8325	39.8325	39.825	39.825	7400.0
2017-08-23 08:07:00	AAPL	Stock	39.8125	39.825	39.8125	39.825	5488.0
2017-08-23 08:08:00	AAPL	Stock	39.825	39.825	39.8125	39.815	5500.0
2017-08-23 08:09:00	AAPL	Stock	39.825	39.84	39.825	39.84	2792.0
2017-08-23 08:10:00	AAPL	Stock	39.835	39.835	39.835	39.835	400.0
2017-08-23 08:11:00	AAPL	Stock	39.825	39.825	39.815	39.815	2000.0
2017-08-23 08:13:00	AAPL	Stock	39.8125	39.8125	39.8125	39.8125	2788.0
2017-08-23 08:14:00	AAPL	Stock	39.8125	39.8125	39.8125	39.8125	800.0

> showing 50 of 997,416 rows — these rows as CSV

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