PREVIEW / etf_30min / 2023-11-10

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-10.parquet
  size:    740 KB
  rows:    29,046

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-11-10 04:00:00	SPY	ETF	434.51	434.51	433.68	433.78	30267.0
2023-11-10 04:30:00	SPY	ETF	433.7	434.34	433.66	434.34	12473.0
2023-11-10 05:00:00	SPY	ETF	434.17	434.2	433.71	433.75	14946.0
2023-11-10 05:30:00	SPY	ETF	433.81	433.93	433.52	433.76	9897.0
2023-11-10 06:00:00	SPY	ETF	433.68	433.84	433.64	433.64	12298.0
2023-11-10 06:30:00	SPY	ETF	433.52	433.82	433.31	433.82	33347.0
2023-11-10 07:00:00	SPY	ETF	433.84	434.32	433.66	434.32	78547.0
2023-11-10 07:30:00	SPY	ETF	434.5	434.94	434.5	434.89	138542.0
2023-11-10 08:00:00	SPY	ETF	434.75	435.29	433.67	435.12	242859.0
2023-11-10 08:30:00	SPY	ETF	435.12	435.9	434.9	435.79	369509.0
2023-11-10 09:00:00	SPY	ETF	435.78	436.14	435.45	435.98	324570.0
2023-11-10 09:30:00	SPY	ETF	435.98	436.24	434.88	435.83	6309180.0
2023-11-10 10:00:00	SPY	ETF	435.8	435.82	434.62	434.8	5518672.0
2023-11-10 10:30:00	SPY	ETF	434.795	435.41	434.43	435.3895	3227401.0
2023-11-10 11:00:00	SPY	ETF	435.38	436.9	435.355	436.64	4228882.0
2023-11-10 11:30:00	SPY	ETF	436.64	436.8	436.15	436.76	2690445.0
2023-11-10 12:00:00	SPY	ETF	436.77	437.51	436.71	437.35	3020641.0
2023-11-10 12:30:00	SPY	ETF	437.36	439.03	437.35	438.785	5575088.0
2023-11-10 13:00:00	SPY	ETF	438.79	439.23	438.21	438.99	3926263.0
2023-11-10 13:30:00	SPY	ETF	438.995	439.77	438.99	439.5299	3744815.0
2023-11-10 14:00:00	SPY	ETF	439.53	439.9287	439.415	439.82	3658787.0
2023-11-10 14:30:00	SPY	ETF	439.83	439.96	439.525	439.6599	2288767.0
2023-11-10 15:00:00	SPY	ETF	439.66	440.42	439.6119	440.38	3210511.0
2023-11-10 15:30:00	SPY	ETF	440.365	440.93	440.22	440.6	14969584.0
2023-11-10 16:00:00	SPY	ETF	440.6	441.09	434.5004	440.75	3709438.0
2023-11-10 16:30:00	SPY	ETF	440.77	440.85	439.82	440.0	643533.0
2023-11-10 17:00:00	SPY	ETF	440.0	440.15	439.9	439.95	154584.0
2023-11-10 17:30:00	SPY	ETF	439.89	439.95	439.75	439.8	83618.0
2023-11-10 18:00:00	SPY	ETF	439.8	440.19	439.75	439.98	77986.0
2023-11-10 18:30:00	SPY	ETF	439.94	439.98	439.9	439.9601	4028.0
2023-11-10 19:00:00	SPY	ETF	439.96	439.96	439.85	439.91	7102.0
2023-11-10 19:30:00	SPY	ETF	439.9	440.2	439.85	440.2	27805.0
2023-11-10 04:00:00	QQQ	ETF	369.95	370.0	369.12	369.18	47748.0
2023-11-10 04:30:00	QQQ	ETF	369.17	369.77	368.98	369.76	26750.0
2023-11-10 05:00:00	QQQ	ETF	369.73	369.73	369.21	369.29	16558.0
2023-11-10 05:30:00	QQQ	ETF	369.39	369.61	369.24	369.61	22639.0
2023-11-10 06:00:00	QQQ	ETF	369.5	369.5	369.24	369.31	17535.0
2023-11-10 06:30:00	QQQ	ETF	369.33	369.45	368.97	369.43	29789.0
2023-11-10 07:00:00	QQQ	ETF	369.47	370.07	369.29	370.06	76007.0
2023-11-10 07:30:00	QQQ	ETF	370.07	370.735	370.04	370.6	148072.0
2023-11-10 08:00:00	QQQ	ETF	369.4603	370.9	369.14	370.75	292514.0
2023-11-10 08:30:00	QQQ	ETF	370.75	371.65	370.59	371.61	245986.0
2023-11-10 09:00:00	QQQ	ETF	371.58	371.9	371.39	371.78	259049.0
2023-11-10 09:30:00	QQQ	ETF	371.82	373.29	371.28	373.03	5420940.0
2023-11-10 10:00:00	QQQ	ETF	373.02	373.08	371.69	371.98	4125423.0
2023-11-10 10:30:00	QQQ	ETF	371.98	372.93	371.71	372.93	2318100.0
2023-11-10 11:00:00	QQQ	ETF	372.93	374.74	372.89	374.45	3401020.0
2023-11-10 11:30:00	QQQ	ETF	374.45	374.81	373.88	374.79	1746639.0
2023-11-10 12:00:00	QQQ	ETF	374.785	375.64	374.6699	375.45	2110195.0
2023-11-10 12:30:00	QQQ	ETF	375.45	376.91	375.3857	376.54	3246324.0

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

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