PREVIEW / stock_5min / 2019-06-28

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-06-28.parquet
  size:    5.9 MB
  rows:    379,684
  symbols: 2,617

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
2019-06-28 04:00:00	AAPL	Stock	49.65	49.69	49.61	49.61	6416.0
2019-06-28 04:05:00	AAPL	Stock	49.5025	49.5025	49.4375	49.4375	1672.0
2019-06-28 04:10:00	AAPL	Stock	49.4775	49.4775	49.4775	49.4775	400.0
2019-06-28 04:15:00	AAPL	Stock	49.55	49.55	49.55	49.55	892.0
2019-06-28 04:20:00	AAPL	Stock	49.5625	49.5625	49.55	49.55	2308.0
2019-06-28 04:40:00	AAPL	Stock	49.5775	49.5775	49.5	49.5	3212.0
2019-06-28 04:45:00	AAPL	Stock	49.4625	49.4625	49.4375	49.4375	1372.0
2019-06-28 04:50:00	AAPL	Stock	49.495	49.5	49.495	49.5	1200.0
2019-06-28 05:00:00	AAPL	Stock	49.5	49.5	49.5	49.5	640.0
2019-06-28 05:10:00	AAPL	Stock	49.4675	49.4675	49.4675	49.4675	1200.0
2019-06-28 05:15:00	AAPL	Stock	49.4675	49.4675	49.4675	49.4675	2248.0
2019-06-28 05:35:00	AAPL	Stock	49.48	49.48	49.48	49.48	1080.0
2019-06-28 06:15:00	AAPL	Stock	49.5225	49.5225	49.52	49.52	2800.0
2019-06-28 06:20:00	AAPL	Stock	49.5	49.5	49.475	49.475	2040.0
2019-06-28 06:45:00	AAPL	Stock	49.5	49.515	49.5	49.515	1600.0
2019-06-28 06:55:00	AAPL	Stock	49.51	49.51	49.51	49.51	400.0
2019-06-28 07:00:00	AAPL	Stock	49.5	49.575	49.475	49.575	12184.0
2019-06-28 07:05:00	AAPL	Stock	49.5725	49.6175	49.5725	49.61	10804.0
2019-06-28 07:10:00	AAPL	Stock	49.6225	49.6475	49.6225	49.64	13008.0
2019-06-28 07:15:00	AAPL	Stock	49.64	49.6875	49.64	49.6625	11164.0
2019-06-28 07:20:00	AAPL	Stock	49.6375	49.6675	49.6375	49.65	3260.0
2019-06-28 07:25:00	AAPL	Stock	49.64	49.6425	49.5525	49.5525	32904.0
2019-06-28 07:30:00	AAPL	Stock	49.6125	49.6125	49.6	49.6	1680.0
2019-06-28 07:35:00	AAPL	Stock	49.5875	49.61	49.5825	49.605	2844.0
2019-06-28 07:40:00	AAPL	Stock	49.61	49.625	49.6	49.605	11924.0
2019-06-28 07:45:00	AAPL	Stock	49.605	49.6075	49.575	49.575	9800.0
2019-06-28 07:50:00	AAPL	Stock	49.6075	49.625	49.605	49.625	5200.0
2019-06-28 07:55:00	AAPL	Stock	49.62	49.6375	49.615	49.6375	11824.0
2019-06-28 08:00:00	AAPL	Stock	49.525	49.72	49.515	49.5775	142052.0
2019-06-28 08:05:00	AAPL	Stock	49.6	49.6	49.555	49.5975	23684.0
2019-06-28 08:10:00	AAPL	Stock	49.5925	49.5925	49.58	49.5925	3200.0
2019-06-28 08:15:00	AAPL	Stock	49.61	49.6225	49.6	49.6	17596.0
2019-06-28 08:20:00	AAPL	Stock	49.58	49.6125	49.58	49.6	11600.0
2019-06-28 08:25:00	AAPL	Stock	49.5875	49.5875	49.555	49.5575	11836.0
2019-06-28 08:30:00	AAPL	Stock	49.5625	49.5625	49.5375	49.5375	20412.0
2019-06-28 08:35:00	AAPL	Stock	49.5625	49.675	49.5625	49.65	55372.0
2019-06-28 08:40:00	AAPL	Stock	49.6775	49.7	49.6275	49.6275	30560.0
2019-06-28 08:45:00	AAPL	Stock	49.6625	49.685	49.65	49.685	22848.0
2019-06-28 08:50:00	AAPL	Stock	49.69	49.6925	49.6525	49.6775	20904.0
2019-06-28 08:55:00	AAPL	Stock	49.6865	49.705	49.6625	49.6625	36932.0
2019-06-28 09:00:00	AAPL	Stock	49.6625	49.675	49.625	49.675	33208.0
2019-06-28 09:05:00	AAPL	Stock	49.675	49.675	49.625	49.6425	29536.0
2019-06-28 09:10:00	AAPL	Stock	49.6425	49.675	49.6425	49.675	33140.0
2019-06-28 09:15:00	AAPL	Stock	49.6868	49.75	49.675	49.725	29124.0
2019-06-28 09:20:00	AAPL	Stock	49.725	49.75	49.675	49.6875	47440.0
2019-06-28 09:25:00	AAPL	Stock	49.6875	49.7	49.6225	49.6675	48744.0
2019-06-28 09:30:00	AAPL	Stock	49.68	49.8738	49.65	49.7175	3774948.0
2019-06-28 09:35:00	AAPL	Stock	49.7175	49.7475	49.5875	49.605	1568728.0
2019-06-28 09:40:00	AAPL	Stock	49.605	49.6062	49.5075	49.5675	1518284.0
2019-06-28 09:45:00	AAPL	Stock	49.5775	49.5842	49.4475	49.4875	1361404.0

> showing 50 of 379,684 rows — these rows as CSV

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