PREVIEW / etf_5min / 2018-11-01

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-11-01.parquet
  size:    1.5 MB
  rows:    64,298

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-11-01 04:00:00	SPY	ETF	270.6	270.7	270.6	270.7	1250.0
2018-11-01 04:05:00	SPY	ETF	270.81	270.9	270.81	270.86	2100.0
2018-11-01 04:10:00	SPY	ETF	270.93	270.93	270.89	270.89	785.0
2018-11-01 04:15:00	SPY	ETF	270.8	271.07	270.8	271.05	6710.0
2018-11-01 04:20:00	SPY	ETF	271.02	271.23	271.02	271.17	5784.0
2018-11-01 04:25:00	SPY	ETF	271.21	271.32	271.21	271.32	2888.0
2018-11-01 04:30:00	SPY	ETF	271.32	271.32	271.21	271.21	1100.0
2018-11-01 04:35:00	SPY	ETF	271.17	271.23	271.17	271.23	2600.0
2018-11-01 04:40:00	SPY	ETF	271.21	271.21	271.11	271.11	4469.0
2018-11-01 04:45:00	SPY	ETF	271.19	271.45	271.19	271.45	4897.0
2018-11-01 04:50:00	SPY	ETF	271.45	271.56	271.4	271.4	3257.0
2018-11-01 04:55:00	SPY	ETF	271.42	271.46	271.4	271.46	2800.0
2018-11-01 05:00:00	SPY	ETF	271.5	271.67	271.5	271.67	17500.0
2018-11-01 05:05:00	SPY	ETF	271.6	271.6	271.45	271.45	6900.0
2018-11-01 05:10:00	SPY	ETF	271.45	271.45	271.38	271.38	1350.0
2018-11-01 05:15:00	SPY	ETF	271.35	271.4	271.35	271.4	1680.0
2018-11-01 05:20:00	SPY	ETF	271.35	271.35	271.33	271.33	1195.0
2018-11-01 05:25:00	SPY	ETF	271.4	271.5	271.4	271.5	3100.0
2018-11-01 05:30:00	SPY	ETF	271.5	271.5	271.35	271.35	2518.0
2018-11-01 05:35:00	SPY	ETF	271.3	271.6	271.3	271.6	4468.0
2018-11-01 05:40:00	SPY	ETF	271.55	271.55	271.55	271.55	700.0
2018-11-01 05:45:00	SPY	ETF	271.64	271.71	271.64	271.71	2965.0
2018-11-01 05:50:00	SPY	ETF	271.63	271.63	271.63	271.63	100.0
2018-11-01 05:55:00	SPY	ETF	271.77	271.8	271.75	271.8	2700.0
2018-11-01 06:00:00	SPY	ETF	271.87	271.87	271.78	271.78	2203.0
2018-11-01 06:05:00	SPY	ETF	271.86	271.9	271.78	271.78	1160.0
2018-11-01 06:10:00	SPY	ETF	271.87	271.9	271.81	271.81	785.0
2018-11-01 06:15:00	SPY	ETF	271.85	271.85	271.85	271.85	500.0
2018-11-01 06:20:00	SPY	ETF	271.68	271.85	271.68	271.85	635.0
2018-11-01 06:25:00	SPY	ETF	271.85	271.85	271.78	271.78	800.0
2018-11-01 06:30:00	SPY	ETF	271.78	272.0	271.78	272.0	30055.0
2018-11-01 06:35:00	SPY	ETF	272.07	272.14	272.07	272.11	7775.0
2018-11-01 06:40:00	SPY	ETF	272.06	272.14	272.06	272.14	9448.0
2018-11-01 06:45:00	SPY	ETF	272.05	272.14	272.04	272.09	8775.0
2018-11-01 06:50:00	SPY	ETF	272.15	272.26	272.12	272.12	19040.0
2018-11-01 06:55:00	SPY	ETF	272.18	272.18	272.0	272.0	41430.0
2018-11-01 07:00:00	SPY	ETF	272.0	272.06	271.96	272.02	29615.0
2018-11-01 07:05:00	SPY	ETF	271.97	271.99	271.89	271.89	3570.0
2018-11-01 07:10:00	SPY	ETF	271.85	271.89	271.85	271.89	14614.0
2018-11-01 07:15:00	SPY	ETF	271.87	272.12	271.85	272.12	29608.0
2018-11-01 07:20:00	SPY	ETF	272.12	272.12	272.02	272.09	7230.0
2018-11-01 07:25:00	SPY	ETF	272.09	272.09	271.99	272.05	14984.0
2018-11-01 07:30:00	SPY	ETF	272.1	272.2	271.79	271.9	28430.0
2018-11-01 07:35:00	SPY	ETF	271.9	271.98	271.88	271.97	19251.0
2018-11-01 07:40:00	SPY	ETF	271.93	272.03	271.85	271.93	27819.0
2018-11-01 07:45:00	SPY	ETF	271.92	271.92	271.81	271.87	18815.0
2018-11-01 07:50:00	SPY	ETF	271.87	271.99	271.79	271.99	21770.0
2018-11-01 07:55:00	SPY	ETF	271.82	271.85	271.78	271.82	9381.0
2018-11-01 08:00:00	SPY	ETF	270.63	272.1	270.4	271.8	65232.0
2018-11-01 08:05:00	SPY	ETF	271.83	271.98	271.8	271.88	64785.0

> showing 50 of 64,298 rows — these rows as CSV

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