PREVIEW / stock_5min / 2018-05-01

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-05-01.parquet
  size:    5.4 MB
  rows:    349,806
  symbols: 2,840

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-05-01 04:00:00	AAPL	Stock	41.55	41.55	41.55	41.55	1904.0
2018-05-01 04:10:00	AAPL	Stock	41.535	41.55	41.535	41.55	7600.0
2018-05-01 04:35:00	AAPL	Stock	41.525	41.5975	41.5125	41.5975	9508.0
2018-05-01 04:45:00	AAPL	Stock	41.5	41.5	41.5	41.5	1200.0
2018-05-01 04:55:00	AAPL	Stock	41.495	41.5	41.495	41.5	1480.0
2018-05-01 06:15:00	AAPL	Stock	41.47	41.47	41.47	41.47	400.0
2018-05-01 06:25:00	AAPL	Stock	41.4275	41.4325	41.425	41.425	2400.0
2018-05-01 06:45:00	AAPL	Stock	41.475	41.475	41.475	41.475	400.0
2018-05-01 06:50:00	AAPL	Stock	41.5275	41.5275	41.5275	41.5275	2000.0
2018-05-01 06:55:00	AAPL	Stock	41.475	41.475	41.475	41.475	800.0
2018-05-01 07:00:00	AAPL	Stock	41.5	41.5875	41.5	41.5875	26916.0
2018-05-01 07:05:00	AAPL	Stock	41.5875	41.5975	41.55	41.575	21824.0
2018-05-01 07:10:00	AAPL	Stock	41.5875	41.685	41.5875	41.6825	20008.0
2018-05-01 07:15:00	AAPL	Stock	41.6625	41.685	41.6275	41.6825	27000.0
2018-05-01 07:20:00	AAPL	Stock	41.68	41.7125	41.675	41.7	53956.0
2018-05-01 07:25:00	AAPL	Stock	41.69	41.6975	41.6375	41.6625	16160.0
2018-05-01 07:30:00	AAPL	Stock	41.6575	41.74	41.6575	41.7125	27312.0
2018-05-01 07:35:00	AAPL	Stock	41.7	41.7	41.655	41.6925	43044.0
2018-05-01 07:40:00	AAPL	Stock	41.6575	41.7525	41.6575	41.72	103048.0
2018-05-01 07:45:00	AAPL	Stock	41.7125	41.7125	41.675	41.6875	8056.0
2018-05-01 07:50:00	AAPL	Stock	41.6875	41.6975	41.635	41.65	14020.0
2018-05-01 07:55:00	AAPL	Stock	41.66	41.6625	41.575	41.58	36920.0
2018-05-01 08:00:00	AAPL	Stock	41.7235	41.75	41.5625	41.6075	118324.0
2018-05-01 08:05:00	AAPL	Stock	41.62	41.62	41.565	41.6125	36044.0
2018-05-01 08:10:00	AAPL	Stock	41.5875	41.62	41.5875	41.6125	15348.0
2018-05-01 08:15:00	AAPL	Stock	41.5875	41.6125	41.5875	41.6075	28400.0
2018-05-01 08:20:00	AAPL	Stock	41.6075	41.65	41.5925	41.6475	26612.0
2018-05-01 08:25:00	AAPL	Stock	41.6475	41.6625	41.625	41.6375	43156.0
2018-05-01 08:30:00	AAPL	Stock	41.64	41.6625	41.6375	41.66	29080.0
2018-05-01 08:35:00	AAPL	Stock	41.6625	41.675	41.6525	41.6525	47244.0
2018-05-01 08:40:00	AAPL	Stock	41.65	41.6625	41.63	41.645	27260.0
2018-05-01 08:45:00	AAPL	Stock	41.64	41.675	41.64	41.675	31632.0
2018-05-01 08:50:00	AAPL	Stock	41.6525	41.6625	41.6125	41.6275	43480.0
2018-05-01 08:55:00	AAPL	Stock	41.6275	41.6275	41.55	41.565	66988.0
2018-05-01 09:00:00	AAPL	Stock	41.575	41.575	41.465	41.475	154608.0
2018-05-01 09:05:00	AAPL	Stock	41.4875	41.51	41.4525	41.51	75248.0
2018-05-01 09:10:00	AAPL	Stock	41.4875	41.515	41.4825	41.4825	37840.0
2018-05-01 09:15:00	AAPL	Stock	41.4975	41.4975	41.45	41.4875	73172.0
2018-05-01 09:20:00	AAPL	Stock	41.4925	41.5125	41.48	41.4925	51512.0
2018-05-01 09:25:00	AAPL	Stock	41.4925	41.615	41.4825	41.595	74400.0
2018-05-01 09:30:00	AAPL	Stock	41.6025	41.7925	41.5625	41.6	6348896.0
2018-05-01 09:35:00	AAPL	Stock	41.595	41.6322	41.3175	41.4325	4005548.0
2018-05-01 09:40:00	AAPL	Stock	41.4325	41.525	41.39	41.5025	2396776.0
2018-05-01 09:45:00	AAPL	Stock	41.5	41.69	41.5	41.6125	2688004.0
2018-05-01 09:50:00	AAPL	Stock	41.6175	41.66	41.57	41.615	1629024.0
2018-05-01 09:55:00	AAPL	Stock	41.6175	41.745	41.61	41.715	2159604.0
2018-05-01 10:00:00	AAPL	Stock	41.7025	41.825	41.695	41.7325	3307384.0
2018-05-01 10:05:00	AAPL	Stock	41.7332	41.77	41.6875	41.695	2085864.0
2018-05-01 10:10:00	AAPL	Stock	41.695	41.9125	41.6875	41.905	3419848.0
2018-05-01 10:15:00	AAPL	Stock	41.905	41.9625	41.85	41.9425	3507676.0

> showing 50 of 349,806 rows — these rows as CSV

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