PREVIEW / etf_1min / 2015-04-02

all etf 1-min files

  file:    by_date/etf_1min/2015/2015-04-02.parquet
  size:    2.4 MB
  rows:    126,627

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
2015-04-02 04:00:00	SPY	ETF	205.59	205.59	205.59	205.59	155.0
2015-04-02 04:02:00	SPY	ETF	205.15	205.15	205.15	205.15	200.0
2015-04-02 04:04:00	SPY	ETF	205.13	205.13	205.13	205.13	310.0
2015-04-02 04:05:00	SPY	ETF	205.11	205.11	205.11	205.11	125.0
2015-04-02 04:10:00	SPY	ETF	205.14	205.14	205.14	205.14	1593.0
2015-04-02 04:13:00	SPY	ETF	205.14	205.14	205.09	205.09	746.0
2015-04-02 04:30:00	SPY	ETF	205.09	205.09	205.05	205.05	300.0
2015-04-02 04:33:00	SPY	ETF	205.08	205.08	205.07	205.07	300.0
2015-04-02 04:34:00	SPY	ETF	205.04	205.04	205.0	205.0	825.0
2015-04-02 04:40:00	SPY	ETF	205.02	205.02	204.95	204.95	300.0
2015-04-02 04:49:00	SPY	ETF	205.17	205.19	205.17	205.17	410.0
2015-04-02 04:52:00	SPY	ETF	205.15	205.15	205.15	205.15	100.0
2015-04-02 04:59:00	SPY	ETF	205.1	205.1	205.1	205.1	500.0
2015-04-02 05:01:00	SPY	ETF	205.07	205.07	205.05	205.05	200.0
2015-04-02 05:03:00	SPY	ETF	205.05	205.05	205.03	205.03	700.0
2015-04-02 05:05:00	SPY	ETF	205.03	205.17	205.03	205.03	500.0
2015-04-02 05:06:00	SPY	ETF	205.11	205.11	205.0	205.0	450.0
2015-04-02 05:12:00	SPY	ETF	205.1	205.1	205.1	205.1	10000.0
2015-04-02 05:13:00	SPY	ETF	205.1	205.1	205.1	205.1	200.0
2015-04-02 05:17:00	SPY	ETF	205.1	205.1	205.1	205.1	100.0
2015-04-02 05:18:00	SPY	ETF	205.07	205.07	205.07	205.07	200.0
2015-04-02 05:29:00	SPY	ETF	205.1	205.1	205.1	205.1	1000.0
2015-04-02 05:43:00	SPY	ETF	205.22	205.22	205.22	205.22	1000.0
2015-04-02 05:48:00	SPY	ETF	205.19	205.19	205.15	205.15	2195.0
2015-04-02 05:54:00	SPY	ETF	205.14	205.14	205.14	205.14	2600.0
2015-04-02 05:55:00	SPY	ETF	205.17	205.17	205.17	205.17	1800.0
2015-04-02 05:56:00	SPY	ETF	205.15	205.15	205.15	205.15	200.0
2015-04-02 05:57:00	SPY	ETF	205.19	205.19	205.19	205.19	400.0
2015-04-02 05:59:00	SPY	ETF	205.15	205.15	205.15	205.15	135.0
2015-04-02 06:02:00	SPY	ETF	205.15	205.15	205.15	205.15	3050.0
2015-04-02 06:04:00	SPY	ETF	205.12	205.12	205.06	205.06	700.0
2015-04-02 06:05:00	SPY	ETF	205.04	205.04	205.02	205.02	300.0
2015-04-02 06:08:00	SPY	ETF	205.07	205.07	205.07	205.07	900.0
2015-04-02 06:12:00	SPY	ETF	205.03	205.03	205.03	205.03	382.0
2015-04-02 06:13:00	SPY	ETF	205.04	205.04	205.04	205.04	548.0
2015-04-02 06:17:00	SPY	ETF	205.05	205.05	205.05	205.05	200.0
2015-04-02 06:19:00	SPY	ETF	205.05	205.05	205.05	205.05	300.0
2015-04-02 06:21:00	SPY	ETF	205.09	205.09	205.09	205.09	200.0
2015-04-02 06:22:00	SPY	ETF	205.07	205.07	205.07	205.07	200.0
2015-04-02 06:23:00	SPY	ETF	205.02	205.02	205.02	205.02	500.0
2015-04-02 06:26:00	SPY	ETF	205.04	205.05	205.04	205.05	400.0
2015-04-02 06:30:00	SPY	ETF	205.09	205.1	205.09	205.1	1200.0
2015-04-02 06:31:00	SPY	ETF	205.1	205.1	205.09	205.09	500.0
2015-04-02 06:33:00	SPY	ETF	205.07	205.07	205.07	205.07	300.0
2015-04-02 06:34:00	SPY	ETF	205.06	205.06	205.04	205.04	1050.0
2015-04-02 06:36:00	SPY	ETF	205.01	205.01	205.01	205.01	100.0
2015-04-02 06:38:00	SPY	ETF	205.04	205.04	205.04	205.04	400.0
2015-04-02 06:40:00	SPY	ETF	205.07	205.07	205.07	205.07	100.0
2015-04-02 06:43:00	SPY	ETF	205.04	205.04	205.04	205.04	100.0
2015-04-02 06:45:00	SPY	ETF	205.07	205.07	205.07	205.07	1000.0

> showing 50 of 126,627 rows — these rows as CSV

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