PREVIEW / etf_30min / 2023-10-17

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-17.parquet
  size:    727 KB
  rows:    28,383

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-17 04:00:00	SPY	ETF	436.02	436.02	435.44	435.79	10200.0
2023-10-17 04:30:00	SPY	ETF	435.69	435.69	434.68	434.8	31936.0
2023-10-17 05:00:00	SPY	ETF	434.77	435.6	434.77	435.29	8620.0
2023-10-17 05:30:00	SPY	ETF	435.37	435.47	435.2	435.25	3408.0
2023-10-17 06:00:00	SPY	ETF	435.2	435.4	434.7	434.98	26998.0
2023-10-17 06:30:00	SPY	ETF	434.88	435.06	434.69	435.06	14719.0
2023-10-17 07:00:00	SPY	ETF	434.93	435.05	434.44	434.8	101227.0
2023-10-17 07:30:00	SPY	ETF	434.79	435.09	434.73	435.04	62355.0
2023-10-17 08:00:00	SPY	ETF	434.9492	436.03	434.45	434.72	202392.0
2023-10-17 08:30:00	SPY	ETF	434.71	434.71	433.56	433.58	562186.0
2023-10-17 09:00:00	SPY	ETF	433.59	433.61	432.75	432.84	575044.0
2023-10-17 09:30:00	SPY	ETF	432.81	433.71	432.45	432.72	7248126.0
2023-10-17 10:00:00	SPY	ETF	432.72	435.25	432.59	434.665	5847613.0
2023-10-17 10:30:00	SPY	ETF	434.675	435.7	434.48	435.135	4015341.0
2023-10-17 11:00:00	SPY	ETF	435.14	436.27	434.94	435.94	3648187.0
2023-10-17 11:30:00	SPY	ETF	435.95	437.5167	435.935	437.265	4624092.0
2023-10-17 12:00:00	SPY	ETF	437.27	438.08	437.17	438.0793	3997279.0
2023-10-17 12:30:00	SPY	ETF	438.08	438.14	436.6	436.79	3687588.0
2023-10-17 13:00:00	SPY	ETF	436.8	437.01	436.23	436.325	2748015.0
2023-10-17 13:30:00	SPY	ETF	436.34	436.355	434.615	434.8738	4159415.0
2023-10-17 14:00:00	SPY	ETF	434.88	435.41	434.6699	435.1501	3785900.0
2023-10-17 14:30:00	SPY	ETF	435.15	435.695	434.225	434.5771	4171220.0
2023-10-17 15:00:00	SPY	ETF	434.57	435.56	434.3	435.48	3724587.0
2023-10-17 15:30:00	SPY	ETF	435.49	436.115	434.86	436.09	8610060.0
2023-10-17 16:00:00	SPY	ETF	436.085	437.3228	432.9516	435.79	2102184.0
2023-10-17 16:30:00	SPY	ETF	435.79	436.07	435.78	435.81	172752.0
2023-10-17 17:00:00	SPY	ETF	435.84	435.86	435.62	435.83	27497.0
2023-10-17 17:30:00	SPY	ETF	435.84	435.85	435.61	435.7	19448.0
2023-10-17 18:00:00	SPY	ETF	435.7	435.71	435.44	435.54	25303.0
2023-10-17 18:30:00	SPY	ETF	435.51	435.57	435.49	435.5	92335.0
2023-10-17 19:00:00	SPY	ETF	435.52	435.52	435.29	435.29	8430.0
2023-10-17 19:30:00	SPY	ETF	435.33	435.35	435.04	435.06	36450.0
2023-10-17 04:00:00	QQQ	ETF	369.48	369.53	368.98	369.32	21178.0
2023-10-17 04:30:00	QQQ	ETF	369.24	369.25	368.24	368.49	50799.0
2023-10-17 05:00:00	QQQ	ETF	368.41	369.18	368.41	368.82	13575.0
2023-10-17 05:30:00	QQQ	ETF	368.86	368.91	368.7	368.81	6094.0
2023-10-17 06:00:00	QQQ	ETF	368.8	368.99	368.3	368.59	28106.0
2023-10-17 06:30:00	QQQ	ETF	368.38	368.57	368.3	368.43	15346.0
2023-10-17 07:00:00	QQQ	ETF	368.43	368.51	367.9	368.2	45402.0
2023-10-17 07:30:00	QQQ	ETF	368.15	368.5	368.15	368.44	36975.0
2023-10-17 08:00:00	QQQ	ETF	368.4006	369.687	367.66	368.0	133549.0
2023-10-17 08:30:00	QQQ	ETF	367.9	367.9	366.39	366.46	462726.0
2023-10-17 09:00:00	QQQ	ETF	366.42	366.53	365.74	365.74	546049.0
2023-10-17 09:30:00	QQQ	ETF	365.81	365.86	363.66	364.38	6778312.0
2023-10-17 10:00:00	QQQ	ETF	364.4	367.395	364.2001	366.87	4813720.0
2023-10-17 10:30:00	QQQ	ETF	366.87	368.19	366.78	367.3107	3314555.0
2023-10-17 11:00:00	QQQ	ETF	367.31	368.42	366.96	368.05	2719346.0
2023-10-17 11:30:00	QQQ	ETF	368.06	369.31	368.042	369.0399	3349763.0
2023-10-17 12:00:00	QQQ	ETF	369.04	369.92	368.935	369.92	2269471.0
2023-10-17 12:30:00	QQQ	ETF	369.91	369.92	368.85	369.07	2021593.0

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

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