PREVIEW / etf_5min / 2018-05-17

all etf 5-min files

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

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-17 04:00:00	SPY	ETF	271.95	271.95	271.72	271.72	1668.0
2018-05-17 04:05:00	SPY	ETF	271.75	271.79	271.75	271.76	1000.0
2018-05-17 04:15:00	SPY	ETF	271.79	271.79	271.79	271.79	541.0
2018-05-17 04:25:00	SPY	ETF	271.84	271.85	271.84	271.85	600.0
2018-05-17 04:30:00	SPY	ETF	271.9	271.9	271.9	271.9	200.0
2018-05-17 04:35:00	SPY	ETF	271.8	271.8	271.8	271.8	300.0
2018-05-17 04:45:00	SPY	ETF	271.76	271.76	271.65	271.65	400.0
2018-05-17 05:00:00	SPY	ETF	271.78	271.78	271.78	271.78	125.0
2018-05-17 05:10:00	SPY	ETF	271.77	271.77	271.77	271.77	300.0
2018-05-17 05:20:00	SPY	ETF	271.85	271.85	271.85	271.85	1200.0
2018-05-17 05:25:00	SPY	ETF	271.9	271.9	271.9	271.9	200.0
2018-05-17 05:30:00	SPY	ETF	271.96	271.96	271.96	271.96	100.0
2018-05-17 05:40:00	SPY	ETF	272.01	272.01	271.96	271.96	1400.0
2018-05-17 05:45:00	SPY	ETF	271.91	271.91	271.91	271.91	1300.0
2018-05-17 05:50:00	SPY	ETF	271.85	271.85	271.85	271.85	300.0
2018-05-17 05:55:00	SPY	ETF	271.91	271.91	271.91	271.91	1200.0
2018-05-17 06:10:00	SPY	ETF	272.06	272.06	272.06	272.06	2500.0
2018-05-17 06:20:00	SPY	ETF	271.9	271.9	271.9	271.9	1100.0
2018-05-17 06:25:00	SPY	ETF	271.85	271.85	271.8	271.8	1350.0
2018-05-17 06:30:00	SPY	ETF	271.89	271.9	271.89	271.9	3000.0
2018-05-17 06:35:00	SPY	ETF	271.9	271.9	271.9	271.9	100.0
2018-05-17 06:40:00	SPY	ETF	271.9	271.9	271.9	271.9	1000.0
2018-05-17 06:45:00	SPY	ETF	271.83	271.87	271.8	271.85	8000.0
2018-05-17 06:50:00	SPY	ETF	271.87	271.89	271.85	271.85	72900.0
2018-05-17 06:55:00	SPY	ETF	271.84	271.85	271.8	271.8	2300.0
2018-05-17 07:00:00	SPY	ETF	271.78	271.78	271.71	271.77	8658.0
2018-05-17 07:05:00	SPY	ETF	271.77	271.77	271.71	271.72	2000.0
2018-05-17 07:10:00	SPY	ETF	271.75	271.79	271.75	271.79	28000.0
2018-05-17 07:15:00	SPY	ETF	271.8	271.8	271.78	271.8	13000.0
2018-05-17 07:20:00	SPY	ETF	271.8	271.85	271.8	271.85	8875.0
2018-05-17 07:25:00	SPY	ETF	271.85	271.87	271.85	271.85	36050.0
2018-05-17 07:30:00	SPY	ETF	271.85	271.93	271.83	271.92	31261.0
2018-05-17 07:35:00	SPY	ETF	271.92	271.92	271.88	271.88	3900.0
2018-05-17 07:40:00	SPY	ETF	271.9	271.95	271.9	271.95	15300.0
2018-05-17 07:45:00	SPY	ETF	271.95	271.96	271.88	271.95	29728.0
2018-05-17 07:50:00	SPY	ETF	271.92	271.92	271.8	271.8	22658.0
2018-05-17 07:55:00	SPY	ETF	271.79	271.83	271.75	271.76	1620.0
2018-05-17 08:00:00	SPY	ETF	271.75	272.37	271.71	271.72	30578.0
2018-05-17 08:05:00	SPY	ETF	271.74	271.81	271.71	271.77	20075.0
2018-05-17 08:10:00	SPY	ETF	271.77	271.83	271.77	271.8	30066.0
2018-05-17 08:15:00	SPY	ETF	271.82	271.89	271.82	271.84	18868.0
2018-05-17 08:20:00	SPY	ETF	271.83	271.84	271.7	271.71	62663.0
2018-05-17 08:25:00	SPY	ETF	271.75	271.81	271.74	271.81	7417.0
2018-05-17 08:30:00	SPY	ETF	271.82	271.82	271.64	271.68	24082.0
2018-05-17 08:35:00	SPY	ETF	271.66	271.67	271.54	271.65	126853.0
2018-05-17 08:40:00	SPY	ETF	271.66	271.76	271.66	271.73	42118.0
2018-05-17 08:45:00	SPY	ETF	271.73	271.74	271.62	271.62	34212.0
2018-05-17 08:50:00	SPY	ETF	271.65	271.8	271.65	271.78	44366.0
2018-05-17 08:55:00	SPY	ETF	271.8	271.85	271.8	271.84	5585.0
2018-05-17 09:00:00	SPY	ETF	271.85	271.96	271.83	271.96	29578.0

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

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