PREVIEW / etf_30min / 2023-07-10

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-10.parquet
  size:    700 KB
  rows:    27,665

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-10 04:00:00	SPY	ETF	437.14	437.86	437.04	437.71	51937.0
2023-07-10 04:30:00	SPY	ETF	437.71	437.71	437.46	437.54	17109.0
2023-07-10 05:00:00	SPY	ETF	437.56	437.88	437.56	437.65	7641.0
2023-07-10 05:30:00	SPY	ETF	437.7	437.9	437.59	437.65	5002.0
2023-07-10 06:00:00	SPY	ETF	437.64	437.8	437.49	437.77	11782.0
2023-07-10 06:30:00	SPY	ETF	437.82	438.13	437.72	438.13	17656.0
2023-07-10 07:00:00	SPY	ETF	438.15	438.46	438.11	438.39	64256.0
2023-07-10 07:30:00	SPY	ETF	438.33	438.75	438.27	438.69	98018.0
2023-07-10 08:00:00	SPY	ETF	438.16	439.0	436.5	438.61	160368.0
2023-07-10 08:30:00	SPY	ETF	438.62	438.62	438.14	438.32	310423.0
2023-07-10 09:00:00	SPY	ETF	438.35	438.6	438.04	438.18	219738.0
2023-07-10 09:30:00	SPY	ETF	438.18	439.348	438.05	439.095	5048885.0
2023-07-10 10:00:00	SPY	ETF	439.08	439.84	439.03	439.2699	3741038.0
2023-07-10 10:30:00	SPY	ETF	439.27	439.39	438.37	438.6299	3886002.0
2023-07-10 11:00:00	SPY	ETF	438.6208	438.78	438.01	438.72	2849973.0
2023-07-10 11:30:00	SPY	ETF	438.7099	439.08	438.1	438.4201	2370351.0
2023-07-10 12:00:00	SPY	ETF	438.44	438.48	437.585	438.39	3161585.0
2023-07-10 12:30:00	SPY	ETF	438.39	438.98	438.27	438.88	1992976.0
2023-07-10 13:00:00	SPY	ETF	438.88	439.1399	438.77	439.1399	1981163.0
2023-07-10 13:30:00	SPY	ETF	439.13	439.4	438.81	438.97	1843973.0
2023-07-10 14:00:00	SPY	ETF	438.97	439.42	438.5299	439.3899	2271926.0
2023-07-10 14:30:00	SPY	ETF	439.39	439.435	438.755	439.26	1565349.0
2023-07-10 15:00:00	SPY	ETF	439.265	439.32	438.81	439.01	1747821.0
2023-07-10 15:30:00	SPY	ETF	439.0	439.67	438.61	439.66	8126974.0
2023-07-10 16:00:00	SPY	ETF	439.65	439.96	438.98	439.7	3375279.0
2023-07-10 16:30:00	SPY	ETF	439.7	439.73	439.6	439.61	90565.0
2023-07-10 17:00:00	SPY	ETF	439.61	439.7	439.6	439.6	10825.0
2023-07-10 17:30:00	SPY	ETF	439.62	439.65	439.56	439.61	40921.0
2023-07-10 18:00:00	SPY	ETF	439.61	439.61	439.37	439.49	32704.0
2023-07-10 18:30:00	SPY	ETF	439.5	439.7	439.5	439.66	12940.0
2023-07-10 19:00:00	SPY	ETF	439.63	439.63	439.47	439.51	8321.0
2023-07-10 19:30:00	SPY	ETF	439.52	439.7	439.51	439.7	16998.0
2023-07-10 04:00:00	QQQ	ETF	364.62	365.43	364.57	365.15	50872.0
2023-07-10 04:30:00	QQQ	ETF	365.2	365.2	364.85	364.85	14244.0
2023-07-10 05:00:00	QQQ	ETF	364.9	365.24	364.89	364.89	8343.0
2023-07-10 05:30:00	QQQ	ETF	364.99	365.14	364.81	364.87	11997.0
2023-07-10 06:00:00	QQQ	ETF	364.84	365.04	364.7	365.02	16223.0
2023-07-10 06:30:00	QQQ	ETF	365.09	365.27	364.89	365.25	21434.0
2023-07-10 07:00:00	QQQ	ETF	365.27	365.62	365.21	365.48	70652.0
2023-07-10 07:30:00	QQQ	ETF	365.46	366.2	365.39	366.16	81492.0
2023-07-10 08:00:00	QQQ	ETF	365.72	366.64	363.97	366.21	178649.0
2023-07-10 08:30:00	QQQ	ETF	366.2	366.2	365.57	365.88	237703.0
2023-07-10 09:00:00	QQQ	ETF	365.93	366.28	365.73	365.95	290936.0
2023-07-10 09:30:00	QQQ	ETF	365.96	367.05	363.93	364.64	5983308.0
2023-07-10 10:00:00	QQQ	ETF	364.6497	366.7876	364.55	366.0799	3628374.0
2023-07-10 10:30:00	QQQ	ETF	366.08	366.2919	365.08	365.43	2732522.0
2023-07-10 11:00:00	QQQ	ETF	365.42	365.72	364.79	365.59	2066774.0
2023-07-10 11:30:00	QQQ	ETF	365.605	366.09	364.51	364.67	1947207.0
2023-07-10 12:00:00	QQQ	ETF	364.67	364.71	363.41	364.4737	2441743.0
2023-07-10 12:30:00	QQQ	ETF	364.49	365.635	364.33	365.47	1853205.0

> showing 50 of 27,665 rows — these rows as CSV

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