PREVIEW / etf_5min / 2018-04-04

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-04.parquet
  size:    1.4 MB
  rows:    60,977

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-04-04 04:00:00	SPY	ETF	257.98	258.12	257.75	257.75	32965.0
2018-04-04 04:05:00	SPY	ETF	257.73	257.83	257.23	257.23	14850.0
2018-04-04 04:10:00	SPY	ETF	257.33	257.43	256.39	257.17	34121.0
2018-04-04 04:15:00	SPY	ETF	257.11	257.57	257.02	257.53	21010.0
2018-04-04 04:20:00	SPY	ETF	257.53	257.53	256.91	257.0	7701.0
2018-04-04 04:25:00	SPY	ETF	257.18	257.18	256.95	257.18	7199.0
2018-04-04 04:30:00	SPY	ETF	257.22	257.22	256.68	256.73	4560.0
2018-04-04 04:35:00	SPY	ETF	256.69	257.25	256.69	257.2	11925.0
2018-04-04 04:40:00	SPY	ETF	257.31	257.33	257.18	257.2	7925.0
2018-04-04 04:45:00	SPY	ETF	256.9	256.94	256.82	256.94	6002.0
2018-04-04 04:50:00	SPY	ETF	257.0	257.2	257.0	257.16	5280.0
2018-04-04 04:55:00	SPY	ETF	257.12	257.28	257.12	257.24	2025.0
2018-04-04 05:00:00	SPY	ETF	257.2	257.2	257.18	257.2	1069.0
2018-04-04 05:05:00	SPY	ETF	257.05	257.09	256.88	257.0	7294.0
2018-04-04 05:10:00	SPY	ETF	256.95	257.09	256.93	257.09	4840.0
2018-04-04 05:15:00	SPY	ETF	257.06	257.1	256.8	256.8	6740.0
2018-04-04 05:20:00	SPY	ETF	256.8	257.15	256.75	257.0	18360.0
2018-04-04 05:25:00	SPY	ETF	257.03	257.15	256.93	257.06	3940.0
2018-04-04 05:30:00	SPY	ETF	257.1	257.11	256.95	256.95	3080.0
2018-04-04 05:35:00	SPY	ETF	256.97	257.21	256.97	257.21	1200.0
2018-04-04 05:40:00	SPY	ETF	257.1	257.23	257.1	257.19	3070.0
2018-04-04 05:45:00	SPY	ETF	256.97	257.11	256.94	256.94	970.0
2018-04-04 05:50:00	SPY	ETF	257.0	257.06	256.9	256.92	3262.0
2018-04-04 05:55:00	SPY	ETF	256.89	257.07	256.89	257.07	3440.0
2018-04-04 06:00:00	SPY	ETF	257.07	257.07	256.97	256.98	2250.0
2018-04-04 06:05:00	SPY	ETF	256.99	256.99	256.81	256.82	30709.0
2018-04-04 06:10:00	SPY	ETF	256.84	256.9	256.25	256.3	6658.0
2018-04-04 06:15:00	SPY	ETF	256.2	256.2	255.57	255.57	8647.0
2018-04-04 06:20:00	SPY	ETF	255.5	256.05	255.39	255.97	11824.0
2018-04-04 06:25:00	SPY	ETF	256.08	256.12	255.87	255.87	3340.0
2018-04-04 06:30:00	SPY	ETF	255.85	255.85	255.55	255.59	37036.0
2018-04-04 06:35:00	SPY	ETF	255.58	256.95	255.58	256.25	26515.0
2018-04-04 06:40:00	SPY	ETF	256.26	256.26	256.0	256.19	13978.0
2018-04-04 06:45:00	SPY	ETF	256.19	256.24	256.0	256.06	21716.0
2018-04-04 06:50:00	SPY	ETF	256.16	256.34	256.16	256.3	7089.0
2018-04-04 06:55:00	SPY	ETF	256.32	256.39	256.24	256.26	47445.0
2018-04-04 07:00:00	SPY	ETF	256.32	256.72	256.3	256.66	68099.0
2018-04-04 07:05:00	SPY	ETF	256.67	256.82	256.55	256.6	74085.0
2018-04-04 07:10:00	SPY	ETF	256.59	256.8	256.54	256.54	96880.0
2018-04-04 07:15:00	SPY	ETF	256.52	256.88	256.45	256.53	41968.0
2018-04-04 07:20:00	SPY	ETF	256.53	256.87	256.46	256.85	48604.0
2018-04-04 07:25:00	SPY	ETF	256.85	257.06	256.7	256.96	41116.0
2018-04-04 07:30:00	SPY	ETF	256.97	257.24	256.91	257.2	75801.0
2018-04-04 07:35:00	SPY	ETF	257.2	257.21	257.02	257.06	25602.0
2018-04-04 07:40:00	SPY	ETF	257.06	257.13	256.75	256.8	155325.0
2018-04-04 07:45:00	SPY	ETF	256.81	257.17	256.8	256.89	213572.0
2018-04-04 07:50:00	SPY	ETF	256.89	256.94	256.68	256.73	81192.0
2018-04-04 07:55:00	SPY	ETF	256.72	257.09	256.72	256.95	196400.0
2018-04-04 08:00:00	SPY	ETF	256.71	259.3	256.29	256.29	162310.0
2018-04-04 08:05:00	SPY	ETF	256.9	257.3	256.9	257.26	34415.0

> showing 50 of 60,977 rows — these rows as CSV

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