PREVIEW / etf_5min / 2023-08-04

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-08-04.parquet
  size:    2.0 MB
  rows:    97,807

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
2023-08-04 04:00:00	SPY	ETF	450.86	451.38	450.86	451.38	22471.0
2023-08-04 04:05:00	SPY	ETF	451.39	451.49	451.34	451.48	9400.0
2023-08-04 04:10:00	SPY	ETF	451.46	451.51	451.39	451.44	2378.0
2023-08-04 04:15:00	SPY	ETF	451.46	451.46	451.35	451.41	3701.0
2023-08-04 04:20:00	SPY	ETF	451.38	451.38	451.14	451.19	8950.0
2023-08-04 04:25:00	SPY	ETF	451.19	451.23	451.0	451.0	2853.0
2023-08-04 04:30:00	SPY	ETF	450.98	450.98	450.7	450.7	4737.0
2023-08-04 04:35:00	SPY	ETF	450.71	450.8	450.55	450.55	4299.0
2023-08-04 04:40:00	SPY	ETF	450.71	450.75	450.61	450.61	1222.0
2023-08-04 04:45:00	SPY	ETF	450.84	450.84	450.72	450.72	362.0
2023-08-04 04:55:00	SPY	ETF	450.7	450.7	450.66	450.66	300.0
2023-08-04 05:00:00	SPY	ETF	450.73	450.85	450.73	450.85	1128.0
2023-08-04 05:05:00	SPY	ETF	450.76	450.76	450.75	450.75	1595.0
2023-08-04 05:15:00	SPY	ETF	450.97	451.14	450.96	451.09	4500.0
2023-08-04 05:20:00	SPY	ETF	451.09	451.19	451.09	451.17	1321.0
2023-08-04 05:25:00	SPY	ETF	451.15	451.27	451.15	451.27	797.0
2023-08-04 05:30:00	SPY	ETF	451.18	451.18	450.78	450.78	300.0
2023-08-04 05:35:00	SPY	ETF	450.78	450.78	450.76	450.76	600.0
2023-08-04 05:40:00	SPY	ETF	450.91	450.91	450.68	450.68	1778.0
2023-08-04 05:45:00	SPY	ETF	450.69	450.79	450.69	450.79	700.0
2023-08-04 05:55:00	SPY	ETF	450.95	450.95	450.77	450.77	1500.0
2023-08-04 06:00:00	SPY	ETF	450.56	450.61	450.55	450.61	1800.0
2023-08-04 06:05:00	SPY	ETF	450.62	450.62	450.5	450.56	2200.0
2023-08-04 06:15:00	SPY	ETF	450.46	450.54	450.46	450.54	4992.0
2023-08-04 06:20:00	SPY	ETF	450.64	450.64	450.55	450.58	20500.0
2023-08-04 06:25:00	SPY	ETF	450.45	450.59	450.45	450.59	3197.0
2023-08-04 06:30:00	SPY	ETF	450.58	450.63	450.58	450.63	1882.0
2023-08-04 06:35:00	SPY	ETF	450.53	450.53	450.37	450.37	1800.0
2023-08-04 06:40:00	SPY	ETF	450.36	450.42	450.3	450.3	996.0
2023-08-04 06:45:00	SPY	ETF	450.35	450.35	450.14	450.14	6363.0
2023-08-04 06:50:00	SPY	ETF	450.13	450.14	449.98	450.02	5810.0
2023-08-04 06:55:00	SPY	ETF	449.93	449.95	449.88	449.88	2700.0
2023-08-04 07:00:00	SPY	ETF	449.97	449.97	449.84	449.9	8941.0
2023-08-04 07:05:00	SPY	ETF	449.88	449.91	449.75	449.88	67630.0
2023-08-04 07:10:00	SPY	ETF	449.73	449.81	449.68	449.8	10121.0
2023-08-04 07:15:00	SPY	ETF	449.79	449.79	449.57	449.66	6800.0
2023-08-04 07:20:00	SPY	ETF	449.59	449.7	449.59	449.7	4645.0
2023-08-04 07:25:00	SPY	ETF	449.79	449.79	449.47	449.47	16211.0
2023-08-04 07:30:00	SPY	ETF	449.38	449.59	449.37	449.59	5716.0
2023-08-04 07:35:00	SPY	ETF	449.54	449.56	449.3	449.35	7940.0
2023-08-04 07:40:00	SPY	ETF	449.36	449.38	449.23	449.23	6435.0
2023-08-04 07:45:00	SPY	ETF	449.27	449.27	448.95	449.0	21184.0
2023-08-04 07:50:00	SPY	ETF	449.0	449.17	448.9	449.17	9803.0
2023-08-04 07:55:00	SPY	ETF	449.1	449.4	449.1	449.28	11102.0
2023-08-04 08:00:00	SPY	ETF	450.61	451.4104	448.86	449.38	138792.0
2023-08-04 08:05:00	SPY	ETF	449.39	449.5	449.35	449.35	35297.0
2023-08-04 08:10:00	SPY	ETF	449.37	449.41	449.25	449.25	14191.0
2023-08-04 08:15:00	SPY	ETF	449.32	449.39	449.23	449.35	49445.0
2023-08-04 08:20:00	SPY	ETF	449.35	449.83	449.34	449.83	63475.0
2023-08-04 08:25:00	SPY	ETF	449.81	449.87	449.69	449.75	37253.0

> showing 50 of 97,807 rows — these rows as CSV

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