PREVIEW / etf_5min / 2013-09-05

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-09-05.parquet
  size:    928 KB
  rows:    40,097

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-09-05 04:05:00	SPY	ETF	166.13	166.13	166.11	166.11	3450.0
2013-09-05 04:10:00	SPY	ETF	166.07	166.07	166.05	166.05	835.0
2013-09-05 04:15:00	SPY	ETF	166.03	166.03	165.99	165.99	900.0
2013-09-05 04:20:00	SPY	ETF	165.98	165.98	165.98	165.98	100.0
2013-09-05 04:25:00	SPY	ETF	165.98	165.98	165.94	165.94	830.0
2013-09-05 04:30:00	SPY	ETF	165.97	166.0	165.97	166.0	500.0
2013-09-05 04:35:00	SPY	ETF	166.02	166.02	166.02	166.02	100.0
2013-09-05 04:45:00	SPY	ETF	165.96	165.96	165.71	165.75	12300.0
2013-09-05 04:50:00	SPY	ETF	165.73	165.93	165.73	165.93	5700.0
2013-09-05 04:55:00	SPY	ETF	165.91	165.91	165.82	165.88	3500.0
2013-09-05 05:00:00	SPY	ETF	165.85	165.85	165.85	165.85	600.0
2013-09-05 05:05:00	SPY	ETF	165.87	165.93	165.87	165.93	2300.0
2013-09-05 05:10:00	SPY	ETF	165.91	165.91	165.84	165.84	2300.0
2013-09-05 05:15:00	SPY	ETF	165.83	165.83	165.82	165.82	300.0
2013-09-05 05:20:00	SPY	ETF	165.81	165.81	165.74	165.74	1800.0
2013-09-05 05:25:00	SPY	ETF	165.79	165.8	165.77	165.77	1700.0
2013-09-05 05:30:00	SPY	ETF	165.79	165.79	165.74	165.74	300.0
2013-09-05 05:35:00	SPY	ETF	165.73	165.73	165.72	165.72	10800.0
2013-09-05 05:40:00	SPY	ETF	165.69	165.69	165.65	165.67	3635.0
2013-09-05 05:45:00	SPY	ETF	165.71	165.72	165.71	165.72	1200.0
2013-09-05 05:50:00	SPY	ETF	165.74	165.77	165.74	165.77	35800.0
2013-09-05 06:00:00	SPY	ETF	165.75	165.75	165.73	165.75	1900.0
2013-09-05 06:05:00	SPY	ETF	165.75	165.75	165.73	165.73	4200.0
2013-09-05 06:10:00	SPY	ETF	165.75	165.78	165.75	165.78	1300.0
2013-09-05 06:15:00	SPY	ETF	165.78	165.78	165.72	165.72	1200.0
2013-09-05 06:20:00	SPY	ETF	165.75	165.88	165.75	165.88	4800.0
2013-09-05 06:25:00	SPY	ETF	165.9	165.91	165.89	165.9	3200.0
2013-09-05 06:30:00	SPY	ETF	165.91	165.98	165.91	165.98	7900.0
2013-09-05 06:35:00	SPY	ETF	166.0	166.02	166.0	166.02	300.0
2013-09-05 06:40:00	SPY	ETF	166.0	166.0	166.0	166.0	1000.0
2013-09-05 06:45:00	SPY	ETF	165.96	165.97	165.96	165.97	15300.0
2013-09-05 06:50:00	SPY	ETF	165.95	165.95	165.95	165.95	400.0
2013-09-05 06:55:00	SPY	ETF	165.94	165.94	165.94	165.94	100.0
2013-09-05 07:00:00	SPY	ETF	165.92	165.98	165.9	165.98	12364.0
2013-09-05 07:05:00	SPY	ETF	166.0	166.02	165.88	165.88	14900.0
2013-09-05 07:10:00	SPY	ETF	165.88	165.88	165.84	165.84	5200.0
2013-09-05 07:15:00	SPY	ETF	165.83	165.87	165.79	165.87	46600.0
2013-09-05 07:20:00	SPY	ETF	165.87	165.93	165.87	165.93	12500.0
2013-09-05 07:25:00	SPY	ETF	165.94	165.94	165.83	165.83	8100.0
2013-09-05 07:30:00	SPY	ETF	165.86	165.86	165.82	165.83	9700.0
2013-09-05 07:35:00	SPY	ETF	165.87	165.9	165.86	165.87	24650.0
2013-09-05 07:40:00	SPY	ETF	165.87	165.92	165.86	165.89	11900.0
2013-09-05 07:45:00	SPY	ETF	165.9	165.93	165.9	165.91	23300.0
2013-09-05 07:50:00	SPY	ETF	165.93	165.95	165.88	165.88	22300.0
2013-09-05 07:55:00	SPY	ETF	165.89	165.89	165.83	165.84	22200.0
2013-09-05 08:00:00	SPY	ETF	165.95	165.95	165.87	165.89	28545.0
2013-09-05 08:05:00	SPY	ETF	165.9	165.99	165.9	165.98	39050.0
2013-09-05 08:10:00	SPY	ETF	165.98	166.02	165.92	165.92	16615.0
2013-09-05 08:15:00	SPY	ETF	165.93	166.015	165.9	165.9	34260.0
2013-09-05 08:20:00	SPY	ETF	165.91	165.97	165.91	165.93	9190.0

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

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