PREVIEW / etf_30min / 2024-10-22

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-22.parquet
  size:    856 KB
  rows:    34,291

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-22 04:00:00	SPY	ETF	582.78	582.78	582.17	582.31	14204.0
2024-10-22 04:30:00	SPY	ETF	582.25	582.29	581.72	582.29	2746.0
2024-10-22 05:00:00	SPY	ETF	581.65	581.74	580.91	580.97	26175.0
2024-10-22 05:30:00	SPY	ETF	580.99	581.44	580.56	580.76	23755.0
2024-10-22 06:00:00	SPY	ETF	580.77	581.29	580.63	581.01	7775.0
2024-10-22 06:30:00	SPY	ETF	581.0	581.21	580.64	580.88	40047.0
2024-10-22 07:00:00	SPY	ETF	580.9	581.49	580.88	581.39	95330.0
2024-10-22 07:30:00	SPY	ETF	581.38	581.46	580.89	581.12	45937.0
2024-10-22 08:00:00	SPY	ETF	580.97	582.89	580.7596	581.41	106278.0
2024-10-22 08:30:00	SPY	ETF	581.42	581.5096	580.31	580.93	234679.0
2024-10-22 09:00:00	SPY	ETF	580.92	581.3	580.05	581.1	427267.0
2024-10-22 09:30:00	SPY	ETF	581.05	581.5	580.38	581.32	2750482.0
2024-10-22 10:00:00	SPY	ETF	581.33	582.24	581.03	581.41	1736998.0
2024-10-22 10:30:00	SPY	ETF	581.43	582.18	581.02	581.99	1186093.0
2024-10-22 11:00:00	SPY	ETF	581.985	582.5	581.54	582.078	1078134.0
2024-10-22 11:30:00	SPY	ETF	582.06	582.35	582.01	582.02	725633.0
2024-10-22 12:00:00	SPY	ETF	582.01	582.19	581.57	581.76	794969.0
2024-10-22 12:30:00	SPY	ETF	581.76	582.6592	581.7	582.5601	879489.0
2024-10-22 13:00:00	SPY	ETF	582.57	582.71	582.28	582.66	543100.0
2024-10-22 13:30:00	SPY	ETF	582.67	583.98	582.6302	583.98	1523947.0
2024-10-22 14:00:00	SPY	ETF	583.96	584.5	583.48	583.68	1487521.0
2024-10-22 14:30:00	SPY	ETF	583.69	583.71	582.85	583.0201	1155047.0
2024-10-22 15:00:00	SPY	ETF	583.01	583.7	582.89	583.64	1311148.0
2024-10-22 15:30:00	SPY	ETF	583.65	584.26	583.23	583.32	3572796.0
2024-10-22 16:00:00	SPY	ETF	583.32	583.4	582.83	583.02	3225384.0
2024-10-22 16:30:00	SPY	ETF	583.0008	583.11	582.8	582.8	258382.0
2024-10-22 17:00:00	SPY	ETF	582.83	582.95	582.78	582.91	18027.0
2024-10-22 17:30:00	SPY	ETF	582.93	583.32	582.87	582.95	433719.0
2024-10-22 18:00:00	SPY	ETF	582.92	582.92	582.28	582.52	70105.0
2024-10-22 18:30:00	SPY	ETF	582.5	582.54	582.47	582.48	14289.0
2024-10-22 19:00:00	SPY	ETF	582.55	582.67	582.45	582.65	14902.0
2024-10-22 19:30:00	SPY	ETF	582.67	583.12	582.67	583.07	16773.0
2024-10-22 04:00:00	QQQ	ETF	494.5	494.5	493.89	494.1	24956.0
2024-10-22 04:30:00	QQQ	ETF	494.17	494.17	493.48	493.5	11136.0
2024-10-22 05:00:00	QQQ	ETF	493.33	493.39	492.31	492.37	57835.0
2024-10-22 05:30:00	QQQ	ETF	492.59	492.83	492.1	492.37	33212.0
2024-10-22 06:00:00	QQQ	ETF	492.31	492.95	492.09	492.49	23012.0
2024-10-22 06:30:00	QQQ	ETF	492.65	492.81	492.29	492.55	24950.0
2024-10-22 07:00:00	QQQ	ETF	492.55	493.47	492.55	493.39	250944.0
2024-10-22 07:30:00	QQQ	ETF	493.35	493.47	492.7	492.93	141674.0
2024-10-22 08:00:00	QQQ	ETF	492.82	494.6	492.2404	493.16	228449.0
2024-10-22 08:30:00	QQQ	ETF	493.25	493.36	491.74	492.56	288675.0
2024-10-22 09:00:00	QQQ	ETF	492.55	492.73	491.81	492.7	147245.0
2024-10-22 09:30:00	QQQ	ETF	492.72	494.57	491.97	494.11	3230051.0
2024-10-22 10:00:00	QQQ	ETF	494.186	495.5	493.63	494.7501	1727451.0
2024-10-22 10:30:00	QQQ	ETF	494.79	495.31	493.84	494.87	1319984.0
2024-10-22 11:00:00	QQQ	ETF	494.87	495.31	494.0	494.535	1039090.0
2024-10-22 11:30:00	QQQ	ETF	494.51	494.83	494.2623	494.4075	506123.0
2024-10-22 12:00:00	QQQ	ETF	494.3902	494.42	493.39	493.55	1272450.0
2024-10-22 12:30:00	QQQ	ETF	493.54	495.11	493.27	494.99	1293709.0

> showing 50 of 34,291 rows — these rows as CSV

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