PREVIEW / etf_5min / 2014-01-27

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-01-27.parquet
  size:    1.2 MB
  rows:    50,242

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-01-27 04:00:00	SPY	ETF	179.05	179.28	179.05	179.06	7537.0
2014-01-27 04:05:00	SPY	ETF	179.08	179.08	179.01	179.04	8000.0
2014-01-27 04:10:00	SPY	ETF	178.98	178.98	178.98	178.98	100.0
2014-01-27 04:15:00	SPY	ETF	178.96	179.0	178.96	179.0	549.0
2014-01-27 04:20:00	SPY	ETF	179.05	179.09	179.0	179.09	743.0
2014-01-27 04:25:00	SPY	ETF	179.11	179.11	179.06	179.06	2300.0
2014-01-27 04:30:00	SPY	ETF	179.06	179.16	179.06	179.16	38960.0
2014-01-27 04:35:00	SPY	ETF	178.71	179.08	178.71	179.08	1802.0
2014-01-27 04:40:00	SPY	ETF	179.1	179.1	179.01	179.01	7358.0
2014-01-27 04:45:00	SPY	ETF	178.99	179.0	178.96	178.96	8335.0
2014-01-27 04:50:00	SPY	ETF	179.0	179.06	179.0	179.06	17951.0
2014-01-27 04:55:00	SPY	ETF	179.07	179.13	179.07	179.13	5916.0
2014-01-27 05:00:00	SPY	ETF	179.13	179.16	179.09	179.11	8511.0
2014-01-27 05:05:00	SPY	ETF	179.11	179.11	179.06	179.06	2077.0
2014-01-27 05:10:00	SPY	ETF	179.01	179.01	178.99	178.99	200.0
2014-01-27 05:15:00	SPY	ETF	178.99	178.99	178.85	178.85	4086.0
2014-01-27 05:20:00	SPY	ETF	178.82	178.83	178.77	178.77	1628.0
2014-01-27 05:25:00	SPY	ETF	178.79	178.81	178.79	178.81	1100.0
2014-01-27 05:30:00	SPY	ETF	178.79	178.96	178.67	178.96	23931.0
2014-01-27 05:35:00	SPY	ETF	178.98	179.11	178.98	179.11	3140.0
2014-01-27 05:40:00	SPY	ETF	179.11	179.11	179.08	179.08	937.0
2014-01-27 05:45:00	SPY	ETF	179.04	179.04	178.97	178.97	494.0
2014-01-27 05:50:00	SPY	ETF	179.06	179.11	179.06	179.11	747.0
2014-01-27 05:55:00	SPY	ETF	179.11	179.16	179.11	179.13	10628.0
2014-01-27 06:00:00	SPY	ETF	179.11	179.13	179.09	179.11	3615.0
2014-01-27 06:05:00	SPY	ETF	179.06	179.12	179.03	179.03	37142.0
2014-01-27 06:10:00	SPY	ETF	179.03	179.03	178.88	178.88	6458.0
2014-01-27 06:15:00	SPY	ETF	178.95	178.95	178.95	178.95	485.0
2014-01-27 06:20:00	SPY	ETF	178.95	178.99	178.95	178.99	955.0
2014-01-27 06:25:00	SPY	ETF	179.03	179.15	179.03	179.06	32781.0
2014-01-27 06:30:00	SPY	ETF	179.1	179.18	179.1	179.18	28622.0
2014-01-27 06:35:00	SPY	ETF	179.18	179.3	179.18	179.28	23141.0
2014-01-27 06:40:00	SPY	ETF	179.28	179.32	179.28	179.3	36000.0
2014-01-27 06:45:00	SPY	ETF	179.3	179.32	179.3	179.32	12143.0
2014-01-27 06:50:00	SPY	ETF	179.33	179.44	179.33	179.41	17147.0
2014-01-27 06:55:00	SPY	ETF	179.43	179.49	179.41	179.43	47608.0
2014-01-27 07:00:00	SPY	ETF	179.43	179.45	179.4	179.43	193970.0
2014-01-27 07:05:00	SPY	ETF	179.43	179.45	179.4	179.45	83190.0
2014-01-27 07:10:00	SPY	ETF	179.45	179.45	179.35	179.4	31857.0
2014-01-27 07:15:00	SPY	ETF	179.4	179.5	179.4	179.5	61555.0
2014-01-27 07:20:00	SPY	ETF	179.5	179.53	179.48	179.51	14820.0
2014-01-27 07:25:00	SPY	ETF	179.51	179.51	179.46	179.46	138201.0
2014-01-27 07:30:00	SPY	ETF	179.48	179.6	179.48	179.6	679219.0
2014-01-27 07:35:00	SPY	ETF	179.61	179.63	179.5	179.5	44446.0
2014-01-27 07:40:00	SPY	ETF	179.5	179.54	179.4	179.43	87623.0
2014-01-27 07:45:00	SPY	ETF	179.41	179.46	179.35	179.4	107760.0
2014-01-27 07:50:00	SPY	ETF	179.42	179.43	179.35	179.39	32475.0
2014-01-27 07:55:00	SPY	ETF	179.35	179.39	179.27	179.31	112295.0
2014-01-27 08:00:00	SPY	ETF	179.28	179.5	178.73	179.28	111354.0
2014-01-27 08:05:00	SPY	ETF	179.29	179.38	178.9	179.37	177788.0

> showing 50 of 50,242 rows — these rows as CSV

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