PREVIEW / etf_5min / 2019-06-27

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-06-27.parquet
  size:    1.3 MB
  rows:    59,842

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
2019-06-27 04:00:00	SPY	ETF	291.79	291.83	291.79	291.83	2332.0
2019-06-27 04:05:00	SPY	ETF	291.83	291.83	291.8	291.8	845.0
2019-06-27 04:10:00	SPY	ETF	291.67	291.67	291.66	291.67	1712.0
2019-06-27 04:15:00	SPY	ETF	291.67	291.72	291.67	291.72	350.0
2019-06-27 04:20:00	SPY	ETF	291.71	291.77	291.71	291.77	480.0
2019-06-27 04:25:00	SPY	ETF	291.8	291.8	291.8	291.8	200.0
2019-06-27 04:30:00	SPY	ETF	291.82	291.82	291.82	291.82	100.0
2019-06-27 04:35:00	SPY	ETF	291.8	291.8	291.72	291.72	1350.0
2019-06-27 04:40:00	SPY	ETF	291.54	291.54	291.54	291.54	810.0
2019-06-27 04:45:00	SPY	ETF	291.56	291.56	291.56	291.56	100.0
2019-06-27 04:50:00	SPY	ETF	291.56	291.6	291.56	291.6	4070.0
2019-06-27 04:55:00	SPY	ETF	291.64	291.64	291.63	291.63	2253.0
2019-06-27 05:00:00	SPY	ETF	291.61	291.61	291.61	291.61	500.0
2019-06-27 05:05:00	SPY	ETF	291.57	291.57	291.56	291.56	300.0
2019-06-27 05:10:00	SPY	ETF	291.57	291.57	291.57	291.57	260.0
2019-06-27 05:15:00	SPY	ETF	291.61	291.7	291.61	291.7	1268.0
2019-06-27 05:20:00	SPY	ETF	291.69	291.69	291.69	291.69	1204.0
2019-06-27 05:25:00	SPY	ETF	291.8	291.8	291.8	291.8	200.0
2019-06-27 05:35:00	SPY	ETF	291.8	291.8	291.72	291.74	1500.0
2019-06-27 05:40:00	SPY	ETF	291.74	291.74	291.7	291.74	800.0
2019-06-27 05:45:00	SPY	ETF	291.6	292.26	291.53	291.53	38587.0
2019-06-27 05:50:00	SPY	ETF	291.48	291.48	290.98	291.0	10362.0
2019-06-27 05:55:00	SPY	ETF	291.18	291.18	291.02	291.02	2700.0
2019-06-27 06:00:00	SPY	ETF	291.04	291.11	290.45	290.45	15621.0
2019-06-27 06:05:00	SPY	ETF	290.51	290.71	290.51	290.71	16183.0
2019-06-27 06:10:00	SPY	ETF	290.55	290.58	290.51	290.51	1100.0
2019-06-27 06:15:00	SPY	ETF	290.81	290.82	290.81	290.82	395.0
2019-06-27 06:20:00	SPY	ETF	290.82	290.93	290.8	290.93	3848.0
2019-06-27 06:25:00	SPY	ETF	290.92	290.95	290.9	290.94	816.0
2019-06-27 06:30:00	SPY	ETF	290.91	290.91	290.85	290.85	1000.0
2019-06-27 06:35:00	SPY	ETF	290.91	290.96	290.89	290.9	5700.0
2019-06-27 06:45:00	SPY	ETF	290.98	290.98	290.98	290.98	348.0
2019-06-27 06:55:00	SPY	ETF	291.05	291.08	291.05	291.08	2000.0
2019-06-27 07:00:00	SPY	ETF	291.03	291.12	290.97	291.04	10238.0
2019-06-27 07:05:00	SPY	ETF	291.05	291.05	291.04	291.04	500.0
2019-06-27 07:10:00	SPY	ETF	291.04	291.1	290.93	291.0	6605.0
2019-06-27 07:15:00	SPY	ETF	291.0	291.03	290.98	291.0	7500.0
2019-06-27 07:20:00	SPY	ETF	291.0	291.07	290.99	291.07	16620.0
2019-06-27 07:25:00	SPY	ETF	291.04	291.04	290.93	290.93	9147.0
2019-06-27 07:30:00	SPY	ETF	290.9	290.98	290.7	290.7	27128.0
2019-06-27 07:35:00	SPY	ETF	290.8	290.85	290.79	290.83	13410.0
2019-06-27 07:40:00	SPY	ETF	290.83	290.84	290.81	290.81	10300.0
2019-06-27 07:45:00	SPY	ETF	290.82	290.88	290.82	290.86	5340.0
2019-06-27 07:50:00	SPY	ETF	290.81	290.87	290.78	290.78	10900.0
2019-06-27 07:55:00	SPY	ETF	290.87	291.0	290.87	290.92	25745.0
2019-06-27 08:00:00	SPY	ETF	291.0199	292.0	290.82	290.86	46879.0
2019-06-27 08:05:00	SPY	ETF	290.85	290.96	290.84	290.96	23077.0
2019-06-27 08:10:00	SPY	ETF	291.03	291.15	291.03	291.13	41106.0
2019-06-27 08:15:00	SPY	ETF	291.06	291.1	291.04	291.09	25371.0
2019-06-27 08:20:00	SPY	ETF	291.1	291.1301	291.1	291.1301	15590.0

> showing 50 of 59,842 rows — these rows as CSV

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