PREVIEW / etf_5min / 2014-07-24

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-24.parquet
  size:    973 KB
  rows:    41,943

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-24 04:00:00	SPY	ETF	198.47	198.47	198.47	198.47	189.0
2014-07-24 04:05:00	SPY	ETF	198.53	198.68	198.53	198.68	500.0
2014-07-24 04:10:00	SPY	ETF	198.72	198.72	198.72	198.72	100.0
2014-07-24 04:20:00	SPY	ETF	198.76	198.77	198.76	198.77	2700.0
2014-07-24 04:35:00	SPY	ETF	198.77	198.77	198.77	198.77	147.0
2014-07-24 04:45:00	SPY	ETF	198.77	198.77	198.77	198.77	533.0
2014-07-24 04:50:00	SPY	ETF	198.8	198.85	198.8	198.85	912.0
2014-07-24 04:55:00	SPY	ETF	198.89	198.89	198.89	198.89	749.0
2014-07-24 05:00:00	SPY	ETF	198.88	198.88	198.88	198.88	400.0
2014-07-24 05:05:00	SPY	ETF	198.88	198.88	198.86	198.86	800.0
2014-07-24 05:15:00	SPY	ETF	198.85	198.87	198.84	198.87	2937.0
2014-07-24 05:30:00	SPY	ETF	198.85	198.85	198.85	198.85	2000.0
2014-07-24 05:35:00	SPY	ETF	198.85	198.85	198.85	198.85	7302.0
2014-07-24 05:40:00	SPY	ETF	198.84	198.84	198.84	198.84	100.0
2014-07-24 05:45:00	SPY	ETF	198.89	198.89	198.89	198.89	200.0
2014-07-24 05:55:00	SPY	ETF	198.79	198.79	198.79	198.79	100.0
2014-07-24 06:20:00	SPY	ETF	198.83	198.83	198.83	198.83	534.0
2014-07-24 06:30:00	SPY	ETF	198.83	198.83	198.83	198.83	508.0
2014-07-24 06:40:00	SPY	ETF	198.83	198.84	198.83	198.84	506.0
2014-07-24 06:45:00	SPY	ETF	198.82	198.88	198.82	198.88	1065.0
2014-07-24 06:55:00	SPY	ETF	198.91	198.94	198.91	198.93	25265.0
2014-07-24 07:00:00	SPY	ETF	198.9	198.95	198.9	198.94	6190.0
2014-07-24 07:05:00	SPY	ETF	198.96	199.02	198.96	199.02	3025.0
2014-07-24 07:10:00	SPY	ETF	198.97	198.99	198.95	198.98	3560.0
2014-07-24 07:15:00	SPY	ETF	198.98	199.06	198.98	199.06	41300.0
2014-07-24 07:20:00	SPY	ETF	199.06	199.09	199.02	199.03	45855.0
2014-07-24 07:25:00	SPY	ETF	199.03	199.07	199.03	199.07	5650.0
2014-07-24 07:30:00	SPY	ETF	199.06	199.09	199.02	199.02	8200.0
2014-07-24 07:35:00	SPY	ETF	199.03	199.09	199.02	199.05	27360.0
2014-07-24 07:40:00	SPY	ETF	199.03	199.03	199.0	199.01	4250.0
2014-07-24 07:45:00	SPY	ETF	199.0	199.0	198.96	198.96	5800.0
2014-07-24 07:50:00	SPY	ETF	198.97	198.99	198.95	198.98	6905.0
2014-07-24 07:55:00	SPY	ETF	198.98	199.01	198.98	198.99	29400.0
2014-07-24 08:00:00	SPY	ETF	198.96	199.04	198.37	198.37	57276.0
2014-07-24 08:05:00	SPY	ETF	198.99	199.01	198.96	198.98	16528.0
2014-07-24 08:10:00	SPY	ETF	198.99	199.01	198.95	198.95	63608.0
2014-07-24 08:15:00	SPY	ETF	198.96	198.96	198.88	198.89	34240.0
2014-07-24 08:20:00	SPY	ETF	198.88	198.91	198.87	198.9	36288.0
2014-07-24 08:25:00	SPY	ETF	198.91	198.94	198.91	198.94	18875.0
2014-07-24 08:30:00	SPY	ETF	198.95	199.02	198.88	198.94	122392.0
2014-07-24 08:35:00	SPY	ETF	198.92	198.99	198.92	198.94	19651.0
2014-07-24 08:40:00	SPY	ETF	198.95	198.95	198.9	198.93	17100.0
2014-07-24 08:45:00	SPY	ETF	198.91	198.93	198.9	198.91	11100.0
2014-07-24 08:50:00	SPY	ETF	198.92	198.96	198.92	198.94	18200.0
2014-07-24 08:55:00	SPY	ETF	198.95	198.96	198.93	198.96	55412.0
2014-07-24 09:00:00	SPY	ETF	198.94	198.95	198.89	198.89	32470.0
2014-07-24 09:05:00	SPY	ETF	198.89	198.92	198.81	198.92	113573.0
2014-07-24 09:10:00	SPY	ETF	198.92	198.94	198.9	198.92	39488.0
2014-07-24 09:15:00	SPY	ETF	198.93	198.96	198.91	198.91	59839.0
2014-07-24 09:20:00	SPY	ETF	198.93	198.97	198.88	198.9	205603.0

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

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