PREVIEW / etf_30min / 2024-03-26

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-26.parquet
  size:    795 KB
  rows:    31,505

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-26 04:00:00	SPY	ETF	520.98	521.22	520.91	521.13	8321.0
2024-03-26 04:30:00	SPY	ETF	521.24	521.7	521.24	521.51	4085.0
2024-03-26 05:00:00	SPY	ETF	521.5	522.0	521.5	521.93	24581.0
2024-03-26 05:30:00	SPY	ETF	521.89	522.0	521.74	521.89	2664.0
2024-03-26 06:00:00	SPY	ETF	521.97	522.14	521.97	522.05	23524.0
2024-03-26 06:30:00	SPY	ETF	522.01	522.18	522.01	522.17	23779.0
2024-03-26 07:00:00	SPY	ETF	522.16	522.2	521.76	521.76	38937.0
2024-03-26 07:30:00	SPY	ETF	521.86	522.1	521.86	522.1	43157.0
2024-03-26 08:00:00	SPY	ETF	522.1	522.25	520.56	521.8868	83048.0
2024-03-26 08:30:00	SPY	ETF	521.82	521.86	521.04	521.24	167981.0
2024-03-26 09:00:00	SPY	ETF	521.2	521.27	520.81	521.23	199854.0
2024-03-26 09:30:00	SPY	ETF	521.23	521.44	520.83	521.25	2873797.0
2024-03-26 10:00:00	SPY	ETF	521.25	521.58	520.93	521.07	2551545.0
2024-03-26 10:30:00	SPY	ETF	521.07	521.37	520.65	521.3	2357298.0
2024-03-26 11:00:00	SPY	ETF	521.29	521.39	521.11	521.28	1328430.0
2024-03-26 11:30:00	SPY	ETF	521.275	521.4599	521.0699	521.3969	1235140.0
2024-03-26 12:00:00	SPY	ETF	521.4	521.46	520.915	521.14	1667423.0
2024-03-26 12:30:00	SPY	ETF	521.135	521.14	520.75	520.88	1306746.0
2024-03-26 13:00:00	SPY	ETF	520.87	521.01	520.72	520.86	1334561.0
2024-03-26 13:30:00	SPY	ETF	520.8624	521.0099	520.49	520.655	1265962.0
2024-03-26 14:00:00	SPY	ETF	520.66	521.01	520.635	520.965	1239493.0
2024-03-26 14:30:00	SPY	ETF	520.96	521.05	520.65	520.85	1390675.0
2024-03-26 15:00:00	SPY	ETF	520.86	520.91	519.955	520.21	2378531.0
2024-03-26 15:30:00	SPY	ETF	520.21	520.245	518.4	518.66	15779046.0
2024-03-26 16:00:00	SPY	ETF	518.66	519.38	518.36	519.33	5065963.0
2024-03-26 16:30:00	SPY	ETF	519.32	519.48	519.28	519.36	158709.0
2024-03-26 17:00:00	SPY	ETF	519.31	519.5	519.31	519.37	51478.0
2024-03-26 17:30:00	SPY	ETF	519.37	519.5	518.81	519.45	22766.0
2024-03-26 18:00:00	SPY	ETF	519.46	519.51	519.3	519.51	29282.0
2024-03-26 18:30:00	SPY	ETF	519.51	519.51	519.36	519.46	24281.0
2024-03-26 19:00:00	SPY	ETF	519.46	519.58	519.36	519.55	23577.0
2024-03-26 19:30:00	SPY	ETF	519.54	519.72	519.54	519.7	50730.0
2024-03-26 20:00:00	SPY	ETF	519.71	519.71	519.71	519.71	100.0
2024-03-26 04:00:00	QQQ	ETF	446.3	446.68	446.19	446.57	22740.0
2024-03-26 04:30:00	QQQ	ETF	446.62	447.0	446.53	446.8	36389.0
2024-03-26 05:00:00	QQQ	ETF	446.85	447.3	446.79	447.19	19701.0
2024-03-26 05:30:00	QQQ	ETF	447.11	447.33	446.9	447.11	22290.0
2024-03-26 06:00:00	QQQ	ETF	447.18	447.34	447.08	447.13	16258.0
2024-03-26 06:30:00	QQQ	ETF	447.1	447.29	446.96	447.27	15505.0
2024-03-26 07:00:00	QQQ	ETF	447.2	447.45	446.87	446.9	56166.0
2024-03-26 07:30:00	QQQ	ETF	447.0	447.37	446.92	447.35	26882.0
2024-03-26 08:00:00	QQQ	ETF	447.35	447.41	445.093	447.0	82645.0
2024-03-26 08:30:00	QQQ	ETF	446.9	447.01	446.01	446.3	206677.0
2024-03-26 09:00:00	QQQ	ETF	446.28	446.42	445.93	446.28	117921.0
2024-03-26 09:30:00	QQQ	ETF	446.29	446.91	445.85	446.775	2721895.0
2024-03-26 10:00:00	QQQ	ETF	446.775	447.225	445.79	445.95	2254173.0
2024-03-26 10:30:00	QQQ	ETF	445.97	446.19	445.43	446.12	2116860.0
2024-03-26 11:00:00	QQQ	ETF	446.15	446.5301	445.83	446.26	1139661.0
2024-03-26 11:30:00	QQQ	ETF	446.26	446.59	445.93	446.54	1083278.0
2024-03-26 12:00:00	QQQ	ETF	446.55	446.75	445.74	446.0599	1151096.0

> showing 50 of 31,505 rows — these rows as CSV

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