PREVIEW / etf_5min / 2018-12-31

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-12-31.parquet
  size:    1.8 MB
  rows:    74,765

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-31 04:00:00	SPY	ETF	249.62	249.72	249.6	249.7	14613.0
2018-12-31 04:05:00	SPY	ETF	249.77	249.77	249.65	249.67	2177.0
2018-12-31 04:10:00	SPY	ETF	249.64	249.64	249.57	249.59	2055.0
2018-12-31 04:15:00	SPY	ETF	249.6	249.64	249.6	249.64	286.0
2018-12-31 04:20:00	SPY	ETF	249.62	249.62	249.62	249.62	200.0
2018-12-31 04:25:00	SPY	ETF	249.62	249.76	249.62	249.68	777.0
2018-12-31 04:30:00	SPY	ETF	249.65	249.74	249.65	249.74	721.0
2018-12-31 04:35:00	SPY	ETF	249.74	249.85	249.7	249.7	3254.0
2018-12-31 04:40:00	SPY	ETF	249.78	249.84	249.78	249.81	1388.0
2018-12-31 04:45:00	SPY	ETF	249.78	249.9	249.78	249.9	1642.0
2018-12-31 04:50:00	SPY	ETF	249.82	249.85	249.79	249.79	2079.0
2018-12-31 04:55:00	SPY	ETF	249.82	249.85	249.82	249.85	17658.0
2018-12-31 05:00:00	SPY	ETF	249.86	249.95	249.86	249.89	18345.0
2018-12-31 05:05:00	SPY	ETF	249.9	249.9	249.9	249.9	1000.0
2018-12-31 05:10:00	SPY	ETF	249.86	249.86	249.82	249.82	369.0
2018-12-31 05:15:00	SPY	ETF	249.8	249.84	249.8	249.82	1800.0
2018-12-31 05:20:00	SPY	ETF	249.83	249.83	249.83	249.83	100.0
2018-12-31 05:25:00	SPY	ETF	249.82	249.82	249.68	249.68	2894.0
2018-12-31 05:30:00	SPY	ETF	249.66	249.66	249.62	249.62	1047.0
2018-12-31 05:35:00	SPY	ETF	249.67	249.8	249.67	249.8	2314.0
2018-12-31 05:40:00	SPY	ETF	249.76	249.76	249.6	249.6	9329.0
2018-12-31 05:45:00	SPY	ETF	249.6	249.7	249.6	249.61	2446.0
2018-12-31 05:50:00	SPY	ETF	249.63	249.76	249.63	249.76	1807.0
2018-12-31 05:55:00	SPY	ETF	249.77	249.82	249.77	249.82	2776.0
2018-12-31 06:00:00	SPY	ETF	249.78	249.78	249.75	249.77	2134.0
2018-12-31 06:05:00	SPY	ETF	249.83	249.87	249.74	249.74	2418.0
2018-12-31 06:10:00	SPY	ETF	249.7	249.7	249.7	249.7	173.0
2018-12-31 06:20:00	SPY	ETF	249.73	249.79	249.73	249.79	550.0
2018-12-31 06:25:00	SPY	ETF	249.74	249.84	249.74	249.79	2200.0
2018-12-31 06:30:00	SPY	ETF	249.76	249.95	249.75	249.95	4342.0
2018-12-31 06:35:00	SPY	ETF	249.78	249.78	249.78	249.78	900.0
2018-12-31 06:40:00	SPY	ETF	249.86	249.86	249.86	249.86	900.0
2018-12-31 06:45:00	SPY	ETF	249.83	249.9	249.83	249.88	9340.0
2018-12-31 06:50:00	SPY	ETF	249.84	249.9	249.84	249.9	11800.0
2018-12-31 06:55:00	SPY	ETF	249.93	249.93	249.86	249.87	10600.0
2018-12-31 07:00:00	SPY	ETF	249.86	250.02	249.8	250.0	37593.0
2018-12-31 07:05:00	SPY	ETF	250.03	250.4	250.03	250.29	8586.0
2018-12-31 07:10:00	SPY	ETF	250.32	250.32	250.24	250.3	6199.0
2018-12-31 07:15:00	SPY	ETF	250.29	250.3	250.22	250.3	9622.0
2018-12-31 07:20:00	SPY	ETF	250.29	250.29	250.15	250.17	33618.0
2018-12-31 07:25:00	SPY	ETF	250.19	250.21	250.11	250.13	7074.0
2018-12-31 07:30:00	SPY	ETF	250.19	250.2	250.11	250.12	13783.0
2018-12-31 07:35:00	SPY	ETF	250.15	250.18	250.13	250.14	5216.0
2018-12-31 07:40:00	SPY	ETF	250.14	250.15	250.11	250.13	3817.0
2018-12-31 07:45:00	SPY	ETF	250.17	250.27	250.17	250.27	11415.0
2018-12-31 07:50:00	SPY	ETF	250.29	250.33	250.25	250.32	12082.0
2018-12-31 07:55:00	SPY	ETF	250.26	250.27	250.15	250.25	62274.0
2018-12-31 08:00:00	SPY	ETF	247.75	250.35	247.75	250.12	37373.0
2018-12-31 08:05:00	SPY	ETF	250.12	250.13	249.62	249.75	83190.0
2018-12-31 08:10:00	SPY	ETF	249.77	249.81	249.54	249.63	84752.0

> showing 50 of 74,765 rows — these rows as CSV

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