PREVIEW / etf_5min / 2013-01-18

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-01-18.parquet
  size:    919 KB
  rows:    38,945

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-01-18 04:00:00	SPY	ETF	148.16	148.16	148.16	148.16	100.0
2013-01-18 04:15:00	SPY	ETF	147.97	147.97	147.93	147.93	250.0
2013-01-18 04:20:00	SPY	ETF	147.98	147.98	147.98	147.98	100.0
2013-01-18 04:50:00	SPY	ETF	148.0	148.0	148.0	148.0	1000.0
2013-01-18 05:05:00	SPY	ETF	147.96	147.96	147.96	147.96	600.0
2013-01-18 05:10:00	SPY	ETF	147.92	147.92	147.91	147.91	2191.0
2013-01-18 06:05:00	SPY	ETF	148.02	148.03	148.02	148.03	399.0
2013-01-18 06:15:00	SPY	ETF	147.98	147.98	147.98	147.98	300.0
2013-01-18 06:20:00	SPY	ETF	147.94	147.94	147.93	147.93	470.0
2013-01-18 06:25:00	SPY	ETF	147.94	147.94	147.91	147.91	17600.0
2013-01-18 06:45:00	SPY	ETF	147.91	147.91	147.91	147.91	300.0
2013-01-18 06:50:00	SPY	ETF	147.88	147.95	147.88	147.95	18950.0
2013-01-18 06:55:00	SPY	ETF	147.95	147.95	147.95	147.95	2900.0
2013-01-18 07:00:00	SPY	ETF	147.91	147.98	147.9	147.96	25275.0
2013-01-18 07:05:00	SPY	ETF	147.9	147.9	147.88	147.88	2399.0
2013-01-18 07:10:00	SPY	ETF	147.87	147.93	147.87	147.93	525.0
2013-01-18 07:15:00	SPY	ETF	147.91	147.91	147.89	147.89	13600.0
2013-01-18 07:20:00	SPY	ETF	147.87	147.89	147.82	147.84	28598.0
2013-01-18 07:25:00	SPY	ETF	147.84	147.89	147.8	147.89	98900.0
2013-01-18 07:30:00	SPY	ETF	147.89	147.93	147.89	147.93	34800.0
2013-01-18 07:35:00	SPY	ETF	147.94	148.01	147.94	148.01	5899.0
2013-01-18 07:40:00	SPY	ETF	148.02	148.06	147.98	148.06	7960.0
2013-01-18 07:45:00	SPY	ETF	148.05	148.05	148.0	148.03	8300.0
2013-01-18 07:50:00	SPY	ETF	148.01	148.01	148.0	148.0	7400.0
2013-01-18 07:55:00	SPY	ETF	147.95	147.98	147.92	147.93	13500.0
2013-01-18 08:00:00	SPY	ETF	147.94	147.95	147.84	147.93	44780.0
2013-01-18 08:05:00	SPY	ETF	147.92	147.98	147.915	147.96	230315.0
2013-01-18 08:10:00	SPY	ETF	147.95	148.08	147.94	148.05	30958.0
2013-01-18 08:15:00	SPY	ETF	148.04	148.1	148.01	148.07	66607.0
2013-01-18 08:20:00	SPY	ETF	148.07	148.07	148.01	148.06	65149.0
2013-01-18 08:25:00	SPY	ETF	148.07	148.12	148.07	148.09	117437.0
2013-01-18 08:30:00	SPY	ETF	148.08	148.08	148.04	148.04	66543.0
2013-01-18 08:35:00	SPY	ETF	148.05	148.08	148.02	148.03	33003.0
2013-01-18 08:40:00	SPY	ETF	148.02	148.02	147.98	148.01	26927.0
2013-01-18 08:45:00	SPY	ETF	148.01	148.06	148.01	148.05	23706.0
2013-01-18 08:50:00	SPY	ETF	148.03	148.05	148.02	148.04	23375.0
2013-01-18 08:55:00	SPY	ETF	148.02	148.03	147.98	148.0	24399.0
2013-01-18 09:00:00	SPY	ETF	148.0	148.04	147.96	148.0	37650.0
2013-01-18 09:05:00	SPY	ETF	147.98	148.01	147.96	148.0	67400.0
2013-01-18 09:10:00	SPY	ETF	148.0	148.04	148.0	148.03	138120.0
2013-01-18 09:15:00	SPY	ETF	148.03	148.07	147.99	148.06	47100.0
2013-01-18 09:20:00	SPY	ETF	148.06	148.06	148.01	148.03	94497.0
2013-01-18 09:25:00	SPY	ETF	148.04	148.09	147.93	147.97	619628.0
2013-01-18 09:30:00	SPY	ETF	147.97	148.07	147.921	148.03	2819365.0
2013-01-18 09:35:00	SPY	ETF	148.02	148.03	147.69	147.76	3083515.0
2013-01-18 09:40:00	SPY	ETF	147.75	148.018	147.73	147.795	2117060.0
2013-01-18 09:45:00	SPY	ETF	147.8	147.93	147.79	147.865	2116719.0
2013-01-18 09:50:00	SPY	ETF	147.87	147.93	147.78	147.82	1535268.0
2013-01-18 09:55:00	SPY	ETF	147.8	147.89	147.7	147.87	2332788.0
2013-01-18 10:00:00	SPY	ETF	147.87	147.91	147.78	147.79	1149139.0

> showing 50 of 38,945 rows — these rows as CSV

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