PREVIEW / etf_30min / 2023-12-29

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-29.parquet
  size:    789 KB
  rows:    31,503

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-12-29 04:00:00	SPY	ETF	477.4	477.46	477.34	477.34	2886.0
2023-12-29 04:30:00	SPY	ETF	477.32	477.32	477.11	477.11	16316.0
2023-12-29 05:00:00	SPY	ETF	477.12	477.22	476.97	477.01	15795.0
2023-12-29 05:30:00	SPY	ETF	477.0	477.23	477.0	477.23	2600.0
2023-12-29 06:00:00	SPY	ETF	477.1	477.22	477.1	477.17	3960.0
2023-12-29 06:30:00	SPY	ETF	477.1	477.36	477.1	477.26	5332.0
2023-12-29 07:00:00	SPY	ETF	477.19	477.24	476.79	476.83	37763.0
2023-12-29 07:30:00	SPY	ETF	476.88	476.9	476.54	476.7	36880.0
2023-12-29 08:00:00	SPY	ETF	477.0	477.63	476.48	476.73	84173.0
2023-12-29 08:30:00	SPY	ETF	476.75	476.83	476.51	476.51	72043.0
2023-12-29 09:00:00	SPY	ETF	476.53	476.72	476.44	476.5	130502.0
2023-12-29 09:30:00	SPY	ETF	476.49	476.93	476.41	476.76	3894546.0
2023-12-29 10:00:00	SPY	ETF	476.76	477.03	476.475	476.705	3241868.0
2023-12-29 10:30:00	SPY	ETF	476.71	476.76	475.04	475.4403	6716511.0
2023-12-29 11:00:00	SPY	ETF	475.45	475.685	473.9	473.95	6132326.0
2023-12-29 11:30:00	SPY	ETF	473.94	474.49	473.77	474.2	4663919.0
2023-12-29 12:00:00	SPY	ETF	474.2	474.56	473.3	473.5899	4017145.0
2023-12-29 12:30:00	SPY	ETF	473.58	474.58	473.51	474.48	2840014.0
2023-12-29 13:00:00	SPY	ETF	474.48	475.104	474.305	474.5	3744980.0
2023-12-29 13:30:00	SPY	ETF	474.49	475.32	474.475	475.05	3249172.0
2023-12-29 14:00:00	SPY	ETF	475.06	475.46	474.89	475.05	3475024.0
2023-12-29 14:30:00	SPY	ETF	475.05	475.695	475.05	475.565	3505407.0
2023-12-29 15:00:00	SPY	ETF	475.565	475.89	475.12	475.78	5520845.0
2023-12-29 15:30:00	SPY	ETF	475.77	475.78	474.49	475.35	17267821.0
2023-12-29 16:00:00	SPY	ETF	475.35	476.481	474.8	474.95	5683420.0
2023-12-29 16:30:00	SPY	ETF	474.98	475.03	474.85	474.88	257919.0
2023-12-29 17:00:00	SPY	ETF	474.92	475.05	474.71	474.94	66635.0
2023-12-29 17:30:00	SPY	ETF	474.94	475.25	474.94	475.25	50308.0
2023-12-29 18:00:00	SPY	ETF	475.2	475.31	475.01	475.3	668453.0
2023-12-29 18:30:00	SPY	ETF	475.23	475.28	475.112	475.112	1695.0
2023-12-29 19:00:00	SPY	ETF	475.11	475.24	475.11	475.24	4120.0
2023-12-29 19:30:00	SPY	ETF	475.07	475.09	474.9	475.07	11136.0
2023-12-29 04:00:00	QQQ	ETF	411.93	412.07	411.91	412.01	4074.0
2023-12-29 04:30:00	QQQ	ETF	411.99	411.99	411.75	411.75	9574.0
2023-12-29 05:00:00	QQQ	ETF	411.72	411.83	411.66	411.66	3776.0
2023-12-29 05:30:00	QQQ	ETF	411.84	411.89	411.8	411.81	1750.0
2023-12-29 06:00:00	QQQ	ETF	411.82	411.82	411.82	411.82	600.0
2023-12-29 06:30:00	QQQ	ETF	411.79	412.04	411.79	411.93	2795.0
2023-12-29 07:00:00	QQQ	ETF	411.92	411.95	411.37	411.48	21247.0
2023-12-29 07:30:00	QQQ	ETF	411.47	411.5	411.01	411.2	24847.0
2023-12-29 08:00:00	QQQ	ETF	411.55	412.23	410.82	411.16	72054.0
2023-12-29 08:30:00	QQQ	ETF	411.14	411.38	411.1	411.18	43436.0
2023-12-29 09:00:00	QQQ	ETF	411.2	411.35	411.14	411.29	120444.0
2023-12-29 09:30:00	QQQ	ETF	411.29	411.64	410.9	411.375	1974576.0
2023-12-29 10:00:00	QQQ	ETF	411.375	411.591	411.05	411.305	1248950.0
2023-12-29 10:30:00	QQQ	ETF	411.31	411.325	409.08	409.51	2959999.0
2023-12-29 11:00:00	QQQ	ETF	409.52	409.71	407.63	407.695	3123637.0
2023-12-29 11:30:00	QQQ	ETF	407.7	408.73	407.58	408.51	2348268.0
2023-12-29 12:00:00	QQQ	ETF	408.51	408.89	407.7	407.91	2002337.0
2023-12-29 12:30:00	QQQ	ETF	407.9	408.97	407.87	408.91	1311484.0

> showing 50 of 31,503 rows — these rows as CSV

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