PREVIEW / etf_30min / 2024-06-12

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-12.parquet
  size:    824 KB
  rows:    33,177

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-06-12 04:00:00	SPY	ETF	537.26	537.56	537.23	537.45	5444.0
2024-06-12 04:30:00	SPY	ETF	537.24	537.54	537.24	537.51	1986.0
2024-06-12 05:00:00	SPY	ETF	537.34	537.64	537.34	537.64	684.0
2024-06-12 05:30:00	SPY	ETF	537.57	537.77	537.57	537.6	4003.0
2024-06-12 06:00:00	SPY	ETF	537.55	537.68	537.51	537.51	8859.0
2024-06-12 06:30:00	SPY	ETF	537.62	537.79	537.58	537.68	4243.0
2024-06-12 07:00:00	SPY	ETF	537.74	537.83	537.63	537.83	39003.0
2024-06-12 07:30:00	SPY	ETF	537.81	537.81	537.51	537.65	42932.0
2024-06-12 08:00:00	SPY	ETF	537.77	538.0	537.26	538.0	198601.0
2024-06-12 08:30:00	SPY	ETF	537.57	542.0	536.95	541.77	1515965.0
2024-06-12 09:00:00	SPY	ETF	541.72	541.94	541.56	541.62	386992.0
2024-06-12 09:30:00	SPY	ETF	541.64	542.96	541.21	542.6887	5357739.0
2024-06-12 10:00:00	SPY	ETF	542.68	543.92	542.54	543.91	2931136.0
2024-06-12 10:30:00	SPY	ETF	543.92	543.96	542.815	543.085	2379424.0
2024-06-12 11:00:00	SPY	ETF	543.1	543.4	542.56	543.23	1615589.0
2024-06-12 11:30:00	SPY	ETF	543.22	543.26	542.53	543.0	1253224.0
2024-06-12 12:00:00	SPY	ETF	543.0	543.13	542.495	542.5	1000237.0
2024-06-12 12:30:00	SPY	ETF	542.51	542.95	542.42	542.81	1129529.0
2024-06-12 13:00:00	SPY	ETF	542.82	543.37	542.73	542.92	976815.0
2024-06-12 13:30:00	SPY	ETF	542.9103	542.93	541.9514	542.5651	1628609.0
2024-06-12 14:00:00	SPY	ETF	542.54	542.85	540.73	542.67	3963515.0
2024-06-12 14:30:00	SPY	ETF	542.69	543.08	541.18	542.5	3158982.0
2024-06-12 15:00:00	SPY	ETF	542.5	544.12	540.74	540.99	4643612.0
2024-06-12 15:30:00	SPY	ETF	541.0	542.395	540.3	541.34	7658710.0
2024-06-12 16:00:00	SPY	ETF	541.34	542.15	541.04	541.94	3249748.0
2024-06-12 16:30:00	SPY	ETF	541.93	542.52	541.451	542.45	813178.0
2024-06-12 17:00:00	SPY	ETF	542.44	542.5081	541.36	541.98	289008.0
2024-06-12 17:30:00	SPY	ETF	542.05	542.17	541.86	542.16	92163.0
2024-06-12 18:00:00	SPY	ETF	542.16	542.3	541.97	542.15	195036.0
2024-06-12 18:30:00	SPY	ETF	542.15	542.2	542.05	542.05	16852.0
2024-06-12 19:00:00	SPY	ETF	542.0304	542.15	541.9	542.13	14466.0
2024-06-12 19:30:00	SPY	ETF	542.1	542.28	542.1	542.23	14403.0
2024-06-12 04:00:00	QQQ	ETF	468.34	468.59	468.19	468.2	13880.0
2024-06-12 04:30:00	QQQ	ETF	468.2	468.56	468.2	468.48	5709.0
2024-06-12 05:00:00	QQQ	ETF	468.47	468.71	468.47	468.71	14822.0
2024-06-12 05:30:00	QQQ	ETF	468.61	468.81	468.61	468.78	5524.0
2024-06-12 06:00:00	QQQ	ETF	468.64	468.81	468.55	468.68	7863.0
2024-06-12 06:30:00	QQQ	ETF	468.6	468.83	468.6	468.83	21841.0
2024-06-12 07:00:00	QQQ	ETF	468.7	468.95	468.62	468.9	36001.0
2024-06-12 07:30:00	QQQ	ETF	468.95	468.95	468.61	468.76	48045.0
2024-06-12 08:00:00	QQQ	ETF	468.72	469.68	468.1	469.68	120002.0
2024-06-12 08:30:00	QQQ	ETF	469.68	473.5	469.68	472.47	1004967.0
2024-06-12 09:00:00	QQQ	ETF	472.45	472.54	472.0	472.01	270489.0
2024-06-12 09:30:00	QQQ	ETF	471.99	474.4599	471.29	474.13	3735166.0
2024-06-12 10:00:00	QQQ	ETF	474.14	475.38	473.85	475.36	2566905.0
2024-06-12 10:30:00	QQQ	ETF	475.37	475.43	474.02	474.4094	2076653.0
2024-06-12 11:00:00	QQQ	ETF	474.43	475.26	474.29	475.135	949567.0
2024-06-12 11:30:00	QQQ	ETF	475.175	475.185	474.43	474.7075	1031866.0
2024-06-12 12:00:00	QQQ	ETF	474.68	474.94	474.23	474.35	603366.0
2024-06-12 12:30:00	QQQ	ETF	474.35	474.84	474.18	474.57	761110.0

> showing 50 of 33,177 rows — these rows as CSV

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