PREVIEW / etf_5min / 2018-08-30

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-08-30.parquet
  size:    1.3 MB
  rows:    57,733

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-08-30 04:00:00	SPY	ETF	291.19	291.19	291.05	291.05	3441.0
2018-08-30 04:05:00	SPY	ETF	291.03	291.03	291.02	291.02	1417.0
2018-08-30 04:10:00	SPY	ETF	291.12	291.12	291.12	291.12	151.0
2018-08-30 04:15:00	SPY	ETF	291.16	291.16	291.16	291.16	100.0
2018-08-30 04:20:00	SPY	ETF	291.11	291.11	290.98	290.98	3690.0
2018-08-30 04:25:00	SPY	ETF	290.95	290.95	290.9	290.9	4647.0
2018-08-30 04:30:00	SPY	ETF	290.9	290.95	290.9	290.95	2800.0
2018-08-30 04:35:00	SPY	ETF	290.95	290.95	290.92	290.92	4300.0
2018-08-30 04:40:00	SPY	ETF	290.87	290.87	290.82	290.82	600.0
2018-08-30 04:45:00	SPY	ETF	290.82	290.82	290.74	290.74	1427.0
2018-08-30 04:50:00	SPY	ETF	290.74	290.9	290.74	290.9	38500.0
2018-08-30 04:55:00	SPY	ETF	290.9	290.9	290.84	290.84	4500.0
2018-08-30 05:00:00	SPY	ETF	290.95	290.95	290.89	290.89	1552.0
2018-08-30 05:05:00	SPY	ETF	290.94	290.94	290.94	290.94	200.0
2018-08-30 05:10:00	SPY	ETF	290.94	290.94	290.9	290.9	400.0
2018-08-30 05:15:00	SPY	ETF	290.86	290.86	290.86	290.86	2100.0
2018-08-30 05:20:00	SPY	ETF	290.92	290.92	290.9	290.9	3600.0
2018-08-30 05:25:00	SPY	ETF	290.92	290.92	290.92	290.92	5000.0
2018-08-30 05:30:00	SPY	ETF	290.87	290.96	290.87	290.96	600.0
2018-08-30 05:35:00	SPY	ETF	290.99	291.0	290.99	291.0	2700.0
2018-08-30 05:40:00	SPY	ETF	290.97	290.97	290.97	290.97	800.0
2018-08-30 05:45:00	SPY	ETF	290.98	291.0	290.98	291.0	300.0
2018-08-30 05:55:00	SPY	ETF	290.92	290.92	290.91	290.91	2100.0
2018-08-30 06:00:00	SPY	ETF	290.96	290.96	290.96	290.96	500.0
2018-08-30 06:05:00	SPY	ETF	290.91	290.91	290.85	290.85	3100.0
2018-08-30 06:10:00	SPY	ETF	290.81	290.85	290.81	290.81	1500.0
2018-08-30 06:15:00	SPY	ETF	290.82	290.82	290.82	290.82	1100.0
2018-08-30 06:20:00	SPY	ETF	290.84	290.84	290.84	290.84	800.0
2018-08-30 06:25:00	SPY	ETF	290.86	290.86	290.86	290.86	600.0
2018-08-30 06:30:00	SPY	ETF	290.86	290.9	290.84	290.9	3800.0
2018-08-30 06:35:00	SPY	ETF	290.97	291.07	290.97	291.07	3152.0
2018-08-30 06:40:00	SPY	ETF	291.09	291.17	291.09	291.1	12600.0
2018-08-30 06:45:00	SPY	ETF	291.06	291.08	291.06	291.07	22500.0
2018-08-30 06:50:00	SPY	ETF	291.04	291.04	291.02	291.02	500.0
2018-08-30 06:55:00	SPY	ETF	291.02	291.02	290.97	290.97	2000.0
2018-08-30 07:00:00	SPY	ETF	291.07	291.12	291.07	291.1	15681.0
2018-08-30 07:05:00	SPY	ETF	291.1	291.1	291.01	291.01	11912.0
2018-08-30 07:10:00	SPY	ETF	291.0	291.05	290.99	291.05	11725.0
2018-08-30 07:15:00	SPY	ETF	291.05	291.05	290.96	290.97	6300.0
2018-08-30 07:20:00	SPY	ETF	290.98	291.02	290.97	291.0	5502.0
2018-08-30 07:25:00	SPY	ETF	291.05	291.08	291.05	291.08	3500.0
2018-08-30 07:30:00	SPY	ETF	291.1	291.15	291.1	291.15	22345.0
2018-08-30 07:35:00	SPY	ETF	291.17	291.17	291.17	291.17	253.0
2018-08-30 07:40:00	SPY	ETF	291.09	291.09	291.02	291.07	3610.0
2018-08-30 07:45:00	SPY	ETF	291.07	291.07	290.95	290.95	46143.0
2018-08-30 07:50:00	SPY	ETF	290.96	291.01	290.96	291.01	47090.0
2018-08-30 07:55:00	SPY	ETF	290.96	290.99	290.93	290.99	9800.0
2018-08-30 08:00:00	SPY	ETF	291.0001	291.15	290.92	290.9401	30224.0
2018-08-30 08:05:00	SPY	ETF	291.01	291.07	291.01	291.07	31252.0
2018-08-30 08:10:00	SPY	ETF	291.1	291.15	291.08	291.14	9400.0

> showing 50 of 57,733 rows — these rows as CSV

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