PREVIEW / etf_30min / 2024-04-12

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-12.parquet
  size:    810 KB
  rows:    32,500

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-04-12 04:00:00	SPY	ETF	518.51	518.59	518.25	518.58	19154.0
2024-04-12 04:30:00	SPY	ETF	518.45	518.45	517.89	517.89	6132.0
2024-04-12 05:00:00	SPY	ETF	517.79	517.9	517.38	517.42	6241.0
2024-04-12 05:30:00	SPY	ETF	517.48	517.68	517.3	517.58	7900.0
2024-04-12 06:00:00	SPY	ETF	517.46	517.51	517.14	517.36	30972.0
2024-04-12 06:30:00	SPY	ETF	517.37	517.4	515.44	515.82	86310.0
2024-04-12 07:00:00	SPY	ETF	515.93	516.38	515.68	516.38	142268.0
2024-04-12 07:30:00	SPY	ETF	516.39	517.13	516.33	516.82	104704.0
2024-04-12 08:00:00	SPY	ETF	515.91	518.62	515.6996	516.44	190792.0
2024-04-12 08:30:00	SPY	ETF	516.42	516.46	514.21	514.28	476175.0
2024-04-12 09:00:00	SPY	ETF	514.22	514.44	513.45	514.4	645645.0
2024-04-12 09:30:00	SPY	ETF	514.38	515.815	514.08	515.34	6965944.0
2024-04-12 10:00:00	SPY	ETF	515.37	515.44	513.56	513.8	5792784.0
2024-04-12 10:30:00	SPY	ETF	513.81	514.09	512.02	512.3101	4995104.0
2024-04-12 11:00:00	SPY	ETF	512.31	513.54	512.2	513.53	3755663.0
2024-04-12 11:30:00	SPY	ETF	513.53	514.03	513.14	513.4	2565591.0
2024-04-12 12:00:00	SPY	ETF	513.43	513.53	511.76	511.82	3791912.0
2024-04-12 12:30:00	SPY	ETF	511.8	512.02	510.48	510.57	4966867.0
2024-04-12 13:00:00	SPY	ETF	510.58	511.09	509.47	509.7	4643667.0
2024-04-12 13:30:00	SPY	ETF	509.69	511.25	509.32	510.49	4500203.0
2024-04-12 14:00:00	SPY	ETF	510.49	511.415	509.96	510.67	3823625.0
2024-04-12 14:30:00	SPY	ETF	510.68	510.74	509.56	509.625	3704118.0
2024-04-12 15:00:00	SPY	ETF	509.62	510.08	509.08	509.505	4275283.0
2024-04-12 15:30:00	SPY	ETF	509.495	510.93	509.26	510.82	11975977.0
2024-04-12 16:00:00	SPY	ETF	510.82	511.09	510.8	510.93	3555086.0
2024-04-12 16:30:00	SPY	ETF	510.94	511.0	510.65	510.69	178512.0
2024-04-12 17:00:00	SPY	ETF	510.739	510.85	510.6	510.7	60020.0
2024-04-12 17:30:00	SPY	ETF	510.65	510.65	510.4	510.47	30606.0
2024-04-12 18:00:00	SPY	ETF	510.45	510.5	510.38	510.38	7761.0
2024-04-12 18:30:00	SPY	ETF	510.32	510.39	510.3	510.38	6189.0
2024-04-12 19:00:00	SPY	ETF	510.3	510.39	510.22	510.23	10735.0
2024-04-12 19:30:00	SPY	ETF	510.23	510.24	509.92	509.98	50929.0
2024-04-12 04:00:00	QQQ	ETF	445.21	445.5	444.9	445.42	26802.0
2024-04-12 04:30:00	QQQ	ETF	445.34	445.34	444.56	444.56	19817.0
2024-04-12 05:00:00	QQQ	ETF	444.55	444.64	443.96	444.09	27967.0
2024-04-12 05:30:00	QQQ	ETF	444.05	444.35	443.9	444.1	13773.0
2024-04-12 06:00:00	QQQ	ETF	444.1	444.11	443.69	443.89	27479.0
2024-04-12 06:30:00	QQQ	ETF	443.98	444.0	442.61	443.16	63760.0
2024-04-12 07:00:00	QQQ	ETF	443.18	443.43	443.0	443.269	78894.0
2024-04-12 07:30:00	QQQ	ETF	443.36	444.2	443.25	443.8	219326.0
2024-04-12 08:00:00	QQQ	ETF	443.1792	446.0	442.7896	443.57	154259.0
2024-04-12 08:30:00	QQQ	ETF	443.5	443.55	441.5	441.61	467737.0
2024-04-12 09:00:00	QQQ	ETF	441.61	441.61	440.6	441.1	453710.0
2024-04-12 09:30:00	QQQ	ETF	441.1	442.24	440.74	442.16	4639515.0
2024-04-12 10:00:00	QQQ	ETF	442.16	442.23	440.24	440.59	3245450.0
2024-04-12 10:30:00	QQQ	ETF	440.59	440.92	438.661	438.775	3518611.0
2024-04-12 11:00:00	QQQ	ETF	438.79	440.36	438.68	440.34	2577300.0
2024-04-12 11:30:00	QQQ	ETF	440.38	441.01	440.05	440.16	2012196.0
2024-04-12 12:00:00	QQQ	ETF	440.18	440.4266	438.8	438.85	1771558.0
2024-04-12 12:30:00	QQQ	ETF	438.86	439.01	437.535	437.8007	2987431.0

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

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