PREVIEW / stock_1min / 2017-07-07

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-07.parquet
  size:    13.7 MB
  rows:    1,009,457
  symbols: 2,489

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-07-07 04:12:00	AAPL	Stock	35.6	35.6	35.6	35.6	3784.0
2017-07-07 06:13:00	AAPL	Stock	35.7	35.7	35.7	35.7	2000.0
2017-07-07 06:20:00	AAPL	Stock	35.7	35.7	35.7	35.7	400.0
2017-07-07 06:27:00	AAPL	Stock	35.7075	35.7075	35.7075	35.7075	1600.0
2017-07-07 06:41:00	AAPL	Stock	35.7	35.7	35.7	35.7	3040.0
2017-07-07 07:12:00	AAPL	Stock	35.6625	35.6625	35.6625	35.6625	3220.0
2017-07-07 07:20:00	AAPL	Stock	35.6625	35.665	35.6625	35.665	3480.0
2017-07-07 07:23:00	AAPL	Stock	35.68	35.68	35.68	35.68	448.0
2017-07-07 07:24:00	AAPL	Stock	35.6875	35.6875	35.6875	35.6875	700.0
2017-07-07 07:28:00	AAPL	Stock	35.6725	35.6725	35.6725	35.6725	400.0
2017-07-07 07:32:00	AAPL	Stock	35.675	35.675	35.675	35.675	400.0
2017-07-07 08:01:00	AAPL	Stock	35.665	35.665	35.665	35.665	400.0
2017-07-07 08:02:00	AAPL	Stock	35.67	35.67	35.67	35.67	500.0
2017-07-07 08:03:00	AAPL	Stock	35.69	35.69	35.69	35.69	400.0
2017-07-07 08:06:00	AAPL	Stock	35.68	35.68	35.68	35.68	1200.0
2017-07-07 08:08:00	AAPL	Stock	35.68	35.68	35.68	35.68	2000.0
2017-07-07 08:09:00	AAPL	Stock	35.68	35.68	35.68	35.68	800.0
2017-07-07 08:11:00	AAPL	Stock	35.7	35.7	35.7	35.7	1992.0
2017-07-07 08:19:00	AAPL	Stock	35.69	35.69	35.69	35.69	1996.0
2017-07-07 08:22:00	AAPL	Stock	35.705	35.705	35.705	35.705	400.0
2017-07-07 08:24:00	AAPL	Stock	35.7	35.7	35.7	35.7	1200.0
2017-07-07 08:25:00	AAPL	Stock	35.7125	35.7125	35.71	35.7125	4488.0
2017-07-07 08:26:00	AAPL	Stock	35.7175	35.7175	35.7175	35.7175	572.0
2017-07-07 08:27:00	AAPL	Stock	35.7225	35.7375	35.7225	35.7375	3028.0
2017-07-07 08:28:00	AAPL	Stock	35.75	35.75	35.75	35.75	5108.0
2017-07-07 08:29:00	AAPL	Stock	35.75	35.75	35.75	35.75	400.0
2017-07-07 08:30:00	AAPL	Stock	35.7275	35.775	35.725	35.775	12248.0
2017-07-07 08:31:00	AAPL	Stock	35.775	35.825	35.775	35.815	17056.0
2017-07-07 08:32:00	AAPL	Stock	35.8175	35.8375	35.7925	35.83	31500.0
2017-07-07 08:33:00	AAPL	Stock	35.83	35.8375	35.75	35.8375	12252.0
2017-07-07 08:34:00	AAPL	Stock	35.8375	35.8375	35.8375	35.8375	880.0
2017-07-07 08:35:00	AAPL	Stock	35.8425	35.8675	35.8375	35.8675	4008.0
2017-07-07 08:37:00	AAPL	Stock	35.845	35.85	35.845	35.85	9048.0
2017-07-07 08:38:00	AAPL	Stock	35.85	35.8725	35.85	35.8725	10608.0
2017-07-07 08:39:00	AAPL	Stock	35.87	35.8725	35.85	35.8625	20072.0
2017-07-07 08:40:00	AAPL	Stock	35.855	35.855	35.8425	35.8425	27440.0
2017-07-07 08:41:00	AAPL	Stock	35.8425	35.8425	35.8125	35.8125	13672.0
2017-07-07 08:42:00	AAPL	Stock	35.8125	35.8125	35.7975	35.7975	22400.0
2017-07-07 08:43:00	AAPL	Stock	35.7975	35.8225	35.7925	35.8225	2000.0
2017-07-07 08:44:00	AAPL	Stock	35.825	35.8375	35.825	35.8375	6260.0
2017-07-07 08:45:00	AAPL	Stock	35.8375	35.84	35.8375	35.84	8208.0
2017-07-07 08:46:00	AAPL	Stock	35.84	35.84	35.84	35.84	400.0
2017-07-07 08:47:00	AAPL	Stock	35.8325	35.8375	35.8325	35.8375	3196.0
2017-07-07 08:48:00	AAPL	Stock	35.825	35.8375	35.825	35.8375	2720.0
2017-07-07 08:49:00	AAPL	Stock	35.825	35.825	35.825	35.825	600.0
2017-07-07 08:50:00	AAPL	Stock	35.8425	35.8425	35.825	35.84	4040.0
2017-07-07 08:51:00	AAPL	Stock	35.8425	35.85	35.8425	35.85	17540.0
2017-07-07 08:52:00	AAPL	Stock	35.84	35.84	35.8375	35.8375	1800.0
2017-07-07 08:53:00	AAPL	Stock	35.855	35.8575	35.855	35.8575	25200.0
2017-07-07 08:54:00	AAPL	Stock	35.8575	35.87	35.8575	35.87	1680.0

> showing 50 of 1,009,457 rows — these rows as CSV

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