PREVIEW / etf_5min / 2014-07-16

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-16.parquet
  size:    981 KB
  rows:    41,979

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-16 04:05:00	SPY	ETF	197.5	197.5	197.5	197.5	300.0
2014-07-16 04:15:00	SPY	ETF	197.49	197.67	197.49	197.67	1545.0
2014-07-16 04:20:00	SPY	ETF	197.68	197.73	197.68	197.73	975.0
2014-07-16 04:35:00	SPY	ETF	197.8	197.8	197.8	197.8	300.0
2014-07-16 04:40:00	SPY	ETF	197.76	197.82	197.76	197.82	500.0
2014-07-16 05:00:00	SPY	ETF	197.86	197.87	197.86	197.87	1500.0
2014-07-16 05:05:00	SPY	ETF	197.8	197.8	197.8	197.8	200.0
2014-07-16 05:10:00	SPY	ETF	197.85	197.85	197.8	197.8	1000.0
2014-07-16 05:15:00	SPY	ETF	197.74	197.74	197.74	197.74	100.0
2014-07-16 05:25:00	SPY	ETF	197.78	197.78	197.78	197.78	1207.0
2014-07-16 05:30:00	SPY	ETF	197.79	197.79	197.78	197.78	1680.0
2014-07-16 05:40:00	SPY	ETF	197.8	197.8	197.8	197.8	236.0
2014-07-16 05:55:00	SPY	ETF	197.81	197.81	197.81	197.81	230.0
2014-07-16 06:00:00	SPY	ETF	197.84	197.9	197.8	197.8	1573.0
2014-07-16 06:10:00	SPY	ETF	197.75	197.75	197.75	197.75	180.0
2014-07-16 06:15:00	SPY	ETF	197.83	197.83	197.75	197.75	550.0
2014-07-16 06:20:00	SPY	ETF	197.85	197.9	197.85	197.9	6232.0
2014-07-16 06:25:00	SPY	ETF	197.9	197.92	197.84	197.86	1700.0
2014-07-16 06:30:00	SPY	ETF	197.85	197.85	197.83	197.83	25100.0
2014-07-16 06:35:00	SPY	ETF	197.81	197.81	197.78	197.78	7300.0
2014-07-16 06:40:00	SPY	ETF	197.8	197.81	197.8	197.81	3500.0
2014-07-16 06:45:00	SPY	ETF	197.85	197.89	197.85	197.85	7800.0
2014-07-16 06:50:00	SPY	ETF	197.84	197.84	197.84	197.84	500.0
2014-07-16 06:55:00	SPY	ETF	197.79	197.89	197.79	197.89	5700.0
2014-07-16 07:00:00	SPY	ETF	197.88	198.01	197.88	197.97	36525.0
2014-07-16 07:05:00	SPY	ETF	197.97	197.97	197.88	197.89	21048.0
2014-07-16 07:10:00	SPY	ETF	197.89	197.92	197.89	197.91	47600.0
2014-07-16 07:15:00	SPY	ETF	197.91	197.92	197.9	197.9	16200.0
2014-07-16 07:20:00	SPY	ETF	197.91	197.97	197.91	197.92	27600.0
2014-07-16 07:25:00	SPY	ETF	197.92	197.94	197.92	197.94	22900.0
2014-07-16 07:30:00	SPY	ETF	197.93	197.94	197.9	197.91	22247.0
2014-07-16 07:35:00	SPY	ETF	197.92	197.98	197.92	197.98	24014.0
2014-07-16 07:40:00	SPY	ETF	197.98	198.0	197.95	197.95	95565.0
2014-07-16 07:45:00	SPY	ETF	197.95	197.95	197.91	197.92	24095.0
2014-07-16 07:50:00	SPY	ETF	197.96	197.96	197.92	197.92	30060.0
2014-07-16 07:55:00	SPY	ETF	197.93	197.95	197.93	197.95	20900.0
2014-07-16 08:00:00	SPY	ETF	197.93	198.0	197.91	197.93	50752.0
2014-07-16 08:05:00	SPY	ETF	197.94	197.94	197.91	197.92	23039.0
2014-07-16 08:10:00	SPY	ETF	197.93	197.98	197.93	197.96	157885.0
2014-07-16 08:15:00	SPY	ETF	197.96	198.0	197.96	198.0	73782.0
2014-07-16 08:20:00	SPY	ETF	198.0	198.07	197.99	198.04	370667.0
2014-07-16 08:25:00	SPY	ETF	198.03	198.06	198.03	198.04	308432.0
2014-07-16 08:30:00	SPY	ETF	198.03	198.04	197.99	198.04	98645.0
2014-07-16 08:35:00	SPY	ETF	198.02	198.2	198.01	198.17	285968.0
2014-07-16 08:40:00	SPY	ETF	198.16	198.23	198.11	198.11	109257.0
2014-07-16 08:45:00	SPY	ETF	198.12	198.16	198.1	198.15	62152.0
2014-07-16 08:50:00	SPY	ETF	198.15	198.17	198.09	198.09	88901.0
2014-07-16 08:55:00	SPY	ETF	198.1	198.14	198.1	198.1	66870.0
2014-07-16 09:00:00	SPY	ETF	198.1	198.1	198.08	198.08	26117.0
2014-07-16 09:05:00	SPY	ETF	198.09	198.12	198.08	198.08	22011.0

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

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