PREVIEW / etf_30min / 2024-06-27

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-27.parquet
  size:    787 KB
  rows:    31,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-06-27 04:00:00	SPY	ETF	544.7	544.84	544.41	544.41	12808.0
2024-06-27 04:30:00	SPY	ETF	544.43	544.72	544.43	544.72	4423.0
2024-06-27 05:00:00	SPY	ETF	544.68	545.01	544.6	545.01	4473.0
2024-06-27 05:30:00	SPY	ETF	545.0	545.05	544.9	545.03	4525.0
2024-06-27 06:00:00	SPY	ETF	545.0	545.19	544.96	545.19	3828.0
2024-06-27 06:30:00	SPY	ETF	545.2	545.35	545.15	545.16	4290.0
2024-06-27 07:00:00	SPY	ETF	545.18	545.18	544.77	545.0	20135.0
2024-06-27 07:30:00	SPY	ETF	544.99	545.16	544.92	544.95	41006.0
2024-06-27 08:00:00	SPY	ETF	545.05	545.1818	543.92	545.1	61671.0
2024-06-27 08:30:00	SPY	ETF	544.94	545.75	544.74	545.72	121032.0
2024-06-27 09:00:00	SPY	ETF	545.67	545.73	545.35	545.37	55975.0
2024-06-27 09:30:00	SPY	ETF	545.37	546.84	545.14	546.11	2593697.0
2024-06-27 10:00:00	SPY	ETF	546.1	546.96	545.76	546.53	1626494.0
2024-06-27 10:30:00	SPY	ETF	546.53	546.81	545.62	545.99	1380427.0
2024-06-27 11:00:00	SPY	ETF	545.97	546.04	544.92	545.29	1458490.0
2024-06-27 11:30:00	SPY	ETF	545.275	545.32	544.67	545.225	1410545.0
2024-06-27 12:00:00	SPY	ETF	545.25	546.02	545.1	545.86	1207257.0
2024-06-27 12:30:00	SPY	ETF	545.85	546.1	545.612	545.66	1116869.0
2024-06-27 13:00:00	SPY	ETF	545.64	546.34	545.64	546.305	774470.0
2024-06-27 13:30:00	SPY	ETF	546.31	546.43	545.78	545.78	626317.0
2024-06-27 14:00:00	SPY	ETF	545.79	545.8	544.64	544.77	1417088.0
2024-06-27 14:30:00	SPY	ETF	544.78	545.48	544.61	545.39	1391139.0
2024-06-27 15:00:00	SPY	ETF	545.4	545.81	545.23	545.765	832014.0
2024-06-27 15:30:00	SPY	ETF	545.76	546.4	545.18	546.35	4913977.0
2024-06-27 16:00:00	SPY	ETF	546.34	546.69	545.6308	546.52	2710002.0
2024-06-27 16:30:00	SPY	ETF	546.52	546.55	546.42	546.44	86130.0
2024-06-27 17:00:00	SPY	ETF	546.44	547.19	546.13	546.5	192306.0
2024-06-27 17:30:00	SPY	ETF	546.51	546.51	546.38	546.47	14621.0
2024-06-27 18:00:00	SPY	ETF	546.43	546.67	546.37	546.67	38536.0
2024-06-27 18:30:00	SPY	ETF	546.68	546.78	546.68	546.7	15849.0
2024-06-27 19:00:00	SPY	ETF	546.74	546.9	546.74	546.9	5775.0
2024-06-27 19:30:00	SPY	ETF	546.91	547.08	546.91	547.08	25869.0
2024-06-27 04:00:00	QQQ	ETF	479.13	479.33	478.76	478.9	20027.0
2024-06-27 04:30:00	QQQ	ETF	478.94	479.46	478.94	479.46	19524.0
2024-06-27 05:00:00	QQQ	ETF	479.3	479.72	479.19	479.62	9883.0
2024-06-27 05:30:00	QQQ	ETF	479.69	479.81	479.58	479.78	4618.0
2024-06-27 06:00:00	QQQ	ETF	479.71	480.11	479.67	480.1	22690.0
2024-06-27 06:30:00	QQQ	ETF	480.07	480.15	479.85	479.94	10771.0
2024-06-27 07:00:00	QQQ	ETF	479.93	479.93	479.4	479.651	109089.0
2024-06-27 07:30:00	QQQ	ETF	479.72	479.97	479.55	479.71	20164.0
2024-06-27 08:00:00	QQQ	ETF	479.42	480.0796	479.0904	479.55	75859.0
2024-06-27 08:30:00	QQQ	ETF	479.5	480.45	479.37	480.41	154559.0
2024-06-27 09:00:00	QQQ	ETF	480.43	480.48	480.1	480.18	57007.0
2024-06-27 09:30:00	QQQ	ETF	480.13	482.76	480.12	481.77	2753610.0
2024-06-27 10:00:00	QQQ	ETF	481.75	483.1	481.2803	482.24	1459038.0
2024-06-27 10:30:00	QQQ	ETF	482.23	482.34	480.41	481.0561	1201368.0
2024-06-27 11:00:00	QQQ	ETF	481.06	481.27	479.86	480.21	984354.0
2024-06-27 11:30:00	QQQ	ETF	480.2	480.24	479.3	480.13	1176424.0
2024-06-27 12:00:00	QQQ	ETF	480.1	481.295	479.92	481.14	744561.0
2024-06-27 12:30:00	QQQ	ETF	481.16	481.78	481.0461	481.12	618506.0

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

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