PREVIEW / etf_5min / 2020-07-20

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-07-20.parquet
  size:    1.6 MB
  rows:    73,394

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-07-20 04:00:00	SPY	ETF	319.92	320.06	319.87	319.87	5853.0
2020-07-20 04:05:00	SPY	ETF	319.9	319.94	319.75	319.75	2636.0
2020-07-20 04:10:00	SPY	ETF	319.8	319.8	319.62	319.69	1151.0
2020-07-20 04:15:00	SPY	ETF	319.69	319.96	319.67	319.88	3338.0
2020-07-20 04:20:00	SPY	ETF	319.87	319.87	319.8	319.8	930.0
2020-07-20 04:25:00	SPY	ETF	319.84	319.89	319.84	319.89	330.0
2020-07-20 04:30:00	SPY	ETF	319.95	319.99	319.78	319.99	1874.0
2020-07-20 04:35:00	SPY	ETF	320.04	320.14	320.04	320.14	991.0
2020-07-20 04:40:00	SPY	ETF	320.26	320.67	320.26	320.67	5910.0
2020-07-20 04:45:00	SPY	ETF	320.77	320.77	320.7	320.75	764.0
2020-07-20 04:50:00	SPY	ETF	320.86	320.87	320.85	320.87	1255.0
2020-07-20 04:55:00	SPY	ETF	320.81	320.91	320.81	320.85	5050.0
2020-07-20 05:00:00	SPY	ETF	321.0	321.27	321.0	321.15	3267.0
2020-07-20 05:05:00	SPY	ETF	321.03	321.05	321.03	321.05	711.0
2020-07-20 05:10:00	SPY	ETF	321.16	321.43	321.16	321.35	8599.0
2020-07-20 05:15:00	SPY	ETF	321.39	321.39	321.01	321.01	88727.0
2020-07-20 05:25:00	SPY	ETF	320.9	320.9	320.9	320.9	130.0
2020-07-20 05:30:00	SPY	ETF	320.97	320.97	320.81	320.83	401.0
2020-07-20 05:35:00	SPY	ETF	320.8	320.91	320.8	320.89	500.0
2020-07-20 05:40:00	SPY	ETF	320.98	321.03	320.95	320.95	390.0
2020-07-20 05:45:00	SPY	ETF	321.0	321.06	320.98	321.03	950.0
2020-07-20 05:50:00	SPY	ETF	321.03	321.08	321.02	321.06	1850.0
2020-07-20 05:55:00	SPY	ETF	321.02	321.06	320.88	320.88	825.0
2020-07-20 06:00:00	SPY	ETF	320.96	321.03	320.96	321.03	944.0
2020-07-20 06:05:00	SPY	ETF	320.88	320.9	320.83	320.84	11112.0
2020-07-20 06:10:00	SPY	ETF	320.91	320.91	320.91	320.91	490.0
2020-07-20 06:15:00	SPY	ETF	320.83	320.84	320.71	320.74	1765.0
2020-07-20 06:20:00	SPY	ETF	320.73	320.78	320.73	320.76	2200.0
2020-07-20 06:25:00	SPY	ETF	320.91	320.91	320.58	320.58	4211.0
2020-07-20 06:30:00	SPY	ETF	320.53	320.64	320.46	320.64	4674.0
2020-07-20 06:35:00	SPY	ETF	320.61	320.61	320.49	320.59	3955.0
2020-07-20 06:40:00	SPY	ETF	320.62	320.62	320.61	320.61	620.0
2020-07-20 06:45:00	SPY	ETF	320.64	320.82	320.64	320.74	2755.0
2020-07-20 06:50:00	SPY	ETF	320.72	320.72	320.62	320.62	5654.0
2020-07-20 06:55:00	SPY	ETF	320.59	320.79	320.59	320.67	3379.0
2020-07-20 07:00:00	SPY	ETF	320.68	320.86	320.68	320.78	35697.0
2020-07-20 07:05:00	SPY	ETF	320.88	320.93	320.83	320.89	14594.0
2020-07-20 07:10:00	SPY	ETF	320.89	320.91	320.73	320.73	23343.0
2020-07-20 07:15:00	SPY	ETF	320.7	320.86	320.7	320.86	22101.0
2020-07-20 07:20:00	SPY	ETF	320.9	321.17	320.9	321.07	9886.0
2020-07-20 07:25:00	SPY	ETF	321.15	321.2	321.13	321.13	7022.0
2020-07-20 07:30:00	SPY	ETF	321.06	321.06	320.93	320.95	4280.0
2020-07-20 07:35:00	SPY	ETF	321.05	321.05	320.95	320.95	2145.0
2020-07-20 07:40:00	SPY	ETF	321.0	321.0	320.92	320.99	7521.0
2020-07-20 07:45:00	SPY	ETF	321.1	321.21	320.96	321.21	16953.0
2020-07-20 07:50:00	SPY	ETF	321.25	321.48	321.16	321.19	24644.0
2020-07-20 07:55:00	SPY	ETF	321.2	321.27	321.16	321.24	16248.0
2020-07-20 08:00:00	SPY	ETF	321.2	321.26	320.0	321.1	85857.0
2020-07-20 08:05:00	SPY	ETF	321.09	321.35	320.91	320.92	109887.0
2020-07-20 08:10:00	SPY	ETF	320.9	321.0	320.89	320.96	18738.0

> showing 50 of 73,394 rows — these rows as CSV

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