PREVIEW / etf_30min / 2023-07-11

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-11.parquet
  size:    708 KB
  rows:    27,853

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-11 04:00:00	SPY	ETF	439.68	439.87	439.49	439.63	10037.0
2023-07-11 04:30:00	SPY	ETF	439.56	439.6	439.13	439.44	18111.0
2023-07-11 05:00:00	SPY	ETF	439.42	439.76	439.38	439.76	9619.0
2023-07-11 05:30:00	SPY	ETF	439.78	440.27	439.77	440.24	17392.0
2023-07-11 06:00:00	SPY	ETF	440.21	440.3	439.93	440.11	21751.0
2023-07-11 06:30:00	SPY	ETF	440.04	440.12	440.0	440.01	5513.0
2023-07-11 07:00:00	SPY	ETF	439.96	440.43	439.93	440.43	51878.0
2023-07-11 07:30:00	SPY	ETF	440.42	440.57	440.25	440.55	56797.0
2023-07-11 08:00:00	SPY	ETF	440.07	440.73	439.83	440.53	110187.0
2023-07-11 08:30:00	SPY	ETF	440.54	440.86	440.5	440.77	112418.0
2023-07-11 09:00:00	SPY	ETF	440.78	440.85	440.34	440.46	217959.0
2023-07-11 09:30:00	SPY	ETF	440.45	441.0471	439.65	440.39	4866044.0
2023-07-11 10:00:00	SPY	ETF	440.385	440.405	439.44	440.27	3536549.0
2023-07-11 10:30:00	SPY	ETF	440.26	440.78	440.02	440.61	2457863.0
2023-07-11 11:00:00	SPY	ETF	440.62	440.97	440.41	440.57	2688082.0
2023-07-11 11:30:00	SPY	ETF	440.57	441.48	440.375	441.46	2937176.0
2023-07-11 12:00:00	SPY	ETF	441.45	441.7	440.45	440.85	3445118.0
2023-07-11 12:30:00	SPY	ETF	440.88	441.3	440.711	441.14	1729520.0
2023-07-11 13:00:00	SPY	ETF	441.145	441.33	440.6	440.88	1715275.0
2023-07-11 13:30:00	SPY	ETF	440.89	441.07	440.525	441.01	1467556.0
2023-07-11 14:00:00	SPY	ETF	441.0	441.1408	440.27	440.7107	2137256.0
2023-07-11 14:30:00	SPY	ETF	440.72	441.44	440.36	441.38	2397551.0
2023-07-11 15:00:00	SPY	ETF	441.385	441.615	441.1	441.5401	2913887.0
2023-07-11 15:30:00	SPY	ETF	441.54	442.97	441.19	442.48	13056236.0
2023-07-11 16:00:00	SPY	ETF	442.485	442.54	442.2099	442.42	2813774.0
2023-07-11 16:30:00	SPY	ETF	442.4	442.42	442.32	442.36	146870.0
2023-07-11 17:00:00	SPY	ETF	442.31	442.44	442.31	442.44	22460.0
2023-07-11 17:30:00	SPY	ETF	442.39	442.41	442.28	442.32	32586.0
2023-07-11 18:00:00	SPY	ETF	442.3	442.51	442.22	442.4401	63216.0
2023-07-11 18:30:00	SPY	ETF	442.4899	442.61	442.42	442.61	20647.0
2023-07-11 19:00:00	SPY	ETF	442.62	442.74	442.4	442.4	35065.0
2023-07-11 19:30:00	SPY	ETF	442.35	442.45	442.33	442.41	31126.0
2023-07-11 04:00:00	QQQ	ETF	366.81	366.82	366.36	366.65	21797.0
2023-07-11 04:30:00	QQQ	ETF	366.5	366.68	366.26	366.61	12402.0
2023-07-11 05:00:00	QQQ	ETF	366.55	366.8	366.5	366.8	6028.0
2023-07-11 05:30:00	QQQ	ETF	366.78	367.3	366.78	367.3	14116.0
2023-07-11 06:00:00	QQQ	ETF	367.24	367.24	366.88	367.0	15468.0
2023-07-11 06:30:00	QQQ	ETF	366.93	367.11	366.83	366.83	9476.0
2023-07-11 07:00:00	QQQ	ETF	366.81	367.25	366.8	367.211	18503.0
2023-07-11 07:30:00	QQQ	ETF	367.21	367.46	367.12	367.42	48890.0
2023-07-11 08:00:00	QQQ	ETF	367.05	367.59	366.5604	367.37	110533.0
2023-07-11 08:30:00	QQQ	ETF	367.39	367.67	367.16	367.43	119991.0
2023-07-11 09:00:00	QQQ	ETF	367.4301	367.4301	366.73	366.77	180427.0
2023-07-11 09:30:00	QQQ	ETF	366.79	367.55	365.3799	365.96	5059527.0
2023-07-11 10:00:00	QQQ	ETF	365.96	366.2	364.62	366.14	2997287.0
2023-07-11 10:30:00	QQQ	ETF	366.12	367.06	366.04	366.665	2277393.0
2023-07-11 11:00:00	QQQ	ETF	366.68	367.28	366.011	366.28	2092026.0
2023-07-11 11:30:00	QQQ	ETF	366.3	367.63	365.89	367.63	2002162.0
2023-07-11 12:00:00	QQQ	ETF	367.62	367.95	366.31	366.6029	2471580.0
2023-07-11 12:30:00	QQQ	ETF	366.62	367.24	366.5288	367.1168	1685196.0

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

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