PREVIEW / stock_5min / 2017-06-30

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-30.parquet
  size:    5.3 MB
  rows:    348,468
  symbols: 3,010

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-06-30 05:00:00	AAPL	Stock	35.9875	35.9875	35.9875	35.9875	6968.0
2017-06-30 06:00:00	AAPL	Stock	36.0475	36.0475	36.0475	36.0475	1400.0
2017-06-30 06:05:00	AAPL	Stock	36.0225	36.065	36.0225	36.065	1880.0
2017-06-30 06:10:00	AAPL	Stock	36.0625	36.065	36.0625	36.065	2960.0
2017-06-30 06:15:00	AAPL	Stock	36.0725	36.0725	36.0725	36.0725	400.0
2017-06-30 06:30:00	AAPL	Stock	36.055	36.055	36.0525	36.0525	1820.0
2017-06-30 06:55:00	AAPL	Stock	36.09	36.09	36.09	36.09	892.0
2017-06-30 07:00:00	AAPL	Stock	36.0675	36.08	36.0675	36.08	4800.0
2017-06-30 07:05:00	AAPL	Stock	36.1	36.115	36.1	36.115	16960.0
2017-06-30 07:10:00	AAPL	Stock	36.125	36.145	36.1225	36.1225	43884.0
2017-06-30 07:15:00	AAPL	Stock	36.1125	36.1125	36.1075	36.1075	2848.0
2017-06-30 07:20:00	AAPL	Stock	36.1025	36.1025	36.1025	36.1025	5072.0
2017-06-30 07:25:00	AAPL	Stock	36.105	36.105	36.075	36.075	12472.0
2017-06-30 07:30:00	AAPL	Stock	36.0625	36.08	36.0625	36.08	5600.0
2017-06-30 07:35:00	AAPL	Stock	36.08	36.0875	36.08	36.0875	2400.0
2017-06-30 07:40:00	AAPL	Stock	36.0775	36.0775	36.0775	36.0775	4000.0
2017-06-30 07:50:00	AAPL	Stock	36.07	36.075	36.0675	36.075	4392.0
2017-06-30 07:55:00	AAPL	Stock	36.0825	36.0825	36.0675	36.0675	1792.0
2017-06-30 08:00:00	AAPL	Stock	36.1125	36.145	36.0425	36.0425	50164.0
2017-06-30 08:05:00	AAPL	Stock	36.025	36.0775	36.025	36.0775	64064.0
2017-06-30 08:10:00	AAPL	Stock	36.0775	36.0775	36.045	36.0625	8540.0
2017-06-30 08:15:00	AAPL	Stock	36.05	36.0575	36.025	36.0375	14348.0
2017-06-30 08:20:00	AAPL	Stock	36.0275	36.0275	35.9875	35.9875	15132.0
2017-06-30 08:25:00	AAPL	Stock	35.9875	36.0	35.985	36.0	8076.0
2017-06-30 08:30:00	AAPL	Stock	35.99	36.025	35.9875	36.0	25160.0
2017-06-30 08:35:00	AAPL	Stock	35.9975	35.9975	35.93	35.935	25940.0
2017-06-30 08:40:00	AAPL	Stock	35.925	35.925	35.9	35.92	88604.0
2017-06-30 08:45:00	AAPL	Stock	35.9025	35.91	35.86	35.91	29876.0
2017-06-30 08:50:00	AAPL	Stock	35.9	35.925	35.8875	35.925	11516.0
2017-06-30 08:55:00	AAPL	Stock	35.945	35.945	35.9	35.9	2224.0
2017-06-30 09:00:00	AAPL	Stock	35.9	35.905	35.8775	35.905	12584.0
2017-06-30 09:10:00	AAPL	Stock	35.9175	35.9325	35.9125	35.9125	10596.0
2017-06-30 09:15:00	AAPL	Stock	35.915	35.915	35.89	35.89	2336.0
2017-06-30 09:20:00	AAPL	Stock	35.9225	35.925	35.92	35.9225	6640.0
2017-06-30 09:25:00	AAPL	Stock	35.945	36.4225	35.9425	36.19	1056612.0
2017-06-30 09:30:00	AAPL	Stock	36.1125	36.2	36.04	36.0875	8764132.0
2017-06-30 09:35:00	AAPL	Stock	36.0925	36.105	35.9975	36.0975	1778240.0
2017-06-30 09:40:00	AAPL	Stock	36.0975	36.155	36.045	36.1125	1463220.0
2017-06-30 09:45:00	AAPL	Stock	36.12	36.1925	36.095	36.1625	1375432.0
2017-06-30 09:50:00	AAPL	Stock	36.17	36.24	36.115	36.135	1828084.0
2017-06-30 09:55:00	AAPL	Stock	36.14	36.1475	36.0675	36.1075	1290596.0
2017-06-30 10:00:00	AAPL	Stock	36.107	36.13	36.045	36.0465	1176352.0
2017-06-30 10:05:00	AAPL	Stock	36.0488	36.0912	36.0025	36.075	1106644.0
2017-06-30 10:10:00	AAPL	Stock	36.07	36.085	36.0075	36.0175	728704.0
2017-06-30 10:15:00	AAPL	Stock	36.0175	36.03	35.9648	36.005	1217876.0
2017-06-30 10:20:00	AAPL	Stock	36.0075	36.0875	35.9975	36.0872	625568.0
2017-06-30 10:25:00	AAPL	Stock	36.0835	36.105	36.065	36.0975	717244.0
2017-06-30 10:30:00	AAPL	Stock	36.1025	36.1352	36.0825	36.1025	1079928.0
2017-06-30 10:35:00	AAPL	Stock	36.1025	36.115	36.0325	36.0325	959476.0
2017-06-30 10:40:00	AAPL	Stock	36.0325	36.055	35.995	36.02	934648.0

> showing 50 of 348,468 rows — these rows as CSV

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