PREVIEW / etf_5min / 2013-11-27

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-11-27.parquet
  size:    945 KB
  rows:    40,147

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-11-27 04:00:00	SPY	ETF	180.72	180.8	180.72	180.8	4500.0
2013-11-27 04:20:00	SPY	ETF	180.92	180.92	180.9	180.9	217.0
2013-11-27 04:30:00	SPY	ETF	180.88	180.88	180.88	180.88	250.0
2013-11-27 04:35:00	SPY	ETF	180.86	180.88	180.86	180.88	430.0
2013-11-27 04:40:00	SPY	ETF	180.86	180.86	180.86	180.86	400.0
2013-11-27 04:55:00	SPY	ETF	180.9	180.92	180.9	180.92	200.0
2013-11-27 05:05:00	SPY	ETF	180.93	180.93	180.93	180.93	800.0
2013-11-27 05:10:00	SPY	ETF	180.89	180.89	180.87	180.89	900.0
2013-11-27 05:15:00	SPY	ETF	180.86	180.92	180.86	180.92	36139.0
2013-11-27 05:20:00	SPY	ETF	180.92	180.92	180.92	180.92	100.0
2013-11-27 05:25:00	SPY	ETF	180.92	180.92	180.92	180.92	100.0
2013-11-27 05:30:00	SPY	ETF	180.89	180.89	180.88	180.88	1039.0
2013-11-27 05:35:00	SPY	ETF	180.89	180.89	180.89	180.89	100.0
2013-11-27 05:40:00	SPY	ETF	180.87	180.87	180.87	180.87	1129.0
2013-11-27 05:55:00	SPY	ETF	180.87	180.87	180.85	180.85	4000.0
2013-11-27 06:15:00	SPY	ETF	180.85	180.85	180.85	180.85	768.0
2013-11-27 06:20:00	SPY	ETF	180.81	180.83	180.8	180.82	10194.0
2013-11-27 06:30:00	SPY	ETF	180.85	180.92	180.85	180.9	922.0
2013-11-27 06:35:00	SPY	ETF	180.91	180.91	180.9	180.9	22500.0
2013-11-27 06:40:00	SPY	ETF	180.93	180.93	180.93	180.93	1000.0
2013-11-27 06:55:00	SPY	ETF	180.89	180.89	180.88	180.88	1395.0
2013-11-27 07:00:00	SPY	ETF	180.9	180.92	180.9	180.92	2000.0
2013-11-27 07:05:00	SPY	ETF	180.93	180.94	180.93	180.94	20000.0
2013-11-27 07:10:00	SPY	ETF	180.91	180.91	180.9	180.9	1782.0
2013-11-27 07:15:00	SPY	ETF	180.93	180.94	180.93	180.94	4900.0
2013-11-27 07:20:00	SPY	ETF	180.92	180.94	180.92	180.92	2000.0
2013-11-27 07:25:00	SPY	ETF	180.91	180.93	180.89	180.91	22350.0
2013-11-27 07:30:00	SPY	ETF	180.85	180.85	180.85	180.85	1300.0
2013-11-27 07:35:00	SPY	ETF	180.85	180.86	180.85	180.85	5872.0
2013-11-27 07:40:00	SPY	ETF	180.84	180.84	180.835	180.835	500.0
2013-11-27 07:45:00	SPY	ETF	180.86	180.9	180.86	180.88	4100.0
2013-11-27 07:50:00	SPY	ETF	180.91	180.91	180.86	180.89	3388.0
2013-11-27 07:55:00	SPY	ETF	180.86	180.86	180.83	180.84	3600.0
2013-11-27 08:00:00	SPY	ETF	180.87	180.87	180.83	180.85	10550.0
2013-11-27 08:05:00	SPY	ETF	180.86	180.89	180.84	180.89	42270.0
2013-11-27 08:10:00	SPY	ETF	180.85	180.89	180.85	180.88	5600.0
2013-11-27 08:15:00	SPY	ETF	180.87	180.89	180.86	180.86	7600.0
2013-11-27 08:20:00	SPY	ETF	180.84	180.86	180.83	180.83	1400.0
2013-11-27 08:25:00	SPY	ETF	180.84	180.89	180.82	180.89	3600.0
2013-11-27 08:30:00	SPY	ETF	180.88	180.88	180.74	180.78	82630.0
2013-11-27 08:35:00	SPY	ETF	180.8	180.84	180.8	180.83	41000.0
2013-11-27 08:40:00	SPY	ETF	180.83	180.88	180.83	180.85	54440.0
2013-11-27 08:45:00	SPY	ETF	180.85	180.94	180.84	180.94	31178.0
2013-11-27 08:50:00	SPY	ETF	180.92	180.95	180.89	180.91	30852.0
2013-11-27 08:55:00	SPY	ETF	180.9	180.93	180.88	180.88	33319.0
2013-11-27 09:00:00	SPY	ETF	180.92	180.95	180.9	180.9	34800.0
2013-11-27 09:05:00	SPY	ETF	180.9	180.94	180.9	180.92	28020.0
2013-11-27 09:10:00	SPY	ETF	180.92	180.92	180.88	180.9	42508.0
2013-11-27 09:15:00	SPY	ETF	180.9	180.95	180.9	180.93	95910.0
2013-11-27 09:20:00	SPY	ETF	180.92	180.94	180.92	180.93	105812.0

> showing 50 of 40,147 rows — these rows as CSV

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