PREVIEW / stock_5min / 2017-08-25

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-25.parquet
  size:    5.1 MB
  rows:    335,361
  symbols: 2,963

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-08-25 05:40:00	AAPL	Stock	39.875	39.875	39.875	39.875	4000.0
2017-08-25 06:00:00	AAPL	Stock	39.9225	39.9225	39.9225	39.9225	800.0
2017-08-25 06:20:00	AAPL	Stock	39.9475	39.9475	39.9475	39.9475	800.0
2017-08-25 06:35:00	AAPL	Stock	39.9625	39.9625	39.9625	39.9625	400.0
2017-08-25 06:45:00	AAPL	Stock	39.985	39.9925	39.985	39.9925	1196.0
2017-08-25 06:55:00	AAPL	Stock	39.9875	39.9925	39.9875	39.9925	6676.0
2017-08-25 07:00:00	AAPL	Stock	39.965	39.99	39.965	39.9875	2276.0
2017-08-25 07:05:00	AAPL	Stock	39.985	40.0	39.985	40.0	9480.0
2017-08-25 07:10:00	AAPL	Stock	40.025	40.05	40.0	40.0	18192.0
2017-08-25 07:15:00	AAPL	Stock	40.025	40.025	40.025	40.025	1200.0
2017-08-25 07:20:00	AAPL	Stock	40.025	40.025	40.025	40.025	800.0
2017-08-25 07:25:00	AAPL	Stock	40.025	40.025	40.025	40.025	1200.0
2017-08-25 07:30:00	AAPL	Stock	40.025	40.025	40.025	40.025	1948.0
2017-08-25 07:35:00	AAPL	Stock	40.03	40.0425	40.03	40.04	5996.0
2017-08-25 07:40:00	AAPL	Stock	40.0425	40.0875	40.0375	40.0875	26568.0
2017-08-25 07:45:00	AAPL	Stock	40.0875	40.0975	40.0575	40.075	13940.0
2017-08-25 07:50:00	AAPL	Stock	40.075	40.075	40.075	40.075	1200.0
2017-08-25 08:00:00	AAPL	Stock	40.0	40.075	39.9975	40.07	49820.0
2017-08-25 08:05:00	AAPL	Stock	40.05	40.07	40.05	40.07	14532.0
2017-08-25 08:10:00	AAPL	Stock	40.0625	40.0625	40.04	40.0475	17948.0
2017-08-25 08:15:00	AAPL	Stock	40.04	40.045	40.0125	40.0125	17600.0
2017-08-25 08:20:00	AAPL	Stock	40.0325	40.0325	40.0	40.0	11496.0
2017-08-25 08:25:00	AAPL	Stock	40.0225	40.0225	40.02	40.02	2000.0
2017-08-25 08:30:00	AAPL	Stock	40.0225	40.0225	39.9875	39.9875	11100.0
2017-08-25 08:35:00	AAPL	Stock	39.9875	40.0125	39.9625	39.975	62044.0
2017-08-25 08:40:00	AAPL	Stock	40.0125	40.0125	39.9625	40.0	47660.0
2017-08-25 08:45:00	AAPL	Stock	39.9975	39.9975	39.9975	39.9975	400.0
2017-08-25 08:50:00	AAPL	Stock	39.965	39.9875	39.965	39.9875	20204.0
2017-08-25 08:55:00	AAPL	Stock	39.9875	40.0075	39.9875	40.0075	17344.0
2017-08-25 09:00:00	AAPL	Stock	40.0	40.0025	39.99	39.99	14084.0
2017-08-25 09:05:00	AAPL	Stock	39.975	39.9825	39.9675	39.9675	2200.0
2017-08-25 09:10:00	AAPL	Stock	39.96	39.9775	39.9	39.9225	65676.0
2017-08-25 09:15:00	AAPL	Stock	39.905	39.925	39.905	39.925	30404.0
2017-08-25 09:20:00	AAPL	Stock	39.9025	39.9725	39.8875	39.9725	31096.0
2017-08-25 09:25:00	AAPL	Stock	39.9625	39.9625	39.88	39.9075	20692.0
2017-08-25 09:30:00	AAPL	Stock	39.9125	40.04	39.895	40.0125	3026796.0
2017-08-25 09:35:00	AAPL	Stock	40.0075	40.0375	39.9625	39.9625	1656144.0
2017-08-25 09:40:00	AAPL	Stock	39.97	40.07	39.97	40.045	1988700.0
2017-08-25 09:45:00	AAPL	Stock	40.048	40.05	40.0025	40.0338	1094268.0
2017-08-25 09:50:00	AAPL	Stock	40.0338	40.07	40.0	40.0662	2266064.0
2017-08-25 09:55:00	AAPL	Stock	40.065	40.0975	40.02	40.0375	1335964.0
2017-08-25 10:00:00	AAPL	Stock	40.0375	40.1175	40.03	40.055	1857812.0
2017-08-25 10:05:00	AAPL	Stock	40.0575	40.09	40.03	40.0672	761260.0
2017-08-25 10:10:00	AAPL	Stock	40.0635	40.119	40.0575	40.1	1015188.0
2017-08-25 10:15:00	AAPL	Stock	40.1	40.135	40.0075	40.105	1475032.0
2017-08-25 10:20:00	AAPL	Stock	40.105	40.1138	40.0548	40.0825	709484.0
2017-08-25 10:25:00	AAPL	Stock	40.0775	40.1125	40.0575	40.105	614496.0
2017-08-25 10:30:00	AAPL	Stock	40.107	40.1175	40.07	40.09	643560.0
2017-08-25 10:35:00	AAPL	Stock	40.09	40.1375	40.09	40.1285	902840.0
2017-08-25 10:40:00	AAPL	Stock	40.1275	40.14	40.075	40.0775	959068.0

> showing 50 of 335,361 rows — these rows as CSV

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