PREVIEW / etf_1min / 2016-07-01

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-07-01.parquet
  size:    2.7 MB
  rows:    145,817

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
2016-07-01 04:00:00	SPY	ETF	208.85	208.85	208.8	208.8	1725.0
2016-07-01 04:02:00	SPY	ETF	208.81	208.81	208.81	208.81	8000.0
2016-07-01 04:03:00	SPY	ETF	208.84	208.84	208.84	208.84	500.0
2016-07-01 04:04:00	SPY	ETF	208.81	208.81	208.76	208.76	13200.0
2016-07-01 04:05:00	SPY	ETF	208.83	208.83	208.83	208.83	500.0
2016-07-01 04:06:00	SPY	ETF	208.84	208.84	208.76	208.76	16000.0
2016-07-01 04:07:00	SPY	ETF	208.85	208.85	208.85	208.85	1000.0
2016-07-01 04:10:00	SPY	ETF	208.85	208.85	208.85	208.85	1100.0
2016-07-01 04:11:00	SPY	ETF	208.83	208.83	208.83	208.83	700.0
2016-07-01 04:13:00	SPY	ETF	208.8	208.8	208.8	208.8	150.0
2016-07-01 04:15:00	SPY	ETF	208.9	208.9	208.9	208.9	600.0
2016-07-01 04:16:00	SPY	ETF	208.98	209.0	208.98	209.0	460.0
2016-07-01 04:17:00	SPY	ETF	209.0	209.0	209.0	209.0	300.0
2016-07-01 04:18:00	SPY	ETF	209.05	209.05	209.05	209.05	500.0
2016-07-01 04:22:00	SPY	ETF	209.0	209.0	209.0	209.0	900.0
2016-07-01 04:23:00	SPY	ETF	209.0	209.04	209.0	209.04	200.0
2016-07-01 04:28:00	SPY	ETF	209.0	209.0	209.0	209.0	1400.0
2016-07-01 04:29:00	SPY	ETF	209.02	209.08	209.02	209.08	1520.0
2016-07-01 04:30:00	SPY	ETF	209.12	209.12	209.12	209.12	2400.0
2016-07-01 04:33:00	SPY	ETF	209.05	209.05	209.05	209.05	100.0
2016-07-01 04:35:00	SPY	ETF	209.08	209.08	209.08	209.08	200.0
2016-07-01 04:36:00	SPY	ETF	209.02	209.02	209.02	209.02	300.0
2016-07-01 04:37:00	SPY	ETF	209.01	209.01	209.01	209.01	200.0
2016-07-01 04:39:00	SPY	ETF	208.96	208.96	208.96	208.96	400.0
2016-07-01 04:43:00	SPY	ETF	208.92	208.92	208.92	208.92	500.0
2016-07-01 04:44:00	SPY	ETF	208.91	208.91	208.91	208.91	1000.0
2016-07-01 04:46:00	SPY	ETF	208.9	208.9	208.9	208.9	100.0
2016-07-01 04:47:00	SPY	ETF	208.92	208.92	208.92	208.92	100.0
2016-07-01 04:48:00	SPY	ETF	208.86	208.86	208.82	208.82	900.0
2016-07-01 04:49:00	SPY	ETF	208.85	208.85	208.82	208.85	12600.0
2016-07-01 04:51:00	SPY	ETF	208.82	208.82	208.82	208.82	400.0
2016-07-01 04:53:00	SPY	ETF	208.81	208.81	208.81	208.81	500.0
2016-07-01 04:56:00	SPY	ETF	208.89	208.89	208.85	208.85	1300.0
2016-07-01 04:57:00	SPY	ETF	208.82	208.82	208.82	208.82	1330.0
2016-07-01 04:58:00	SPY	ETF	208.81	208.81	208.81	208.81	600.0
2016-07-01 05:01:00	SPY	ETF	208.8	208.89	208.8	208.89	2800.0
2016-07-01 05:03:00	SPY	ETF	208.85	208.85	208.85	208.85	1100.0
2016-07-01 05:04:00	SPY	ETF	208.83	208.83	208.81	208.81	2800.0
2016-07-01 05:07:00	SPY	ETF	208.78	208.78	208.76	208.76	720.0
2016-07-01 05:09:00	SPY	ETF	208.79	208.79	208.79	208.79	400.0
2016-07-01 05:11:00	SPY	ETF	208.8	208.82	208.8	208.82	900.0
2016-07-01 05:12:00	SPY	ETF	208.85	208.85	208.85	208.85	2000.0
2016-07-01 05:13:00	SPY	ETF	208.86	208.87	208.86	208.87	3100.0
2016-07-01 05:14:00	SPY	ETF	208.88	208.88	208.88	208.88	300.0
2016-07-01 05:15:00	SPY	ETF	208.91	208.91	208.82	208.82	6500.0
2016-07-01 05:17:00	SPY	ETF	208.86	208.86	208.86	208.86	2500.0
2016-07-01 05:18:00	SPY	ETF	208.91	208.91	208.91	208.91	3000.0
2016-07-01 05:19:00	SPY	ETF	208.87	208.87	208.87	208.87	310.0
2016-07-01 05:22:00	SPY	ETF	208.82	208.82	208.82	208.82	210.0
2016-07-01 05:29:00	SPY	ETF	208.8	208.8	208.8	208.8	400.0

> showing 50 of 145,817 rows — these rows as CSV

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