PREVIEW / etf_5min / 2014-07-07

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-07.parquet
  size:    990 KB
  rows:    43,449

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-07 04:00:00	SPY	ETF	197.95	198.08	197.85	197.85	5872.0
2014-07-07 04:05:00	SPY	ETF	197.9	197.9	197.9	197.9	600.0
2014-07-07 04:25:00	SPY	ETF	197.91	197.95	197.91	197.95	1702.0
2014-07-07 04:30:00	SPY	ETF	197.88	197.91	197.88	197.91	1500.0
2014-07-07 04:35:00	SPY	ETF	197.91	197.91	197.86	197.87	4623.0
2014-07-07 04:40:00	SPY	ETF	197.89	197.89	197.86	197.86	1600.0
2014-07-07 04:45:00	SPY	ETF	197.88	197.88	197.84	197.86	3600.0
2014-07-07 04:50:00	SPY	ETF	197.85	197.9	197.85	197.9	1500.0
2014-07-07 05:05:00	SPY	ETF	197.88	197.9	197.88	197.9	274.0
2014-07-07 05:25:00	SPY	ETF	197.95	197.95	197.95	197.95	180.0
2014-07-07 05:35:00	SPY	ETF	197.96	198.02	197.96	198.0	800.0
2014-07-07 05:45:00	SPY	ETF	197.97	197.97	197.97	197.97	600.0
2014-07-07 06:00:00	SPY	ETF	197.94	197.94	197.94	197.94	530.0
2014-07-07 06:10:00	SPY	ETF	198.0	198.04	197.98	198.04	980.0
2014-07-07 06:20:00	SPY	ETF	198.01	198.01	198.0	198.01	400.0
2014-07-07 06:25:00	SPY	ETF	198.02	198.02	198.02	198.02	333.0
2014-07-07 06:35:00	SPY	ETF	198.01	198.01	198.01	198.01	6779.0
2014-07-07 06:45:00	SPY	ETF	197.95	197.95	197.94	197.94	600.0
2014-07-07 06:50:00	SPY	ETF	197.92	197.92	197.88	197.88	32936.0
2014-07-07 06:55:00	SPY	ETF	197.86	197.9	197.86	197.86	18764.0
2014-07-07 07:00:00	SPY	ETF	197.87	197.92	197.87	197.87	10942.0
2014-07-07 07:05:00	SPY	ETF	197.9	197.9	197.89	197.89	20504.0
2014-07-07 07:10:00	SPY	ETF	197.9	197.91	197.87	197.88	1700.0
2014-07-07 07:15:00	SPY	ETF	197.89	197.9	197.84	197.9	53640.0
2014-07-07 07:20:00	SPY	ETF	197.9	197.9	197.875	197.89	43115.0
2014-07-07 07:25:00	SPY	ETF	197.91	197.91	197.89	197.91	510.0
2014-07-07 07:30:00	SPY	ETF	197.91	197.91	197.89	197.89	200.0
2014-07-07 07:35:00	SPY	ETF	197.89	197.92	197.88	197.89	1600.0
2014-07-07 07:40:00	SPY	ETF	197.9	197.95	197.89	197.89	11481.0
2014-07-07 07:45:00	SPY	ETF	197.89	197.92	197.89	197.89	7300.0
2014-07-07 07:50:00	SPY	ETF	197.88	197.88	197.79	197.79	24235.0
2014-07-07 07:55:00	SPY	ETF	197.75	197.79	197.74	197.79	43594.0
2014-07-07 08:00:00	SPY	ETF	197.77	197.82	197.74	197.76	59555.0
2014-07-07 08:05:00	SPY	ETF	197.77	197.78	197.75	197.76	11295.0
2014-07-07 08:10:00	SPY	ETF	197.75	197.75	197.68	197.68	42408.0
2014-07-07 08:15:00	SPY	ETF	197.7	197.7	197.61	197.65	45438.0
2014-07-07 08:20:00	SPY	ETF	197.63	197.71	197.61	197.7	37730.0
2014-07-07 08:25:00	SPY	ETF	197.71	197.74	197.7	197.74	21812.0
2014-07-07 08:30:00	SPY	ETF	197.71	197.72	197.69	197.7	165820.0
2014-07-07 08:35:00	SPY	ETF	197.7	197.72	197.66	197.7	41758.0
2014-07-07 08:40:00	SPY	ETF	197.7	198.25	197.69	197.74	8327.0
2014-07-07 08:45:00	SPY	ETF	197.74	197.74	197.7	197.71	62875.0
2014-07-07 08:50:00	SPY	ETF	197.71	197.78	197.71	197.77	103911.0
2014-07-07 08:55:00	SPY	ETF	197.76	197.76	197.71	197.74	122309.0
2014-07-07 09:00:00	SPY	ETF	197.71	197.75	197.7	197.75	70663.0
2014-07-07 09:05:00	SPY	ETF	197.74	197.77	197.73	197.77	25015.0
2014-07-07 09:10:00	SPY	ETF	197.76	197.79	197.72	197.76	409257.0
2014-07-07 09:15:00	SPY	ETF	197.76	197.78	197.76	197.77	76853.0
2014-07-07 09:20:00	SPY	ETF	197.77	197.89	197.77	197.8	78512.0
2014-07-07 09:25:00	SPY	ETF	197.81	197.83	197.75	197.81	210893.0

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

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