PREVIEW / etf_5min / 2013-06-20

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-06-20.parquet
  size:    1.2 MB
  rows:    50,041

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
2013-06-20 04:00:00	SPY	ETF	163.0	163.06	162.83	162.88	3630.0
2013-06-20 04:05:00	SPY	ETF	162.88	162.9	162.56	162.6	6650.0
2013-06-20 04:10:00	SPY	ETF	162.57	162.57	162.48	162.48	26700.0
2013-06-20 04:15:00	SPY	ETF	162.45	162.49	162.4	162.4	14569.0
2013-06-20 04:20:00	SPY	ETF	162.44	162.45	162.44	162.45	300.0
2013-06-20 04:25:00	SPY	ETF	162.48	162.56	162.47	162.56	900.0
2013-06-20 04:30:00	SPY	ETF	162.6	162.6	162.55	162.55	500.0
2013-06-20 04:35:00	SPY	ETF	162.54	162.54	162.54	162.54	200.0
2013-06-20 04:40:00	SPY	ETF	162.58	162.59	162.54	162.56	7600.0
2013-06-20 04:45:00	SPY	ETF	162.56	162.56	162.54	162.54	7161.0
2013-06-20 04:50:00	SPY	ETF	162.56	162.56	162.56	162.56	1723.0
2013-06-20 04:55:00	SPY	ETF	162.52	162.52	162.4	162.4	1100.0
2013-06-20 05:00:00	SPY	ETF	162.36	162.36	162.32	162.33	30350.0
2013-06-20 05:05:00	SPY	ETF	162.35	162.41	162.35	162.4	27200.0
2013-06-20 05:10:00	SPY	ETF	162.44	162.6	162.44	162.6	1800.0
2013-06-20 05:15:00	SPY	ETF	162.63	162.63	162.48	162.48	1800.0
2013-06-20 05:20:00	SPY	ETF	162.52	162.58	162.52	162.53	2900.0
2013-06-20 05:25:00	SPY	ETF	162.53	162.53	162.52	162.52	500.0
2013-06-20 05:30:00	SPY	ETF	162.48	162.48	162.4	162.43	900.0
2013-06-20 05:35:00	SPY	ETF	162.43	162.43	162.4	162.4	1200.0
2013-06-20 05:40:00	SPY	ETF	162.36	162.36	162.35	162.35	600.0
2013-06-20 05:45:00	SPY	ETF	162.32	162.32	162.1	162.16	3850.0
2013-06-20 05:50:00	SPY	ETF	162.15	162.19	161.92	161.92	27800.0
2013-06-20 05:55:00	SPY	ETF	161.91	161.92	161.76	161.92	20250.0
2013-06-20 06:00:00	SPY	ETF	161.94	162.08	161.94	161.95	10600.0
2013-06-20 06:05:00	SPY	ETF	161.92	162.03	161.87	161.96	8300.0
2013-06-20 06:10:00	SPY	ETF	161.92	162.0	161.83	161.92	38500.0
2013-06-20 06:15:00	SPY	ETF	161.98	161.98	161.83	161.91	16300.0
2013-06-20 06:20:00	SPY	ETF	161.85	161.98	161.79	161.98	8800.0
2013-06-20 06:25:00	SPY	ETF	161.98	162.04	161.88	162.01	16800.0
2013-06-20 06:30:00	SPY	ETF	161.97	162.13	161.97	162.12	5300.0
2013-06-20 06:35:00	SPY	ETF	162.12	162.28	162.09	162.23	15350.0
2013-06-20 06:40:00	SPY	ETF	162.19	162.2	162.04	162.11	38503.0
2013-06-20 06:45:00	SPY	ETF	162.12	162.14	162.12	162.14	600.0
2013-06-20 06:50:00	SPY	ETF	162.16	162.24	162.15	162.22	20450.0
2013-06-20 06:55:00	SPY	ETF	162.23	162.25	162.22	162.22	19300.0
2013-06-20 07:00:00	SPY	ETF	162.17	162.36	162.14	162.35	59934.0
2013-06-20 07:05:00	SPY	ETF	162.29	162.33	162.28	162.31	118695.0
2013-06-20 07:10:00	SPY	ETF	162.3	162.38	162.28	162.35	75880.0
2013-06-20 07:15:00	SPY	ETF	162.33	162.44	162.28	162.44	76300.0
2013-06-20 07:20:00	SPY	ETF	162.43	162.43	162.22	162.28	117845.0
2013-06-20 07:25:00	SPY	ETF	162.27	162.32	162.13	162.13	155051.0
2013-06-20 07:30:00	SPY	ETF	162.14	162.14	162.02	162.07	94425.0
2013-06-20 07:35:00	SPY	ETF	162.12	162.12	161.87	161.97	86494.0
2013-06-20 07:40:00	SPY	ETF	162.0	162.14	161.95	161.97	59216.0
2013-06-20 07:45:00	SPY	ETF	161.92	162.13	161.91	162.13	69780.0
2013-06-20 07:50:00	SPY	ETF	162.13	162.21	162.08	162.1	78539.0
2013-06-20 07:55:00	SPY	ETF	162.13	162.19	162.08	162.19	116480.0
2013-06-20 08:00:00	SPY	ETF	162.19	162.42	161.951	162.34	194305.0
2013-06-20 08:05:00	SPY	ETF	161.94	162.43	161.94	162.43	73028.0

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

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