PREVIEW / etf_30min / 2024-09-06

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-06.parquet
  size:    823 KB
  rows:    33,894

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
2024-09-06 04:00:00	SPY	ETF	547.0	547.0	546.2	546.44	7173.0
2024-09-06 04:30:00	SPY	ETF	546.5	546.5	545.45	545.81	13333.0
2024-09-06 05:00:00	SPY	ETF	545.77	546.0	545.37	545.94	5873.0
2024-09-06 05:30:00	SPY	ETF	546.02	546.41	545.67	546.08	131172.0
2024-09-06 06:00:00	SPY	ETF	546.08	546.31	546.05	546.31	9063.0
2024-09-06 06:30:00	SPY	ETF	546.2	546.3	545.66	545.95	35973.0
2024-09-06 07:00:00	SPY	ETF	545.95	546.42	545.89	546.12	62527.0
2024-09-06 07:30:00	SPY	ETF	546.17	546.82	546.1	546.79	79763.0
2024-09-06 08:00:00	SPY	ETF	546.05	549.06	545.55	546.16	242400.0
2024-09-06 08:30:00	SPY	ETF	545.7	550.36	545.47	549.73	1300535.0
2024-09-06 09:00:00	SPY	ETF	549.77	550.6	549.28	549.86	236125.0
2024-09-06 09:30:00	SPY	ETF	549.93	551.6	547.83	547.8901	5065181.0
2024-09-06 10:00:00	SPY	ETF	547.89	548.26	544.64	544.7	3301047.0
2024-09-06 10:30:00	SPY	ETF	544.69	545.17	541.56	542.22	5165754.0
2024-09-06 11:00:00	SPY	ETF	542.25	545.505	540.96	541.5	5312819.0
2024-09-06 11:30:00	SPY	ETF	541.49	542.65	540.26	540.58	2563430.0
2024-09-06 12:00:00	SPY	ETF	540.53	541.07	539.84	539.9	1761647.0
2024-09-06 12:30:00	SPY	ETF	539.914	541.18	539.66	540.135	1704163.0
2024-09-06 13:00:00	SPY	ETF	540.15	542.0	539.91	540.83	1844927.0
2024-09-06 13:30:00	SPY	ETF	540.83	541.05	539.89	540.64	1445497.0
2024-09-06 14:00:00	SPY	ETF	540.65	540.85	539.44	539.99	1508689.0
2024-09-06 14:30:00	SPY	ETF	540.0	540.65	539.55	540.45	1353669.0
2024-09-06 15:00:00	SPY	ETF	540.45	541.88	540.4	541.33	2223202.0
2024-09-06 15:30:00	SPY	ETF	541.33	541.7	539.67	540.43	11079103.0
2024-09-06 16:00:00	SPY	ETF	540.42	542.91	538.7	538.72	4490162.0
2024-09-06 16:30:00	SPY	ETF	538.75	538.8	537.86	538.68	300263.0
2024-09-06 17:00:00	SPY	ETF	538.68	539.02	538.6	539.01	115953.0
2024-09-06 17:30:00	SPY	ETF	539.0292	539.03	538.61	538.9005	32643.0
2024-09-06 18:00:00	SPY	ETF	538.83	538.83	538.56	538.7	24280.0
2024-09-06 18:30:00	SPY	ETF	538.8	538.86	538.65	538.67	10137.0
2024-09-06 19:00:00	SPY	ETF	538.795	538.8	538.68	538.76	8540.0
2024-09-06 19:30:00	SPY	ETF	538.74	538.96	538.73	538.8	12073.0
2024-09-06 04:00:00	QQQ	ETF	457.1	457.1	455.74	456.42	46752.0
2024-09-06 04:30:00	QQQ	ETF	456.33	456.5	455.0	455.23	45791.0
2024-09-06 05:00:00	QQQ	ETF	455.27	455.77	454.83	455.6	73351.0
2024-09-06 05:30:00	QQQ	ETF	455.67	456.32	455.32	456.22	30297.0
2024-09-06 06:00:00	QQQ	ETF	456.11	456.2	455.77	455.94	29116.0
2024-09-06 06:30:00	QQQ	ETF	456.04	456.04	455.27	455.68	51968.0
2024-09-06 07:00:00	QQQ	ETF	455.68	456.5	455.68	456.15	90308.0
2024-09-06 07:30:00	QQQ	ETF	456.17	456.87	456.06	456.77	62697.0
2024-09-06 08:00:00	QQQ	ETF	455.83	461.385	455.23	456.63	247821.0
2024-09-06 08:30:00	QQQ	ETF	456.28	460.9784	455.3	460.394	1418881.0
2024-09-06 09:00:00	QQQ	ETF	460.38	461.35	459.81	460.32	397889.0
2024-09-06 09:30:00	QQQ	ETF	460.32	461.22	455.74	455.85	4784131.0
2024-09-06 10:00:00	QQQ	ETF	455.88	456.878	453.31	453.34	3672591.0
2024-09-06 10:30:00	QQQ	ETF	453.34	453.81	449.99	450.73	3909401.0
2024-09-06 11:00:00	QQQ	ETF	450.73	453.4	449.41	450.03	4164381.0
2024-09-06 11:30:00	QQQ	ETF	450.04	451.1175	448.57	448.98	2395788.0
2024-09-06 12:00:00	QQQ	ETF	448.96	449.63	448.64	448.6601	1289064.0
2024-09-06 12:30:00	QQQ	ETF	448.67	449.83	448.19	448.6999	1531447.0

> showing 50 of 33,894 rows — these rows as CSV

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