PREVIEW / etf_5min / 2023-05-16

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-16.parquet
  size:    1.9 MB
  rows:    93,586

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-05-16 04:00:00	SPY	ETF	412.83	412.9	412.7	412.78	5345.0
2023-05-16 04:05:00	SPY	ETF	412.76	412.76	412.62	412.62	2865.0
2023-05-16 04:10:00	SPY	ETF	412.81	412.86	412.72	412.72	2944.0
2023-05-16 04:15:00	SPY	ETF	412.85	412.9	412.81	412.89	1654.0
2023-05-16 04:20:00	SPY	ETF	412.85	412.88	412.81	412.88	1300.0
2023-05-16 04:25:00	SPY	ETF	412.86	412.86	412.79	412.79	1900.0
2023-05-16 04:30:00	SPY	ETF	412.85	412.94	412.81	412.82	1638.0
2023-05-16 04:35:00	SPY	ETF	412.75	412.77	412.75	412.77	439.0
2023-05-16 04:40:00	SPY	ETF	412.68	412.7	412.64	412.64	6350.0
2023-05-16 04:45:00	SPY	ETF	412.62	412.62	412.53	412.53	305.0
2023-05-16 04:55:00	SPY	ETF	412.67	412.67	412.67	412.67	100.0
2023-05-16 05:00:00	SPY	ETF	412.7	412.86	412.7	412.86	3512.0
2023-05-16 05:05:00	SPY	ETF	412.87	412.89	412.83	412.83	3100.0
2023-05-16 05:10:00	SPY	ETF	412.84	412.88	412.79	412.88	4000.0
2023-05-16 05:15:00	SPY	ETF	412.86	412.86	412.86	412.86	600.0
2023-05-16 05:20:00	SPY	ETF	412.42	412.42	412.42	412.42	500.0
2023-05-16 05:25:00	SPY	ETF	412.48	412.54	412.4	412.54	2504.0
2023-05-16 05:30:00	SPY	ETF	412.65	412.67	412.65	412.67	3100.0
2023-05-16 05:35:00	SPY	ETF	412.77	412.77	412.68	412.68	214.0
2023-05-16 05:45:00	SPY	ETF	412.65	412.66	412.55	412.55	1700.0
2023-05-16 05:55:00	SPY	ETF	412.61	412.61	412.58	412.58	5227.0
2023-05-16 06:00:00	SPY	ETF	412.37	412.41	412.07	412.27	6791.0
2023-05-16 06:05:00	SPY	ETF	412.08	412.22	412.07	412.22	2308.0
2023-05-16 06:10:00	SPY	ETF	412.23	412.31	412.2	412.3	23950.0
2023-05-16 06:15:00	SPY	ETF	412.37	412.37	412.3	412.3	299.0
2023-05-16 06:20:00	SPY	ETF	412.4	412.5	412.4	412.5	1300.0
2023-05-16 06:25:00	SPY	ETF	412.47	412.65	412.47	412.63	8450.0
2023-05-16 06:30:00	SPY	ETF	412.59	412.61	412.5	412.5	1300.0
2023-05-16 06:35:00	SPY	ETF	412.47	412.47	412.47	412.47	100.0
2023-05-16 06:40:00	SPY	ETF	412.53	412.53	412.47	412.47	2000.0
2023-05-16 06:45:00	SPY	ETF	412.46	412.52	412.44	412.52	3878.0
2023-05-16 06:50:00	SPY	ETF	412.5	412.5	412.44	412.47	9332.0
2023-05-16 06:55:00	SPY	ETF	412.63	412.7	412.63	412.64	4493.0
2023-05-16 07:00:00	SPY	ETF	412.62	412.79	412.62	412.71	8496.0
2023-05-16 07:05:00	SPY	ETF	412.73	412.73	412.6	412.62	4306.0
2023-05-16 07:10:00	SPY	ETF	412.6	412.61	412.55	412.61	5050.0
2023-05-16 07:15:00	SPY	ETF	412.6	412.6	412.35	412.35	18453.0
2023-05-16 07:20:00	SPY	ETF	412.38	412.46	412.38	412.39	18300.0
2023-05-16 07:25:00	SPY	ETF	412.37	412.46	412.35	412.43	2073.0
2023-05-16 07:30:00	SPY	ETF	412.5	412.5	412.44	412.46	4504.0
2023-05-16 07:35:00	SPY	ETF	412.43	412.43	412.25	412.26	5075.0
2023-05-16 07:40:00	SPY	ETF	412.29	412.44	412.29	412.39	2028.0
2023-05-16 07:45:00	SPY	ETF	412.29	412.32	412.25	412.29	30900.0
2023-05-16 07:50:00	SPY	ETF	412.31	412.31	412.22	412.25	26436.0
2023-05-16 07:55:00	SPY	ETF	412.269	412.32	412.269	412.27	998.0
2023-05-16 08:00:00	SPY	ETF	412.26	413.17	411.8	412.44	50890.0
2023-05-16 08:05:00	SPY	ETF	412.47	412.47	412.2	412.21	59132.0
2023-05-16 08:10:00	SPY	ETF	412.24	412.3	412.19	412.2716	22515.0
2023-05-16 08:15:00	SPY	ETF	412.29	412.37	412.27	412.321	10556.0
2023-05-16 08:20:00	SPY	ETF	412.37	412.38	412.3	412.31	30622.0

> showing 50 of 93,586 rows — these rows as CSV

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