PREVIEW / etf_30min / 2024-05-22

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-22.parquet
  size:    802 KB
  rows:    32,184

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-05-22 04:00:00	SPY	ETF	531.11	531.15	530.96	530.96	2039.0
2024-05-22 04:30:00	SPY	ETF	530.96	530.96	530.73	530.73	2842.0
2024-05-22 05:30:00	SPY	ETF	530.6	530.72	530.58	530.58	1013.0
2024-05-22 06:00:00	SPY	ETF	530.67	530.74	530.55	530.55	9123.0
2024-05-22 06:30:00	SPY	ETF	530.5	530.57	530.35	530.5	12858.0
2024-05-22 07:00:00	SPY	ETF	530.49	530.96	530.48	530.8	31344.0
2024-05-22 07:30:00	SPY	ETF	530.8	530.85	530.38	530.38	108140.0
2024-05-22 08:00:00	SPY	ETF	530.89	531.54	530.35	530.43	61574.0
2024-05-22 08:30:00	SPY	ETF	530.47	530.69	530.37	530.6	55027.0
2024-05-22 09:00:00	SPY	ETF	530.6	530.7	530.4	530.67	61602.0
2024-05-22 09:30:00	SPY	ETF	530.66	531.19	530.625	531.15	1894160.0
2024-05-22 10:00:00	SPY	ETF	531.145	531.28	530.9	531.125	1161327.0
2024-05-22 10:30:00	SPY	ETF	531.13	531.18	530.78	531.12	833366.0
2024-05-22 11:00:00	SPY	ETF	531.13	531.38	531.0	531.0358	1047497.0
2024-05-22 11:30:00	SPY	ETF	531.04	531.05	530.16	530.71	1246861.0
2024-05-22 12:00:00	SPY	ETF	530.69	531.1	530.63	531.025	860534.0
2024-05-22 12:30:00	SPY	ETF	531.03	531.17	530.67	530.8625	910432.0
2024-05-22 13:00:00	SPY	ETF	530.85	531.24	530.85	530.915	968792.0
2024-05-22 13:30:00	SPY	ETF	530.91	530.92	529.43	529.9995	2532500.0
2024-05-22 14:00:00	SPY	ETF	529.98	529.98	527.77	527.81	3541163.0
2024-05-22 14:30:00	SPY	ETF	527.82	528.63	527.6	528.57	2763850.0
2024-05-22 15:00:00	SPY	ETF	528.56	528.87	527.8	528.76	2120939.0
2024-05-22 15:30:00	SPY	ETF	528.76	529.83	528.015	529.82	8195182.0
2024-05-22 16:00:00	SPY	ETF	529.8	531.52	528.01	529.76	4582506.0
2024-05-22 16:30:00	SPY	ETF	529.7	530.24	529.09	529.94	309060.0
2024-05-22 17:00:00	SPY	ETF	529.92	530.64	529.9	530.58	280905.0
2024-05-22 17:30:00	SPY	ETF	530.6	531.12	530.52	530.85	93677.0
2024-05-22 18:00:00	SPY	ETF	530.8	531.04	530.35	530.47	161113.0
2024-05-22 18:30:00	SPY	ETF	530.52	530.64	530.4807	530.6	12848.0
2024-05-22 19:00:00	SPY	ETF	530.6	530.94	530.58	530.93	13450.0
2024-05-22 19:30:00	SPY	ETF	530.9	531.03	530.89	531.0	39693.0
2024-05-22 04:00:00	QQQ	ETF	455.82	456.05	455.8	455.86	23262.0
2024-05-22 04:30:00	QQQ	ETF	455.82	455.84	455.52	455.67	8930.0
2024-05-22 05:00:00	QQQ	ETF	455.74	455.77	455.4	455.4	7961.0
2024-05-22 05:30:00	QQQ	ETF	455.46	455.47	455.18	455.33	11982.0
2024-05-22 06:00:00	QQQ	ETF	455.43	455.43	455.12	455.17	3699.0
2024-05-22 06:30:00	QQQ	ETF	455.02	455.31	454.79	455.3	26698.0
2024-05-22 07:00:00	QQQ	ETF	455.4	456.12	455.4	456.05	91223.0
2024-05-22 07:30:00	QQQ	ETF	455.98	456.05	455.65	455.69	70340.0
2024-05-22 08:00:00	QQQ	ETF	455.69	456.24	455.2601	455.66	81277.0
2024-05-22 08:30:00	QQQ	ETF	455.66	455.96	455.54	455.91	63633.0
2024-05-22 09:00:00	QQQ	ETF	455.93	456.14	455.72	456.0	89050.0
2024-05-22 09:30:00	QQQ	ETF	456.06	456.61	455.62	456.48	2211306.0
2024-05-22 10:00:00	QQQ	ETF	456.47	456.65	455.93	456.29	1033626.0
2024-05-22 10:30:00	QQQ	ETF	456.3	456.44	455.92	456.3899	549973.0
2024-05-22 11:00:00	QQQ	ETF	456.39	456.82	456.25	456.71	656785.0
2024-05-22 11:30:00	QQQ	ETF	456.72	456.79	455.88	456.3601	773839.0
2024-05-22 12:00:00	QQQ	ETF	456.36	456.67	456.23	456.38	569319.0
2024-05-22 12:30:00	QQQ	ETF	456.39	456.41	455.6603	455.98	738860.0
2024-05-22 13:00:00	QQQ	ETF	455.97	456.5	455.91	456.31	506716.0

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

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