PREVIEW / etf_5min / 2018-12-19

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-12-19.parquet
  size:    1.7 MB
  rows:    69,890

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-12-19 04:00:00	SPY	ETF	255.46	255.63	255.46	255.63	2366.0
2018-12-19 04:05:00	SPY	ETF	255.65	255.68	255.65	255.68	3900.0
2018-12-19 04:10:00	SPY	ETF	255.64	255.72	255.63	255.72	9956.0
2018-12-19 04:15:00	SPY	ETF	255.73	255.82	255.73	255.8	6859.0
2018-12-19 04:25:00	SPY	ETF	255.73	255.77	255.73	255.76	1600.0
2018-12-19 04:30:00	SPY	ETF	255.7	255.7	255.65	255.65	3557.0
2018-12-19 04:35:00	SPY	ETF	255.65	255.76	255.62	255.76	9869.0
2018-12-19 04:40:00	SPY	ETF	255.79	255.96	255.78	255.89	5826.0
2018-12-19 04:45:00	SPY	ETF	255.9	255.94	255.77	255.94	3845.0
2018-12-19 04:50:00	SPY	ETF	255.85	255.87	255.82	255.87	1438.0
2018-12-19 04:55:00	SPY	ETF	255.95	255.97	255.94	255.97	3694.0
2018-12-19 05:00:00	SPY	ETF	255.93	256.05	255.93	256.05	6519.0
2018-12-19 05:05:00	SPY	ETF	256.05	256.13	256.05	256.13	8008.0
2018-12-19 05:10:00	SPY	ETF	256.13	256.2	256.12	256.15	11288.0
2018-12-19 05:15:00	SPY	ETF	256.25	256.37	256.25	256.37	2644.0
2018-12-19 05:20:00	SPY	ETF	256.28	256.32	256.16	256.32	15745.0
2018-12-19 05:25:00	SPY	ETF	256.28	256.29	256.21	256.21	6064.0
2018-12-19 05:30:00	SPY	ETF	256.19	256.19	256.13	256.13	2342.0
2018-12-19 05:35:00	SPY	ETF	256.13	256.23	256.1	256.17	6414.0
2018-12-19 05:40:00	SPY	ETF	256.16	256.17	256.14	256.14	819.0
2018-12-19 05:45:00	SPY	ETF	256.1	256.2	256.04	256.19	8843.0
2018-12-19 05:50:00	SPY	ETF	256.14	256.14	256.07	256.07	2169.0
2018-12-19 05:55:00	SPY	ETF	256.06	256.14	256.03	256.14	3924.0
2018-12-19 06:00:00	SPY	ETF	256.11	256.11	256.05	256.06	4538.0
2018-12-19 06:05:00	SPY	ETF	256.05	256.07	256.0	256.02	23517.0
2018-12-19 06:10:00	SPY	ETF	256.02	256.06	256.02	256.06	2159.0
2018-12-19 06:15:00	SPY	ETF	256.0	256.09	255.98	256.07	51465.0
2018-12-19 06:20:00	SPY	ETF	256.08	256.17	256.08	256.16	2834.0
2018-12-19 06:25:00	SPY	ETF	256.19	256.22	256.04	256.04	6807.0
2018-12-19 06:30:00	SPY	ETF	256.09	256.09	256.05	256.06	12269.0
2018-12-19 06:35:00	SPY	ETF	256.09	256.09	256.0	256.01	2139.0
2018-12-19 06:40:00	SPY	ETF	256.02	256.02	256.0	256.0	1150.0
2018-12-19 06:45:00	SPY	ETF	256.0	256.0	255.95	255.98	2119.0
2018-12-19 06:50:00	SPY	ETF	255.98	256.13	255.98	256.13	14225.0
2018-12-19 06:55:00	SPY	ETF	256.07	256.13	256.05	256.13	3395.0
2018-12-19 07:00:00	SPY	ETF	256.13	256.32	256.1	256.28	58989.0
2018-12-19 07:05:00	SPY	ETF	256.29	256.33	256.24	256.25	12415.0
2018-12-19 07:10:00	SPY	ETF	256.26	256.51	256.25	256.46	37641.0
2018-12-19 07:15:00	SPY	ETF	256.45	256.46	256.3	256.38	19861.0
2018-12-19 07:20:00	SPY	ETF	256.3	256.3	256.23	256.26	34107.0
2018-12-19 07:25:00	SPY	ETF	256.23	256.3	256.23	256.27	29521.0
2018-12-19 07:30:00	SPY	ETF	256.25	256.25	256.16	256.2	20861.0
2018-12-19 07:35:00	SPY	ETF	256.2	256.26	256.17	256.18	18863.0
2018-12-19 07:40:00	SPY	ETF	256.21	256.23	256.11	256.11	44828.0
2018-12-19 07:45:00	SPY	ETF	256.09	256.15	256.09	256.14	16072.0
2018-12-19 07:50:00	SPY	ETF	256.14	256.24	256.13	256.21	63469.0
2018-12-19 07:55:00	SPY	ETF	256.2	256.2	256.1	256.2	55812.0
2018-12-19 08:00:00	SPY	ETF	256.18	256.45	255.38	255.9	73519.0
2018-12-19 08:05:00	SPY	ETF	255.9	255.9	255.62	255.65	50414.0
2018-12-19 08:10:00	SPY	ETF	255.68	255.74	255.6	255.63	28301.0

> showing 50 of 69,890 rows — these rows as CSV

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