PREVIEW / etf_30min / 2024-11-18

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-18.parquet
  size:    910 KB
  rows:    36,983

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-11-18 04:00:00	SPY	ETF	587.66	587.66	585.78	586.25	55535.0
2024-11-18 04:30:00	SPY	ETF	586.05	586.26	585.71	585.96	8112.0
2024-11-18 05:00:00	SPY	ETF	586.03	586.08	585.86	586.07	2710.0
2024-11-18 05:30:00	SPY	ETF	586.07	586.58	586.01	586.58	6204.0
2024-11-18 06:00:00	SPY	ETF	586.58	586.58	586.16	586.2	8523.0
2024-11-18 06:30:00	SPY	ETF	586.31	586.31	585.81	586.04	26932.0
2024-11-18 07:00:00	SPY	ETF	586.15	586.39	585.94	586.21	17075.0
2024-11-18 07:30:00	SPY	ETF	586.26	586.55	585.99	586.27	95335.0
2024-11-18 08:00:00	SPY	ETF	586.1483	587.75	584.79	585.21	144989.0
2024-11-18 08:30:00	SPY	ETF	585.18	586.38	585.16	586.15	123870.0
2024-11-18 09:00:00	SPY	ETF	586.24	586.73	586.14	586.21	185348.0
2024-11-18 09:30:00	SPY	ETF	586.22	586.39	585.34	585.72	2298856.0
2024-11-18 10:00:00	SPY	ETF	585.75	587.39	585.59	587.36	1620772.0
2024-11-18 10:30:00	SPY	ETF	587.37	588.35	587.3038	588.21	1836024.0
2024-11-18 11:00:00	SPY	ETF	588.23	589.14	588.0999	588.65	1211665.0
2024-11-18 11:30:00	SPY	ETF	588.65	589.49	587.9301	588.2805	1605851.0
2024-11-18 12:00:00	SPY	ETF	588.29	588.52	587.83	588.37	798414.0
2024-11-18 12:30:00	SPY	ETF	588.34	588.68	587.75	588.65	911284.0
2024-11-18 13:00:00	SPY	ETF	588.65	588.65	588.11	588.14	565795.0
2024-11-18 13:30:00	SPY	ETF	588.14	588.446	587.02	588.36	1130687.0
2024-11-18 14:00:00	SPY	ETF	588.35	588.39	587.08	587.28	1138424.0
2024-11-18 14:30:00	SPY	ETF	587.28	588.34	587.11	588.095	967657.0
2024-11-18 15:00:00	SPY	ETF	588.08	588.41	587.96	588.395	1087267.0
2024-11-18 15:30:00	SPY	ETF	588.38	588.39	587.5143	588.14	5927237.0
2024-11-18 16:00:00	SPY	ETF	588.15	588.32	587.77	587.94	1789440.0
2024-11-18 16:30:00	SPY	ETF	587.94	588.15	587.83	588.03	97461.0
2024-11-18 17:00:00	SPY	ETF	588.0	588.05	587.95	588.0	39842.0
2024-11-18 17:30:00	SPY	ETF	588.04	588.1	588.03	588.1	7967.0
2024-11-18 18:00:00	SPY	ETF	588.08	588.08	587.43	587.75	56075.0
2024-11-18 18:30:00	SPY	ETF	587.74	587.9	587.73	587.88	7036.0
2024-11-18 19:00:00	SPY	ETF	587.88	588.44	587.86	588.36	19966.0
2024-11-18 19:30:00	SPY	ETF	588.21	588.21	587.759	588.04	24756.0
2024-11-18 04:00:00	QQQ	ETF	500.04	500.04	498.53	498.73	53861.0
2024-11-18 04:30:00	QQQ	ETF	498.75	498.92	497.89	498.17	58727.0
2024-11-18 05:00:00	QQQ	ETF	498.22	498.64	498.09	498.6	31827.0
2024-11-18 05:30:00	QQQ	ETF	498.41	498.9	498.33	498.88	17698.0
2024-11-18 06:00:00	QQQ	ETF	498.94	498.94	498.39	498.39	13641.0
2024-11-18 06:30:00	QQQ	ETF	498.69	498.73	498.1	498.47	29999.0
2024-11-18 07:00:00	QQQ	ETF	498.46	498.75	498.13	498.38	75023.0
2024-11-18 07:30:00	QQQ	ETF	498.34	498.62	497.95	498.23	63344.0
2024-11-18 08:00:00	QQQ	ETF	498.4	500.4	496.3444	496.83	368251.0
2024-11-18 08:30:00	QQQ	ETF	496.85	498.23	496.82	498.02	185737.0
2024-11-18 09:00:00	QQQ	ETF	498.08	498.88	498.08	498.13	174733.0
2024-11-18 09:30:00	QQQ	ETF	498.13	498.45	496.73	497.44	2868124.0
2024-11-18 10:00:00	QQQ	ETF	497.45	500.43	497.27	500.41	1587007.0
2024-11-18 10:30:00	QQQ	ETF	500.41	501.45	500.3601	501.1064	1639359.0
2024-11-18 11:00:00	QQQ	ETF	501.12	501.9877	500.9799	501.49	1414403.0
2024-11-18 11:30:00	QQQ	ETF	501.48	502.14	500.13	500.71	1303587.0
2024-11-18 12:00:00	QQQ	ETF	500.7151	500.89	500.09	500.55	731872.0
2024-11-18 12:30:00	QQQ	ETF	500.56	500.715	499.61	500.68	962099.0

> showing 50 of 36,983 rows — these rows as CSV

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