PREVIEW / etf_5min / 2014-06-23

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-06-23.parquet
  size:    952 KB
  rows:    41,479

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-06-23 04:00:00	SPY	ETF	195.94	195.94	195.94	195.94	500.0
2014-06-23 04:10:00	SPY	ETF	195.81	195.81	195.81	195.81	2560.0
2014-06-23 04:20:00	SPY	ETF	195.71	195.74	195.71	195.74	1404.0
2014-06-23 04:25:00	SPY	ETF	195.75	195.76	195.75	195.76	319.0
2014-06-23 04:30:00	SPY	ETF	195.8	195.8	195.8	195.8	200.0
2014-06-23 04:35:00	SPY	ETF	195.85	195.87	195.85	195.87	400.0
2014-06-23 04:55:00	SPY	ETF	195.82	195.82	195.82	195.82	200.0
2014-06-23 05:00:00	SPY	ETF	195.86	195.86	195.86	195.86	425.0
2014-06-23 05:25:00	SPY	ETF	195.84	195.84	195.84	195.84	150.0
2014-06-23 05:30:00	SPY	ETF	195.86	195.87	195.86	195.87	200.0
2014-06-23 05:35:00	SPY	ETF	195.91	195.91	195.91	195.91	400.0
2014-06-23 05:40:00	SPY	ETF	195.99	195.99	195.99	195.99	200.0
2014-06-23 05:45:00	SPY	ETF	196.03	196.07	196.03	196.07	1000.0
2014-06-23 05:50:00	SPY	ETF	196.03	196.03	196.03	196.03	100.0
2014-06-23 05:55:00	SPY	ETF	196.04	196.04	196.03	196.03	500.0
2014-06-23 06:05:00	SPY	ETF	196.04	196.05	196.04	196.05	1601.0
2014-06-23 06:25:00	SPY	ETF	195.99	195.99	195.98	195.98	700.0
2014-06-23 06:30:00	SPY	ETF	195.95	195.95	195.88	195.88	800.0
2014-06-23 06:35:00	SPY	ETF	195.87	195.87	195.87	195.87	1460.0
2014-06-23 06:40:00	SPY	ETF	195.83	195.83	195.78	195.79	2710.0
2014-06-23 06:45:00	SPY	ETF	195.83	195.83	195.79	195.79	900.0
2014-06-23 06:50:00	SPY	ETF	195.78	195.79	195.75	195.76	40200.0
2014-06-23 07:00:00	SPY	ETF	195.78	195.87	195.78	195.87	2800.0
2014-06-23 07:05:00	SPY	ETF	195.83	195.87	195.83	195.87	500.0
2014-06-23 07:10:00	SPY	ETF	195.87	195.87	195.8	195.8	1800.0
2014-06-23 07:15:00	SPY	ETF	195.8	195.87	195.79	195.87	6150.0
2014-06-23 07:20:00	SPY	ETF	195.87	195.87	195.87	195.87	100.0
2014-06-23 07:25:00	SPY	ETF	195.86	195.86	195.85	195.85	200.0
2014-06-23 07:30:00	SPY	ETF	195.88	195.93	195.88	195.93	5048.0
2014-06-23 07:35:00	SPY	ETF	195.93	195.93	195.89	195.89	27727.0
2014-06-23 07:40:00	SPY	ETF	195.92	195.94	195.89	195.89	3287.0
2014-06-23 07:45:00	SPY	ETF	195.9	195.96	195.9	195.96	6800.0
2014-06-23 07:50:00	SPY	ETF	195.96	195.96	195.93	195.93	1270.0
2014-06-23 07:55:00	SPY	ETF	195.9	195.9	195.8	195.81	6366.0
2014-06-23 08:00:00	SPY	ETF	195.83	195.87	195.82	195.87	34074.0
2014-06-23 08:05:00	SPY	ETF	195.85	195.86	195.8	195.81	7897.0
2014-06-23 08:10:00	SPY	ETF	195.8	195.81	195.8	195.8	1390.0
2014-06-23 08:15:00	SPY	ETF	195.8	195.81	195.79	195.81	3800.0
2014-06-23 08:20:00	SPY	ETF	195.79	195.89	195.79	195.89	4750.0
2014-06-23 08:25:00	SPY	ETF	195.9	195.94	195.88	195.9	73246.0
2014-06-23 08:30:00	SPY	ETF	195.9	195.93	195.9	195.91	6400.0
2014-06-23 08:35:00	SPY	ETF	195.92	195.95	195.92	195.94	27250.0
2014-06-23 08:40:00	SPY	ETF	195.92	195.95	195.91	195.93	18845.0
2014-06-23 08:45:00	SPY	ETF	195.95	195.96	195.93	195.96	2819.0
2014-06-23 08:50:00	SPY	ETF	195.96	195.97	195.89	195.89	18819.0
2014-06-23 08:55:00	SPY	ETF	195.91	195.91	195.86	195.87	11600.0
2014-06-23 09:00:00	SPY	ETF	195.88	196.02	195.88	195.98	43683.0
2014-06-23 09:05:00	SPY	ETF	195.99	196.0	195.94	195.96	27501.0
2014-06-23 09:10:00	SPY	ETF	195.96	195.97	195.94	195.94	8111.0
2014-06-23 09:15:00	SPY	ETF	195.93	196.0	195.92	196.0	47512.0

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

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