PREVIEW / etf_5min / 2018-05-07

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-05-07.parquet
  size:    1.3 MB
  rows:    56,344

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-05-07 04:05:00	SPY	ETF	266.61	266.61	266.61	266.61	100.0
2018-05-07 04:15:00	SPY	ETF	266.69	266.69	266.69	266.69	304.0
2018-05-07 04:20:00	SPY	ETF	266.7	266.74	266.69	266.69	1104.0
2018-05-07 04:25:00	SPY	ETF	266.71	266.75	266.71	266.75	3500.0
2018-05-07 04:40:00	SPY	ETF	266.84	266.9	266.84	266.9	400.0
2018-05-07 04:45:00	SPY	ETF	266.98	267.0	266.98	267.0	470.0
2018-05-07 04:50:00	SPY	ETF	267.0	267.0	266.95	266.95	2700.0
2018-05-07 04:55:00	SPY	ETF	266.9	266.9	266.85	266.85	844.0
2018-05-07 05:05:00	SPY	ETF	266.9	266.9	266.9	266.9	475.0
2018-05-07 05:15:00	SPY	ETF	266.91	266.91	266.91	266.91	165.0
2018-05-07 05:25:00	SPY	ETF	266.86	266.86	266.86	266.86	114.0
2018-05-07 05:35:00	SPY	ETF	266.81	266.86	266.75	266.86	2300.0
2018-05-07 05:40:00	SPY	ETF	266.95	266.95	266.95	266.95	1500.0
2018-05-07 05:45:00	SPY	ETF	266.98	266.98	266.98	266.98	100.0
2018-05-07 05:55:00	SPY	ETF	266.84	266.86	266.84	266.86	1860.0
2018-05-07 06:00:00	SPY	ETF	266.9	266.9	266.9	266.9	200.0
2018-05-07 06:05:00	SPY	ETF	266.74	266.84	266.74	266.84	400.0
2018-05-07 06:15:00	SPY	ETF	266.89	266.92	266.84	266.84	1450.0
2018-05-07 06:20:00	SPY	ETF	266.76	266.76	266.76	266.76	1000.0
2018-05-07 06:25:00	SPY	ETF	266.77	266.77	266.74	266.74	3225.0
2018-05-07 06:30:00	SPY	ETF	266.77	266.81	266.77	266.8	1300.0
2018-05-07 06:35:00	SPY	ETF	266.81	267.04	266.81	267.0	5851.0
2018-05-07 06:40:00	SPY	ETF	266.99	266.99	266.99	266.99	250.0
2018-05-07 06:45:00	SPY	ETF	266.93	266.95	266.93	266.95	200.0
2018-05-07 06:50:00	SPY	ETF	266.94	267.04	266.94	267.04	22002.0
2018-05-07 06:55:00	SPY	ETF	267.02	267.11	267.02	267.02	7040.0
2018-05-07 07:00:00	SPY	ETF	267.03	267.17	267.03	267.17	26685.0
2018-05-07 07:05:00	SPY	ETF	267.19	267.21	267.09	267.09	11811.0
2018-05-07 07:10:00	SPY	ETF	267.11	267.25	267.11	267.25	23622.0
2018-05-07 07:15:00	SPY	ETF	267.25	267.25	267.09	267.11	14061.0
2018-05-07 07:20:00	SPY	ETF	267.12	267.12	267.05	267.09	27644.0
2018-05-07 07:25:00	SPY	ETF	267.15	267.15	267.11	267.11	6150.0
2018-05-07 07:30:00	SPY	ETF	267.15	267.4	267.15	267.37	24877.0
2018-05-07 07:35:00	SPY	ETF	267.26	267.29	267.18	267.18	14497.0
2018-05-07 07:40:00	SPY	ETF	267.18	267.2	267.09	267.19	10400.0
2018-05-07 07:45:00	SPY	ETF	267.2	267.2	267.0	267.0	20568.0
2018-05-07 07:50:00	SPY	ETF	267.01	267.06	266.93	267.03	12880.0
2018-05-07 07:55:00	SPY	ETF	267.05	267.06	266.99	266.99	15992.0
2018-05-07 08:00:00	SPY	ETF	266.99	267.31	266.6	267.04	97506.0
2018-05-07 08:05:00	SPY	ETF	267.02	267.04	266.98	267.04	8273.0
2018-05-07 08:10:00	SPY	ETF	267.02	267.02	266.9	266.94	18722.0
2018-05-07 08:15:00	SPY	ETF	266.94	266.94	266.85	266.85	41062.0
2018-05-07 08:20:00	SPY	ETF	266.84	266.86	266.79	266.85	28712.0
2018-05-07 08:25:00	SPY	ETF	266.85	266.9	266.83	266.9	4444.0
2018-05-07 08:30:00	SPY	ETF	266.88	266.88	266.83	266.87	9018.0
2018-05-07 08:35:00	SPY	ETF	266.86	266.87	266.82	266.83	15669.0
2018-05-07 08:40:00	SPY	ETF	266.86	266.87	266.83	266.86	10085.0
2018-05-07 08:45:00	SPY	ETF	266.87	266.88	266.78	266.79	45790.0
2018-05-07 08:50:00	SPY	ETF	266.81	266.96	266.76	266.96	27524.0
2018-05-07 08:55:00	SPY	ETF	266.96	267.07	266.96	267.03	43025.0

> showing 50 of 56,344 rows — these rows as CSV

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