PREVIEW / etf_1min / 2018-04-02

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-04-02.parquet
  size:    3.6 MB
  rows:    180,824

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
2018-04-02 04:00:00	SPY	ETF	262.68	262.91	262.68	262.77	1162.0
2018-04-02 04:02:00	SPY	ETF	262.87	262.87	262.78	262.78	496.0
2018-04-02 04:03:00	SPY	ETF	262.85	262.85	262.78	262.78	468.0
2018-04-02 04:05:00	SPY	ETF	262.8	262.8	262.8	262.8	1000.0
2018-04-02 04:07:00	SPY	ETF	262.83	262.83	262.83	262.83	320.0
2018-04-02 04:09:00	SPY	ETF	262.8	262.8	262.8	262.8	500.0
2018-04-02 04:10:00	SPY	ETF	262.82	262.82	262.82	262.82	100.0
2018-04-02 04:16:00	SPY	ETF	262.86	262.86	262.86	262.86	500.0
2018-04-02 04:17:00	SPY	ETF	262.82	262.82	262.74	262.74	420.0
2018-04-02 04:20:00	SPY	ETF	262.79	262.79	262.79	262.79	1120.0
2018-04-02 04:21:00	SPY	ETF	262.84	262.84	262.84	262.84	520.0
2018-04-02 04:23:00	SPY	ETF	262.94	262.94	262.94	262.94	1040.0
2018-04-02 04:24:00	SPY	ETF	262.93	262.93	262.93	262.93	200.0
2018-04-02 04:25:00	SPY	ETF	262.91	262.91	262.91	262.91	550.0
2018-04-02 04:26:00	SPY	ETF	262.94	262.94	262.94	262.94	300.0
2018-04-02 04:27:00	SPY	ETF	263.0	263.0	262.94	263.0	490.0
2018-04-02 04:30:00	SPY	ETF	262.91	262.91	262.91	262.91	100.0
2018-04-02 04:59:00	SPY	ETF	262.77	262.77	262.77	262.77	118.0
2018-04-02 05:01:00	SPY	ETF	262.74	262.74	262.73	262.73	520.0
2018-04-02 05:02:00	SPY	ETF	262.79	262.79	262.79	262.79	150.0
2018-04-02 05:13:00	SPY	ETF	262.85	262.85	262.85	262.85	100.0
2018-04-02 05:16:00	SPY	ETF	262.86	262.86	262.86	262.86	500.0
2018-04-02 05:17:00	SPY	ETF	262.85	262.85	262.85	262.85	2000.0
2018-04-02 05:21:00	SPY	ETF	262.85	262.85	262.85	262.85	617.0
2018-04-02 05:23:00	SPY	ETF	262.91	262.91	262.91	262.91	420.0
2018-04-02 05:27:00	SPY	ETF	262.86	262.86	262.86	262.86	620.0
2018-04-02 05:35:00	SPY	ETF	262.83	262.83	262.83	262.83	180.0
2018-04-02 05:54:00	SPY	ETF	262.92	262.92	262.92	262.92	1000.0
2018-04-02 06:00:00	SPY	ETF	262.94	262.94	262.94	262.94	400.0
2018-04-02 06:01:00	SPY	ETF	263.1	263.1	263.1	263.1	260.0
2018-04-02 06:06:00	SPY	ETF	263.03	263.03	263.03	263.03	485.0
2018-04-02 06:07:00	SPY	ETF	263.02	263.02	263.02	263.02	3000.0
2018-04-02 06:16:00	SPY	ETF	263.02	263.02	263.02	263.02	510.0
2018-04-02 06:19:00	SPY	ETF	263.04	263.04	263.04	263.04	490.0
2018-04-02 06:23:00	SPY	ETF	263.03	263.03	263.03	263.03	1000.0
2018-04-02 06:31:00	SPY	ETF	263.0	263.01	263.0	263.01	200.0
2018-04-02 06:32:00	SPY	ETF	263.04	263.04	263.04	263.04	820.0
2018-04-02 06:35:00	SPY	ETF	263.05	263.07	263.05	263.07	2000.0
2018-04-02 06:37:00	SPY	ETF	263.06	263.08	263.06	263.08	799.0
2018-04-02 06:38:00	SPY	ETF	263.09	263.1	263.09	263.1	701.0
2018-04-02 06:48:00	SPY	ETF	262.92	262.95	262.92	262.95	1770.0
2018-04-02 06:51:00	SPY	ETF	263.0	263.0	263.0	263.0	170.0
2018-04-02 06:52:00	SPY	ETF	263.0	263.0	263.0	263.0	100.0
2018-04-02 07:00:00	SPY	ETF	262.8	262.8	262.74	262.75	2071.0
2018-04-02 07:01:00	SPY	ETF	262.79	262.79	262.79	262.79	3055.0
2018-04-02 07:02:00	SPY	ETF	262.83	262.83	262.83	262.83	207.0
2018-04-02 07:03:00	SPY	ETF	262.7	262.7	262.62	262.62	2770.0
2018-04-02 07:04:00	SPY	ETF	262.6	262.67	262.6	262.67	11020.0
2018-04-02 07:06:00	SPY	ETF	262.68	262.68	262.68	262.68	1000.0
2018-04-02 07:07:00	SPY	ETF	262.64	262.64	262.64	262.64	300.0

> showing 50 of 180,824 rows — these rows as CSV

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