PREVIEW / etf_30min / 2025-05-19

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-19.parquet
  size:    992 KB
  rows:    40,910

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
2025-05-19 04:00:00	SPY	ETF	588.2	588.88	586.6	586.71	54155.0
2025-05-19 04:30:00	SPY	ETF	586.7	586.82	586.2	586.7	68244.0
2025-05-19 05:00:00	SPY	ETF	586.41	587.48	586.33	587.48	117703.0
2025-05-19 05:30:00	SPY	ETF	587.48	587.67	587.03	587.38	57447.0
2025-05-19 06:00:00	SPY	ETF	587.36	587.46	586.51	587.23	39371.0
2025-05-19 06:30:00	SPY	ETF	587.18	588.21	586.96	587.84	40681.0
2025-05-19 07:00:00	SPY	ETF	587.87	588.33	587.68	587.84	160933.0
2025-05-19 07:30:00	SPY	ETF	587.85	588.69	587.5	588.58	153231.0
2025-05-19 08:00:00	SPY	ETF	588.08	589.1	586.6004	587.87	207040.0
2025-05-19 08:30:00	SPY	ETF	587.88	588.74	587.74	588.67	261812.0
2025-05-19 09:00:00	SPY	ETF	588.64	588.77	587.1	588.12	877587.0
2025-05-19 09:30:00	SPY	ETF	588.1	591.41	588.09	591.24	6600960.0
2025-05-19 10:00:00	SPY	ETF	591.24	593.3	591.05	592.25	5239272.0
2025-05-19 10:30:00	SPY	ETF	592.26	592.91	591.61	592.015	2105143.0
2025-05-19 11:00:00	SPY	ETF	592.02	592.87	591.95	592.3565	1726155.0
2025-05-19 11:30:00	SPY	ETF	592.35	593.77	588.51	593.1	1956304.0
2025-05-19 12:00:00	SPY	ETF	593.1057	594.14	588.9495	593.9622	1667490.0
2025-05-19 12:30:00	SPY	ETF	593.98	594.76	593.57	594.54	2262664.0
2025-05-19 13:00:00	SPY	ETF	594.54	595.54	594.45	595.11	3156613.0
2025-05-19 13:30:00	SPY	ETF	595.11	595.4766	589.57	594.36	2156187.0
2025-05-19 14:00:00	SPY	ETF	594.36	594.55	593.335	593.75	2571152.0
2025-05-19 14:30:00	SPY	ETF	593.76	594.5	593.59	594.39	2067200.0
2025-05-19 15:00:00	SPY	ETF	594.4	594.66	593.16	593.545	2664801.0
2025-05-19 15:30:00	SPY	ETF	593.56	595.25	593.515	594.94	7638535.0
2025-05-19 16:00:00	SPY	ETF	594.94	595.05	593.87	594.33	3390775.0
2025-05-19 16:30:00	SPY	ETF	594.3108	594.88	594.25	594.85	114189.0
2025-05-19 17:00:00	SPY	ETF	594.8	594.81	594.5218	594.75	63755.0
2025-05-19 17:30:00	SPY	ETF	594.8024	594.96	594.75	594.77	50456.0
2025-05-19 18:00:00	SPY	ETF	594.74	594.959	594.46	594.73	44418.0
2025-05-19 18:30:00	SPY	ETF	594.731	594.83	594.66	594.72	18208.0
2025-05-19 19:00:00	SPY	ETF	594.8099	595.46	594.7	595.43	41000.0
2025-05-19 19:30:00	SPY	ETF	595.38	596.05	595.2	595.54	64471.0
2025-05-19 04:00:00	QQQ	ETF	514.14	514.14	512.55	512.62	124182.0
2025-05-19 04:30:00	QQQ	ETF	512.61	512.84	512.09	512.64	96513.0
2025-05-19 05:00:00	QQQ	ETF	512.58	513.45	512.26	513.44	60586.0
2025-05-19 05:30:00	QQQ	ETF	513.53	513.7	513.06	513.4	39250.0
2025-05-19 06:00:00	QQQ	ETF	513.4	513.48	512.56	513.34	56590.0
2025-05-19 06:30:00	QQQ	ETF	513.34	514.34	513.0	513.88	75789.0
2025-05-19 07:00:00	QQQ	ETF	513.9	514.5	513.78	513.81	166233.0
2025-05-19 07:30:00	QQQ	ETF	513.76	514.56	513.34	514.36	107260.0
2025-05-19 08:00:00	QQQ	ETF	513.88	516.3	512.5604	513.64	295917.0
2025-05-19 08:30:00	QQQ	ETF	513.64	514.59	513.4	514.54	217196.0
2025-05-19 09:00:00	QQQ	ETF	514.54	514.64	513.12	514.29	554694.0
2025-05-19 09:30:00	QQQ	ETF	514.3	518.44	514.24	518.01	5670696.0
2025-05-19 10:00:00	QQQ	ETF	517.99	520.95	517.8	519.1667	4049750.0
2025-05-19 10:30:00	QQQ	ETF	519.19	519.88	518.52	518.8999	1732530.0
2025-05-19 11:00:00	QQQ	ETF	518.91	519.89	518.57	519.16	1718389.0
2025-05-19 11:30:00	QQQ	ETF	519.17	520.88	519.04	519.87	1636576.0
2025-05-19 12:00:00	QQQ	ETF	519.88	520.92	516.3	520.78	1082413.0
2025-05-19 12:30:00	QQQ	ETF	520.79	521.54	520.14	521.435	1356915.0

> showing 50 of 40,910 rows — these rows as CSV

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