PREVIEW / etf_5min / 2013-06-27

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-06-27.parquet
  size:    1024 KB
  rows:    43,433

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-27 04:00:00	SPY	ETF	160.11	160.11	160.11	160.11	6000.0
2013-06-27 04:05:00	SPY	ETF	160.11	160.2	160.11	160.2	11333.0
2013-06-27 04:10:00	SPY	ETF	160.2	160.21	160.2	160.21	20100.0
2013-06-27 04:15:00	SPY	ETF	160.22	160.27	160.22	160.27	2200.0
2013-06-27 04:20:00	SPY	ETF	160.2	160.2	160.2	160.2	200.0
2013-06-27 04:25:00	SPY	ETF	160.15	160.15	160.15	160.15	700.0
2013-06-27 04:30:00	SPY	ETF	160.1	160.1	160.1	160.1	600.0
2013-06-27 04:35:00	SPY	ETF	160.05	160.07	160.05	160.07	400.0
2013-06-27 04:40:00	SPY	ETF	160.1	160.1	160.1	160.1	200.0
2013-06-27 04:45:00	SPY	ETF	160.15	160.2	160.15	160.2	400.0
2013-06-27 04:50:00	SPY	ETF	160.15	160.15	160.15	160.15	200.0
2013-06-27 04:55:00	SPY	ETF	160.2	160.2	160.15	160.15	500.0
2013-06-27 05:00:00	SPY	ETF	160.1	160.1	160.05	160.05	400.0
2013-06-27 05:05:00	SPY	ETF	160.1	160.1	160.1	160.1	200.0
2013-06-27 05:10:00	SPY	ETF	160.15	160.15	160.15	160.15	200.0
2013-06-27 05:15:00	SPY	ETF	160.2	160.2	160.15	160.15	400.0
2013-06-27 05:20:00	SPY	ETF	160.2	160.2	160.2	160.2	200.0
2013-06-27 05:25:00	SPY	ETF	160.2	160.2	160.2	160.2	2000.0
2013-06-27 05:40:00	SPY	ETF	160.2	160.2	160.2	160.2	1000.0
2013-06-27 05:50:00	SPY	ETF	160.25	160.27	160.25	160.27	500.0
2013-06-27 05:55:00	SPY	ETF	160.3	160.34	160.3	160.34	300.0
2013-06-27 06:05:00	SPY	ETF	160.32	160.32	160.32	160.32	2000.0
2013-06-27 06:10:00	SPY	ETF	160.3	160.37	160.29	160.37	1050.0
2013-06-27 06:15:00	SPY	ETF	160.3	160.3	160.3	160.3	200.0
2013-06-27 06:20:00	SPY	ETF	160.35	160.35	160.35	160.35	200.0
2013-06-27 06:25:00	SPY	ETF	160.37	160.37	160.32	160.32	2500.0
2013-06-27 06:30:00	SPY	ETF	160.31	160.37	160.31	160.37	20200.0
2013-06-27 06:35:00	SPY	ETF	160.37	160.37	160.35	160.35	6200.0
2013-06-27 06:40:00	SPY	ETF	160.32	160.35	160.315	160.35	12600.0
2013-06-27 06:45:00	SPY	ETF	160.31	160.31	160.24	160.24	8300.0
2013-06-27 06:50:00	SPY	ETF	160.24	160.27	160.21	160.21	35600.0
2013-06-27 06:55:00	SPY	ETF	160.25	160.25	160.25	160.25	900.0
2013-06-27 07:00:00	SPY	ETF	160.22	160.31	160.17	160.31	8674.0
2013-06-27 07:05:00	SPY	ETF	160.31	160.31	160.23	160.24	6700.0
2013-06-27 07:10:00	SPY	ETF	160.26	160.34	160.26	160.34	17295.0
2013-06-27 07:15:00	SPY	ETF	160.36	160.36	160.29	160.29	9169.0
2013-06-27 07:20:00	SPY	ETF	160.29	160.35	160.29	160.35	1700.0
2013-06-27 07:25:00	SPY	ETF	160.35	160.36	160.34	160.34	1100.0
2013-06-27 07:30:00	SPY	ETF	160.32	160.39	160.32	160.39	61650.0
2013-06-27 07:35:00	SPY	ETF	160.39	160.47	160.39	160.45	44193.0
2013-06-27 07:40:00	SPY	ETF	160.46	160.47	160.44	160.44	6100.0
2013-06-27 07:45:00	SPY	ETF	160.45	160.78	160.44	160.68	440795.0
2013-06-27 07:50:00	SPY	ETF	160.66	160.84	160.66	160.82	85520.0
2013-06-27 07:55:00	SPY	ETF	160.79	160.82	160.69	160.69	19481.0
2013-06-27 08:00:00	SPY	ETF	160.24	160.75	160.21	160.7	72163.0
2013-06-27 08:05:00	SPY	ETF	160.7	160.71	160.66	160.71	48500.0
2013-06-27 08:10:00	SPY	ETF	160.72	160.79	160.69	160.7	136800.0
2013-06-27 08:15:00	SPY	ETF	160.7	160.79	160.66	160.77	115790.0
2013-06-27 08:20:00	SPY	ETF	160.76	160.77	160.74	160.76	118859.0
2013-06-27 08:25:00	SPY	ETF	160.77	160.8	160.68	160.69	59876.0

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

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