PREVIEW / etf_30min / 2024-08-23

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-23.parquet
  size:    816 KB
  rows:    33,012

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-23 04:00:00	SPY	ETF	558.13	558.43	558.05	558.35	28291.0
2024-08-23 04:30:00	SPY	ETF	558.41	558.75	558.4	558.71	11767.0
2024-08-23 05:00:00	SPY	ETF	558.75	558.75	558.46	558.56	4365.0
2024-08-23 05:30:00	SPY	ETF	558.84	558.95	558.84	558.95	6932.0
2024-08-23 06:00:00	SPY	ETF	558.87	559.18	558.84	558.85	4383.0
2024-08-23 06:30:00	SPY	ETF	558.97	559.59	558.97	559.4	12168.0
2024-08-23 07:00:00	SPY	ETF	559.4	559.56	558.91	559.25	237890.0
2024-08-23 07:30:00	SPY	ETF	559.18	559.45	559.07	559.45	83617.0
2024-08-23 08:00:00	SPY	ETF	559.47	559.62	558.17	559.1512	103298.0
2024-08-23 08:30:00	SPY	ETF	559.18	559.82	559.14	559.8	76957.0
2024-08-23 09:00:00	SPY	ETF	559.79	559.95	559.46	559.54	261423.0
2024-08-23 09:30:00	SPY	ETF	559.53	559.83	558.83	559.78	3115781.0
2024-08-23 10:00:00	SPY	ETF	559.77	563.09	559.77	562.69	5664539.0
2024-08-23 10:30:00	SPY	ETF	562.71	562.85	558.35	560.53	4395057.0
2024-08-23 11:00:00	SPY	ETF	560.5	562.4	559.52	561.645	2168264.0
2024-08-23 11:30:00	SPY	ETF	561.66	562.5	559.95	560.0	1620821.0
2024-08-23 12:00:00	SPY	ETF	560.01	560.16	558.01	558.56	2026582.0
2024-08-23 12:30:00	SPY	ETF	558.59	559.71	557.29	559.2923	1738815.0
2024-08-23 13:00:00	SPY	ETF	559.25	560.43	558.96	560.27	976539.0
2024-08-23 13:30:00	SPY	ETF	560.27	561.0	560.16	560.39	1287252.0
2024-08-23 14:00:00	SPY	ETF	560.39	561.02	560.2	560.86	1348984.0
2024-08-23 14:30:00	SPY	ETF	560.86	561.19	560.37	560.76	1344543.0
2024-08-23 15:00:00	SPY	ETF	560.76	562.27	560.1623	562.17	1966402.0
2024-08-23 15:30:00	SPY	ETF	562.17	562.68	560.71	562.09	6175236.0
2024-08-23 16:00:00	SPY	ETF	562.09	562.45	561.78	562.31	2655435.0
2024-08-23 16:30:00	SPY	ETF	562.3	562.34	562.05	562.06	315499.0
2024-08-23 17:00:00	SPY	ETF	562.16	562.19	562.0068	562.1	44460.0
2024-08-23 17:30:00	SPY	ETF	562.1	562.22	562.0	562.05	35560.0
2024-08-23 18:00:00	SPY	ETF	562.05	562.22	562.05	562.22	10714.0
2024-08-23 18:30:00	SPY	ETF	562.15	562.25	562.13	562.25	2208.0
2024-08-23 19:00:00	SPY	ETF	562.25	562.3	562.16	562.16	5917.0
2024-08-23 19:30:00	SPY	ETF	562.24	562.4	562.12	562.29	18370.0
2024-08-23 04:00:00	QQQ	ETF	477.4	477.85	477.26	477.72	32503.0
2024-08-23 04:30:00	QQQ	ETF	477.84	478.15	477.7	478.11	11069.0
2024-08-23 05:00:00	QQQ	ETF	478.16	478.16	477.59	478.0	13436.0
2024-08-23 05:30:00	QQQ	ETF	478.07	478.36	478.05	478.33	11767.0
2024-08-23 06:00:00	QQQ	ETF	478.31	478.7	478.31	478.39	52839.0
2024-08-23 06:30:00	QQQ	ETF	478.41	479.2	478.41	478.84	88298.0
2024-08-23 07:00:00	QQQ	ETF	478.85	479.0	478.39	478.61	66071.0
2024-08-23 07:30:00	QQQ	ETF	478.621	478.83	478.49	478.78	30521.0
2024-08-23 08:00:00	QQQ	ETF	478.93	479.0796	475.206	478.44	128399.0
2024-08-23 08:30:00	QQQ	ETF	478.53	479.31	478.49	479.26	96078.0
2024-08-23 09:00:00	QQQ	ETF	479.27	479.75	478.9797	479.2	385049.0
2024-08-23 09:30:00	QQQ	ETF	479.23	479.42	478.02	479.08	2560551.0
2024-08-23 10:00:00	QQQ	ETF	479.17	482.74	479.13	482.1874	4802882.0
2024-08-23 10:30:00	QQQ	ETF	482.26	482.49	475.98	478.36	4008220.0
2024-08-23 11:00:00	QQQ	ETF	478.35	480.3	476.98	479.53	2283843.0
2024-08-23 11:30:00	QQQ	ETF	479.57	480.69	478.08	478.28	1432846.0
2024-08-23 12:00:00	QQQ	ETF	478.29	478.44	476.22	476.94	1535799.0
2024-08-23 12:30:00	QQQ	ETF	476.95	477.88	475.28	477.4	1546429.0

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

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