PREVIEW / stock_5min / 2014-10-31

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-10-31.parquet
  size:    5.7 MB
  rows:    376,001
  symbols: 3,589

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
2014-10-31 04:00:00	AAPL	Stock	26.75	27.5	26.75	27.0525	35420.0
2014-10-31 04:05:00	AAPL	Stock	27.0525	27.0525	27.0	27.0	4760.0
2014-10-31 04:10:00	AAPL	Stock	26.9625	26.9625	26.9625	26.9625	2000.0
2014-10-31 04:15:00	AAPL	Stock	26.94	26.945	26.94	26.945	19728.0
2014-10-31 04:20:00	AAPL	Stock	26.945	26.945	26.9425	26.9425	7832.0
2014-10-31 04:30:00	AAPL	Stock	26.9675	26.9675	26.9675	26.9675	5680.0
2014-10-31 04:35:00	AAPL	Stock	26.975	27.0	26.975	27.0	10604.0
2014-10-31 04:55:00	AAPL	Stock	27.0	27.0025	27.0	27.0025	3200.0
2014-10-31 05:00:00	AAPL	Stock	27.0025	27.0025	27.0	27.0025	9432.0
2014-10-31 05:05:00	AAPL	Stock	27.0025	27.035	27.0025	27.035	11932.0
2014-10-31 05:15:00	AAPL	Stock	27.04	27.04	27.04	27.04	664.0
2014-10-31 05:20:00	AAPL	Stock	27.0425	27.0625	27.0425	27.0625	4400.0
2014-10-31 05:25:00	AAPL	Stock	27.1	27.1	27.0625	27.0625	3000.0
2014-10-31 05:30:00	AAPL	Stock	27.0875	27.1025	27.0875	27.1025	4800.0
2014-10-31 05:35:00	AAPL	Stock	27.11	27.11	27.0875	27.0875	2000.0
2014-10-31 05:40:00	AAPL	Stock	27.0825	27.0825	27.0825	27.0825	800.0
2014-10-31 05:45:00	AAPL	Stock	27.085	27.085	27.08	27.08	9072.0
2014-10-31 05:55:00	AAPL	Stock	27.075	27.075	27.075	27.075	23600.0
2014-10-31 06:00:00	AAPL	Stock	27.085	27.0925	27.085	27.0925	1740.0
2014-10-31 06:05:00	AAPL	Stock	27.075	27.0825	27.075	27.0825	4800.0
2014-10-31 06:15:00	AAPL	Stock	27.075	27.085	27.075	27.085	5760.0
2014-10-31 06:30:00	AAPL	Stock	27.0775	27.09	27.0775	27.09	1200.0
2014-10-31 06:40:00	AAPL	Stock	27.0625	27.0625	27.0625	27.0625	1040.0
2014-10-31 06:50:00	AAPL	Stock	27.0875	27.0875	27.0625	27.0875	16512.0
2014-10-31 07:00:00	AAPL	Stock	27.0775	27.0775	27.0525	27.0525	21760.0
2014-10-31 07:05:00	AAPL	Stock	27.0375	27.0375	27.0275	27.0275	42848.0
2014-10-31 07:10:00	AAPL	Stock	27.035	27.0425	27.0275	27.0375	50392.0
2014-10-31 07:15:00	AAPL	Stock	27.0425	27.05	27.025	27.025	35664.0
2014-10-31 07:20:00	AAPL	Stock	27.02	27.025	27.0	27.015	56352.0
2014-10-31 07:25:00	AAPL	Stock	27.015	27.015	27.0025	27.01	14764.0
2014-10-31 07:30:00	AAPL	Stock	27.005	27.01	27.0025	27.005	16360.0
2014-10-31 07:35:00	AAPL	Stock	27.0025	27.005	26.975	26.9875	22612.0
2014-10-31 07:40:00	AAPL	Stock	26.9925	26.995	26.9925	26.995	9796.0
2014-10-31 07:45:00	AAPL	Stock	26.995	27.0	26.995	27.0	47800.0
2014-10-31 07:50:00	AAPL	Stock	27.0	27.0	26.975	26.975	20988.0
2014-10-31 07:55:00	AAPL	Stock	26.97	26.9875	26.97	26.975	29348.0
2014-10-31 08:00:00	AAPL	Stock	26.9775	27.0925	26.9625	26.975	305300.0
2014-10-31 08:05:00	AAPL	Stock	26.975	26.975	26.95	26.9625	139768.0
2014-10-31 08:10:00	AAPL	Stock	26.9625	26.9725	26.95	26.9725	73688.0
2014-10-31 08:15:00	AAPL	Stock	26.97	26.9725	26.965	26.9725	20360.0
2014-10-31 08:20:00	AAPL	Stock	26.9725	26.975	26.9575	26.97	207836.0
2014-10-31 08:25:00	AAPL	Stock	26.97	26.9725	26.95	26.95	58000.0
2014-10-31 08:30:00	AAPL	Stock	26.965	26.975	26.9625	26.975	47104.0
2014-10-31 08:35:00	AAPL	Stock	26.98	26.9825	26.965	26.975	51120.0
2014-10-31 08:40:00	AAPL	Stock	26.9725	26.9725	26.9625	26.97	36000.0
2014-10-31 08:45:00	AAPL	Stock	26.97	26.98	26.97	26.975	94216.0
2014-10-31 08:50:00	AAPL	Stock	26.9725	26.9825	26.9725	26.975	56764.0
2014-10-31 08:55:00	AAPL	Stock	26.975	26.985	26.975	26.9825	119152.0
2014-10-31 09:00:00	AAPL	Stock	26.9825	27.0	26.975	27.0	138176.0
2014-10-31 09:05:00	AAPL	Stock	27.0	27.0075	26.9975	27.0	58540.0

> showing 50 of 376,001 rows — these rows as CSV

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