PREVIEW / etf_5min / 2014-07-29

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-29.parquet
  size:    978 KB
  rows:    41,806

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-07-29 04:00:00	SPY	ETF	197.58	197.58	197.34	197.34	3439.0
2014-07-29 04:05:00	SPY	ETF	197.36	197.38	197.36	197.38	300.0
2014-07-29 04:10:00	SPY	ETF	197.35	197.36	197.35	197.36	2000.0
2014-07-29 04:15:00	SPY	ETF	197.35	197.35	197.35	197.35	300.0
2014-07-29 04:20:00	SPY	ETF	197.33	197.33	197.33	197.33	105.0
2014-07-29 04:30:00	SPY	ETF	197.37	197.37	197.37	197.37	100.0
2014-07-29 04:40:00	SPY	ETF	197.37	197.37	197.35	197.35	350.0
2014-07-29 04:45:00	SPY	ETF	197.4	197.4	197.4	197.4	100.0
2014-07-29 04:50:00	SPY	ETF	197.42	197.42	197.42	197.42	100.0
2014-07-29 04:55:00	SPY	ETF	197.48	197.49	197.48	197.49	200.0
2014-07-29 05:05:00	SPY	ETF	197.5	197.5	197.5	197.5	1000.0
2014-07-29 05:25:00	SPY	ETF	197.51	197.51	197.51	197.51	1000.0
2014-07-29 05:30:00	SPY	ETF	197.5	197.5	197.5	197.5	500.0
2014-07-29 05:35:00	SPY	ETF	197.5	197.5	197.44	197.44	900.0
2014-07-29 05:45:00	SPY	ETF	197.65	197.65	197.65	197.65	100.0
2014-07-29 05:50:00	SPY	ETF	197.6	197.6	197.6	197.6	100.0
2014-07-29 05:55:00	SPY	ETF	197.56	197.56	197.56	197.56	500.0
2014-07-29 06:00:00	SPY	ETF	197.6	197.6	197.6	197.6	316.0
2014-07-29 06:15:00	SPY	ETF	197.62	197.64	197.62	197.64	1100.0
2014-07-29 06:30:00	SPY	ETF	197.76	197.8	197.76	197.8	300.0
2014-07-29 06:35:00	SPY	ETF	197.84	197.84	197.84	197.84	200.0
2014-07-29 06:45:00	SPY	ETF	197.84	197.84	197.84	197.84	100.0
2014-07-29 06:50:00	SPY	ETF	197.84	197.84	197.83	197.83	1050.0
2014-07-29 06:55:00	SPY	ETF	197.88	197.95	197.88	197.95	32700.0
2014-07-29 07:00:00	SPY	ETF	197.96	198.08	197.96	198.07	38143.0
2014-07-29 07:05:00	SPY	ETF	198.1	198.16	198.05	198.11	80455.0
2014-07-29 07:10:00	SPY	ETF	198.11	198.13	198.1	198.11	36005.0
2014-07-29 07:15:00	SPY	ETF	198.12	198.15	198.08	198.08	66900.0
2014-07-29 07:20:00	SPY	ETF	198.09	198.16	198.09	198.16	3399.0
2014-07-29 07:25:00	SPY	ETF	198.15	198.16	198.1	198.1	10806.0
2014-07-29 07:30:00	SPY	ETF	198.16	198.16	198.07	198.07	6950.0
2014-07-29 07:35:00	SPY	ETF	198.08	198.08	198.06	198.08	700.0
2014-07-29 07:40:00	SPY	ETF	198.1	198.11	198.1	198.11	2645.0
2014-07-29 07:45:00	SPY	ETF	198.09	198.09	198.02	198.02	20160.0
2014-07-29 07:50:00	SPY	ETF	198.03	198.06	198.03	198.05	23700.0
2014-07-29 07:55:00	SPY	ETF	198.05	198.05	198.03	198.04	1920.0
2014-07-29 08:00:00	SPY	ETF	198.11	198.14	198.0	198.1	25091.0
2014-07-29 08:05:00	SPY	ETF	197.59	198.25	197.59	198.24	162121.0
2014-07-29 08:10:00	SPY	ETF	198.23	198.25	198.21	198.21	56448.0
2014-07-29 08:15:00	SPY	ETF	198.21	198.23	198.16	198.17	13580.0
2014-07-29 08:20:00	SPY	ETF	198.18	198.2	198.14	198.15	36500.0
2014-07-29 08:25:00	SPY	ETF	198.17	198.17	198.13	198.17	9950.0
2014-07-29 08:30:00	SPY	ETF	198.17	198.2	198.16	198.17	12377.0
2014-07-29 08:35:00	SPY	ETF	198.17	198.18	198.13	198.14	19310.0
2014-07-29 08:40:00	SPY	ETF	198.14	198.14	198.11	198.11	22090.0
2014-07-29 08:45:00	SPY	ETF	198.1	198.1	197.97	197.98	90088.0
2014-07-29 08:50:00	SPY	ETF	197.97	198.04	197.97	198.03	56840.0
2014-07-29 08:55:00	SPY	ETF	198.03	198.08	198.03	198.06	53001.0
2014-07-29 09:00:00	SPY	ETF	198.05	198.1	198.04	198.04	32150.0
2014-07-29 09:05:00	SPY	ETF	198.04	198.13	198.03	198.06	38559.0

> showing 50 of 41,806 rows — these rows as CSV

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