PREVIEW / etf_30min / 2024-03-06

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-06.parquet
  size:    826 KB
  rows:    32,626

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-03-06 04:00:00	SPY	ETF	508.58	509.21	508.0	509.08	44111.0
2024-03-06 04:30:00	SPY	ETF	509.1	509.2	508.86	509.1	6150.0
2024-03-06 05:00:00	SPY	ETF	509.2	509.3	509.1	509.3	31991.0
2024-03-06 05:30:00	SPY	ETF	509.23	509.32	508.84	508.85	7009.0
2024-03-06 06:00:00	SPY	ETF	508.85	509.1	508.85	509.02	7449.0
2024-03-06 06:30:00	SPY	ETF	508.99	509.05	508.71	508.86	9455.0
2024-03-06 07:00:00	SPY	ETF	508.9	509.46	508.82	509.2	108134.0
2024-03-06 07:30:00	SPY	ETF	509.21	509.52	509.21	509.45	34998.0
2024-03-06 08:00:00	SPY	ETF	508.8511	510.03	507.51	509.75	258030.0
2024-03-06 08:30:00	SPY	ETF	509.76	510.34	509.28	510.31	358964.0
2024-03-06 09:00:00	SPY	ETF	510.3	510.71	510.12	510.55	259922.0
2024-03-06 09:30:00	SPY	ETF	510.55	510.8504	509.63	509.91	5560298.0
2024-03-06 10:00:00	SPY	ETF	509.9	509.94	508.42	509.36	3632511.0
2024-03-06 10:30:00	SPY	ETF	509.35	510.58	509.04	510.455	2636101.0
2024-03-06 11:00:00	SPY	ETF	510.47	511.38	510.47	511.34	2721896.0
2024-03-06 11:30:00	SPY	ETF	511.35	511.64	510.51	511.2159	3208176.0
2024-03-06 12:00:00	SPY	ETF	511.22	511.92	511.11	511.76	2702366.0
2024-03-06 12:30:00	SPY	ETF	511.77	512.069	511.05	511.33	2342900.0
2024-03-06 13:00:00	SPY	ETF	511.33	511.95	511.08	511.86	1691312.0
2024-03-06 13:30:00	SPY	ETF	511.87	511.92	509.12	510.15	5759017.0
2024-03-06 14:00:00	SPY	ETF	510.16	510.43	508.52	510.17	4793001.0
2024-03-06 14:30:00	SPY	ETF	510.18	510.41	508.78	509.24	3412094.0
2024-03-06 15:00:00	SPY	ETF	509.24	509.79	508.57	509.17	3272687.0
2024-03-06 15:30:00	SPY	ETF	509.18	510.27	508.57	509.8	8449750.0
2024-03-06 16:00:00	SPY	ETF	509.8	510.05	509.69	509.94	2915017.0
2024-03-06 16:30:00	SPY	ETF	509.93	510.1701	509.88	509.93	213061.0
2024-03-06 17:00:00	SPY	ETF	509.95	510.04	509.75	509.9	122852.0
2024-03-06 17:30:00	SPY	ETF	509.9	510.02	509.75	509.99	66033.0
2024-03-06 18:00:00	SPY	ETF	509.95	509.96	509.71	509.89	16231.0
2024-03-06 18:30:00	SPY	ETF	509.91	509.91	509.55	509.55	12291.0
2024-03-06 19:00:00	SPY	ETF	509.6	509.69	509.05	509.09	35956.0
2024-03-06 19:30:00	SPY	ETF	509.01	509.06	508.64	508.93	109050.0
2024-03-06 04:00:00	QQQ	ETF	437.62	439.36	437.62	439.07	60071.0
2024-03-06 04:30:00	QQQ	ETF	439.05	439.17	438.9	439.13	17072.0
2024-03-06 05:00:00	QQQ	ETF	439.23	439.49	439.17	439.38	29032.0
2024-03-06 05:30:00	QQQ	ETF	439.35	439.6	439.06	439.06	17136.0
2024-03-06 06:00:00	QQQ	ETF	439.04	439.34	438.99	439.19	16560.0
2024-03-06 06:30:00	QQQ	ETF	439.2	439.2	438.66	438.8	34392.0
2024-03-06 07:00:00	QQQ	ETF	438.82	439.58	438.6	439.18	122843.0
2024-03-06 07:30:00	QQQ	ETF	439.25	439.58	439.15	439.44	75571.0
2024-03-06 08:00:00	QQQ	ETF	438.69	440.05	435.723	439.65	280149.0
2024-03-06 08:30:00	QQQ	ETF	439.6	440.14	439.12	440.14	405047.0
2024-03-06 09:00:00	QQQ	ETF	440.14	440.34	439.83	440.31	253393.0
2024-03-06 09:30:00	QQQ	ETF	440.32	440.83	438.59	438.94	5696610.0
2024-03-06 10:00:00	QQQ	ETF	438.94	438.99	436.89	438.2	3484307.0
2024-03-06 10:30:00	QQQ	ETF	438.21	439.86	437.8	439.6501	2668818.0
2024-03-06 11:00:00	QQQ	ETF	439.64	440.4	439.635	440.13	2280504.0
2024-03-06 11:30:00	QQQ	ETF	440.155	440.94	439.26	440.735	1857528.0
2024-03-06 12:00:00	QQQ	ETF	440.74	441.76	440.71	441.52	1696706.0
2024-03-06 12:30:00	QQQ	ETF	441.545	441.99	440.61	440.99	1481799.0

> showing 50 of 32,626 rows — these rows as CSV

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