PREVIEW / etf_30min / 2024-10-11

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-11.parquet
  size:    834 KB
  rows:    32,868

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-10-11 04:00:00	SPY	ETF	575.68	576.1	575.6	575.82	10427.0
2024-10-11 04:30:00	SPY	ETF	575.76	575.87	575.27	575.28	4497.0
2024-10-11 05:00:00	SPY	ETF	575.37	575.74	575.28	575.5	13529.0
2024-10-11 05:30:00	SPY	ETF	575.56	575.56	575.3	575.3	8466.0
2024-10-11 06:00:00	SPY	ETF	575.35	575.95	575.35	575.95	2192.0
2024-10-11 06:30:00	SPY	ETF	575.76	576.28	575.74	576.25	16224.0
2024-10-11 07:00:00	SPY	ETF	576.18	576.33	575.92	575.95	14013.0
2024-10-11 07:30:00	SPY	ETF	575.95	576.03	575.86	575.88	35608.0
2024-10-11 08:00:00	SPY	ETF	576.0	576.83	575.38	576.29	65671.0
2024-10-11 08:30:00	SPY	ETF	576.43	577.0	575.82	576.19	240544.0
2024-10-11 09:00:00	SPY	ETF	576.3	576.35	575.93	576.03	89258.0
2024-10-11 09:30:00	SPY	ETF	576.05	577.52	575.91	577.39	2605924.0
2024-10-11 10:00:00	SPY	ETF	577.39	580.095	577.01	579.78	3273424.0
2024-10-11 10:30:00	SPY	ETF	579.76	580.0	578.7	579.08	2328303.0
2024-10-11 11:00:00	SPY	ETF	579.07	579.77	579.0	579.18	1220521.0
2024-10-11 11:30:00	SPY	ETF	579.19	579.65	579.12	579.64	888930.0
2024-10-11 12:00:00	SPY	ETF	579.64	579.64	578.43	578.75	1439209.0
2024-10-11 12:30:00	SPY	ETF	578.74	578.9266	578.07	578.86	1319357.0
2024-10-11 13:00:00	SPY	ETF	578.87	579.08	578.385	578.8698	892576.0
2024-10-11 13:30:00	SPY	ETF	578.86	579.37	578.6537	579.14	748395.0
2024-10-11 14:00:00	SPY	ETF	579.13	579.9	579.0001	579.46	1124201.0
2024-10-11 14:30:00	SPY	ETF	579.47	579.725	578.79	579.7	1199007.0
2024-10-11 15:00:00	SPY	ETF	579.705	580.33	579.57	580.0595	1714940.0
2024-10-11 15:30:00	SPY	ETF	580.055	580.32	579.46	579.55	4675741.0
2024-10-11 16:00:00	SPY	ETF	579.53	579.69	579.041	579.1	4065824.0
2024-10-11 16:30:00	SPY	ETF	579.09	579.26	578.8715	578.99	436809.0
2024-10-11 17:00:00	SPY	ETF	579.0	579.24	578.99	579.2	46880.0
2024-10-11 17:30:00	SPY	ETF	579.12	579.12	578.24	578.32	116845.0
2024-10-11 18:00:00	SPY	ETF	578.31	578.48	578.08	578.4199	40302.0
2024-10-11 18:30:00	SPY	ETF	578.39	578.52	578.39	578.52	9353.0
2024-10-11 19:00:00	SPY	ETF	578.51	578.68	578.51	578.62	2711.0
2024-10-11 19:30:00	SPY	ETF	578.59	578.65	578.4	578.61	12725.0
2024-10-11 04:00:00	QQQ	ETF	492.43	492.48	491.4	491.69	21355.0
2024-10-11 04:30:00	QQQ	ETF	491.75	491.95	491.17	491.17	22802.0
2024-10-11 05:00:00	QQQ	ETF	491.23	491.77	491.21	491.51	19796.0
2024-10-11 05:30:00	QQQ	ETF	491.53	491.76	491.24	491.45	18604.0
2024-10-11 06:00:00	QQQ	ETF	491.45	491.84	491.22	491.79	9279.0
2024-10-11 06:30:00	QQQ	ETF	491.7	491.82	491.5	491.73	30218.0
2024-10-11 07:00:00	QQQ	ETF	491.77	491.9	491.37	491.45	33860.0
2024-10-11 07:30:00	QQQ	ETF	491.45	491.61	491.36	491.42	47767.0
2024-10-11 08:00:00	QQQ	ETF	491.5085	493.47	491.3196	491.71	116556.0
2024-10-11 08:30:00	QQQ	ETF	492.0	492.83	491.15	491.4101	174175.0
2024-10-11 09:00:00	QQQ	ETF	491.58	491.68	490.76	490.77	136925.0
2024-10-11 09:30:00	QQQ	ETF	490.74	491.48	490.17	491.19	1826617.0
2024-10-11 10:00:00	QQQ	ETF	491.14	494.1	490.63	493.52	2293605.0
2024-10-11 10:30:00	QQQ	ETF	493.505	494.04	491.93	492.83	1851381.0
2024-10-11 11:00:00	QQQ	ETF	492.84	493.69	492.29	492.84	1182175.0
2024-10-11 11:30:00	QQQ	ETF	492.8788	493.84	492.755	493.78	794640.0
2024-10-11 12:00:00	QQQ	ETF	493.78	493.83	492.81	493.14	828809.0
2024-10-11 12:30:00	QQQ	ETF	493.06	493.19	492.27	493.125	652230.0

> showing 50 of 32,868 rows — these rows as CSV

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