PREVIEW / stock_1min / 2018-07-31

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-31.parquet
  size:    15.2 MB
  rows:    1,084,511
  symbols: 2,347

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
2018-07-31 04:20:00	AAPL	Stock	47.5825	47.5825	47.5825	47.5825	1196.0
2018-07-31 04:26:00	AAPL	Stock	47.58	47.58	47.58	47.58	800.0
2018-07-31 04:27:00	AAPL	Stock	47.58	47.58	47.58	47.58	980.0
2018-07-31 04:32:00	AAPL	Stock	47.5425	47.5425	47.5425	47.5425	400.0
2018-07-31 04:36:00	AAPL	Stock	47.5425	47.5475	47.5425	47.5475	6400.0
2018-07-31 05:11:00	AAPL	Stock	47.5525	47.5525	47.5525	47.5525	400.0
2018-07-31 05:19:00	AAPL	Stock	47.57	47.57	47.57	47.57	400.0
2018-07-31 05:26:00	AAPL	Stock	47.55	47.55	47.55	47.55	6800.0
2018-07-31 05:29:00	AAPL	Stock	47.55	47.55	47.55	47.55	2000.0
2018-07-31 05:41:00	AAPL	Stock	47.5375	47.5375	47.5375	47.5375	8000.0
2018-07-31 05:47:00	AAPL	Stock	47.515	47.515	47.515	47.515	800.0
2018-07-31 05:53:00	AAPL	Stock	47.5375	47.5375	47.5375	47.5375	19320.0
2018-07-31 06:06:00	AAPL	Stock	47.5225	47.5225	47.5225	47.5225	4000.0
2018-07-31 06:08:00	AAPL	Stock	47.5225	47.5225	47.5225	47.5225	400.0
2018-07-31 06:18:00	AAPL	Stock	47.5225	47.5225	47.5225	47.5225	400.0
2018-07-31 06:24:00	AAPL	Stock	47.55	47.55	47.55	47.55	980.0
2018-07-31 06:31:00	AAPL	Stock	47.56	47.56	47.56	47.56	416.0
2018-07-31 06:37:00	AAPL	Stock	47.5375	47.56	47.5375	47.56	4400.0
2018-07-31 06:41:00	AAPL	Stock	47.5375	47.5375	47.5375	47.5375	2000.0
2018-07-31 06:45:00	AAPL	Stock	47.55	47.55	47.55	47.55	800.0
2018-07-31 06:47:00	AAPL	Stock	47.5475	47.5625	47.5475	47.5625	4040.0
2018-07-31 06:48:00	AAPL	Stock	47.5625	47.5625	47.5625	47.5625	1200.0
2018-07-31 06:50:00	AAPL	Stock	47.5525	47.5525	47.5375	47.5375	6088.0
2018-07-31 06:51:00	AAPL	Stock	47.5375	47.5375	47.5375	47.5375	1600.0
2018-07-31 06:57:00	AAPL	Stock	47.55	47.55	47.55	47.55	400.0
2018-07-31 06:59:00	AAPL	Stock	47.56	47.56	47.56	47.56	3752.0
2018-07-31 07:00:00	AAPL	Stock	47.5525	47.5675	47.54	47.5675	10920.0
2018-07-31 07:01:00	AAPL	Stock	47.565	47.6175	47.565	47.6175	18744.0
2018-07-31 07:02:00	AAPL	Stock	47.575	47.575	47.575	47.575	1200.0
2018-07-31 07:04:00	AAPL	Stock	47.6	47.625	47.6	47.625	13840.0
2018-07-31 07:07:00	AAPL	Stock	47.6225	47.6225	47.62	47.62	8600.0
2018-07-31 07:09:00	AAPL	Stock	47.6125	47.6125	47.6075	47.6075	3120.0
2018-07-31 07:10:00	AAPL	Stock	47.6225	47.625	47.6225	47.625	14980.0
2018-07-31 07:11:00	AAPL	Stock	47.625	47.625	47.625	47.625	500.0
2018-07-31 07:12:00	AAPL	Stock	47.6475	47.6475	47.6475	47.6475	3600.0
2018-07-31 07:13:00	AAPL	Stock	47.6375	47.6475	47.6375	47.6475	14000.0
2018-07-31 07:16:00	AAPL	Stock	47.625	47.625	47.625	47.625	2396.0
2018-07-31 07:17:00	AAPL	Stock	47.625	47.625	47.625	47.625	3600.0
2018-07-31 07:19:00	AAPL	Stock	47.625	47.625	47.625	47.625	400.0
2018-07-31 07:21:00	AAPL	Stock	47.625	47.625	47.6225	47.6225	2400.0
2018-07-31 07:22:00	AAPL	Stock	47.6225	47.625	47.6225	47.625	1600.0
2018-07-31 07:23:00	AAPL	Stock	47.625	47.625	47.625	47.625	1976.0
2018-07-31 07:24:00	AAPL	Stock	47.615	47.615	47.615	47.615	564.0
2018-07-31 07:25:00	AAPL	Stock	47.62	47.62	47.62	47.62	600.0
2018-07-31 07:26:00	AAPL	Stock	47.62	47.6275	47.62	47.6275	12320.0
2018-07-31 07:27:00	AAPL	Stock	47.6375	47.6375	47.6375	47.6375	800.0
2018-07-31 07:29:00	AAPL	Stock	47.6475	47.6475	47.6475	47.6475	400.0
2018-07-31 07:30:00	AAPL	Stock	47.65	47.65	47.65	47.65	548.0
2018-07-31 07:31:00	AAPL	Stock	47.65	47.65	47.65	47.65	400.0
2018-07-31 07:33:00	AAPL	Stock	47.64	47.65	47.64	47.65	3664.0

> showing 50 of 1,084,511 rows — these rows as CSV

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