PREVIEW / etf_30min / 2023-07-06

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-06.parquet
  size:    713 KB
  rows:    28,512

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-07-06 04:00:00	SPY	ETF	441.5	441.56	441.3	441.31	15695.0
2023-07-06 04:30:00	SPY	ETF	441.34	441.74	441.24	441.45	9229.0
2023-07-06 05:00:00	SPY	ETF	441.28	441.58	441.18	441.47	14786.0
2023-07-06 05:30:00	SPY	ETF	441.5	441.59	441.38	441.53	17769.0
2023-07-06 06:00:00	SPY	ETF	441.42	441.54	441.32	441.54	13958.0
2023-07-06 06:30:00	SPY	ETF	441.62	441.64	441.36	441.38	19402.0
2023-07-06 07:00:00	SPY	ETF	441.43	441.75	441.43	441.7	160347.0
2023-07-06 07:30:00	SPY	ETF	441.7	441.7	441.15	441.16	225234.0
2023-07-06 08:00:00	SPY	ETF	441.4695	442.0	440.35	440.4	400303.0
2023-07-06 08:30:00	SPY	ETF	440.485	440.5	439.28	439.71	817345.0
2023-07-06 09:00:00	SPY	ETF	439.68	441.8	439.35	439.41	371022.0
2023-07-06 09:30:00	SPY	ETF	439.41	439.62	438.04	438.49	8368566.0
2023-07-06 10:00:00	SPY	ETF	438.51	438.53	437.45	437.72	7339707.0
2023-07-06 10:30:00	SPY	ETF	437.73	437.85	437.13	437.2	4485584.0
2023-07-06 11:00:00	SPY	ETF	437.2	437.6496	437.06	437.35	3802642.0
2023-07-06 11:30:00	SPY	ETF	437.33	438.22	437.33	438.1	3959810.0
2023-07-06 12:00:00	SPY	ETF	438.115	438.825	438.105	438.81	3113258.0
2023-07-06 12:30:00	SPY	ETF	438.81	439.24	438.685	439.19	2874902.0
2023-07-06 13:00:00	SPY	ETF	439.19	439.55	439.09	439.2799	3042014.0
2023-07-06 13:30:00	SPY	ETF	439.27	439.76	438.995	439.72	2761096.0
2023-07-06 14:00:00	SPY	ETF	439.73	439.76	439.24	439.3	2115458.0
2023-07-06 14:30:00	SPY	ETF	439.29	440.1	439.275	440.04	2535637.0
2023-07-06 15:00:00	SPY	ETF	440.04	440.08	439.5832	439.75	2694734.0
2023-07-06 15:30:00	SPY	ETF	439.75	439.99	439.47	439.67	9312822.0
2023-07-06 16:00:00	SPY	ETF	439.68	439.89	439.57	439.57	2176338.0
2023-07-06 16:30:00	SPY	ETF	439.57	439.57	439.42	439.51	126462.0
2023-07-06 17:00:00	SPY	ETF	439.5	439.57	439.4	439.57	36443.0
2023-07-06 17:30:00	SPY	ETF	439.52	439.57	439.43	439.43	10172.0
2023-07-06 18:00:00	SPY	ETF	439.41	439.5	439.25	439.45	52171.0
2023-07-06 18:30:00	SPY	ETF	439.45	439.63	439.45	439.5	13138.0
2023-07-06 19:00:00	SPY	ETF	439.56	439.72	439.55	439.66	5325.0
2023-07-06 19:30:00	SPY	ETF	439.65	439.68	439.49	439.49	27743.0
2023-07-06 04:00:00	QQQ	ETF	368.46	369.0	368.46	368.58	24427.0
2023-07-06 04:30:00	QQQ	ETF	368.56	369.1	368.46	368.91	19173.0
2023-07-06 05:00:00	QQQ	ETF	368.85	368.96	368.56	368.89	13144.0
2023-07-06 05:30:00	QQQ	ETF	369.0	369.14	368.81	369.08	16423.0
2023-07-06 06:00:00	QQQ	ETF	369.03	369.12	368.8	368.88	13470.0
2023-07-06 06:30:00	QQQ	ETF	368.93	368.98	368.58	368.6	27136.0
2023-07-06 07:00:00	QQQ	ETF	368.67	369.15	368.67	369.15	86005.0
2023-07-06 07:30:00	QQQ	ETF	369.13	369.13	368.64	368.79	74345.0
2023-07-06 08:00:00	QQQ	ETF	368.8691	369.14	367.71	367.88	341797.0
2023-07-06 08:30:00	QQQ	ETF	368.0	370.557	365.8	366.46	913967.0
2023-07-06 09:00:00	QQQ	ETF	366.41	366.65	366.08	366.53	571992.0
2023-07-06 09:30:00	QQQ	ETF	366.51	366.96	364.94	365.66	7545364.0
2023-07-06 10:00:00	QQQ	ETF	365.68	365.81	364.52	365.77	4332368.0
2023-07-06 10:30:00	QQQ	ETF	365.8	366.07	364.73	364.8099	2493676.0
2023-07-06 11:00:00	QQQ	ETF	364.82	365.6	364.57	365.11	2178239.0
2023-07-06 11:30:00	QQQ	ETF	365.121	366.06	365.11	365.67	2683476.0
2023-07-06 12:00:00	QQQ	ETF	365.68	366.76	365.6507	366.68	1990319.0
2023-07-06 12:30:00	QQQ	ETF	366.68	367.13	366.6399	367.0399	1623559.0

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

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