PREVIEW / stock_5min / 2017-05-23

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-05-23.parquet
  size:    5.3 MB
  rows:    346,072
  symbols: 3,044

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-05-23 04:00:00	AAPL	Stock	38.5075	38.575	38.5075	38.575	4128.0
2017-05-23 04:55:00	AAPL	Stock	38.5625	38.5625	38.5	38.5	4560.0
2017-05-23 05:45:00	AAPL	Stock	38.595	38.6	38.595	38.6	2800.0
2017-05-23 06:05:00	AAPL	Stock	38.5375	38.5375	38.5375	38.5375	7700.0
2017-05-23 06:10:00	AAPL	Stock	38.545	38.545	38.545	38.545	2000.0
2017-05-23 06:15:00	AAPL	Stock	38.5475	38.5475	38.5475	38.5475	400.0
2017-05-23 06:20:00	AAPL	Stock	38.55	38.55	38.55	38.55	400.0
2017-05-23 06:25:00	AAPL	Stock	38.555	38.555	38.555	38.555	2384.0
2017-05-23 06:35:00	AAPL	Stock	38.5375	38.575	38.5375	38.575	3744.0
2017-05-23 07:00:00	AAPL	Stock	38.5825	38.5875	38.5825	38.5825	3428.0
2017-05-23 07:05:00	AAPL	Stock	38.585	38.6125	38.585	38.6025	12680.0
2017-05-23 07:10:00	AAPL	Stock	38.6025	38.6025	38.6	38.6	6140.0
2017-05-23 07:15:00	AAPL	Stock	38.6	38.6	38.6	38.6	1532.0
2017-05-23 07:20:00	AAPL	Stock	38.6	38.61	38.6	38.61	4280.0
2017-05-23 07:25:00	AAPL	Stock	38.6125	38.6475	38.6125	38.6475	13132.0
2017-05-23 07:30:00	AAPL	Stock	38.6625	38.7	38.6625	38.7	8072.0
2017-05-23 07:35:00	AAPL	Stock	38.6775	38.685	38.6775	38.685	1700.0
2017-05-23 07:40:00	AAPL	Stock	38.665	38.665	38.665	38.665	1840.0
2017-05-23 07:45:00	AAPL	Stock	38.675	38.675	38.675	38.675	10272.0
2017-05-23 07:50:00	AAPL	Stock	38.675	38.675	38.65	38.65	10328.0
2017-05-23 08:00:00	AAPL	Stock	38.65	38.685	38.625	38.65	42576.0
2017-05-23 08:05:00	AAPL	Stock	38.6525	38.655	38.6425	38.65	16360.0
2017-05-23 08:10:00	AAPL	Stock	38.655	38.675	38.655	38.675	30656.0
2017-05-23 08:15:00	AAPL	Stock	38.6825	38.6875	38.675	38.675	13472.0
2017-05-23 08:20:00	AAPL	Stock	38.675	38.705	38.675	38.69	55960.0
2017-05-23 08:25:00	AAPL	Stock	38.7075	38.7075	38.6925	38.6925	12432.0
2017-05-23 08:30:00	AAPL	Stock	38.7	38.7075	38.6625	38.675	34988.0
2017-05-23 08:35:00	AAPL	Stock	38.6975	38.7	38.6975	38.7	10400.0
2017-05-23 08:40:00	AAPL	Stock	38.705	38.725	38.7	38.725	21704.0
2017-05-23 08:45:00	AAPL	Stock	38.71	38.7175	38.7075	38.7075	10068.0
2017-05-23 08:50:00	AAPL	Stock	38.7075	38.7075	38.7	38.7	9128.0
2017-05-23 08:55:00	AAPL	Stock	38.7	38.7075	38.6975	38.6975	14664.0
2017-05-23 09:00:00	AAPL	Stock	38.6975	38.7375	38.6975	38.7375	35280.0
2017-05-23 09:05:00	AAPL	Stock	38.745	38.7475	38.735	38.7375	33796.0
2017-05-23 09:10:00	AAPL	Stock	38.735	38.7475	38.725	38.7275	52160.0
2017-05-23 09:15:00	AAPL	Stock	38.725	38.7475	38.725	38.7325	10944.0
2017-05-23 09:20:00	AAPL	Stock	38.73	38.73	38.715	38.7175	11596.0
2017-05-23 09:25:00	AAPL	Stock	38.72	38.745	38.7125	38.725	69120.0
2017-05-23 09:30:00	AAPL	Stock	38.7225	38.725	38.475	38.5125	5979464.0
2017-05-23 09:35:00	AAPL	Stock	38.5175	38.6075	38.5025	38.5598	1945584.0
2017-05-23 09:40:00	AAPL	Stock	38.5595	38.565	38.4825	38.4895	1696548.0
2017-05-23 09:45:00	AAPL	Stock	38.49	38.5275	38.465	38.4782	1386964.0
2017-05-23 09:50:00	AAPL	Stock	38.4775	38.5012	38.445	38.485	1447424.0
2017-05-23 09:55:00	AAPL	Stock	38.4825	38.4975	38.45	38.465	1213140.0
2017-05-23 10:00:00	AAPL	Stock	38.465	38.51	38.4325	38.51	1300520.0
2017-05-23 10:05:00	AAPL	Stock	38.51	38.575	38.5	38.5688	1764472.0
2017-05-23 10:10:00	AAPL	Stock	38.57	38.5775	38.52	38.53	1257676.0
2017-05-23 10:15:00	AAPL	Stock	38.53	38.545	38.5025	38.515	838160.0
2017-05-23 10:20:00	AAPL	Stock	38.5125	38.5475	38.5	38.5375	1035560.0
2017-05-23 10:25:00	AAPL	Stock	38.5352	38.5372	38.515	38.5162	580600.0

> showing 50 of 346,072 rows — these rows as CSV

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