PREVIEW / stock_1min / 2017-01-17

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-17.parquet
  size:    14.5 MB
  rows:    1,046,955
  symbols: 2,576

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-01-17 04:00:00	AAPL	Stock	29.685	29.685	29.6725	29.6725	880.0
2017-01-17 05:38:00	AAPL	Stock	29.625	29.625	29.625	29.625	2000.0
2017-01-17 05:53:00	AAPL	Stock	29.62	29.62	29.6	29.6	1944.0
2017-01-17 05:56:00	AAPL	Stock	29.615	29.615	29.61	29.61	800.0
2017-01-17 05:57:00	AAPL	Stock	29.6	29.6	29.6	29.6	456.0
2017-01-17 06:27:00	AAPL	Stock	29.625	29.625	29.6125	29.6125	4000.0
2017-01-17 06:45:00	AAPL	Stock	29.5675	29.5675	29.5675	29.5675	2388.0
2017-01-17 06:46:00	AAPL	Stock	29.5675	29.5675	29.5675	29.5675	400.0
2017-01-17 06:47:00	AAPL	Stock	29.595	29.595	29.595	29.595	1596.0
2017-01-17 06:51:00	AAPL	Stock	29.6	29.625	29.6	29.6125	4616.0
2017-01-17 06:53:00	AAPL	Stock	29.6125	29.6225	29.6125	29.6225	4800.0
2017-01-17 06:57:00	AAPL	Stock	29.625	29.6425	29.625	29.6425	4156.0
2017-01-17 07:06:00	AAPL	Stock	29.6625	29.6725	29.6625	29.6725	2400.0
2017-01-17 07:07:00	AAPL	Stock	29.675	29.675	29.67	29.67	13036.0
2017-01-17 07:08:00	AAPL	Stock	29.665	29.665	29.665	29.665	3920.0
2017-01-17 07:12:00	AAPL	Stock	29.665	29.685	29.665	29.685	4032.0
2017-01-17 07:13:00	AAPL	Stock	29.675	29.675	29.675	29.675	2000.0
2017-01-17 07:17:00	AAPL	Stock	29.665	29.665	29.665	29.665	10000.0
2017-01-17 07:22:00	AAPL	Stock	29.675	29.675	29.675	29.675	800.0
2017-01-17 07:23:00	AAPL	Stock	29.675	29.675	29.675	29.675	400.0
2017-01-17 07:26:00	AAPL	Stock	29.6525	29.6525	29.6525	29.6525	1384.0
2017-01-17 07:39:00	AAPL	Stock	29.6575	29.6575	29.64	29.64	3600.0
2017-01-17 07:40:00	AAPL	Stock	29.635	29.635	29.635	29.635	2000.0
2017-01-17 07:41:00	AAPL	Stock	29.6375	29.6375	29.6375	29.6375	600.0
2017-01-17 07:42:00	AAPL	Stock	29.65	29.6625	29.65	29.66	8600.0
2017-01-17 07:47:00	AAPL	Stock	29.67	29.675	29.67	29.675	2800.0
2017-01-17 07:48:00	AAPL	Stock	29.6825	29.6825	29.675	29.675	1200.0
2017-01-17 07:51:00	AAPL	Stock	29.6625	29.6625	29.6625	29.6625	1000.0
2017-01-17 07:52:00	AAPL	Stock	29.675	29.675	29.675	29.675	5804.0
2017-01-17 07:59:00	AAPL	Stock	29.675	29.6825	29.675	29.6825	1600.0
2017-01-17 08:00:00	AAPL	Stock	29.665	29.6875	29.65	29.675	39564.0
2017-01-17 08:02:00	AAPL	Stock	29.675	29.675	29.675	29.675	1000.0
2017-01-17 08:04:00	AAPL	Stock	29.665	29.665	29.665	29.665	800.0
2017-01-17 08:05:00	AAPL	Stock	29.6575	29.6575	29.6575	29.6575	5600.0
2017-01-17 08:06:00	AAPL	Stock	29.66	29.665	29.66	29.665	10400.0
2017-01-17 08:08:00	AAPL	Stock	29.665	29.665	29.6575	29.6575	8728.0
2017-01-17 08:09:00	AAPL	Stock	29.655	29.655	29.65	29.65	8400.0
2017-01-17 08:10:00	AAPL	Stock	29.6575	29.6725	29.6575	29.6725	6096.0
2017-01-17 08:14:00	AAPL	Stock	29.6425	29.6425	29.6325	29.6325	2052.0
2017-01-17 08:15:00	AAPL	Stock	29.65	29.6625	29.65	29.6625	1200.0
2017-01-17 08:17:00	AAPL	Stock	29.6475	29.6475	29.6475	29.6475	3600.0
2017-01-17 08:19:00	AAPL	Stock	29.6275	29.6275	29.6275	29.6275	400.0
2017-01-17 08:21:00	AAPL	Stock	29.6275	29.6275	29.6275	29.6275	800.0
2017-01-17 08:22:00	AAPL	Stock	29.6425	29.645	29.6425	29.645	4000.0
2017-01-17 08:24:00	AAPL	Stock	29.645	29.65	29.645	29.65	10000.0
2017-01-17 08:28:00	AAPL	Stock	29.65	29.65	29.65	29.65	4000.0
2017-01-17 08:30:00	AAPL	Stock	29.6525	29.6525	29.6525	29.6525	1068.0
2017-01-17 08:32:00	AAPL	Stock	29.6525	29.6525	29.6525	29.6525	400.0
2017-01-17 08:34:00	AAPL	Stock	29.6525	29.6525	29.6525	29.6525	564.0
2017-01-17 08:35:00	AAPL	Stock	29.6525	29.6525	29.6525	29.6525	26124.0

> showing 50 of 1,046,955 rows — these rows as CSV

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