PREVIEW / stock_5min / 2014-08-12

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-08-12.parquet
  size:    5.2 MB
  rows:    348,077
  symbols: 3,569

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-08-12 04:00:00	AAPL	Stock	24.0625	24.0625	24.0625	24.0625	400.0
2014-08-12 04:15:00	AAPL	Stock	24.12	24.12	24.12	24.12	2000.0
2014-08-12 04:25:00	AAPL	Stock	24.12	24.12	24.12	24.12	1200.0
2014-08-12 04:35:00	AAPL	Stock	24.12	24.12	24.12	24.12	800.0
2014-08-12 05:15:00	AAPL	Stock	24.15	24.15	24.15	24.15	400.0
2014-08-12 05:35:00	AAPL	Stock	24.14	24.14	24.1125	24.1125	2400.0
2014-08-12 05:45:00	AAPL	Stock	24.1375	24.1375	24.1375	24.1375	2000.0
2014-08-12 05:50:00	AAPL	Stock	24.1375	24.1375	24.1125	24.1175	7920.0
2014-08-12 05:55:00	AAPL	Stock	24.1125	24.1125	24.0875	24.0875	7816.0
2014-08-12 06:00:00	AAPL	Stock	24.08	24.0875	24.075	24.075	14000.0
2014-08-12 06:05:00	AAPL	Stock	24.1	24.1	24.1	24.1	400.0
2014-08-12 06:10:00	AAPL	Stock	24.0975	24.0975	24.0975	24.0975	1240.0
2014-08-12 06:15:00	AAPL	Stock	24.1	24.1	24.1	24.1	11416.0
2014-08-12 06:20:00	AAPL	Stock	24.115	24.115	24.115	24.115	1600.0
2014-08-12 06:25:00	AAPL	Stock	24.0975	24.0975	24.0975	24.0975	2000.0
2014-08-12 06:30:00	AAPL	Stock	24.1125	24.135	24.1125	24.135	2308.0
2014-08-12 06:35:00	AAPL	Stock	24.135	24.1375	24.135	24.1375	2400.0
2014-08-12 06:45:00	AAPL	Stock	24.12	24.12	24.12	24.12	4216.0
2014-08-12 06:50:00	AAPL	Stock	24.125	24.135	24.125	24.135	5000.0
2014-08-12 06:55:00	AAPL	Stock	24.1375	24.1425	24.125	24.125	7680.0
2014-08-12 07:00:00	AAPL	Stock	24.1175	24.1175	24.1125	24.1125	4800.0
2014-08-12 07:05:00	AAPL	Stock	24.1175	24.1225	24.1125	24.1125	3204.0
2014-08-12 07:10:00	AAPL	Stock	24.1075	24.11	24.0975	24.1	7600.0
2014-08-12 07:15:00	AAPL	Stock	24.0975	24.1	24.0875	24.1	17908.0
2014-08-12 07:20:00	AAPL	Stock	24.1	24.1	24.0875	24.0875	8960.0
2014-08-12 07:25:00	AAPL	Stock	24.0825	24.0825	24.08	24.08	3460.0
2014-08-12 07:30:00	AAPL	Stock	24.095	24.095	24.095	24.095	3932.0
2014-08-12 07:35:00	AAPL	Stock	24.085	24.085	24.08	24.08	1840.0
2014-08-12 07:40:00	AAPL	Stock	24.0875	24.0875	24.0775	24.0775	3600.0
2014-08-12 07:45:00	AAPL	Stock	24.075	24.0775	24.065	24.0675	28060.0
2014-08-12 07:50:00	AAPL	Stock	24.0725	24.0825	24.0525	24.0525	13256.0
2014-08-12 07:55:00	AAPL	Stock	24.0425	24.075	24.04	24.07	47080.0
2014-08-12 08:00:00	AAPL	Stock	24.07	24.12	24.055	24.075	116952.0
2014-08-12 08:05:00	AAPL	Stock	24.0675	24.0825	24.0675	24.075	11976.0
2014-08-12 08:10:00	AAPL	Stock	24.08	24.0825	24.0675	24.08	31616.0
2014-08-12 08:15:00	AAPL	Stock	24.0825	24.0875	24.065	24.075	53112.0
2014-08-12 08:20:00	AAPL	Stock	24.07	24.075	24.0525	24.0625	88052.0
2014-08-12 08:25:00	AAPL	Stock	24.0625	24.0725	24.0625	24.0725	11800.0
2014-08-12 08:30:00	AAPL	Stock	24.07	24.0725	24.045	24.0525	38996.0
2014-08-12 08:35:00	AAPL	Stock	24.0525	24.0525	24.045	24.045	40352.0
2014-08-12 08:40:00	AAPL	Stock	24.05	24.05	24.05	24.05	7200.0
2014-08-12 08:45:00	AAPL	Stock	24.06	24.06	24.05	24.05	18000.0
2014-08-12 08:50:00	AAPL	Stock	24.0475	24.0575	24.0375	24.05	38536.0
2014-08-12 08:55:00	AAPL	Stock	24.05	24.0575	24.0425	24.0575	45192.0
2014-08-12 09:00:00	AAPL	Stock	24.0575	24.0575	24.035	24.0375	52600.0
2014-08-12 09:05:00	AAPL	Stock	24.0375	24.045	24.02	24.02	85180.0
2014-08-12 09:10:00	AAPL	Stock	24.0125	24.02	24.0075	24.0175	90296.0
2014-08-12 09:15:00	AAPL	Stock	24.02	24.025	24.0075	24.025	29564.0
2014-08-12 09:20:00	AAPL	Stock	24.0175	24.045	24.0175	24.0375	65304.0
2014-08-12 09:25:00	AAPL	Stock	24.0325	24.05	24.0325	24.0475	74260.0

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

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