PREVIEW / etf_30min / 2024-03-01

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-01.parquet
  size:    820 KB
  rows:    32,519

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-01 04:00:00	SPY	ETF	509.0	509.64	509.0	509.53	27148.0
2024-03-01 04:30:00	SPY	ETF	509.5	509.5	509.2	509.25	7155.0
2024-03-01 05:00:00	SPY	ETF	509.2	509.2	507.39	507.4	22726.0
2024-03-01 05:30:00	SPY	ETF	507.6	508.05	507.55	507.93	87138.0
2024-03-01 06:00:00	SPY	ETF	507.95	508.33	507.95	508.26	56725.0
2024-03-01 06:30:00	SPY	ETF	508.24	508.5	508.14	508.45	7340.0
2024-03-01 07:00:00	SPY	ETF	508.48	508.5	508.17	508.27	30867.0
2024-03-01 07:30:00	SPY	ETF	508.25	508.82	508.24	508.54	162734.0
2024-03-01 08:00:00	SPY	ETF	508.4982	509.96	507.8904	508.88	135841.0
2024-03-01 08:30:00	SPY	ETF	508.98	508.98	508.34	508.68	197285.0
2024-03-01 09:00:00	SPY	ETF	508.66	508.99	508.48	508.98	82340.0
2024-03-01 09:30:00	SPY	ETF	508.98	509.56	508.56	509.08	3923312.0
2024-03-01 10:00:00	SPY	ETF	509.085	510.4	508.67	510.37	4853686.0
2024-03-01 10:30:00	SPY	ETF	510.365	510.84	509.69	510.66	3843219.0
2024-03-01 11:00:00	SPY	ETF	510.65	511.38	510.61	510.82	3931762.0
2024-03-01 11:30:00	SPY	ETF	510.82	511.3	510.16	511.1408	2864615.0
2024-03-01 12:00:00	SPY	ETF	511.15	511.77	510.71	511.53	2153481.0
2024-03-01 12:30:00	SPY	ETF	511.54	512.06	511.41	511.81	2427189.0
2024-03-01 13:00:00	SPY	ETF	511.82	512.24	511.68	512.13	2513853.0
2024-03-01 13:30:00	SPY	ETF	512.1286	512.695	511.98	512.615	2783952.0
2024-03-01 14:00:00	SPY	ETF	512.62	513.175	512.56	513.155	3697430.0
2024-03-01 14:30:00	SPY	ETF	513.155	513.29	512.58	513.0999	2641003.0
2024-03-01 15:00:00	SPY	ETF	513.09	513.09	512.315	512.89	3561046.0
2024-03-01 15:30:00	SPY	ETF	512.89	513.14	512.59	512.84	8447627.0
2024-03-01 16:00:00	SPY	ETF	512.84	512.86	512.38	512.39	2422346.0
2024-03-01 16:30:00	SPY	ETF	512.38	512.46	512.22	512.22	139406.0
2024-03-01 17:00:00	SPY	ETF	512.23	512.45	511.99	512.05	117305.0
2024-03-01 17:30:00	SPY	ETF	512.017	512.15	511.81	511.94	43276.0
2024-03-01 18:00:00	SPY	ETF	511.93	512.1	511.85	512.06	12122.0
2024-03-01 18:30:00	SPY	ETF	512.08	512.1	512.01	512.0506	1216.0
2024-03-01 19:00:00	SPY	ETF	512.1	512.17	512.1	512.17	5355.0
2024-03-01 19:30:00	SPY	ETF	512.2	512.23	512.0	512.01	17369.0
2024-03-01 04:00:00	QQQ	ETF	440.49	441.04	440.45	440.99	31462.0
2024-03-01 04:30:00	QQQ	ETF	440.94	441.09	440.66	440.69	18386.0
2024-03-01 05:00:00	QQQ	ETF	440.61	440.61	438.3	438.57	91109.0
2024-03-01 05:30:00	QQQ	ETF	438.64	439.39	438.64	439.14	30051.0
2024-03-01 06:00:00	QQQ	ETF	439.06	439.51	439.04	439.48	16987.0
2024-03-01 06:30:00	QQQ	ETF	439.54	439.84	439.29	439.74	18786.0
2024-03-01 07:00:00	QQQ	ETF	439.77	439.83	439.38	439.6	42734.0
2024-03-01 07:30:00	QQQ	ETF	439.5	440.04	439.45	439.8	42061.0
2024-03-01 08:00:00	QQQ	ETF	439.766	441.4	438.5696	440.0535	173098.0
2024-03-01 08:30:00	QQQ	ETF	440.021	440.17	439.3	439.729	165895.0
2024-03-01 09:00:00	QQQ	ETF	439.69	439.93	439.54	439.85	105048.0
2024-03-01 09:30:00	QQQ	ETF	439.9	441.07	439.84	440.81	3256294.0
2024-03-01 10:00:00	QQQ	ETF	440.83	442.3	440.51	441.9	3230045.0
2024-03-01 10:30:00	QQQ	ETF	441.92	442.49	441.03	442.21	2350098.0
2024-03-01 11:00:00	QQQ	ETF	442.2	443.41	442.13	443.1103	1993169.0
2024-03-01 11:30:00	QQQ	ETF	443.12	443.57	442.57	443.35	1421980.0
2024-03-01 12:00:00	QQQ	ETF	443.35	444.13	442.93	443.99	1364108.0
2024-03-01 12:30:00	QQQ	ETF	443.99	444.61	443.76	444.47	1652669.0

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

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