PREVIEW / stock_5min / 2018-07-31

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-31.parquet
  size:    5.6 MB
  rows:    355,751
  symbols: 2,818

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:25:00	AAPL	Stock	47.58	47.58	47.58	47.58	1780.0
2018-07-31 04:30:00	AAPL	Stock	47.5425	47.5425	47.5425	47.5425	400.0
2018-07-31 04:35:00	AAPL	Stock	47.5425	47.5475	47.5425	47.5475	6400.0
2018-07-31 05:10:00	AAPL	Stock	47.5525	47.5525	47.5525	47.5525	400.0
2018-07-31 05:15:00	AAPL	Stock	47.57	47.57	47.57	47.57	400.0
2018-07-31 05:25:00	AAPL	Stock	47.55	47.55	47.55	47.55	8800.0
2018-07-31 05:40:00	AAPL	Stock	47.5375	47.5375	47.5375	47.5375	8000.0
2018-07-31 05:45:00	AAPL	Stock	47.515	47.515	47.515	47.515	800.0
2018-07-31 05:50:00	AAPL	Stock	47.5375	47.5375	47.5375	47.5375	19320.0
2018-07-31 06:05:00	AAPL	Stock	47.5225	47.5225	47.5225	47.5225	4400.0
2018-07-31 06:15:00	AAPL	Stock	47.5225	47.5225	47.5225	47.5225	400.0
2018-07-31 06:20:00	AAPL	Stock	47.55	47.55	47.55	47.55	980.0
2018-07-31 06:30:00	AAPL	Stock	47.56	47.56	47.56	47.56	416.0
2018-07-31 06:35:00	AAPL	Stock	47.5375	47.56	47.5375	47.56	4400.0
2018-07-31 06:40:00	AAPL	Stock	47.5375	47.5375	47.5375	47.5375	2000.0
2018-07-31 06:45:00	AAPL	Stock	47.55	47.5625	47.5475	47.5625	6040.0
2018-07-31 06:50:00	AAPL	Stock	47.5525	47.5525	47.5375	47.5375	7688.0
2018-07-31 06:55:00	AAPL	Stock	47.55	47.56	47.55	47.56	4152.0
2018-07-31 07:00:00	AAPL	Stock	47.5525	47.625	47.54	47.625	44704.0
2018-07-31 07:05:00	AAPL	Stock	47.6225	47.6225	47.6075	47.6075	11720.0
2018-07-31 07:10:00	AAPL	Stock	47.6225	47.6475	47.6225	47.6475	33080.0
2018-07-31 07:15:00	AAPL	Stock	47.625	47.625	47.625	47.625	6396.0
2018-07-31 07:20:00	AAPL	Stock	47.625	47.625	47.615	47.615	6540.0
2018-07-31 07:25:00	AAPL	Stock	47.62	47.6475	47.62	47.6475	14120.0
2018-07-31 07:30:00	AAPL	Stock	47.65	47.6625	47.64	47.6625	6536.0
2018-07-31 07:35:00	AAPL	Stock	47.6625	47.7125	47.6625	47.6875	21088.0
2018-07-31 07:40:00	AAPL	Stock	47.6875	47.6875	47.6625	47.6625	7740.0
2018-07-31 07:45:00	AAPL	Stock	47.6425	47.675	47.6375	47.675	5288.0
2018-07-31 07:50:00	AAPL	Stock	47.6875	47.6925	47.675	47.6925	2660.0
2018-07-31 07:55:00	AAPL	Stock	47.6975	47.71	47.6975	47.7075	9908.0
2018-07-31 08:00:00	AAPL	Stock	47.7025	47.7082	47.5538	47.65	53192.0
2018-07-31 08:05:00	AAPL	Stock	47.67	47.675	47.65	47.665	2444.0
2018-07-31 08:10:00	AAPL	Stock	47.6625	47.675	47.6625	47.67	11568.0
2018-07-31 08:15:00	AAPL	Stock	47.67	47.675	47.6625	47.675	6772.0
2018-07-31 08:20:00	AAPL	Stock	47.6625	47.6625	47.6375	47.645	19340.0
2018-07-31 08:25:00	AAPL	Stock	47.65	47.65	47.6375	47.6475	4600.0
2018-07-31 08:30:00	AAPL	Stock	47.655	47.6625	47.6325	47.65	18916.0
2018-07-31 08:35:00	AAPL	Stock	47.65	47.675	47.65	47.675	16072.0
2018-07-31 08:40:00	AAPL	Stock	47.6825	47.6925	47.6575	47.6575	25732.0
2018-07-31 08:45:00	AAPL	Stock	47.6525	47.6575	47.6025	47.6025	39156.0
2018-07-31 08:50:00	AAPL	Stock	47.6075	47.6125	47.575	47.5825	41452.0
2018-07-31 08:55:00	AAPL	Stock	47.6	47.6075	47.5875	47.6025	22976.0
2018-07-31 09:00:00	AAPL	Stock	47.61	47.61	47.5775	47.5775	52716.0
2018-07-31 09:05:00	AAPL	Stock	47.575	47.575	47.4875	47.5075	99204.0
2018-07-31 09:10:00	AAPL	Stock	47.5025	47.5225	47.4775	47.4775	37992.0
2018-07-31 09:15:00	AAPL	Stock	47.5	47.525	47.5	47.5225	29588.0
2018-07-31 09:20:00	AAPL	Stock	47.505	47.7675	47.505	47.7	107452.0
2018-07-31 09:25:00	AAPL	Stock	47.685	47.7125	47.54	47.5875	100364.0
2018-07-31 09:30:00	AAPL	Stock	47.585	47.625	47.4775	47.5275	3303344.0

> showing 50 of 355,751 rows — these rows as CSV

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