PREVIEW / etf_30min / 2024-08-26

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-26.parquet
  size:    818 KB
  rows:    33,399

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-08-26 04:00:00	SPY	ETF	562.13	563.39	562.13	563.11	7416.0
2024-08-26 04:30:00	SPY	ETF	563.28	563.39	563.16	563.39	3394.0
2024-08-26 05:00:00	SPY	ETF	563.4	563.4	563.09	563.19	1891.0
2024-08-26 05:30:00	SPY	ETF	563.23	563.26	563.07	563.24	1400.0
2024-08-26 06:00:00	SPY	ETF	563.2	563.35	563.2	563.3	1750.0
2024-08-26 06:30:00	SPY	ETF	563.33	563.33	562.9	563.24	9993.0
2024-08-26 07:00:00	SPY	ETF	563.22	563.4	563.01	563.01	51093.0
2024-08-26 07:30:00	SPY	ETF	563.02	563.2	562.34	562.95	73163.0
2024-08-26 08:00:00	SPY	ETF	563.37	563.41	561.81	563.09	80869.0
2024-08-26 08:30:00	SPY	ETF	563.07	563.2	562.59	563.2	95546.0
2024-08-26 09:00:00	SPY	ETF	563.17	563.46	562.97	563.13	188790.0
2024-08-26 09:30:00	SPY	ETF	563.14	563.91	562.68	563.0	4045604.0
2024-08-26 10:00:00	SPY	ETF	563.02	563.1701	561.5	561.9	2023116.0
2024-08-26 10:30:00	SPY	ETF	561.9	561.92	560.16	561.11	1975857.0
2024-08-26 11:00:00	SPY	ETF	561.1	561.33	560.4701	560.64	1098364.0
2024-08-26 11:30:00	SPY	ETF	560.63	560.98	559.78	559.995	1097219.0
2024-08-26 12:00:00	SPY	ETF	559.98	561.2328	559.72	561.15	1076677.0
2024-08-26 12:30:00	SPY	ETF	561.18	561.66	561.12	561.5	865867.0
2024-08-26 13:00:00	SPY	ETF	561.48	561.71	560.84	560.96	822292.0
2024-08-26 13:30:00	SPY	ETF	560.96	561.1	559.2	559.5	1141294.0
2024-08-26 14:00:00	SPY	ETF	559.51	560.36	559.05	560.26	1229460.0
2024-08-26 14:30:00	SPY	ETF	560.24	560.91	560.0227	560.84	1069230.0
2024-08-26 15:00:00	SPY	ETF	560.82	560.89	560.31	560.45	1182778.0
2024-08-26 15:30:00	SPY	ETF	560.45	560.83	559.85	560.73	5112958.0
2024-08-26 16:00:00	SPY	ETF	560.73	560.79	560.1	560.21	2471204.0
2024-08-26 16:30:00	SPY	ETF	560.17	560.25	559.8	560.01	82988.0
2024-08-26 17:00:00	SPY	ETF	560.01	560.23	559.99	560.05	33833.0
2024-08-26 17:30:00	SPY	ETF	559.97	560.05	559.84	559.93	28513.0
2024-08-26 18:00:00	SPY	ETF	559.95	560.3	559.52	559.6902	51938.0
2024-08-26 18:30:00	SPY	ETF	559.63	559.66	559.32	559.59	10416.0
2024-08-26 19:00:00	SPY	ETF	559.6	560.31	559.6	560.28	10758.0
2024-08-26 19:30:00	SPY	ETF	560.29	560.3	560.19	560.29	12536.0
2024-08-26 04:00:00	QQQ	ETF	481.0	481.43	480.75	481.11	15785.0
2024-08-26 04:30:00	QQQ	ETF	481.1	481.44	481.1	481.44	5391.0
2024-08-26 05:00:00	QQQ	ETF	481.39	481.39	481.05	481.29	5656.0
2024-08-26 05:30:00	QQQ	ETF	481.19	481.26	481.1	481.25	17968.0
2024-08-26 06:00:00	QQQ	ETF	481.2	481.41	481.18	481.28	4937.0
2024-08-26 06:30:00	QQQ	ETF	481.25	481.25	480.35	480.55	41754.0
2024-08-26 07:00:00	QQQ	ETF	480.6	480.81	480.049	480.11	51780.0
2024-08-26 07:30:00	QQQ	ETF	480.11	480.3	479.1	479.74	85969.0
2024-08-26 08:00:00	QQQ	ETF	479.75	481.44	479.06	479.95	84334.0
2024-08-26 08:30:00	QQQ	ETF	479.85	479.94	479.12	479.78	87581.0
2024-08-26 09:00:00	QQQ	ETF	479.68	479.96	479.42	479.44	89002.0
2024-08-26 09:30:00	QQQ	ETF	479.44	480.38	478.18	478.44	2378326.0
2024-08-26 10:00:00	QQQ	ETF	478.46	478.6287	475.69	475.95	2090233.0
2024-08-26 10:30:00	QQQ	ETF	475.91	475.96	473.24	475.54	3177039.0
2024-08-26 11:00:00	QQQ	ETF	475.53	476.32	475.08	475.75	1619457.0
2024-08-26 11:30:00	QQQ	ETF	475.61	475.99	474.23	474.46	1393889.0
2024-08-26 12:00:00	QQQ	ETF	474.4	475.98	474.12	475.915	1034508.0
2024-08-26 12:30:00	QQQ	ETF	475.91	476.56	475.65	475.97	865770.0

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

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