PREVIEW / etf_5min / 2013-07-01

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-07-01.parquet
  size:    1016 KB
  rows:    43,118

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-07-01 04:00:00	SPY	ETF	161.2	161.26	161.16	161.16	4088.0
2013-07-01 04:05:00	SPY	ETF	161.13	161.13	161.0	161.0	4400.0
2013-07-01 04:10:00	SPY	ETF	161.0	161.0	160.81	160.81	2125.0
2013-07-01 04:15:00	SPY	ETF	160.78	160.81	160.68	160.81	3300.0
2013-07-01 04:20:00	SPY	ETF	160.74	160.79	160.7	160.79	1400.0
2013-07-01 04:25:00	SPY	ETF	160.74	160.74	160.7	160.7	800.0
2013-07-01 04:30:00	SPY	ETF	160.7	160.78	160.7	160.77	800.0
2013-07-01 04:35:00	SPY	ETF	160.81	160.81	160.81	160.81	100.0
2013-07-01 04:40:00	SPY	ETF	160.74	160.76	160.74	160.76	700.0
2013-07-01 04:45:00	SPY	ETF	160.78	160.86	160.78	160.86	1200.0
2013-07-01 04:50:00	SPY	ETF	160.84	160.84	160.75	160.75	700.0
2013-07-01 04:55:00	SPY	ETF	160.79	160.79	160.7	160.7	1100.0
2013-07-01 05:00:00	SPY	ETF	160.74	160.82	160.72	160.72	19400.0
2013-07-01 05:05:00	SPY	ETF	160.75	160.82	160.75	160.82	800.0
2013-07-01 05:10:00	SPY	ETF	160.86	160.86	160.78	160.78	800.0
2013-07-01 05:15:00	SPY	ETF	160.74	160.74	160.7	160.7	1600.0
2013-07-01 05:20:00	SPY	ETF	160.74	160.78	160.74	160.78	700.0
2013-07-01 05:25:00	SPY	ETF	160.82	161.08	160.82	161.08	1900.0
2013-07-01 05:30:00	SPY	ETF	161.1	161.18	161.1	161.18	1800.0
2013-07-01 05:35:00	SPY	ETF	161.22	161.3	161.21	161.3	26149.0
2013-07-01 05:40:00	SPY	ETF	161.34	161.35	161.34	161.35	500.0
2013-07-01 05:45:00	SPY	ETF	161.26	161.26	161.26	161.26	300.0
2013-07-01 05:50:00	SPY	ETF	161.27	161.32	161.26	161.31	4100.0
2013-07-01 05:55:00	SPY	ETF	161.33	161.33	161.31	161.31	51100.0
2013-07-01 06:00:00	SPY	ETF	161.31	161.34	161.28	161.31	5000.0
2013-07-01 06:05:00	SPY	ETF	161.34	161.38	161.34	161.38	1500.0
2013-07-01 06:10:00	SPY	ETF	161.36	161.36	161.3	161.3	10300.0
2013-07-01 06:15:00	SPY	ETF	161.26	161.26	161.18	161.18	16045.0
2013-07-01 06:20:00	SPY	ETF	161.17	161.17	161.05	161.07	5900.0
2013-07-01 06:25:00	SPY	ETF	161.1	161.14	161.07	161.07	1600.0
2013-07-01 06:30:00	SPY	ETF	161.1	161.1	161.06	161.06	1000.0
2013-07-01 06:35:00	SPY	ETF	161.06	161.1	161.04	161.04	11000.0
2013-07-01 06:40:00	SPY	ETF	161.04	161.06	160.98	161.06	1700.0
2013-07-01 06:45:00	SPY	ETF	161.1	161.13	161.1	161.13	700.0
2013-07-01 06:50:00	SPY	ETF	161.14	161.17	161.1	161.1	10200.0
2013-07-01 06:55:00	SPY	ETF	161.09	161.1	161.06	161.06	1600.0
2013-07-01 07:00:00	SPY	ETF	161.03	161.06	161.0	161.06	11400.0
2013-07-01 07:05:00	SPY	ETF	161.06	161.15	161.06	161.15	14400.0
2013-07-01 07:10:00	SPY	ETF	161.12	161.12	161.11	161.12	3400.0
2013-07-01 07:15:00	SPY	ETF	161.11	161.13	160.98	161.0	16160.0
2013-07-01 07:20:00	SPY	ETF	161.02	161.06	160.96	161.02	27700.0
2013-07-01 07:25:00	SPY	ETF	161.04	161.04	161.01	161.01	22800.0
2013-07-01 07:30:00	SPY	ETF	161.06	161.22	161.06	161.11	40300.0
2013-07-01 07:35:00	SPY	ETF	161.16	161.19	161.1	161.16	6800.0
2013-07-01 07:40:00	SPY	ETF	161.16	161.2	161.16	161.16	22236.0
2013-07-01 07:45:00	SPY	ETF	161.16	161.16	161.1	161.1	22700.0
2013-07-01 07:50:00	SPY	ETF	161.1	161.1	161.06	161.06	9293.0
2013-07-01 07:55:00	SPY	ETF	161.06	161.15	161.05	161.1	26450.0
2013-07-01 08:00:00	SPY	ETF	161.06	161.17	161.0	161.1	33658.0
2013-07-01 08:05:00	SPY	ETF	161.1	161.21	160.05	161.21	148361.0

> showing 50 of 43,118 rows — these rows as CSV

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