PREVIEW / etf_30min / 2024-08-19

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-19.parquet
  size:    830 KB
  rows:    33,585

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-19 04:00:00	SPY	ETF	554.15	554.15	553.24	553.96	19219.0
2024-08-19 04:30:00	SPY	ETF	553.89	554.24	553.72	554.23	12498.0
2024-08-19 05:00:00	SPY	ETF	553.97	554.17	553.73	554.17	3172.0
2024-08-19 05:30:00	SPY	ETF	554.17	554.26	554.02	554.14	4209.0
2024-08-19 06:00:00	SPY	ETF	554.17	554.55	554.17	554.32	7890.0
2024-08-19 06:30:00	SPY	ETF	554.38	554.38	554.1	554.1	114292.0
2024-08-19 07:00:00	SPY	ETF	554.05	554.64	554.04	554.6	35993.0
2024-08-19 07:30:00	SPY	ETF	554.63	554.68	554.43	554.53	67020.0
2024-08-19 08:00:00	SPY	ETF	554.56	554.98	553.74	554.92	115409.0
2024-08-19 08:30:00	SPY	ETF	554.9	554.93	554.66	554.85	82041.0
2024-08-19 09:00:00	SPY	ETF	554.85	555.33	554.69	554.74	179387.0
2024-08-19 09:30:00	SPY	ETF	554.73	555.5313	554.52	554.98	2805840.0
2024-08-19 10:00:00	SPY	ETF	554.98	555.68	553.86	555.355	2028767.0
2024-08-19 10:30:00	SPY	ETF	555.36	556.6766	555.27	556.52	1357583.0
2024-08-19 11:00:00	SPY	ETF	556.53	556.75	556.15	556.515	1242967.0
2024-08-19 11:30:00	SPY	ETF	556.51	556.96	555.78	556.1926	1515404.0
2024-08-19 12:00:00	SPY	ETF	556.21	556.83	555.93	556.77	808939.0
2024-08-19 12:30:00	SPY	ETF	556.77	557.47	556.5	557.31	1075522.0
2024-08-19 13:00:00	SPY	ETF	557.3	557.43	556.94	557.12	914413.0
2024-08-19 13:30:00	SPY	ETF	557.13	557.56	556.89	557.55	870183.0
2024-08-19 14:00:00	SPY	ETF	557.54	557.76	557.355	557.7	1478742.0
2024-08-19 14:30:00	SPY	ETF	557.7	558.48	557.69	558.1584	1485965.0
2024-08-19 15:00:00	SPY	ETF	558.16	558.3	557.81	558.2	2040240.0
2024-08-19 15:30:00	SPY	ETF	558.2	559.58	557.94	559.56	7300722.0
2024-08-19 16:00:00	SPY	ETF	559.56	559.64	558.85	559.09	2350065.0
2024-08-19 16:30:00	SPY	ETF	559.08	559.27	559.01	559.01	122990.0
2024-08-19 17:00:00	SPY	ETF	559.06	559.2	559.06	559.13	349437.0
2024-08-19 17:30:00	SPY	ETF	559.1	559.61	559.07	559.61	130785.0
2024-08-19 18:00:00	SPY	ETF	559.26	559.61	559.26	559.57	65986.0
2024-08-19 18:30:00	SPY	ETF	559.54	559.56	559.371	559.46	8352.0
2024-08-19 19:00:00	SPY	ETF	559.37	559.39	559.3	559.3	4646.0
2024-08-19 19:30:00	SPY	ETF	559.4	559.44	559.24	559.31	31080.0
2024-08-19 04:00:00	QQQ	ETF	474.6	474.77	473.25	474.04	59664.0
2024-08-19 04:30:00	QQQ	ETF	474.04	474.3	473.79	474.3	8936.0
2024-08-19 05:00:00	QQQ	ETF	474.31	474.33	473.7	474.33	5460.0
2024-08-19 05:30:00	QQQ	ETF	474.37	474.63	474.16	474.58	9246.0
2024-08-19 06:00:00	QQQ	ETF	474.46	475.13	474.46	474.95	24336.0
2024-08-19 06:30:00	QQQ	ETF	474.9	475.07	474.5	474.5	24515.0
2024-08-19 07:00:00	QQQ	ETF	474.55	475.45	474.49	475.33	45759.0
2024-08-19 07:30:00	QQQ	ETF	475.36	475.39	475.13	475.3	58292.0
2024-08-19 08:00:00	QQQ	ETF	474.62	476.11	474.13	475.8201	83265.0
2024-08-19 08:30:00	QQQ	ETF	475.85	475.85	475.49	475.57	80202.0
2024-08-19 09:00:00	QQQ	ETF	475.63	475.97	475.07	475.1	143493.0
2024-08-19 09:30:00	QQQ	ETF	475.17	475.67	473.71	474.74	2601291.0
2024-08-19 10:00:00	QQQ	ETF	474.77	475.62	473.37	475.32	1731598.0
2024-08-19 10:30:00	QQQ	ETF	475.34	476.52	474.88	476.35	1120499.0
2024-08-19 11:00:00	QQQ	ETF	476.3338	476.9	475.8126	476.43	786159.0
2024-08-19 11:30:00	QQQ	ETF	476.42	476.95	475.52	475.95	736464.0
2024-08-19 12:00:00	QQQ	ETF	475.96	476.5711	475.545	476.5711	630531.0
2024-08-19 12:30:00	QQQ	ETF	476.52	477.42	476.145	477.26	714666.0

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

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