PREVIEW / etf_5min / 2020-05-07

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-05-07.parquet
  size:    1.6 MB
  rows:    74,054

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
2020-05-07 04:00:00	SPY	ETF	286.7	286.96	286.7	286.72	19283.0
2020-05-07 04:05:00	SPY	ETF	286.73	286.9	286.71	286.9	11886.0
2020-05-07 04:10:00	SPY	ETF	286.87	286.9	286.72	286.9	6884.0
2020-05-07 04:15:00	SPY	ETF	287.0	287.1	286.96	287.04	4711.0
2020-05-07 04:20:00	SPY	ETF	286.94	287.05	286.94	287.05	7316.0
2020-05-07 04:25:00	SPY	ETF	286.9	287.13	286.89	287.13	9410.0
2020-05-07 04:30:00	SPY	ETF	287.11	287.32	287.11	287.25	9055.0
2020-05-07 04:35:00	SPY	ETF	287.16	287.25	287.02	287.02	17286.0
2020-05-07 04:40:00	SPY	ETF	286.95	287.02	286.91	286.93	17073.0
2020-05-07 04:45:00	SPY	ETF	287.18	287.35	287.18	287.3	8423.0
2020-05-07 04:50:00	SPY	ETF	287.4	287.4	287.35	287.35	1839.0
2020-05-07 04:55:00	SPY	ETF	287.24	287.4	287.22	287.28	5921.0
2020-05-07 05:00:00	SPY	ETF	287.31	287.36	287.29	287.29	4433.0
2020-05-07 05:05:00	SPY	ETF	287.22	287.32	287.19	287.28	11045.0
2020-05-07 05:10:00	SPY	ETF	287.32	287.4	287.32	287.37	8059.0
2020-05-07 05:15:00	SPY	ETF	287.36	287.45	287.31	287.45	11414.0
2020-05-07 05:20:00	SPY	ETF	287.45	287.47	287.36	287.36	2478.0
2020-05-07 05:25:00	SPY	ETF	287.46	287.49	287.46	287.48	2087.0
2020-05-07 05:30:00	SPY	ETF	287.5	287.56	287.47	287.55	4593.0
2020-05-07 05:35:00	SPY	ETF	287.55	287.8	287.54	287.8	5841.0
2020-05-07 05:40:00	SPY	ETF	287.8	288.11	287.8	288.03	11664.0
2020-05-07 05:45:00	SPY	ETF	288.02	288.09	287.78	287.83	19604.0
2020-05-07 05:50:00	SPY	ETF	287.87	288.05	287.87	287.95	10555.0
2020-05-07 05:55:00	SPY	ETF	287.96	288.06	287.84	287.84	8252.0
2020-05-07 06:00:00	SPY	ETF	287.87	287.87	287.59	287.64	10073.0
2020-05-07 06:05:00	SPY	ETF	287.6	287.84	287.56	287.84	9694.0
2020-05-07 06:10:00	SPY	ETF	287.88	288.18	287.88	288.18	26292.0
2020-05-07 06:15:00	SPY	ETF	288.15	288.19	287.78	287.89	24692.0
2020-05-07 06:20:00	SPY	ETF	287.87	287.9	287.72	287.81	13900.0
2020-05-07 06:25:00	SPY	ETF	287.84	287.9	287.67	287.86	9820.0
2020-05-07 06:30:00	SPY	ETF	287.9	287.9	287.69	287.79	12398.0
2020-05-07 06:35:00	SPY	ETF	287.76	287.76	287.69	287.73	6382.0
2020-05-07 06:40:00	SPY	ETF	287.71	287.72	287.57	287.67	7420.0
2020-05-07 06:45:00	SPY	ETF	287.62	287.63	287.36	287.42	16824.0
2020-05-07 06:50:00	SPY	ETF	287.37	287.47	287.36	287.46	18106.0
2020-05-07 06:55:00	SPY	ETF	287.42	287.5	287.42	287.5	12355.0
2020-05-07 07:00:00	SPY	ETF	287.49	287.5	287.31	287.32	72848.0
2020-05-07 07:05:00	SPY	ETF	287.33	287.5	287.29	287.37	41697.0
2020-05-07 07:10:00	SPY	ETF	287.48	287.5	287.36	287.5	42114.0
2020-05-07 07:15:00	SPY	ETF	287.5	287.66	287.44	287.52	117034.0
2020-05-07 07:20:00	SPY	ETF	287.52	287.6	287.4	287.45	81505.0
2020-05-07 07:25:00	SPY	ETF	287.43	287.43	287.16	287.31	14754.0
2020-05-07 07:30:00	SPY	ETF	287.29	287.66	287.24	287.61	35928.0
2020-05-07 07:35:00	SPY	ETF	287.6	287.66	287.58	287.64	51217.0
2020-05-07 07:40:00	SPY	ETF	287.64	287.96	287.6	287.95	42720.0
2020-05-07 07:45:00	SPY	ETF	287.91	287.99	287.88	287.89	36969.0
2020-05-07 07:50:00	SPY	ETF	287.89	287.93	287.7	287.88	21207.0
2020-05-07 07:55:00	SPY	ETF	287.89	288.4	287.86	288.27	91264.0
2020-05-07 08:00:00	SPY	ETF	287.8999	288.3599	285.18	288.01	249665.0
2020-05-07 08:05:00	SPY	ETF	288.0102	288.05	287.79	287.81	45110.0

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

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