PREVIEW / etf_30min / 2024-04-11

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-11.parquet
  size:    802 KB
  rows:    32,182

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
2024-04-11 04:00:00	SPY	ETF	514.2	514.63	514.2	514.29	10258.0
2024-04-11 04:30:00	SPY	ETF	514.19	514.39	513.4	513.4	14615.0
2024-04-11 05:00:00	SPY	ETF	513.29	513.64	513.0	513.28	14550.0
2024-04-11 05:30:00	SPY	ETF	513.37	513.75	513.14	513.3	6945.0
2024-04-11 06:00:00	SPY	ETF	513.18	513.32	512.88	513.3	17100.0
2024-04-11 06:30:00	SPY	ETF	513.38	513.38	513.0	513.21	15103.0
2024-04-11 07:00:00	SPY	ETF	513.24	513.44	512.56	512.83	99830.0
2024-04-11 07:30:00	SPY	ETF	512.8	512.89	511.7	512.1	185770.0
2024-04-11 08:00:00	SPY	ETF	512.62	514.61	511.75	512.09	178676.0
2024-04-11 08:30:00	SPY	ETF	511.72	515.45	511.48	515.06	943144.0
2024-04-11 09:00:00	SPY	ETF	515.15	516.03	514.82	515.72	431552.0
2024-04-11 09:30:00	SPY	ETF	515.68	515.87	514.09	514.61	4704142.0
2024-04-11 10:00:00	SPY	ETF	514.62	514.69	512.08	512.57	4654654.0
2024-04-11 10:30:00	SPY	ETF	512.57	513.82	512.4514	513.22	3178790.0
2024-04-11 11:00:00	SPY	ETF	513.23	514.23	513.15	513.57	2722116.0
2024-04-11 11:30:00	SPY	ETF	513.57	515.45	513.415	515.34	3030363.0
2024-04-11 12:00:00	SPY	ETF	515.33	515.52	514.81	514.8399	3372202.0
2024-04-11 12:30:00	SPY	ETF	514.84	515.65	514.73	515.29	2274805.0
2024-04-11 13:00:00	SPY	ETF	515.3	517.91	514.88	517.51	5218290.0
2024-04-11 13:30:00	SPY	ETF	517.52	518.13	516.96	518.0	3159168.0
2024-04-11 14:00:00	SPY	ETF	518.005	519.27	517.92	519.08	3280397.0
2024-04-11 14:30:00	SPY	ETF	519.07	519.48	518.54	518.689	2703950.0
2024-04-11 15:00:00	SPY	ETF	518.69	519.23	518.51	518.91	2287385.0
2024-04-11 15:30:00	SPY	ETF	518.915	519.39	517.97	518.05	9324583.0
2024-04-11 16:00:00	SPY	ETF	518.05	518.31	517.81	518.24	4020148.0
2024-04-11 16:30:00	SPY	ETF	518.21	518.28	518.05	518.15	156463.0
2024-04-11 17:00:00	SPY	ETF	518.14	518.2	518.0	518.02	41512.0
2024-04-11 17:30:00	SPY	ETF	518.05	518.1	518.0	518.07	24601.0
2024-04-11 18:00:00	SPY	ETF	518.05	518.49	518.03	518.39	53398.0
2024-04-11 18:30:00	SPY	ETF	518.3011	518.33	518.24	518.29	7280.0
2024-04-11 19:00:00	SPY	ETF	518.35	518.44	518.32	518.32	15640.0
2024-04-11 19:30:00	SPY	ETF	518.23	518.31	517.86	518.25	38488.0
2024-04-11 04:00:00	QQQ	ETF	438.65	438.9	438.47	438.59	22394.0
2024-04-11 04:30:00	QQQ	ETF	438.62	438.71	437.72	437.73	30689.0
2024-04-11 05:00:00	QQQ	ETF	437.65	437.98	437.46	437.6	14993.0
2024-04-11 05:30:00	QQQ	ETF	437.64	437.99	437.58	437.68	9023.0
2024-04-11 06:00:00	QQQ	ETF	437.78	437.78	437.38	437.74	21752.0
2024-04-11 06:30:00	QQQ	ETF	437.91	437.96	437.55	437.83	33766.0
2024-04-11 07:00:00	QQQ	ETF	437.85	438.0	437.14	437.42	41239.0
2024-04-11 07:30:00	QQQ	ETF	437.36	437.45	436.61	436.9	55154.0
2024-04-11 08:00:00	QQQ	ETF	437.8297	438.86	436.63	436.9	350939.0
2024-04-11 08:30:00	QQQ	ETF	436.5	440.19	436.07	439.79	1125149.0
2024-04-11 09:00:00	QQQ	ETF	439.83	440.75	439.66	440.29	446725.0
2024-04-11 09:30:00	QQQ	ETF	440.25	440.48	439.26	440.17	3942774.0
2024-04-11 10:00:00	QQQ	ETF	440.17	440.24	437.96	438.91	2666856.0
2024-04-11 10:30:00	QQQ	ETF	438.94	440.24	438.76	439.57	2295031.0
2024-04-11 11:00:00	QQQ	ETF	439.6	440.559	439.56	439.795	1694405.0
2024-04-11 11:30:00	QQQ	ETF	439.81	441.61	439.71	441.49	1902798.0
2024-04-11 12:00:00	QQQ	ETF	441.5	441.7	440.91	440.94	1549323.0
2024-04-11 12:30:00	QQQ	ETF	440.95	441.64	440.79	441.245	826462.0

> showing 50 of 32,182 rows — these rows as CSV

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