PREVIEW / etf_5min / 2013-05-21

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-05-21.parquet
  size:    977 KB
  rows:    41,852

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
2013-05-21 04:00:00	SPY	ETF	167.05	167.05	167.05	167.05	100.0
2013-05-21 04:05:00	SPY	ETF	167.04	167.04	167.04	167.04	100.0
2013-05-21 04:10:00	SPY	ETF	166.99	167.02	166.99	167.01	500.0
2013-05-21 04:15:00	SPY	ETF	167.01	167.11	167.01	167.06	35100.0
2013-05-21 04:35:00	SPY	ETF	166.91	166.91	166.91	166.91	300.0
2013-05-21 04:40:00	SPY	ETF	166.89	166.89	166.89	166.89	360.0
2013-05-21 04:45:00	SPY	ETF	166.94	166.94	166.85	166.85	10500.0
2013-05-21 04:50:00	SPY	ETF	166.83	166.84	166.83	166.84	10800.0
2013-05-21 05:05:00	SPY	ETF	166.78	166.8	166.76	166.76	10400.0
2013-05-21 05:10:00	SPY	ETF	166.76	166.76	166.76	166.76	100.0
2013-05-21 05:15:00	SPY	ETF	166.78	166.78	166.77	166.77	11900.0
2013-05-21 05:20:00	SPY	ETF	166.83	166.83	166.83	166.83	5130.0
2013-05-21 05:25:00	SPY	ETF	166.81	166.81	166.78	166.78	5677.0
2013-05-21 05:35:00	SPY	ETF	166.73	166.75	166.71	166.74	5500.0
2013-05-21 05:40:00	SPY	ETF	166.7	166.7	166.7	166.7	200.0
2013-05-21 05:45:00	SPY	ETF	166.68	166.68	166.65	166.66	1300.0
2013-05-21 05:55:00	SPY	ETF	166.72	166.72	166.72	166.72	100.0
2013-05-21 06:00:00	SPY	ETF	166.75	166.78	166.75	166.78	300.0
2013-05-21 06:10:00	SPY	ETF	166.78	166.78	166.78	166.78	100.0
2013-05-21 06:15:00	SPY	ETF	166.82	166.83	166.82	166.83	270.0
2013-05-21 06:20:00	SPY	ETF	166.82	166.87	166.82	166.87	10900.0
2013-05-21 06:25:00	SPY	ETF	166.87	166.87	166.85	166.85	600.0
2013-05-21 06:30:00	SPY	ETF	166.83	166.83	166.83	166.83	100.0
2013-05-21 06:40:00	SPY	ETF	166.83	166.85	166.83	166.85	300.0
2013-05-21 06:50:00	SPY	ETF	166.82	166.87	166.82	166.87	11300.0
2013-05-21 06:55:00	SPY	ETF	166.85	166.88	166.83	166.83	10700.0
2013-05-21 07:00:00	SPY	ETF	166.85	166.85	166.82	166.82	700.0
2013-05-21 07:05:00	SPY	ETF	166.81	166.84	166.77	166.8	2100.0
2013-05-21 07:10:00	SPY	ETF	166.77	166.8	166.64	166.67	25994.0
2013-05-21 07:15:00	SPY	ETF	166.66	166.68	166.62	166.66	14600.0
2013-05-21 07:20:00	SPY	ETF	166.69	166.75	166.69	166.74	9700.0
2013-05-21 07:25:00	SPY	ETF	166.74	166.78	166.74	166.78	1500.0
2013-05-21 07:30:00	SPY	ETF	166.73	166.75	166.72	166.75	11500.0
2013-05-21 07:35:00	SPY	ETF	166.75	166.82	166.72	166.8	14900.0
2013-05-21 07:40:00	SPY	ETF	166.8	166.8	166.77	166.78	8300.0
2013-05-21 07:45:00	SPY	ETF	166.79	166.8	166.78	166.78	22198.0
2013-05-21 07:50:00	SPY	ETF	166.82	166.83	166.82	166.83	200.0
2013-05-21 07:55:00	SPY	ETF	166.82	166.85	166.82	166.84	22500.0
2013-05-21 08:00:00	SPY	ETF	166.85	166.95	166.85	166.95	47524.0
2013-05-21 08:05:00	SPY	ETF	166.95	166.95	166.92	166.92	9396.0
2013-05-21 08:10:00	SPY	ETF	166.94	166.98	166.92	166.92	24600.0
2013-05-21 08:15:00	SPY	ETF	166.92	166.93	166.85	166.87	37715.0
2013-05-21 08:20:00	SPY	ETF	166.88	166.97	166.88	166.95	7151.0
2013-05-21 08:25:00	SPY	ETF	166.94	167.01	166.94	166.99	22207.0
2013-05-21 08:30:00	SPY	ETF	166.98	166.98	166.95	166.97	61060.0
2013-05-21 08:35:00	SPY	ETF	166.97	166.97	166.93	166.94	8508.0
2013-05-21 08:40:00	SPY	ETF	166.97	166.97	166.93	166.94	13996.0
2013-05-21 08:45:00	SPY	ETF	166.94	166.98	166.93	166.98	62730.0
2013-05-21 08:50:00	SPY	ETF	166.99	167.0	166.96	166.96	30895.0
2013-05-21 08:55:00	SPY	ETF	167.01	167.08	167.0	167.07	94464.0

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

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