PREVIEW / stock_5min / 2018-05-22

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-05-22.parquet
  size:    5.6 MB
  rows:    356,906
  symbols: 2,856

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-22 04:20:00	AAPL	Stock	46.98	46.98	46.98	46.98	1332.0
2018-05-22 06:05:00	AAPL	Stock	47.0275	47.0275	47.0275	47.0275	612.0
2018-05-22 06:50:00	AAPL	Stock	47.0725	47.0725	47.025	47.025	4548.0
2018-05-22 06:55:00	AAPL	Stock	47.07	47.075	47.07	47.075	3100.0
2018-05-22 07:00:00	AAPL	Stock	47.0325	47.075	47.0325	47.075	24064.0
2018-05-22 07:05:00	AAPL	Stock	47.085	47.095	47.085	47.0925	11720.0
2018-05-22 07:10:00	AAPL	Stock	47.095	47.1075	47.095	47.1075	21556.0
2018-05-22 07:15:00	AAPL	Stock	47.11	47.12	47.11	47.1175	27312.0
2018-05-22 07:20:00	AAPL	Stock	47.1175	47.1175	47.1175	47.1175	1780.0
2018-05-22 07:25:00	AAPL	Stock	47.125	47.125	47.1	47.1	10732.0
2018-05-22 07:30:00	AAPL	Stock	47.0875	47.0875	47.0875	47.0875	1600.0
2018-05-22 07:35:00	AAPL	Stock	47.095	47.095	47.07	47.08	20136.0
2018-05-22 07:45:00	AAPL	Stock	47.0875	47.095	47.08	47.095	6800.0
2018-05-22 07:50:00	AAPL	Stock	47.1	47.1	47.1	47.1	780.0
2018-05-22 08:00:00	AAPL	Stock	47.1125	47.1375	47.0288	47.0975	58676.0
2018-05-22 08:05:00	AAPL	Stock	47.095	47.1125	47.095	47.11	12936.0
2018-05-22 08:10:00	AAPL	Stock	47.11	47.11	47.0875	47.0875	5412.0
2018-05-22 08:15:00	AAPL	Stock	47.09	47.1	47.075	47.075	3344.0
2018-05-22 08:20:00	AAPL	Stock	47.0775	47.0875	47.0775	47.0875	6640.0
2018-05-22 08:30:00	AAPL	Stock	47.095	47.095	47.095	47.095	4000.0
2018-05-22 08:35:00	AAPL	Stock	47.0725	47.0775	47.05	47.0775	6964.0
2018-05-22 08:40:00	AAPL	Stock	47.0462	47.0675	47.0462	47.0625	7668.0
2018-05-22 08:45:00	AAPL	Stock	47.065	47.0675	47.0625	47.0675	4860.0
2018-05-22 08:50:00	AAPL	Stock	47.0725	47.0875	47.0575	47.0575	11100.0
2018-05-22 08:55:00	AAPL	Stock	47.025	47.0625	47.025	47.0625	5960.0
2018-05-22 09:00:00	AAPL	Stock	47.0525	47.0725	47.05	47.0725	6800.0
2018-05-22 09:10:00	AAPL	Stock	47.07	47.08	47.0675	47.07	17552.0
2018-05-22 09:15:00	AAPL	Stock	47.07	47.0725	47.0625	47.0625	4260.0
2018-05-22 09:20:00	AAPL	Stock	47.0752	47.0875	47.075	47.0875	10296.0
2018-05-22 09:25:00	AAPL	Stock	47.0875	47.125	47.085	47.095	15388.0
2018-05-22 09:30:00	AAPL	Stock	47.1225	47.22	47.0625	47.1505	2698740.0
2018-05-22 09:35:00	AAPL	Stock	47.145	47.1975	47.1375	47.185	1526564.0
2018-05-22 09:40:00	AAPL	Stock	47.185	47.205	47.0525	47.1175	1458516.0
2018-05-22 09:45:00	AAPL	Stock	47.1225	47.1325	47.0775	47.104	729052.0
2018-05-22 09:50:00	AAPL	Stock	47.1075	47.11	46.9862	46.9963	930044.0
2018-05-22 09:55:00	AAPL	Stock	46.9975	47.0255	46.9658	46.9875	1028420.0
2018-05-22 10:00:00	AAPL	Stock	46.9875	47.0225	46.9425	46.99	927524.0
2018-05-22 10:05:00	AAPL	Stock	46.9875	47.0425	46.9675	47.0378	861420.0
2018-05-22 10:10:00	AAPL	Stock	47.04	47.0465	46.8675	46.895	1183076.0
2018-05-22 10:15:00	AAPL	Stock	46.89	46.9	46.8428	46.8625	1009520.0
2018-05-22 10:20:00	AAPL	Stock	46.865	46.92	46.86	46.89	899940.0
2018-05-22 10:25:00	AAPL	Stock	46.8925	46.935	46.85	46.8775	757888.0
2018-05-22 10:30:00	AAPL	Stock	46.88	46.9075	46.8452	46.8825	931428.0
2018-05-22 10:35:00	AAPL	Stock	46.8825	46.925	46.8325	46.9075	715824.0
2018-05-22 10:40:00	AAPL	Stock	46.9075	46.9225	46.8525	46.895	586536.0
2018-05-22 10:45:00	AAPL	Stock	46.895	46.915	46.8325	46.8875	537908.0
2018-05-22 10:50:00	AAPL	Stock	46.89	46.9275	46.8575	46.88	400816.0
2018-05-22 10:55:00	AAPL	Stock	46.88	46.9	46.86	46.8625	410120.0
2018-05-22 11:00:00	AAPL	Stock	46.8625	46.9	46.8625	46.885	406968.0
2018-05-22 11:05:00	AAPL	Stock	46.885	46.9075	46.8725	46.875	368488.0

> showing 50 of 356,906 rows — these rows as CSV

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