PREVIEW / etf_30min / 2024-02-06

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-06.parquet
  size:    805 KB
  rows:    31,497

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-02-06 04:00:00	SPY	ETF	492.99	493.28	492.99	493.17	2332.0
2024-02-06 04:30:00	SPY	ETF	493.2	493.2	492.8	492.82	4342.0
2024-02-06 05:00:00	SPY	ETF	492.8	492.8	492.48	492.49	2167.0
2024-02-06 05:30:00	SPY	ETF	492.49	492.77	492.41	492.67	7862.0
2024-02-06 06:00:00	SPY	ETF	492.75	492.77	492.5	492.68	1793.0
2024-02-06 06:30:00	SPY	ETF	492.65	492.65	492.05	492.26	11533.0
2024-02-06 07:00:00	SPY	ETF	492.34	492.47	492.03	492.08	29267.0
2024-02-06 07:30:00	SPY	ETF	492.13	492.6	492.1	492.51	26498.0
2024-02-06 08:00:00	SPY	ETF	492.35	493.5	492.03	493.12	111187.0
2024-02-06 08:30:00	SPY	ETF	493.16	493.45	493.08	493.37	95096.0
2024-02-06 09:00:00	SPY	ETF	493.4	493.66	493.4	493.5	110382.0
2024-02-06 09:30:00	SPY	ETF	493.52	494.32	492.98	493.0095	5048517.0
2024-02-06 10:00:00	SPY	ETF	493.01	493.05	492.05	492.5	4371756.0
2024-02-06 10:30:00	SPY	ETF	492.48	493.18	492.395	492.825	2847453.0
2024-02-06 11:00:00	SPY	ETF	492.81	493.43	492.5	493.29	2096494.0
2024-02-06 11:30:00	SPY	ETF	493.31	493.41	492.25	492.35	2681764.0
2024-02-06 12:00:00	SPY	ETF	492.37	492.93	492.1	492.8799	2487745.0
2024-02-06 12:30:00	SPY	ETF	492.88	492.96	492.41	492.57	1718637.0
2024-02-06 13:00:00	SPY	ETF	492.575	493.08	492.45	492.92	1796187.0
2024-02-06 13:30:00	SPY	ETF	492.92	493.55	492.9	493.515	2390792.0
2024-02-06 14:00:00	SPY	ETF	493.52	493.57	492.11	492.4999	3742772.0
2024-02-06 14:30:00	SPY	ETF	492.52	493.28	492.24	493.15	2327868.0
2024-02-06 15:00:00	SPY	ETF	493.16	493.54	492.96	493.16	3006585.0
2024-02-06 15:30:00	SPY	ETF	493.16	494.04	492.635	493.97	5969941.0
2024-02-06 16:00:00	SPY	ETF	493.97	494.08	492.2716	493.48	2270665.0
2024-02-06 16:30:00	SPY	ETF	493.52	493.72	493.49	493.7	165123.0
2024-02-06 17:00:00	SPY	ETF	493.7	493.86	493.69	493.85	63327.0
2024-02-06 17:30:00	SPY	ETF	493.81	493.81	493.65	493.65	21377.0
2024-02-06 18:00:00	SPY	ETF	493.72	494.0	493.72	493.81	65122.0
2024-02-06 18:30:00	SPY	ETF	493.86	493.99	493.79	493.8	15319.0
2024-02-06 19:00:00	SPY	ETF	493.84	493.93	493.7	493.87	25024.0
2024-02-06 19:30:00	SPY	ETF	493.91	493.91	493.7599	493.82	28342.0
2024-02-06 04:00:00	QQQ	ETF	429.37	429.97	429.37	429.71	29260.0
2024-02-06 04:30:00	QQQ	ETF	429.71	429.75	429.26	429.31	27730.0
2024-02-06 05:00:00	QQQ	ETF	429.05	429.39	429.05	429.15	9650.0
2024-02-06 05:30:00	QQQ	ETF	429.21	429.45	429.0	429.45	6807.0
2024-02-06 06:00:00	QQQ	ETF	429.51	429.56	429.16	429.25	23995.0
2024-02-06 06:30:00	QQQ	ETF	429.26	429.26	427.99	428.31	86707.0
2024-02-06 07:00:00	QQQ	ETF	428.4	428.57	427.9	428.02	105191.0
2024-02-06 07:30:00	QQQ	ETF	428.09	428.79	428.079	428.7	43254.0
2024-02-06 08:00:00	QQQ	ETF	428.3797	430.15	427.96	429.35	173990.0
2024-02-06 08:30:00	QQQ	ETF	429.35	429.65	429.24	429.45	53277.0
2024-02-06 09:00:00	QQQ	ETF	429.58	429.85	429.51	429.56	106630.0
2024-02-06 09:30:00	QQQ	ETF	429.58	430.22	427.43	427.47	4204913.0
2024-02-06 10:00:00	QQQ	ETF	427.49	427.57	426.13	426.73	3369667.0
2024-02-06 10:30:00	QQQ	ETF	426.73	427.55	426.465	427.08	1881253.0
2024-02-06 11:00:00	QQQ	ETF	427.07	427.59	426.71	427.5	1944572.0
2024-02-06 11:30:00	QQQ	ETF	427.51	427.68	425.64	425.82	2228764.0
2024-02-06 12:00:00	QQQ	ETF	425.84	426.28	425.22	426.24	2346928.0
2024-02-06 12:30:00	QQQ	ETF	426.25	426.535	425.68	425.94	1469113.0

> showing 50 of 31,497 rows — these rows as CSV

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