PREVIEW / stock_5min / 2017-03-31

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-31.parquet
  size:    5.4 MB
  rows:    354,615
  symbols: 3,076

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-03-31 04:10:00	AAPL	Stock	35.88	35.88	35.88	35.88	896.0
2017-03-31 04:15:00	AAPL	Stock	35.88	35.88	35.88	35.88	1012.0
2017-03-31 05:50:00	AAPL	Stock	35.8825	35.8825	35.8825	35.8825	800.0
2017-03-31 05:55:00	AAPL	Stock	35.8825	35.8825	35.8825	35.8825	420.0
2017-03-31 06:40:00	AAPL	Stock	35.8775	35.8775	35.8775	35.8775	800.0
2017-03-31 06:50:00	AAPL	Stock	35.92	35.9225	35.92	35.92	12420.0
2017-03-31 07:10:00	AAPL	Stock	35.89	35.89	35.88	35.88	9540.0
2017-03-31 07:20:00	AAPL	Stock	35.91	35.9125	35.91	35.9125	3916.0
2017-03-31 07:25:00	AAPL	Stock	35.9	35.9	35.89	35.9	2800.0
2017-03-31 07:30:00	AAPL	Stock	35.91	35.9125	35.91	35.9125	1600.0
2017-03-31 07:35:00	AAPL	Stock	35.9075	35.9075	35.9075	35.9075	400.0
2017-03-31 07:40:00	AAPL	Stock	35.89	35.89	35.8875	35.8875	1500.0
2017-03-31 07:45:00	AAPL	Stock	35.9075	35.9125	35.9075	35.9125	4400.0
2017-03-31 07:50:00	AAPL	Stock	35.9125	35.9125	35.9125	35.9125	3600.0
2017-03-31 07:55:00	AAPL	Stock	35.9225	35.925	35.9225	35.925	800.0
2017-03-31 08:00:00	AAPL	Stock	35.9	35.925	35.9	35.925	4840.0
2017-03-31 08:05:00	AAPL	Stock	35.925	35.925	35.925	35.925	940.0
2017-03-31 08:10:00	AAPL	Stock	35.93	35.95	35.93	35.935	7788.0
2017-03-31 08:15:00	AAPL	Stock	35.935	35.95	35.935	35.95	2620.0
2017-03-31 08:20:00	AAPL	Stock	35.945	35.945	35.945	35.945	400.0
2017-03-31 08:25:00	AAPL	Stock	35.945	35.9575	35.945	35.95	3536.0
2017-03-31 08:30:00	AAPL	Stock	35.95	35.96	35.945	35.9575	14208.0
2017-03-31 08:35:00	AAPL	Stock	35.9525	35.955	35.95	35.955	5324.0
2017-03-31 08:40:00	AAPL	Stock	35.9625	35.9625	35.9625	35.9625	1160.0
2017-03-31 08:45:00	AAPL	Stock	35.975	35.975	35.95	35.95	6816.0
2017-03-31 08:55:00	AAPL	Stock	35.95	35.955	35.95	35.95	9504.0
2017-03-31 09:00:00	AAPL	Stock	35.9475	35.9475	35.925	35.925	18680.0
2017-03-31 09:05:00	AAPL	Stock	35.9375	35.945	35.9225	35.9325	16288.0
2017-03-31 09:10:00	AAPL	Stock	35.935	35.935	35.935	35.935	9400.0
2017-03-31 09:20:00	AAPL	Stock	35.9375	35.9375	35.9325	35.9375	32752.0
2017-03-31 09:25:00	AAPL	Stock	35.925	35.935	35.905	35.9125	33464.0
2017-03-31 09:30:00	AAPL	Stock	35.93	35.9575	35.7525	35.9225	5457188.0
2017-03-31 09:35:00	AAPL	Stock	35.92	35.9525	35.8975	35.9	1244020.0
2017-03-31 09:40:00	AAPL	Stock	35.8988	35.9175	35.8775	35.895	1264640.0
2017-03-31 09:45:00	AAPL	Stock	35.8938	35.9375	35.88	35.92	1237900.0
2017-03-31 09:50:00	AAPL	Stock	35.92	35.9725	35.9105	35.965	1116856.0
2017-03-31 09:55:00	AAPL	Stock	35.965	35.975	35.9425	35.945	968724.0
2017-03-31 10:00:00	AAPL	Stock	35.9462	36.0125	35.945	36.0088	1303540.0
2017-03-31 10:05:00	AAPL	Stock	36.01	36.06	36.01	36.04	1697868.0
2017-03-31 10:10:00	AAPL	Stock	36.04	36.045	36.025	36.035	883372.0
2017-03-31 10:15:00	AAPL	Stock	36.0325	36.0675	36.03	36.045	844740.0
2017-03-31 10:20:00	AAPL	Stock	36.0458	36.0458	36.0175	36.0215	698208.0
2017-03-31 10:25:00	AAPL	Stock	36.0225	36.045	35.9775	35.9933	1493740.0
2017-03-31 10:30:00	AAPL	Stock	35.995	36.0125	35.9903	36.0	528852.0
2017-03-31 10:35:00	AAPL	Stock	36.0	36.0175	35.9975	36.0037	704608.0
2017-03-31 10:40:00	AAPL	Stock	36.005	36.005	35.9775	35.9825	708284.0
2017-03-31 10:45:00	AAPL	Stock	35.98	35.9925	35.94	35.955	955000.0
2017-03-31 10:50:00	AAPL	Stock	35.9575	36.0275	35.95	36.01	1167604.0
2017-03-31 10:55:00	AAPL	Stock	36.0075	36.0175	35.9925	35.996	506040.0
2017-03-31 11:00:00	AAPL	Stock	35.995	36.01	35.9862	35.995	598756.0

> showing 50 of 354,615 rows — these rows as CSV

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