PREVIEW / etf_5min / 2013-07-25

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-07-25.parquet
  size:    951 KB
  rows:    40,283

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-25 04:00:00	SPY	ETF	168.38	168.38	168.38	168.38	900.0
2013-07-25 04:05:00	SPY	ETF	168.4	168.4	168.35	168.35	4900.0
2013-07-25 04:15:00	SPY	ETF	168.4	168.5	168.4	168.5	5600.0
2013-07-25 04:20:00	SPY	ETF	168.45	168.45	168.4	168.4	700.0
2013-07-25 04:25:00	SPY	ETF	168.45	168.45	168.35	168.4	500.0
2013-07-25 04:30:00	SPY	ETF	168.36	168.36	168.36	168.36	5000.0
2013-07-25 04:35:00	SPY	ETF	168.38	168.38	168.3	168.3	3100.0
2013-07-25 04:40:00	SPY	ETF	168.27	168.28	168.27	168.28	200.0
2013-07-25 04:45:00	SPY	ETF	168.25	168.27	168.23	168.23	800.0
2013-07-25 04:50:00	SPY	ETF	168.22	168.22	168.07	168.08	2600.0
2013-07-25 04:55:00	SPY	ETF	168.05	168.07	168.01	168.05	6000.0
2013-07-25 05:00:00	SPY	ETF	168.04	168.1	168.04	168.1	20500.0
2013-07-25 05:05:00	SPY	ETF	168.1	168.1	168.07	168.1	9800.0
2013-07-25 05:10:00	SPY	ETF	168.07	168.07	168.02	168.02	5700.0
2013-07-25 05:15:00	SPY	ETF	168.0	168.0	167.79	167.82	23280.0
2013-07-25 05:20:00	SPY	ETF	167.8	167.8	167.72	167.75	1500.0
2013-07-25 05:25:00	SPY	ETF	167.7	167.7	167.64	167.64	2200.0
2013-07-25 05:30:00	SPY	ETF	167.7	167.87	167.7	167.87	56400.0
2013-07-25 05:35:00	SPY	ETF	167.87	167.87	167.87	167.87	400.0
2013-07-25 05:40:00	SPY	ETF	167.88	167.88	167.82	167.82	1630.0
2013-07-25 05:45:00	SPY	ETF	167.85	167.85	167.75	167.75	4620.0
2013-07-25 05:50:00	SPY	ETF	167.78	167.78	167.7	167.7	1550.0
2013-07-25 05:55:00	SPY	ETF	167.7	167.73	167.7	167.73	400.0
2013-07-25 06:00:00	SPY	ETF	167.68	167.7	167.68	167.68	600.0
2013-07-25 06:05:00	SPY	ETF	167.7	167.7	167.65	167.7	31300.0
2013-07-25 06:10:00	SPY	ETF	167.72	167.8	167.72	167.8	10400.0
2013-07-25 06:15:00	SPY	ETF	167.78	167.8	167.78	167.8	300.0
2013-07-25 06:20:00	SPY	ETF	167.83	167.83	167.7	167.7	1901.0
2013-07-25 06:25:00	SPY	ETF	167.69	167.7	167.69	167.7	300.0
2013-07-25 06:30:00	SPY	ETF	167.74	167.77	167.74	167.77	600.0
2013-07-25 06:35:00	SPY	ETF	167.8	167.8	167.74	167.75	3600.0
2013-07-25 06:40:00	SPY	ETF	167.75	167.8	167.7	167.73	13500.0
2013-07-25 06:45:00	SPY	ETF	167.73	167.75	167.73	167.75	54480.0
2013-07-25 06:50:00	SPY	ETF	167.73	167.78	167.73	167.78	40300.0
2013-07-25 06:55:00	SPY	ETF	167.8	167.88	167.8	167.88	2800.0
2013-07-25 07:00:00	SPY	ETF	167.88	168.0	167.88	167.97	69350.0
2013-07-25 07:05:00	SPY	ETF	167.95	168.08	167.95	168.04	12731.0
2013-07-25 07:10:00	SPY	ETF	168.05	168.06	168.02	168.06	28600.0
2013-07-25 07:15:00	SPY	ETF	168.02	168.11	168.02	168.05	11800.0
2013-07-25 07:20:00	SPY	ETF	168.1	168.1	168.0	168.01	111550.0
2013-07-25 07:25:00	SPY	ETF	168.05	168.1	168.05	168.05	27190.0
2013-07-25 07:30:00	SPY	ETF	168.01	168.08	168.0	168.05	17325.0
2013-07-25 07:35:00	SPY	ETF	168.07	168.1	168.07	168.1	27450.0
2013-07-25 07:40:00	SPY	ETF	168.12	168.2	168.12	168.16	114050.0
2013-07-25 07:45:00	SPY	ETF	168.15	168.18	168.15	168.18	16100.0
2013-07-25 07:50:00	SPY	ETF	168.17	168.18	168.14	168.16	16650.0
2013-07-25 07:55:00	SPY	ETF	168.16	168.16	168.11	168.11	26850.0
2013-07-25 08:00:00	SPY	ETF	167.87	168.25	167.87	168.22	163300.0
2013-07-25 08:05:00	SPY	ETF	168.23	168.23	167.91	168.21	72010.0
2013-07-25 08:10:00	SPY	ETF	168.19	168.19	168.06	168.08	32800.0

> showing 50 of 40,283 rows — these rows as CSV

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