PREVIEW / etf_30min / 2023-06-15

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-15.parquet
  size:    731 KB
  rows:    28,380

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-06-15 04:00:00	SPY	ETF	437.11	437.18	436.88	436.9	19877.0
2023-06-15 04:30:00	SPY	ETF	436.86	436.9	436.33	436.39	18515.0
2023-06-15 05:00:00	SPY	ETF	436.39	436.51	436.02	436.14	16900.0
2023-06-15 05:30:00	SPY	ETF	436.27	436.33	436.01	436.22	8871.0
2023-06-15 06:00:00	SPY	ETF	436.22	436.3	435.73	435.89	21988.0
2023-06-15 06:30:00	SPY	ETF	435.9	435.9	435.49	435.64	32346.0
2023-06-15 07:00:00	SPY	ETF	435.64	435.84	435.4	435.67	86204.0
2023-06-15 07:30:00	SPY	ETF	435.66	435.91	435.55	435.79	60444.0
2023-06-15 08:00:00	SPY	ETF	435.47	437.49	435.41	435.66	190675.0
2023-06-15 08:30:00	SPY	ETF	435.59	436.8	434.92	435.96	493808.0
2023-06-15 09:00:00	SPY	ETF	436.0	436.63	435.84	436.32	269165.0
2023-06-15 09:30:00	SPY	ETF	436.32	438.88	436.23	438.7109	8395357.0
2023-06-15 10:00:00	SPY	ETF	438.72	439.66	438.44	439.48	6874552.0
2023-06-15 10:30:00	SPY	ETF	439.48	439.83	438.37	439.415	4700268.0
2023-06-15 11:00:00	SPY	ETF	439.42	440.745	439.22	440.73	4885797.0
2023-06-15 11:30:00	SPY	ETF	440.72	441.1301	440.06	440.72	4914641.0
2023-06-15 12:00:00	SPY	ETF	440.72	441.015	440.38	440.92	2935991.0
2023-06-15 12:30:00	SPY	ETF	440.925	441.18	440.58	440.85	2286612.0
2023-06-15 13:00:00	SPY	ETF	440.86	440.9	440.11	440.88	2366159.0
2023-06-15 13:30:00	SPY	ETF	440.89	441.91	440.77	441.735	3404289.0
2023-06-15 14:00:00	SPY	ETF	441.74	442.015	441.26	441.85	3806964.0
2023-06-15 14:30:00	SPY	ETF	441.8588	443.9	441.85	443.6301	6895248.0
2023-06-15 15:00:00	SPY	ETF	443.64	443.86	442.72	443.14	6538023.0
2023-06-15 15:30:00	SPY	ETF	443.14	443.46	442.06	442.6	15606881.0
2023-06-15 16:00:00	SPY	ETF	442.59	442.61	441.9	442.22	4641846.0
2023-06-15 16:30:00	SPY	ETF	442.23	442.487	442.0	442.15	444844.0
2023-06-15 17:00:00	SPY	ETF	442.07	442.6	442.07	442.4	121520.0
2023-06-15 17:30:00	SPY	ETF	442.4	442.57	442.3	442.41	88936.0
2023-06-15 18:00:00	SPY	ETF	442.37	442.4	442.05	442.16	177555.0
2023-06-15 18:30:00	SPY	ETF	442.18	442.21	441.84	441.91	67750.0
2023-06-15 19:00:00	SPY	ETF	441.91	442.07	441.91	441.97	37711.0
2023-06-15 19:30:00	SPY	ETF	441.97	442.02	441.87	441.91	47830.0
2023-06-15 04:00:00	QQQ	ETF	365.82	365.88	365.16	365.16	32627.0
2023-06-15 04:30:00	QQQ	ETF	365.12	365.16	364.22	364.28	42870.0
2023-06-15 05:00:00	QQQ	ETF	364.18	364.54	363.72	363.8	67458.0
2023-06-15 05:30:00	QQQ	ETF	364.0	364.15	363.52	363.83	32548.0
2023-06-15 06:00:00	QQQ	ETF	363.82	363.97	363.44	363.57	28683.0
2023-06-15 06:30:00	QQQ	ETF	363.6	363.62	363.25	363.57	83617.0
2023-06-15 07:00:00	QQQ	ETF	363.6	363.88	363.25	363.52	164156.0
2023-06-15 07:30:00	QQQ	ETF	363.59	363.75	363.3	363.57	117737.0
2023-06-15 08:00:00	QQQ	ETF	363.62	366.1	363.25	363.55	260277.0
2023-06-15 08:30:00	QQQ	ETF	363.44	364.36	362.85	364.18	622770.0
2023-06-15 09:00:00	QQQ	ETF	364.23	364.84	363.96	364.61	541429.0
2023-06-15 09:30:00	QQQ	ETF	364.61	366.58	363.98	366.07	6356674.0
2023-06-15 10:00:00	QQQ	ETF	366.08	367.74	365.66	367.615	4348277.0
2023-06-15 10:30:00	QQQ	ETF	367.63	368.01	366.44	367.3879	2709538.0
2023-06-15 11:00:00	QQQ	ETF	367.39	368.31	367.03	368.3	2739846.0
2023-06-15 11:30:00	QQQ	ETF	368.29	369.02	367.91	368.58	3057207.0
2023-06-15 12:00:00	QQQ	ETF	368.58	368.8988	368.13	368.42	1609689.0
2023-06-15 12:30:00	QQQ	ETF	368.4272	368.69	367.83	368.405	1538170.0

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

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