PREVIEW / etf_30min / 2023-02-27

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-27.parquet
  size:    673 KB
  rows:    27,171

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-02-27 04:00:00	SPY	ETF	397.86	398.27	397.6	398.27	30691.0
2023-02-27 04:30:00	SPY	ETF	398.26	398.5	398.15	398.15	23866.0
2023-02-27 05:00:00	SPY	ETF	398.16	398.62	398.16	398.25	10189.0
2023-02-27 05:30:00	SPY	ETF	398.34	398.39	398.2	398.2	26369.0
2023-02-27 06:00:00	SPY	ETF	398.16	398.43	398.02	398.42	30844.0
2023-02-27 06:30:00	SPY	ETF	398.39	398.5	398.15	398.28	81552.0
2023-02-27 07:00:00	SPY	ETF	398.26	398.6	398.02	398.33	123536.0
2023-02-27 07:30:00	SPY	ETF	398.31	398.6	398.02	398.2	77249.0
2023-02-27 08:00:00	SPY	ETF	398.16	398.85	396.56	398.64	147210.0
2023-02-27 08:30:00	SPY	ETF	398.61	400.27	398.6	399.9	422655.0
2023-02-27 09:00:00	SPY	ETF	399.91	400.11	399.6101	399.89	370617.0
2023-02-27 09:30:00	SPY	ETF	399.86	400.35	399.08	400.31	8012880.0
2023-02-27 10:00:00	SPY	ETF	400.33	401.29	400.085	400.68	7049426.0
2023-02-27 10:30:00	SPY	ETF	400.68	400.895	398.57	399.21	7225901.0
2023-02-27 11:00:00	SPY	ETF	399.2199	399.57	398.2	398.41	4034042.0
2023-02-27 11:30:00	SPY	ETF	398.43	398.61	397.63	398.2699	3493129.0
2023-02-27 12:00:00	SPY	ETF	398.27	398.35	397.57	398.15	2672877.0
2023-02-27 12:30:00	SPY	ETF	398.17	398.83	398.13	398.71	2508272.0
2023-02-27 13:00:00	SPY	ETF	398.72	399.19	398.56	398.78	1982297.0
2023-02-27 13:30:00	SPY	ETF	398.8	399.02	398.115	399.02	2172126.0
2023-02-27 14:00:00	SPY	ETF	399.02	399.51	398.43	398.66	3212969.0
2023-02-27 14:30:00	SPY	ETF	398.6899	398.78	397.76	397.93	2943528.0
2023-02-27 15:00:00	SPY	ETF	397.945	398.18	397.19	397.648	4555815.0
2023-02-27 15:30:00	SPY	ETF	397.64	397.77	396.75	397.73	10351530.0
2023-02-27 16:00:00	SPY	ETF	397.72	398.08	397.6733	398.06	3502745.0
2023-02-27 16:30:00	SPY	ETF	398.06	398.07	397.96	398.04	113600.0
2023-02-27 17:00:00	SPY	ETF	397.95	398.04	397.95	397.95	138261.0
2023-02-27 17:30:00	SPY	ETF	397.95	398.0	397.87	397.99	29637.0
2023-02-27 18:00:00	SPY	ETF	398.0	398.3	397.94	398.09	46743.0
2023-02-27 18:30:00	SPY	ETF	398.05	398.15	398.0	398.07	16274.0
2023-02-27 19:00:00	SPY	ETF	398.06	398.31	398.06	398.16	7220.0
2023-02-27 19:30:00	SPY	ETF	398.22	398.47	398.15	398.25	44852.0
2023-02-27 04:00:00	QQQ	ETF	293.33	293.58	292.51	293.58	60793.0
2023-02-27 04:30:00	QQQ	ETF	293.59	293.78	293.35	293.35	29501.0
2023-02-27 05:00:00	QQQ	ETF	293.39	293.75	293.39	293.51	23712.0
2023-02-27 05:30:00	QQQ	ETF	293.54	293.54	293.19	293.19	28375.0
2023-02-27 06:00:00	QQQ	ETF	293.16	293.5	293.16	293.5	27462.0
2023-02-27 06:30:00	QQQ	ETF	293.6	293.63	293.4	293.45	10824.0
2023-02-27 07:00:00	QQQ	ETF	293.45	293.77	293.41	293.47	107932.0
2023-02-27 07:30:00	QQQ	ETF	293.52	293.74	293.22	293.38	59806.0
2023-02-27 08:00:00	QQQ	ETF	293.54	293.99	292.068	293.799	247146.0
2023-02-27 08:30:00	QQQ	ETF	293.7	295.61	293.65	295.27	804397.0
2023-02-27 09:00:00	QQQ	ETF	295.27	295.42	294.89	295.11	437966.0
2023-02-27 09:30:00	QQQ	ETF	295.08	295.57	294.47	295.48	5560651.0
2023-02-27 10:00:00	QQQ	ETF	295.48	296.49	295.16	295.69	3533159.0
2023-02-27 10:30:00	QQQ	ETF	295.69	295.7199	293.78	294.44	4188838.0
2023-02-27 11:00:00	QQQ	ETF	294.46	294.7946	293.86	294.19	2704765.0
2023-02-27 11:30:00	QQQ	ETF	294.2	294.52	293.51	294.35	1915335.0
2023-02-27 12:00:00	QQQ	ETF	294.38	294.454	293.66	294.17	1374246.0
2023-02-27 12:30:00	QQQ	ETF	294.19	294.88	294.14	294.7901	1489795.0

> showing 50 of 27,171 rows — these rows as CSV

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