PREVIEW / etf_5min / 2023-06-28

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-28.parquet
  size:    2.0 MB
  rows:    96,182

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-06-28 04:00:00	SPY	ETF	435.52	435.54	435.38	435.38	1477.0
2023-06-28 04:05:00	SPY	ETF	435.37	435.56	435.37	435.46	2770.0
2023-06-28 04:10:00	SPY	ETF	435.38	435.56	435.38	435.5	3516.0
2023-06-28 04:15:00	SPY	ETF	435.56	435.56	435.47	435.47	5179.0
2023-06-28 04:20:00	SPY	ETF	435.7	435.74	435.7	435.74	765.0
2023-06-28 04:25:00	SPY	ETF	435.71	435.71	435.5	435.54	653.0
2023-06-28 04:30:00	SPY	ETF	435.51	435.56	435.39	435.39	1823.0
2023-06-28 04:35:00	SPY	ETF	435.31	435.31	435.14	435.14	2186.0
2023-06-28 04:40:00	SPY	ETF	435.2	435.23	435.12	435.17	1888.0
2023-06-28 04:45:00	SPY	ETF	435.2	435.2	435.12	435.14	1979.0
2023-06-28 04:50:00	SPY	ETF	435.09	435.2	435.09	435.2	1490.0
2023-06-28 04:55:00	SPY	ETF	435.16	435.21	435.16	435.2	800.0
2023-06-28 05:00:00	SPY	ETF	435.2	435.23	435.13	435.19	1583.0
2023-06-28 05:05:00	SPY	ETF	435.18	435.29	435.18	435.26	1388.0
2023-06-28 05:10:00	SPY	ETF	435.29	435.29	435.29	435.29	252.0
2023-06-28 05:15:00	SPY	ETF	435.2	435.3	435.2	435.2	1025.0
2023-06-28 05:20:00	SPY	ETF	435.35	435.35	435.3	435.3	1958.0
2023-06-28 05:25:00	SPY	ETF	435.28	435.32	435.27	435.32	2080.0
2023-06-28 05:30:00	SPY	ETF	435.27	435.27	435.27	435.27	150.0
2023-06-28 05:35:00	SPY	ETF	435.39	435.47	435.39	435.44	1800.0
2023-06-28 05:40:00	SPY	ETF	435.38	435.42	435.35	435.42	727.0
2023-06-28 05:45:00	SPY	ETF	435.33	435.33	435.33	435.33	746.0
2023-06-28 05:50:00	SPY	ETF	435.31	435.31	435.23	435.23	2375.0
2023-06-28 05:55:00	SPY	ETF	435.3	435.39	435.3	435.39	400.0
2023-06-28 06:00:00	SPY	ETF	435.41	435.47	435.38	435.43	2094.0
2023-06-28 06:05:00	SPY	ETF	435.46	435.57	435.46	435.55	1714.0
2023-06-28 06:10:00	SPY	ETF	435.5	435.56	435.5	435.55	1140.0
2023-06-28 06:15:00	SPY	ETF	435.61	435.64	435.56	435.64	914.0
2023-06-28 06:20:00	SPY	ETF	435.65	435.65	435.64	435.64	1200.0
2023-06-28 06:25:00	SPY	ETF	435.62	435.77	435.62	435.73	1465.0
2023-06-28 06:30:00	SPY	ETF	435.75	435.79	435.72	435.79	733.0
2023-06-28 06:35:00	SPY	ETF	435.78	435.78	435.6	435.61	1300.0
2023-06-28 06:40:00	SPY	ETF	435.56	435.56	435.48	435.48	1409.0
2023-06-28 06:45:00	SPY	ETF	435.51	435.51	435.51	435.51	200.0
2023-06-28 06:50:00	SPY	ETF	435.62	435.65	435.62	435.65	894.0
2023-06-28 06:55:00	SPY	ETF	435.57	435.64	435.57	435.64	822.0
2023-06-28 07:00:00	SPY	ETF	435.66	435.99	435.66	435.85	3373.0
2023-06-28 07:05:00	SPY	ETF	435.8	435.95	435.8	435.85	7112.0
2023-06-28 07:10:00	SPY	ETF	435.93	435.98	435.91	435.98	4519.0
2023-06-28 07:15:00	SPY	ETF	435.99	436.08	435.97	436.04	8322.0
2023-06-28 07:20:00	SPY	ETF	436.0	436.0	435.94	435.96	14450.0
2023-06-28 07:25:00	SPY	ETF	435.95	435.95	435.93	435.93	4607.0
2023-06-28 07:30:00	SPY	ETF	435.86	435.86	435.77	435.8	9022.0
2023-06-28 07:35:00	SPY	ETF	435.82	435.85	435.72	435.73	2348.0
2023-06-28 07:40:00	SPY	ETF	435.82	435.82	435.7	435.71	16312.0
2023-06-28 07:45:00	SPY	ETF	435.65	435.68	435.64	435.68	2401.0
2023-06-28 07:50:00	SPY	ETF	435.65	435.65	435.49	435.59	5616.0
2023-06-28 07:55:00	SPY	ETF	435.53	435.59	435.43	435.43	4926.0
2023-06-28 08:00:00	SPY	ETF	435.6611	436.0496	435.14	435.21	109394.0
2023-06-28 08:05:00	SPY	ETF	435.26	435.49	435.22	435.43	71236.0

> showing 50 of 96,182 rows — these rows as CSV

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