PREVIEW / etf_5min / 2023-03-28

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-03-28.parquet
  size:    1.9 MB
  rows:    92,219

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-03-28 04:00:00	SPY	ETF	396.65	396.65	396.4	396.46	12686.0
2023-03-28 04:05:00	SPY	ETF	396.45	396.7	396.4	396.61	3308.0
2023-03-28 04:10:00	SPY	ETF	396.67	396.7	396.6	396.65	6000.0
2023-03-28 04:15:00	SPY	ETF	396.54	396.61	396.51	396.57	896.0
2023-03-28 04:20:00	SPY	ETF	396.43	396.65	396.32	396.53	2147.0
2023-03-28 04:25:00	SPY	ETF	396.49	396.55	396.46	396.46	1720.0
2023-03-28 04:30:00	SPY	ETF	396.45	396.48	396.4	396.48	663.0
2023-03-28 04:35:00	SPY	ETF	396.31	396.31	396.3	396.31	600.0
2023-03-28 04:40:00	SPY	ETF	396.18	396.24	396.11	396.23	11700.0
2023-03-28 04:45:00	SPY	ETF	396.3	396.4	396.16	396.16	1350.0
2023-03-28 04:50:00	SPY	ETF	396.14	396.35	396.12	396.33	4600.0
2023-03-28 04:55:00	SPY	ETF	396.4	396.46	396.22	396.22	2500.0
2023-03-28 05:00:00	SPY	ETF	396.3	396.38	396.3	396.38	757.0
2023-03-28 05:05:00	SPY	ETF	396.37	396.37	396.23	396.23	1054.0
2023-03-28 05:10:00	SPY	ETF	396.25	396.32	396.11	396.31	2037.0
2023-03-28 05:15:00	SPY	ETF	396.27	396.4	396.21	396.4	3178.0
2023-03-28 05:20:00	SPY	ETF	396.39	396.39	396.3	396.3	1205.0
2023-03-28 05:25:00	SPY	ETF	396.33	396.33	396.28	396.28	313.0
2023-03-28 05:30:00	SPY	ETF	396.33	396.33	396.2	396.25	1237.0
2023-03-28 05:35:00	SPY	ETF	396.29	396.29	396.29	396.29	100.0
2023-03-28 05:40:00	SPY	ETF	396.16	396.16	396.09	396.11	1592.0
2023-03-28 05:45:00	SPY	ETF	396.06	396.06	395.78	395.92	5362.0
2023-03-28 05:50:00	SPY	ETF	396.03	396.05	396.02	396.05	580.0
2023-03-28 05:55:00	SPY	ETF	396.06	396.06	395.9	395.93	4153.0
2023-03-28 06:00:00	SPY	ETF	395.9	396.0	395.86	395.98	6350.0
2023-03-28 06:05:00	SPY	ETF	395.97	395.97	395.75	395.83	3052.0
2023-03-28 06:10:00	SPY	ETF	395.96	395.97	395.94	395.94	1154.0
2023-03-28 06:15:00	SPY	ETF	395.98	396.0	395.96	395.96	1330.0
2023-03-28 06:20:00	SPY	ETF	395.99	396.05	395.99	396.02	1147.0
2023-03-28 06:25:00	SPY	ETF	395.79	395.92	395.79	395.89	2196.0
2023-03-28 06:30:00	SPY	ETF	395.86	395.86	395.79	395.81	4853.0
2023-03-28 06:35:00	SPY	ETF	395.77	395.8	395.73	395.8	1895.0
2023-03-28 06:40:00	SPY	ETF	395.79	395.79	395.65	395.71	13719.0
2023-03-28 06:45:00	SPY	ETF	395.69	395.69	395.56	395.6	1950.0
2023-03-28 06:50:00	SPY	ETF	395.59	395.6	395.59	395.6	1600.0
2023-03-28 06:55:00	SPY	ETF	395.59	395.78	395.59	395.78	21600.0
2023-03-28 07:00:00	SPY	ETF	395.79	395.99	395.78	395.99	13595.0
2023-03-28 07:05:00	SPY	ETF	395.96	395.99	395.75	395.84	18158.0
2023-03-28 07:10:00	SPY	ETF	395.81	395.9	395.8	395.89	13169.0
2023-03-28 07:15:00	SPY	ETF	395.85	396.12	395.85	396.09	8664.0
2023-03-28 07:20:00	SPY	ETF	396.14	396.22	396.09	396.19	17383.0
2023-03-28 07:25:00	SPY	ETF	396.2	396.39	396.2	396.34	20220.0
2023-03-28 07:30:00	SPY	ETF	396.38	396.469	396.33	396.37	3820.0
2023-03-28 07:35:00	SPY	ETF	396.37	396.41	396.34	396.38	4133.0
2023-03-28 07:40:00	SPY	ETF	396.31	396.42	396.27	396.4	5295.0
2023-03-28 07:45:00	SPY	ETF	396.31	396.51	396.31	396.49	24508.0
2023-03-28 07:50:00	SPY	ETF	396.53	396.53	396.28	396.28	3945.0
2023-03-28 07:55:00	SPY	ETF	396.28	396.31	396.18	396.22	18824.0
2023-03-28 08:00:00	SPY	ETF	396.42	397.9	395.77	396.04	70637.0
2023-03-28 08:05:00	SPY	ETF	396.04	396.2	395.96	396.12	11277.0

> showing 50 of 92,219 rows — these rows as CSV

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