PREVIEW / etf_30min / 2023-10-06

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-06.parquet
  size:    734 KB
  rows:    28,465

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
2023-10-06 04:00:00	SPY	ETF	424.65	425.01	424.65	424.84	32422.0
2023-10-06 04:30:00	SPY	ETF	424.87	424.87	424.36	424.5	15218.0
2023-10-06 05:00:00	SPY	ETF	424.54	424.94	424.42	424.94	15175.0
2023-10-06 05:30:00	SPY	ETF	424.89	425.05	424.77	425.01	3017.0
2023-10-06 06:00:00	SPY	ETF	425.12	425.68	425.05	425.67	18145.0
2023-10-06 06:30:00	SPY	ETF	425.62	425.84	425.37	425.51	24469.0
2023-10-06 07:00:00	SPY	ETF	425.42	425.581	425.03	425.19	81440.0
2023-10-06 07:30:00	SPY	ETF	425.2	425.24	424.74	424.809	86436.0
2023-10-06 08:00:00	SPY	ETF	425.34	425.8204	423.66	424.61	247101.0
2023-10-06 08:30:00	SPY	ETF	424.5	424.64	419.7	420.51	2526902.0
2023-10-06 09:00:00	SPY	ETF	420.48	422.81	420.19	421.99	1470190.0
2023-10-06 09:30:00	SPY	ETF	421.97	423.0	421.0	421.91	8293381.0
2023-10-06 10:00:00	SPY	ETF	421.94	423.04	420.6	422.99	7765936.0
2023-10-06 10:30:00	SPY	ETF	422.99	424.32	422.98	423.81	6579279.0
2023-10-06 11:00:00	SPY	ETF	423.82	426.205	423.782	425.79	6848098.0
2023-10-06 11:30:00	SPY	ETF	425.8	428.9	425.8	428.879	7120310.0
2023-10-06 12:00:00	SPY	ETF	428.88	429.28	427.8	428.26	7340814.0
2023-10-06 12:30:00	SPY	ETF	428.26	428.72	427.66	428.25	3865970.0
2023-10-06 13:00:00	SPY	ETF	428.28	429.69	428.085	429.44	3912382.0
2023-10-06 13:30:00	SPY	ETF	429.439	429.87	429.05	429.74	3555281.0
2023-10-06 14:00:00	SPY	ETF	429.74	430.465	429.34	430.4441	3662208.0
2023-10-06 14:30:00	SPY	ETF	430.44	431.125	430.26	430.69	4838055.0
2023-10-06 15:00:00	SPY	ETF	430.69	430.83	430.115	430.77	4389169.0
2023-10-06 15:30:00	SPY	ETF	430.77	430.95	429.38	429.52	15991496.0
2023-10-06 16:00:00	SPY	ETF	429.52	430.9099	421.1825	429.83	4434166.0
2023-10-06 16:30:00	SPY	ETF	429.83	429.89	429.72	429.8	172677.0
2023-10-06 17:00:00	SPY	ETF	429.8	429.87	429.75	429.78	18877.0
2023-10-06 17:30:00	SPY	ETF	429.76	429.95	429.76	429.94	13046.0
2023-10-06 18:00:00	SPY	ETF	429.95	430.1	429.92	429.92	15886.0
2023-10-06 18:30:00	SPY	ETF	429.8301	429.9	429.74	429.89	17087.0
2023-10-06 19:00:00	SPY	ETF	429.89	430.05	429.89	429.91	15947.0
2023-10-06 19:30:00	SPY	ETF	429.9	430.15	429.9	430.15	12000.0
2023-10-06 04:00:00	QQQ	ETF	359.23	359.41	358.59	359.12	30175.0
2023-10-06 04:30:00	QQQ	ETF	359.07	359.07	358.68	358.84	9318.0
2023-10-06 05:00:00	QQQ	ETF	358.88	359.24	358.8	359.24	14277.0
2023-10-06 05:30:00	QQQ	ETF	359.24	359.35	359.0	359.29	11119.0
2023-10-06 06:00:00	QQQ	ETF	359.26	359.88	359.2	359.88	22451.0
2023-10-06 06:30:00	QQQ	ETF	359.89	360.07	359.6	359.72	21124.0
2023-10-06 07:00:00	QQQ	ETF	359.7	359.91	359.25	359.38	66772.0
2023-10-06 07:30:00	QQQ	ETF	359.33	359.44	358.91	358.99	54523.0
2023-10-06 08:00:00	QQQ	ETF	358.98	359.9396	358.07	359.1	173425.0
2023-10-06 08:30:00	QQQ	ETF	359.08	359.08	353.78	354.38	3550753.0
2023-10-06 09:00:00	QQQ	ETF	354.33	356.35	354.06	355.66	1416279.0
2023-10-06 09:30:00	QQQ	ETF	355.65	357.2	354.85	356.25	7614896.0
2023-10-06 10:00:00	QQQ	ETF	356.3	358.2621	354.95	358.18	5336682.0
2023-10-06 10:30:00	QQQ	ETF	358.19	359.61	358.1669	359.22	5050631.0
2023-10-06 11:00:00	QQQ	ETF	359.2333	360.79	359.1586	360.164	5201661.0
2023-10-06 11:30:00	QQQ	ETF	360.165	363.17	360.16	363.15	5407865.0
2023-10-06 12:00:00	QQQ	ETF	363.15	363.68	362.47	362.97	4106048.0
2023-10-06 12:30:00	QQQ	ETF	363.0	363.48	362.46	363.13	1947964.0

> showing 50 of 28,465 rows — these rows as CSV

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