PREVIEW / etf_5min / 2013-10-04

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-10-04.parquet
  size:    934 KB
  rows:    38,569

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-10-04 04:05:00	SPY	ETF	167.65	167.65	167.62	167.62	20300.0
2013-10-04 04:10:00	SPY	ETF	167.57	167.62	167.57	167.62	1600.0
2013-10-04 04:15:00	SPY	ETF	167.57	167.57	167.56	167.56	10600.0
2013-10-04 04:20:00	SPY	ETF	167.56	167.6	167.56	167.6	520.0
2013-10-04 04:30:00	SPY	ETF	167.61	167.66	167.61	167.66	2000.0
2013-10-04 04:35:00	SPY	ETF	167.68	167.76	167.68	167.76	1200.0
2013-10-04 04:40:00	SPY	ETF	167.78	167.81	167.78	167.81	700.0
2013-10-04 04:45:00	SPY	ETF	167.84	167.92	167.84	167.92	20900.0
2013-10-04 04:50:00	SPY	ETF	167.88	167.9	167.87	167.9	1603.0
2013-10-04 04:55:00	SPY	ETF	167.84	167.87	167.82	167.87	4300.0
2013-10-04 05:00:00	SPY	ETF	167.86	167.88	167.86	167.87	1710.0
2013-10-04 05:05:00	SPY	ETF	167.9	167.9	167.88	167.88	898.0
2013-10-04 05:10:00	SPY	ETF	167.87	167.87	167.84	167.84	1100.0
2013-10-04 05:15:00	SPY	ETF	167.86	167.88	167.86	167.88	300.0
2013-10-04 05:25:00	SPY	ETF	167.9	167.9	167.87	167.88	25722.0
2013-10-04 05:30:00	SPY	ETF	167.89	167.89	167.86	167.86	200.0
2013-10-04 05:35:00	SPY	ETF	167.84	167.88	167.84	167.88	668.0
2013-10-04 05:40:00	SPY	ETF	167.9	167.9	167.9	167.9	500.0
2013-10-04 05:45:00	SPY	ETF	167.88	167.88	167.86	167.88	700.0
2013-10-04 05:50:00	SPY	ETF	167.9	167.93	167.9	167.93	700.0
2013-10-04 05:55:00	SPY	ETF	167.9	167.9	167.9	167.9	100.0
2013-10-04 06:00:00	SPY	ETF	167.88	167.9	167.88	167.9	5200.0
2013-10-04 06:10:00	SPY	ETF	167.88	167.88	167.86	167.86	200.0
2013-10-04 06:15:00	SPY	ETF	167.88	167.88	167.88	167.88	100.0
2013-10-04 06:25:00	SPY	ETF	167.9	167.9	167.9	167.9	100.0
2013-10-04 06:30:00	SPY	ETF	167.9	167.9	167.86	167.86	10373.0
2013-10-04 06:35:00	SPY	ETF	167.86	167.86	167.85	167.86	400.0
2013-10-04 06:40:00	SPY	ETF	167.88	167.88	167.88	167.88	100.0
2013-10-04 06:45:00	SPY	ETF	167.9	167.9	167.88	167.88	400.0
2013-10-04 06:50:00	SPY	ETF	167.88	167.92	167.88	167.92	5700.0
2013-10-04 06:55:00	SPY	ETF	167.9	167.94	167.88	167.92	15830.0
2013-10-04 07:00:00	SPY	ETF	167.91	167.99	167.9	167.99	2100.0
2013-10-04 07:05:00	SPY	ETF	168.0	168.0	167.96	167.98	83410.0
2013-10-04 07:10:00	SPY	ETF	167.98	167.98	167.96	167.97	5987.0
2013-10-04 07:15:00	SPY	ETF	167.94	167.94	167.9	167.9	3091.0
2013-10-04 07:20:00	SPY	ETF	167.9	167.94	167.89	167.94	8400.0
2013-10-04 07:25:00	SPY	ETF	167.94	167.94	167.88	167.88	1100.0
2013-10-04 07:30:00	SPY	ETF	167.86	167.86	167.85	167.85	23115.0
2013-10-04 07:35:00	SPY	ETF	167.85	167.85	167.81	167.81	5730.0
2013-10-04 07:40:00	SPY	ETF	167.8	167.83	167.79	167.83	7813.0
2013-10-04 07:45:00	SPY	ETF	167.82	167.82	167.78	167.82	26420.0
2013-10-04 07:50:00	SPY	ETF	167.81	167.84	167.8	167.8	16600.0
2013-10-04 07:55:00	SPY	ETF	167.8	167.87	167.8	167.87	6700.0
2013-10-04 08:00:00	SPY	ETF	167.84	168.03	167.79	167.79	77640.0
2013-10-04 08:05:00	SPY	ETF	167.78	167.78	167.67	167.74	30410.0
2013-10-04 08:10:00	SPY	ETF	167.75	167.8	167.75	167.8	3340.0
2013-10-04 08:15:00	SPY	ETF	167.8	167.9	167.8	167.86	10936.0
2013-10-04 08:20:00	SPY	ETF	167.85	167.92	167.84	167.92	39775.0
2013-10-04 08:25:00	SPY	ETF	167.89	167.9	167.79	167.82	36100.0
2013-10-04 08:30:00	SPY	ETF	167.81	167.85	167.76	167.83	116806.0

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

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