PREVIEW / etf_30min / 2022-09-23

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-23.parquet
  size:    711 KB
  rows:    29,362

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
2022-09-23 04:00:00	SPY	ETF	372.84	373.48	372.15	372.22	34528.0
2022-09-23 04:30:00	SPY	ETF	372.26	372.54	371.86	371.88	30581.0
2022-09-23 05:00:00	SPY	ETF	371.83	371.87	371.47	371.47	55016.0
2022-09-23 05:30:00	SPY	ETF	371.52	371.52	370.31	371.28	91057.0
2022-09-23 06:00:00	SPY	ETF	371.31	371.32	370.28	370.34	42888.0
2022-09-23 06:30:00	SPY	ETF	370.32	370.35	368.99	369.08	278520.0
2022-09-23 07:00:00	SPY	ETF	369.07	369.5	368.87	369.5	485550.0
2022-09-23 07:30:00	SPY	ETF	369.38	369.77	368.9	369.6	312933.0
2022-09-23 08:00:00	SPY	ETF	369.17	374.14	368.89	369.87	621232.0
2022-09-23 08:30:00	SPY	ETF	369.87	369.87	368.65	369.13	399978.0
2022-09-23 09:00:00	SPY	ETF	369.12	371.04	369.03	370.57	790273.0
2022-09-23 09:30:00	SPY	ETF	370.58	370.62	367.7	367.79	10980016.0
2022-09-23 10:00:00	SPY	ETF	367.8	368.81	367.43	368.7401	6547121.0
2022-09-23 10:30:00	SPY	ETF	368.76	368.76	367.35	367.4675	4831737.0
2022-09-23 11:00:00	SPY	ETF	367.46	368.82	367.17	367.75	4206877.0
2022-09-23 11:30:00	SPY	ETF	367.78	368.17	366.16	366.82	3831633.0
2022-09-23 12:00:00	SPY	ETF	366.82	366.925	365.07	365.12	4568869.0
2022-09-23 12:30:00	SPY	ETF	365.1	366.72	364.83	366.63	4457207.0
2022-09-23 13:00:00	SPY	ETF	366.6414	367.19	365.7	365.7784	3801749.0
2022-09-23 13:30:00	SPY	ETF	365.77	366.38	365.48	366.1599	3098912.0
2022-09-23 14:00:00	SPY	ETF	366.16	366.65	364.09	364.81	5134227.0
2022-09-23 14:30:00	SPY	ETF	364.79	364.8	363.29	363.495	4695254.0
2022-09-23 15:00:00	SPY	ETF	363.48	366.48	363.41	366.22	8608690.0
2022-09-23 15:30:00	SPY	ETF	366.22	368.235	366.01	367.92	16237664.0
2022-09-23 16:00:00	SPY	ETF	367.91	368.49	367.49	368.31	4269741.0
2022-09-23 16:30:00	SPY	ETF	368.36	368.45	367.95	368.29	208538.0
2022-09-23 17:00:00	SPY	ETF	368.3	368.65	367.95	368.24	186810.0
2022-09-23 17:30:00	SPY	ETF	368.25	368.49	368.01	368.4	44498.0
2022-09-23 18:00:00	SPY	ETF	368.35	368.5	368.21	368.22	20983.0
2022-09-23 18:30:00	SPY	ETF	368.22	368.33	367.95	367.95	56699.0
2022-09-23 19:00:00	SPY	ETF	368.1	368.23	368.03	368.18	17430.0
2022-09-23 19:30:00	SPY	ETF	368.23	368.25	368.05	368.24	28258.0
2022-09-23 04:00:00	QQQ	ETF	279.46	279.46	278.28	278.32	58048.0
2022-09-23 04:30:00	QQQ	ETF	278.32	278.6	277.89	277.91	27869.0
2022-09-23 05:00:00	QQQ	ETF	277.93	278.02	277.6	277.6	45883.0
2022-09-23 05:30:00	QQQ	ETF	277.58	277.58	276.63	277.49	97095.0
2022-09-23 06:00:00	QQQ	ETF	277.5	277.5	276.65	276.87	77578.0
2022-09-23 06:30:00	QQQ	ETF	276.71	276.82	275.8	275.97	209037.0
2022-09-23 07:00:00	QQQ	ETF	275.94	276.27	275.7	276.13	316161.0
2022-09-23 07:30:00	QQQ	ETF	276.1	276.57	275.73	276.4	358672.0
2022-09-23 08:00:00	QQQ	ETF	276.08	279.7	275.7	276.74	495779.0
2022-09-23 08:30:00	QQQ	ETF	276.77	276.77	276.0	276.37	402127.0
2022-09-23 09:00:00	QQQ	ETF	276.39	278.07	276.28	277.58	996001.0
2022-09-23 09:30:00	QQQ	ETF	277.55	277.85	274.97	275.0399	9008144.0
2022-09-23 10:00:00	QQQ	ETF	275.02	276.3	274.66	276.3	5365670.0
2022-09-23 10:30:00	QQQ	ETF	276.2999	276.57	275.2674	275.6	3441751.0
2022-09-23 11:00:00	QQQ	ETF	275.6	276.78	275.17	275.59	2932048.0
2022-09-23 11:30:00	QQQ	ETF	275.6	276.07	274.63	275.22	2591951.0
2022-09-23 12:00:00	QQQ	ETF	275.2	275.34	273.79	273.82	3093388.0
2022-09-23 12:30:00	QQQ	ETF	273.79	275.211	273.6501	275.02	3459396.0

> showing 50 of 29,362 rows — these rows as CSV

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