PREVIEW / etf_5min / 2014-07-17

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-17.parquet
  size:    1.1 MB
  rows:    45,060

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-17 04:00:00	SPY	ETF	197.68	197.68	197.65	197.65	647.0
2014-07-17 04:05:00	SPY	ETF	197.7	197.7	197.7	197.7	3050.0
2014-07-17 04:10:00	SPY	ETF	197.49	197.49	197.49	197.49	200.0
2014-07-17 04:15:00	SPY	ETF	197.61	197.61	197.61	197.61	200.0
2014-07-17 04:20:00	SPY	ETF	197.56	197.56	197.56	197.56	2700.0
2014-07-17 04:30:00	SPY	ETF	197.54	197.54	197.54	197.54	147.0
2014-07-17 04:40:00	SPY	ETF	197.54	197.54	197.51	197.51	3300.0
2014-07-17 04:50:00	SPY	ETF	197.5	197.5	197.5	197.5	100.0
2014-07-17 05:05:00	SPY	ETF	197.42	197.5	197.42	197.5	294.0
2014-07-17 05:15:00	SPY	ETF	197.41	197.41	197.41	197.41	183.0
2014-07-17 05:20:00	SPY	ETF	197.39	197.39	197.28	197.28	5499.0
2014-07-17 05:35:00	SPY	ETF	197.38	197.38	197.38	197.38	175.0
2014-07-17 05:40:00	SPY	ETF	197.37	197.37	197.25	197.25	1205.0
2014-07-17 05:45:00	SPY	ETF	197.25	197.26	197.23	197.23	1901.0
2014-07-17 05:50:00	SPY	ETF	197.28	197.28	197.27	197.27	200.0
2014-07-17 05:55:00	SPY	ETF	197.25	197.25	197.25	197.25	216.0
2014-07-17 06:00:00	SPY	ETF	197.24	197.25	197.21	197.25	7466.0
2014-07-17 06:05:00	SPY	ETF	197.24	197.24	197.2	197.2	5300.0
2014-07-17 06:10:00	SPY	ETF	197.24	197.24	197.2	197.2	565.0
2014-07-17 06:15:00	SPY	ETF	197.19	197.19	197.19	197.19	100.0
2014-07-17 06:20:00	SPY	ETF	197.18	197.18	197.18	197.18	350.0
2014-07-17 06:25:00	SPY	ETF	197.21	197.21	197.21	197.21	200.0
2014-07-17 06:30:00	SPY	ETF	197.21	197.21	197.16	197.18	5300.0
2014-07-17 06:35:00	SPY	ETF	197.19	197.21	197.14	197.14	8635.0
2014-07-17 06:40:00	SPY	ETF	197.18	197.18	196.94	196.94	11027.0
2014-07-17 06:45:00	SPY	ETF	196.9	196.9	196.77	196.84	6960.0
2014-07-17 06:50:00	SPY	ETF	196.82	196.89	196.78	196.78	10849.0
2014-07-17 06:55:00	SPY	ETF	196.76	196.83	196.75	196.82	16659.0
2014-07-17 07:00:00	SPY	ETF	196.83	196.83	196.7	196.76	29205.0
2014-07-17 07:05:00	SPY	ETF	196.79	196.94	196.76	196.94	38423.0
2014-07-17 07:10:00	SPY	ETF	196.94	196.94	196.8	196.81	22360.0
2014-07-17 07:15:00	SPY	ETF	196.81	196.88	196.8	196.86	52650.0
2014-07-17 07:20:00	SPY	ETF	196.86	196.86	196.79	196.85	85125.0
2014-07-17 07:25:00	SPY	ETF	196.9	196.94	196.89	196.93	43000.0
2014-07-17 07:30:00	SPY	ETF	196.93	196.93	196.9	196.9	61817.0
2014-07-17 07:35:00	SPY	ETF	196.9	196.92	196.86	196.92	76769.0
2014-07-17 07:40:00	SPY	ETF	196.92	197.05	196.92	197.04	70430.0
2014-07-17 07:45:00	SPY	ETF	197.04	197.14	197.04	197.1	36098.0
2014-07-17 07:50:00	SPY	ETF	197.08	197.11	197.06	197.06	4536.0
2014-07-17 07:55:00	SPY	ETF	197.04	197.04	196.91	196.96	62952.0
2014-07-17 08:00:00	SPY	ETF	196.93	197.614	196.93	197.614	131882.0
2014-07-17 08:05:00	SPY	ETF	196.96	196.99	196.95	196.99	39476.0
2014-07-17 08:10:00	SPY	ETF	197.01	197.05	196.98	197.05	65197.0
2014-07-17 08:15:00	SPY	ETF	197.05	197.12	197.05	197.1	51734.0
2014-07-17 08:20:00	SPY	ETF	197.11	197.29	197.11	197.24	139192.0
2014-07-17 08:25:00	SPY	ETF	197.25	197.3	197.2	197.21	81118.0
2014-07-17 08:30:00	SPY	ETF	197.21	197.25	197.08	197.23	165724.0
2014-07-17 08:35:00	SPY	ETF	197.23	197.25	197.15	197.15	58512.0
2014-07-17 08:40:00	SPY	ETF	197.15	197.96	197.11	197.19	60498.0
2014-07-17 08:45:00	SPY	ETF	197.15	197.16	197.12	197.15	19715.0

> showing 50 of 45,060 rows — these rows as CSV

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