PREVIEW / etf_1min / 2016-09-07

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-09-07.parquet
  size:    2.4 MB
  rows:    131,589

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-09-07 04:03:00	SPY	ETF	219.03	219.03	219.03	219.03	106.0
2016-09-07 04:04:00	SPY	ETF	219.03	219.03	219.03	219.03	400.0
2016-09-07 04:14:00	SPY	ETF	218.99	218.99	218.97	218.97	500.0
2016-09-07 04:17:00	SPY	ETF	219.02	219.02	219.02	219.02	130.0
2016-09-07 04:18:00	SPY	ETF	218.97	218.97	218.97	218.97	103.0
2016-09-07 04:30:00	SPY	ETF	219.05	219.05	219.05	219.05	401.0
2016-09-07 04:36:00	SPY	ETF	219.15	219.15	219.15	219.15	244.0
2016-09-07 04:37:00	SPY	ETF	219.12	219.12	219.12	219.12	901.0
2016-09-07 04:44:00	SPY	ETF	219.12	219.12	219.12	219.12	900.0
2016-09-07 04:52:00	SPY	ETF	219.02	219.02	219.02	219.02	100.0
2016-09-07 04:53:00	SPY	ETF	219.05	219.05	219.05	219.05	300.0
2016-09-07 04:58:00	SPY	ETF	219.0	219.0	219.0	219.0	500.0
2016-09-07 05:00:00	SPY	ETF	218.97	218.97	218.97	218.97	1003.0
2016-09-07 05:04:00	SPY	ETF	218.95	218.95	218.95	218.95	2201.0
2016-09-07 05:05:00	SPY	ETF	218.95	218.95	218.95	218.95	154.0
2016-09-07 05:08:00	SPY	ETF	218.93	218.95	218.93	218.95	1101.0
2016-09-07 05:12:00	SPY	ETF	218.93	218.93	218.93	218.93	102.0
2016-09-07 05:20:00	SPY	ETF	219.06	219.06	219.06	219.06	100.0
2016-09-07 05:29:00	SPY	ETF	219.02	219.05	219.02	219.05	1000.0
2016-09-07 05:30:00	SPY	ETF	219.02	219.02	219.02	219.02	1000.0
2016-09-07 05:36:00	SPY	ETF	219.01	219.02	219.01	219.02	400.0
2016-09-07 05:39:00	SPY	ETF	218.97	218.97	218.97	218.97	202.0
2016-09-07 05:49:00	SPY	ETF	218.93	218.93	218.93	218.93	202.0
2016-09-07 06:14:00	SPY	ETF	218.92	218.92	218.92	218.92	400.0
2016-09-07 06:22:00	SPY	ETF	218.9	218.9	218.9	218.9	400.0
2016-09-07 06:33:00	SPY	ETF	218.9	218.9	218.9	218.9	201.0
2016-09-07 06:52:00	SPY	ETF	218.93	218.93	218.93	218.93	100.0
2016-09-07 06:54:00	SPY	ETF	218.93	218.93	218.92	218.92	500.0
2016-09-07 06:56:00	SPY	ETF	218.9	218.9	218.9	218.9	200.0
2016-09-07 06:57:00	SPY	ETF	218.89	218.89	218.86	218.86	253.0
2016-09-07 07:00:00	SPY	ETF	218.85	218.85	218.84	218.84	1300.0
2016-09-07 07:01:00	SPY	ETF	218.86	218.86	218.86	218.86	202.0
2016-09-07 07:02:00	SPY	ETF	218.83	218.83	218.83	218.83	295.0
2016-09-07 07:03:00	SPY	ETF	218.83	218.83	218.83	218.83	200.0
2016-09-07 07:05:00	SPY	ETF	218.83	218.83	218.83	218.83	1858.0
2016-09-07 07:06:00	SPY	ETF	218.8	218.8	218.8	218.8	250.0
2016-09-07 07:12:00	SPY	ETF	218.76	218.76	218.76	218.76	200.0
2016-09-07 07:13:00	SPY	ETF	218.81	218.81	218.81	218.81	300.0
2016-09-07 07:15:00	SPY	ETF	218.8	218.8	218.8	218.8	200.0
2016-09-07 07:17:00	SPY	ETF	218.8	218.8	218.8	218.8	101.0
2016-09-07 07:19:00	SPY	ETF	218.77	218.77	218.76	218.77	5050.0
2016-09-07 07:25:00	SPY	ETF	218.78	218.78	218.78	218.78	2211.0
2016-09-07 07:27:00	SPY	ETF	218.8	218.8	218.79	218.79	454.0
2016-09-07 07:29:00	SPY	ETF	218.8	218.8	218.77	218.77	4825.0
2016-09-07 07:30:00	SPY	ETF	218.77	218.77	218.77	218.77	861.0
2016-09-07 07:36:00	SPY	ETF	218.8	218.81	218.8	218.81	1290.0
2016-09-07 07:37:00	SPY	ETF	218.8	218.82	218.8	218.82	5903.0
2016-09-07 07:38:00	SPY	ETF	218.82	218.82	218.82	218.82	5497.0
2016-09-07 07:40:00	SPY	ETF	218.82	218.82	218.82	218.82	300.0
2016-09-07 07:41:00	SPY	ETF	218.8	218.8	218.78	218.78	2352.0

> showing 50 of 131,589 rows — these rows as CSV

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