PREVIEW / etf_30min / 2024-06-21

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-21.parquet
  size:    791 KB
  rows:    31,725

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-06-21 04:00:00	SPY	ETF	544.93	545.02	544.23	544.35	56353.0
2024-06-21 04:30:00	SPY	ETF	544.29	544.44	543.92	544.23	41605.0
2024-06-21 05:00:00	SPY	ETF	544.36	544.62	544.07	544.59	6599.0
2024-06-21 05:30:00	SPY	ETF	544.85	544.93	544.61	544.72	4052.0
2024-06-21 06:00:00	SPY	ETF	544.81	545.03	544.57	544.57	5742.0
2024-06-21 06:30:00	SPY	ETF	544.5	544.92	544.26	544.78	6091.0
2024-06-21 07:00:00	SPY	ETF	544.82	545.37	544.81	545.23	43054.0
2024-06-21 07:30:00	SPY	ETF	545.24	545.24	544.46	544.52	94270.0
2024-06-21 08:00:00	SPY	ETF	544.94	546.09	544.12	544.34	179616.0
2024-06-21 08:30:00	SPY	ETF	544.38	545.17	544.3	545.17	147779.0
2024-06-21 09:00:00	SPY	ETF	545.12	545.35	544.17	544.43	481038.0
2024-06-21 09:30:00	SPY	ETF	544.47	544.86	543.02	543.85	4417985.0
2024-06-21 10:00:00	SPY	ETF	543.85	544.79	543.78	544.32	1942388.0
2024-06-21 10:30:00	SPY	ETF	544.31	544.9	543.86	544.81	1452217.0
2024-06-21 11:00:00	SPY	ETF	544.8	545.25	544.33	544.415	1675117.0
2024-06-21 11:30:00	SPY	ETF	544.42	545.54	544.0098	545.52	1526963.0
2024-06-21 12:00:00	SPY	ETF	545.55	545.65	545.0	545.25	912400.0
2024-06-21 12:30:00	SPY	ETF	545.26	545.33	544.455	544.5507	1063809.0
2024-06-21 13:00:00	SPY	ETF	544.54	544.84	543.88	544.0899	978574.0
2024-06-21 13:30:00	SPY	ETF	544.07	544.5	543.5589	543.96	1536759.0
2024-06-21 14:00:00	SPY	ETF	543.95	544.755	543.77	544.695	1748880.0
2024-06-21 14:30:00	SPY	ETF	544.69	544.6999	543.95	544.29	1163713.0
2024-06-21 15:00:00	SPY	ETF	544.3	544.845	544.25	544.395	1529017.0
2024-06-21 15:30:00	SPY	ETF	544.4	545.22	544.08	544.13	8673705.0
2024-06-21 16:00:00	SPY	ETF	544.1	544.94	544.05	544.77	7133231.0
2024-06-21 16:30:00	SPY	ETF	544.79	544.85	544.51	544.7	251874.0
2024-06-21 17:00:00	SPY	ETF	544.7	545.04	544.277	545.0	708313.0
2024-06-21 17:30:00	SPY	ETF	545.02	545.02	544.68	544.72	31775.0
2024-06-21 18:00:00	SPY	ETF	544.74	544.8	544.55	544.8	50066.0
2024-06-21 18:30:00	SPY	ETF	544.8	544.8	544.5	544.5	15461.0
2024-06-21 19:00:00	SPY	ETF	544.55	544.55	544.45	544.51	7589.0
2024-06-21 19:30:00	SPY	ETF	544.51	544.51	544.35	544.36	10914.0
2024-06-21 04:00:00	QQQ	ETF	481.44	482.58	480.03	480.09	162428.0
2024-06-21 04:30:00	QQQ	ETF	480.1	480.42	479.5	480.15	66343.0
2024-06-21 05:00:00	QQQ	ETF	480.21	480.82	480.01	480.64	43644.0
2024-06-21 05:30:00	QQQ	ETF	480.8	481.19	480.72	480.94	36366.0
2024-06-21 06:00:00	QQQ	ETF	481.01	481.45	480.79	480.79	24696.0
2024-06-21 06:30:00	QQQ	ETF	480.74	481.3	480.45	481.23	31940.0
2024-06-21 07:00:00	QQQ	ETF	481.18	481.82	481.18	481.61	46950.0
2024-06-21 07:30:00	QQQ	ETF	481.5	481.52	480.61	480.72	90554.0
2024-06-21 08:00:00	QQQ	ETF	481.37	482.51	479.51	480.59	151318.0
2024-06-21 08:30:00	QQQ	ETF	480.61	481.7	480.55	481.6	137855.0
2024-06-21 09:00:00	QQQ	ETF	481.65	481.85	481.1	481.16	386255.0
2024-06-21 09:30:00	QQQ	ETF	481.19	481.45	478.67	479.62	3215621.0
2024-06-21 10:00:00	QQQ	ETF	479.62	480.95	479.51	479.92	1960376.0
2024-06-21 10:30:00	QQQ	ETF	479.91	481.05	479.4	480.99	1168532.0
2024-06-21 11:00:00	QQQ	ETF	481.01	481.78	480.6	480.71	1133208.0
2024-06-21 11:30:00	QQQ	ETF	480.7	482.41	480.2399	482.41	1252674.0
2024-06-21 12:00:00	QQQ	ETF	482.41	482.535	481.56	481.82	877439.0
2024-06-21 12:30:00	QQQ	ETF	481.89	482.03	480.56	480.73	1044657.0

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

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