PREVIEW / stock_1min / 2017-03-07

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-03-07.parquet
  size:    14.2 MB
  rows:    1,039,000
  symbols: 2,533

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-03-07 05:38:00	AAPL	Stock	34.7625	34.7625	34.7625	34.7625	2156.0
2017-03-07 06:08:00	AAPL	Stock	34.765	34.765	34.765	34.765	432.0
2017-03-07 07:00:00	AAPL	Stock	34.775	34.775	34.775	34.775	1600.0
2017-03-07 07:03:00	AAPL	Stock	34.7675	34.775	34.7675	34.775	4200.0
2017-03-07 07:04:00	AAPL	Stock	34.775	34.775	34.775	34.775	16400.0
2017-03-07 07:05:00	AAPL	Stock	34.775	34.775	34.775	34.775	800.0
2017-03-07 07:18:00	AAPL	Stock	34.78	34.78	34.7775	34.7775	11028.0
2017-03-07 07:20:00	AAPL	Stock	34.78	34.78	34.775	34.775	9764.0
2017-03-07 07:22:00	AAPL	Stock	34.765	34.765	34.765	34.765	1200.0
2017-03-07 07:28:00	AAPL	Stock	34.78	34.78	34.78	34.78	400.0
2017-03-07 07:31:00	AAPL	Stock	34.78	34.78	34.78	34.78	800.0
2017-03-07 07:32:00	AAPL	Stock	34.78	34.78	34.78	34.78	4000.0
2017-03-07 07:37:00	AAPL	Stock	34.78	34.78	34.78	34.78	4000.0
2017-03-07 07:38:00	AAPL	Stock	34.78	34.78	34.78	34.78	2000.0
2017-03-07 08:00:00	AAPL	Stock	34.8	34.8	34.775	34.7975	10060.0
2017-03-07 08:01:00	AAPL	Stock	34.795	34.795	34.795	34.795	804.0
2017-03-07 08:03:00	AAPL	Stock	34.795	34.795	34.7875	34.7875	2400.0
2017-03-07 08:10:00	AAPL	Stock	34.7825	34.7825	34.7825	34.7825	2496.0
2017-03-07 08:14:00	AAPL	Stock	34.78	34.78	34.78	34.78	4872.0
2017-03-07 08:16:00	AAPL	Stock	34.78	34.78	34.78	34.78	800.0
2017-03-07 08:17:00	AAPL	Stock	34.7875	34.7875	34.7875	34.7875	4000.0
2017-03-07 08:21:00	AAPL	Stock	34.78	34.78	34.78	34.78	3996.0
2017-03-07 08:25:00	AAPL	Stock	34.775	34.775	34.7525	34.7525	13060.0
2017-03-07 08:27:00	AAPL	Stock	34.755	34.755	34.755	34.755	3000.0
2017-03-07 08:29:00	AAPL	Stock	34.7725	34.775	34.7725	34.775	3996.0
2017-03-07 08:30:00	AAPL	Stock	34.775	34.775	34.775	34.775	1860.0
2017-03-07 08:31:00	AAPL	Stock	34.775	34.775	34.775	34.775	4000.0
2017-03-07 08:33:00	AAPL	Stock	34.775	34.775	34.775	34.775	2200.0
2017-03-07 08:37:00	AAPL	Stock	34.775	34.775	34.775	34.775	512.0
2017-03-07 08:38:00	AAPL	Stock	34.775	34.775	34.775	34.775	400.0
2017-03-07 08:39:00	AAPL	Stock	34.775	34.775	34.775	34.775	4000.0
2017-03-07 08:40:00	AAPL	Stock	34.775	34.775	34.77	34.77	1172.0
2017-03-07 08:45:00	AAPL	Stock	34.765	34.765	34.765	34.765	1320.0
2017-03-07 08:49:00	AAPL	Stock	34.77	34.77	34.77	34.77	1740.0
2017-03-07 08:50:00	AAPL	Stock	34.7725	34.7725	34.7725	34.7725	10000.0
2017-03-07 08:51:00	AAPL	Stock	34.775	34.775	34.775	34.775	800.0
2017-03-07 08:54:00	AAPL	Stock	34.775	34.775	34.775	34.775	2000.0
2017-03-07 08:56:00	AAPL	Stock	34.7775	34.7775	34.7775	34.7775	2468.0
2017-03-07 08:57:00	AAPL	Stock	34.785	34.785	34.785	34.785	15952.0
2017-03-07 08:58:00	AAPL	Stock	34.78	34.78	34.78	34.78	1000.0
2017-03-07 08:59:00	AAPL	Stock	34.78	34.78	34.78	34.78	1400.0
2017-03-07 09:02:00	AAPL	Stock	34.78	34.78	34.78	34.78	2800.0
2017-03-07 09:03:00	AAPL	Stock	34.78	34.78	34.78	34.78	7420.0
2017-03-07 09:08:00	AAPL	Stock	34.795	34.795	34.795	34.795	1000.0
2017-03-07 09:09:00	AAPL	Stock	34.7825	34.7825	34.765	34.775	11972.0
2017-03-07 09:10:00	AAPL	Stock	34.775	34.775	34.775	34.775	400.0
2017-03-07 09:11:00	AAPL	Stock	34.775	34.775	34.775	34.775	400.0
2017-03-07 09:13:00	AAPL	Stock	34.7975	34.7975	34.7925	34.795	8000.0
2017-03-07 09:14:00	AAPL	Stock	34.795	34.795	34.795	34.795	800.0
2017-03-07 09:15:00	AAPL	Stock	34.7875	34.7875	34.7875	34.7875	4400.0

> showing 50 of 1,039,000 rows — these rows as CSV

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