PREVIEW / etf_5min / 2014-03-20

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-03-20.parquet
  size:    998 KB
  rows:    42,273

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-03-20 04:00:00	SPY	ETF	186.4	186.4	186.29	186.29	1441.0
2014-03-20 04:05:00	SPY	ETF	186.35	186.42	186.35	186.4	2900.0
2014-03-20 04:15:00	SPY	ETF	186.34	186.42	186.34	186.42	700.0
2014-03-20 04:20:00	SPY	ETF	186.39	186.39	186.39	186.39	300.0
2014-03-20 04:25:00	SPY	ETF	186.45	186.49	186.45	186.49	5200.0
2014-03-20 04:30:00	SPY	ETF	186.49	186.49	186.49	186.49	500.0
2014-03-20 04:35:00	SPY	ETF	186.54	186.54	186.49	186.49	2100.0
2014-03-20 04:45:00	SPY	ETF	186.37	186.42	186.37	186.38	1300.0
2014-03-20 04:50:00	SPY	ETF	186.3	186.34	186.3	186.32	3600.0
2014-03-20 04:55:00	SPY	ETF	186.31	186.31	186.31	186.31	200.0
2014-03-20 05:00:00	SPY	ETF	186.3	186.3	186.3	186.3	800.0
2014-03-20 05:05:00	SPY	ETF	186.27	186.27	186.22	186.22	1150.0
2014-03-20 05:10:00	SPY	ETF	186.2	186.23	186.12	186.12	8163.0
2014-03-20 05:15:00	SPY	ETF	186.14	186.24	186.14	186.24	1938.0
2014-03-20 05:20:00	SPY	ETF	186.26	186.35	186.26	186.35	3650.0
2014-03-20 05:25:00	SPY	ETF	186.38	186.38	186.38	186.38	100.0
2014-03-20 05:30:00	SPY	ETF	186.37	186.37	186.36	186.36	821.0
2014-03-20 05:35:00	SPY	ETF	186.4	186.4	186.4	186.4	2500.0
2014-03-20 05:40:00	SPY	ETF	186.37	186.37	186.3	186.3	2900.0
2014-03-20 05:45:00	SPY	ETF	186.29	186.35	186.29	186.35	3600.0
2014-03-20 05:50:00	SPY	ETF	186.3	186.34	186.29	186.29	1300.0
2014-03-20 05:55:00	SPY	ETF	186.28	186.29	186.26	186.26	1125.0
2014-03-20 06:00:00	SPY	ETF	186.26	186.29	186.23	186.29	1700.0
2014-03-20 06:05:00	SPY	ETF	186.24	186.24	186.18	186.22	2544.0
2014-03-20 06:10:00	SPY	ETF	186.22	186.22	186.0	186.0	13855.0
2014-03-20 06:15:00	SPY	ETF	185.98	186.02	185.98	186.0	14425.0
2014-03-20 06:20:00	SPY	ETF	186.01	186.1	185.98	186.1	2500.0
2014-03-20 06:25:00	SPY	ETF	186.09	186.11	186.06	186.06	3900.0
2014-03-20 06:30:00	SPY	ETF	186.06	186.06	186.0	186.06	2200.0
2014-03-20 06:35:00	SPY	ETF	186.01	186.01	185.81	185.86	27090.0
2014-03-20 06:40:00	SPY	ETF	185.83	185.87	185.82	185.83	12737.0
2014-03-20 06:45:00	SPY	ETF	185.82	185.86	185.77	185.85	11470.0
2014-03-20 06:50:00	SPY	ETF	185.85	185.93	185.85	185.93	4438.0
2014-03-20 06:55:00	SPY	ETF	185.87	185.94	185.87	185.9	39488.0
2014-03-20 07:00:00	SPY	ETF	185.89	185.95	185.89	185.95	24210.0
2014-03-20 07:05:00	SPY	ETF	185.95	185.96	185.89	185.96	56232.0
2014-03-20 07:10:00	SPY	ETF	185.95	185.96	185.89	185.94	19625.0
2014-03-20 07:15:00	SPY	ETF	185.95	186.02	185.95	185.96	15654.0
2014-03-20 07:20:00	SPY	ETF	186.0	186.06	185.98	186.06	20181.0
2014-03-20 07:25:00	SPY	ETF	186.06	186.18	186.05	186.12	138090.0
2014-03-20 07:30:00	SPY	ETF	186.13	186.14	186.09	186.13	18532.0
2014-03-20 07:35:00	SPY	ETF	186.11	186.17	186.11	186.14	16100.0
2014-03-20 07:40:00	SPY	ETF	186.16	186.16	186.03	186.03	27800.0
2014-03-20 07:45:00	SPY	ETF	186.08	186.1	186.04	186.1	8890.0
2014-03-20 07:50:00	SPY	ETF	186.14	186.21	186.14	186.2	36800.0
2014-03-20 07:55:00	SPY	ETF	186.2	186.26	186.13	186.13	47629.0
2014-03-20 08:00:00	SPY	ETF	185.89	186.22	185.89	186.13	206880.0
2014-03-20 08:05:00	SPY	ETF	186.11	186.18	186.11	186.18	5313.0
2014-03-20 08:10:00	SPY	ETF	186.18	186.26	186.16	186.24	34580.0
2014-03-20 08:15:00	SPY	ETF	186.23	186.23	186.1	186.12	60835.0

> showing 50 of 42,273 rows — these rows as CSV

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