PREVIEW / etf_30min / 2023-10-13

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-13.parquet
  size:    699 KB
  rows:    28,235

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-10-13 04:00:00	SPY	ETF	434.48	434.84	434.2	434.2	10709.0
2023-10-13 04:30:00	SPY	ETF	434.17	434.35	433.8	433.87	13108.0
2023-10-13 05:00:00	SPY	ETF	433.87	433.87	433.14	433.22	9306.0
2023-10-13 05:30:00	SPY	ETF	433.31	433.31	432.51	432.6	21964.0
2023-10-13 06:00:00	SPY	ETF	432.55	432.8	432.29	432.64	16292.0
2023-10-13 06:30:00	SPY	ETF	432.36	433.21	432.35	432.87	61005.0
2023-10-13 07:00:00	SPY	ETF	432.96	433.77	432.92	433.71	123071.0
2023-10-13 07:30:00	SPY	ETF	433.68	433.77	433.24	433.53	134446.0
2023-10-13 08:00:00	SPY	ETF	432.93	434.66	432.3496	433.84	286369.0
2023-10-13 08:30:00	SPY	ETF	433.84	435.2	433.84	435.1	377515.0
2023-10-13 09:00:00	SPY	ETF	435.1	435.38	434.98	435.21	388206.0
2023-10-13 09:30:00	SPY	ETF	435.21	436.45	435.12	435.91	5769426.0
2023-10-13 10:00:00	SPY	ETF	435.84	435.91	434.14	434.45	5318563.0
2023-10-13 10:30:00	SPY	ETF	434.445	435.1	432.585	432.78	4949929.0
2023-10-13 11:00:00	SPY	ETF	432.79	432.88	431.6	432.14	5614023.0
2023-10-13 11:30:00	SPY	ETF	432.15	432.67	431.04	431.33	3815849.0
2023-10-13 12:00:00	SPY	ETF	431.33	433.03	431.17	432.9045	4109658.0
2023-10-13 12:30:00	SPY	ETF	432.91	433.36	431.58	432.1	3854214.0
2023-10-13 13:00:00	SPY	ETF	432.1	432.33	430.135	430.19	4758145.0
2023-10-13 13:30:00	SPY	ETF	430.19	431.83	429.88	431.4	5406701.0
2023-10-13 14:00:00	SPY	ETF	431.4	431.965	430.991	431.43	3518530.0
2023-10-13 14:30:00	SPY	ETF	431.45	432.115	430.77	431.56	4018192.0
2023-10-13 15:00:00	SPY	ETF	431.6	432.47	430.89	431.08	4462439.0
2023-10-13 15:30:00	SPY	ETF	431.08	431.68	430.33	431.55	13845634.0
2023-10-13 16:00:00	SPY	ETF	431.55	431.55	430.89	430.97	4173102.0
2023-10-13 16:30:00	SPY	ETF	430.97	431.03	430.83	430.93	296254.0
2023-10-13 17:00:00	SPY	ETF	430.89	431.05	430.79	430.86	115308.0
2023-10-13 17:30:00	SPY	ETF	430.83	430.94	430.7	430.85	47475.0
2023-10-13 18:00:00	SPY	ETF	430.77	430.95	430.68	430.9499	26467.0
2023-10-13 18:30:00	SPY	ETF	430.95	430.95	430.65	430.65	12885.0
2023-10-13 19:00:00	SPY	ETF	430.74	430.8	430.64	430.64	3982.0
2023-10-13 19:30:00	SPY	ETF	430.68	430.68	430.45	430.45	14442.0
2023-10-13 04:00:00	QQQ	ETF	370.15	370.36	369.83	369.83	39274.0
2023-10-13 04:30:00	QQQ	ETF	369.76	369.92	369.34	369.43	21508.0
2023-10-13 05:00:00	QQQ	ETF	369.45	369.49	368.73	368.88	104553.0
2023-10-13 05:30:00	QQQ	ETF	368.88	368.9	367.9	367.9	56922.0
2023-10-13 06:00:00	QQQ	ETF	368.0	368.09	367.61	367.84	45374.0
2023-10-13 06:30:00	QQQ	ETF	367.78	368.4	367.77	368.25	79314.0
2023-10-13 07:00:00	QQQ	ETF	368.28	368.92	368.23	368.9	206345.0
2023-10-13 07:30:00	QQQ	ETF	368.83	368.89	368.51	368.8	88389.0
2023-10-13 08:00:00	QQQ	ETF	368.6693	370.28	367.8296	369.06	250089.0
2023-10-13 08:30:00	QQQ	ETF	369.06	370.35	369.06	370.25	270994.0
2023-10-13 09:00:00	QQQ	ETF	370.2	370.72	370.14	370.58	361259.0
2023-10-13 09:30:00	QQQ	ETF	370.56	371.16	369.6225	370.6287	3313532.0
2023-10-13 10:00:00	QQQ	ETF	370.57	370.59	368.74	369.02	3440642.0
2023-10-13 10:30:00	QQQ	ETF	369.01	369.47	366.84	367.1837	2926112.0
2023-10-13 11:00:00	QQQ	ETF	367.17	367.3891	365.8905	366.19	3298640.0
2023-10-13 11:30:00	QQQ	ETF	366.19	366.57	365.0	365.22	2859005.0
2023-10-13 12:00:00	QQQ	ETF	365.21	366.86	365.0601	366.77	2313478.0
2023-10-13 12:30:00	QQQ	ETF	366.76	367.19	365.91	366.3138	2438745.0

> showing 50 of 28,235 rows — these rows as CSV

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