PREVIEW / etf_30min / 2023-08-22

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-22.parquet
  size:    689 KB
  rows:    27,752

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-08-22 04:00:00	SPY	ETF	440.55	440.84	439.52	440.53	42467.0
2023-08-22 04:30:00	SPY	ETF	440.6	440.9	440.59	440.69	125226.0
2023-08-22 05:00:00	SPY	ETF	440.71	440.86	440.54	440.81	10423.0
2023-08-22 05:30:00	SPY	ETF	440.84	441.27	440.84	440.96	22624.0
2023-08-22 06:00:00	SPY	ETF	441.2	441.25	441.1	441.21	18010.0
2023-08-22 06:30:00	SPY	ETF	441.29	441.36	441.0	441.07	6873.0
2023-08-22 07:00:00	SPY	ETF	441.08	441.49	440.86	441.3	134830.0
2023-08-22 07:30:00	SPY	ETF	441.34	441.87	441.3	441.78	108864.0
2023-08-22 08:00:00	SPY	ETF	441.08	442.06	438.85	441.76	200380.0
2023-08-22 08:30:00	SPY	ETF	441.77	442.06	441.2	441.2	200473.0
2023-08-22 09:00:00	SPY	ETF	441.2	441.27	440.9	441.15	335827.0
2023-08-22 09:30:00	SPY	ETF	441.17	441.18	439.58	439.64	5355696.0
2023-08-22 10:00:00	SPY	ETF	439.65	440.41	439.4	439.57	4066788.0
2023-08-22 10:30:00	SPY	ETF	439.59	439.8799	438.64	439.7606	3421298.0
2023-08-22 11:00:00	SPY	ETF	439.77	439.86	438.89	439.37	3138917.0
2023-08-22 11:30:00	SPY	ETF	439.385	439.675	438.58	438.7	2959044.0
2023-08-22 12:00:00	SPY	ETF	438.71	438.855	437.76	438.5401	3210415.0
2023-08-22 12:30:00	SPY	ETF	438.55	439.369	438.27	438.6999	2747333.0
2023-08-22 13:00:00	SPY	ETF	438.7	438.79	437.625	438.23	2715830.0
2023-08-22 13:30:00	SPY	ETF	438.24	438.395	437.67	438.18	2182921.0
2023-08-22 14:00:00	SPY	ETF	438.18	438.67	437.74	438.58	2320621.0
2023-08-22 14:30:00	SPY	ETF	438.6	438.93	438.01	438.5	2658501.0
2023-08-22 15:00:00	SPY	ETF	438.51	439.48	438.27	438.49	3390706.0
2023-08-22 15:30:00	SPY	ETF	438.49	438.5	437.57	438.11	8910146.0
2023-08-22 16:00:00	SPY	ETF	438.1	438.21	437.97	438.0	2441474.0
2023-08-22 16:30:00	SPY	ETF	437.98	438.21	437.96	438.2	215913.0
2023-08-22 17:00:00	SPY	ETF	438.2	438.5	438.14	438.39	228583.0
2023-08-22 17:30:00	SPY	ETF	438.39	438.39	438.23	438.24	24504.0
2023-08-22 18:00:00	SPY	ETF	438.24	438.51	438.16	438.38	73502.0
2023-08-22 18:30:00	SPY	ETF	438.45	438.45	438.34	438.35	3828.0
2023-08-22 19:00:00	SPY	ETF	438.35	438.36	438.3	438.34	4535.0
2023-08-22 19:30:00	SPY	ETF	438.38	438.38	438.15	438.24	44098.0
2023-08-22 04:00:00	QQQ	ETF	365.29	365.76	364.77	365.45	55835.0
2023-08-22 04:30:00	QQQ	ETF	365.51	365.87	365.48	365.7	33680.0
2023-08-22 05:00:00	QQQ	ETF	365.73	365.73	365.38	365.64	22881.0
2023-08-22 05:30:00	QQQ	ETF	365.67	366.1	365.67	365.98	16867.0
2023-08-22 06:00:00	QQQ	ETF	365.94	366.12	365.94	366.04	20647.0
2023-08-22 06:30:00	QQQ	ETF	366.08	366.23	365.77	365.86	80357.0
2023-08-22 07:00:00	QQQ	ETF	365.9	366.41	365.63	366.28	84319.0
2023-08-22 07:30:00	QQQ	ETF	366.32	366.88	366.319	366.7	71538.0
2023-08-22 08:00:00	QQQ	ETF	365.9311	367.05	363.26	366.79	206658.0
2023-08-22 08:30:00	QQQ	ETF	366.8	367.15	366.42	366.42	236964.0
2023-08-22 09:00:00	QQQ	ETF	366.42	366.66	364.22	366.5	178279.0
2023-08-22 09:30:00	QQQ	ETF	366.55	366.56	364.25	364.41	4784731.0
2023-08-22 10:00:00	QQQ	ETF	364.41	365.7	364.3	364.59	2880590.0
2023-08-22 10:30:00	QQQ	ETF	364.6001	365.57	363.58	365.465	2791823.0
2023-08-22 11:00:00	QQQ	ETF	365.47	365.6585	364.47	364.81	1835537.0
2023-08-22 11:30:00	QQQ	ETF	364.82	365.185	363.65	363.94	1967294.0
2023-08-22 12:00:00	QQQ	ETF	363.9494	364.05	362.7039	363.415	2266503.0
2023-08-22 12:30:00	QQQ	ETF	363.415	364.2546	363.15	363.67	1795697.0

> showing 50 of 27,752 rows — these rows as CSV

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