PREVIEW / etf_30min / 2024-10-08

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-08.parquet
  size:    857 KB
  rows:    34,208

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-10-08 04:00:00	SPY	ETF	568.09	568.41	567.86	567.96	10862.0
2024-10-08 04:30:00	SPY	ETF	567.9	568.54	567.85	568.48	8087.0
2024-10-08 05:00:00	SPY	ETF	568.55	569.82	568.55	569.74	15322.0
2024-10-08 05:30:00	SPY	ETF	569.88	569.91	569.58	569.71	16789.0
2024-10-08 06:00:00	SPY	ETF	569.8	570.07	569.7	569.81	21387.0
2024-10-08 06:30:00	SPY	ETF	569.89	570.05	569.31	570.05	28982.0
2024-10-08 07:00:00	SPY	ETF	570.05	570.05	569.6	569.88	244485.0
2024-10-08 07:30:00	SPY	ETF	569.9	570.24	569.79	569.98	117823.0
2024-10-08 08:00:00	SPY	ETF	569.62	570.15	567.07	569.68	158132.0
2024-10-08 08:30:00	SPY	ETF	569.66	569.89	569.6	569.73	31354.0
2024-10-08 09:00:00	SPY	ETF	569.79	570.57	569.58	570.44	254639.0
2024-10-08 09:30:00	SPY	ETF	570.44	570.86	569.5299	570.7403	3502408.0
2024-10-08 10:00:00	SPY	ETF	570.75	571.35	570.39	570.86	2246820.0
2024-10-08 10:30:00	SPY	ETF	570.85	572.55	570.745	571.81	2834526.0
2024-10-08 11:00:00	SPY	ETF	571.8	572.12	571.25	571.84	1591535.0
2024-10-08 11:30:00	SPY	ETF	571.85	572.33	571.71	572.275	933340.0
2024-10-08 12:00:00	SPY	ETF	572.27	572.3299	571.4	572.03	799184.0
2024-10-08 12:30:00	SPY	ETF	572.02	572.24	571.6	571.87	842188.0
2024-10-08 13:00:00	SPY	ETF	571.87	571.97	570.55	571.22	1435227.0
2024-10-08 13:30:00	SPY	ETF	571.22	571.77	571.105	571.7458	537810.0
2024-10-08 14:00:00	SPY	ETF	571.75	572.04	571.7	571.95	706592.0
2024-10-08 14:30:00	SPY	ETF	571.95	572.9	571.75	572.72	1271597.0
2024-10-08 15:00:00	SPY	ETF	572.71	573.04	572.31	572.86	1540959.0
2024-10-08 15:30:00	SPY	ETF	572.86	573.78	572.74	573.13	6016167.0
2024-10-08 16:00:00	SPY	ETF	573.14	573.22	572.71	573.0	1692082.0
2024-10-08 16:30:00	SPY	ETF	572.98	573.2	572.87	572.9	181497.0
2024-10-08 17:00:00	SPY	ETF	572.9	573.17	572.76	572.9	165995.0
2024-10-08 17:30:00	SPY	ETF	572.89	572.92	572.82	572.92	8084.0
2024-10-08 18:00:00	SPY	ETF	572.94	572.95	572.78	572.8	42085.0
2024-10-08 18:30:00	SPY	ETF	572.7998	572.9992	572.65	572.9	21805.0
2024-10-08 19:00:00	SPY	ETF	573.0	573.08	572.72	572.72	17174.0
2024-10-08 19:30:00	SPY	ETF	572.72	572.75	572.63	572.6801	11430.0
2024-10-08 04:00:00	QQQ	ETF	482.29	482.55	481.95	482.07	41441.0
2024-10-08 04:30:00	QQQ	ETF	481.88	482.78	481.88	482.6	18640.0
2024-10-08 05:00:00	QQQ	ETF	482.7	484.08	482.7	483.9	29061.0
2024-10-08 05:30:00	QQQ	ETF	484.05	484.3	483.67	483.93	30767.0
2024-10-08 06:00:00	QQQ	ETF	483.91	484.4	483.91	484.27	22194.0
2024-10-08 06:30:00	QQQ	ETF	484.35	484.35	483.5	484.31	67520.0
2024-10-08 07:00:00	QQQ	ETF	484.26	484.43	483.82	484.03	56904.0
2024-10-08 07:30:00	QQQ	ETF	484.16	484.52	484.15	484.3	37701.0
2024-10-08 08:00:00	QQQ	ETF	484.31	484.6	480.97	483.88	75292.0
2024-10-08 08:30:00	QQQ	ETF	483.8	483.9	483.5307	483.65	70520.0
2024-10-08 09:00:00	QQQ	ETF	483.71	484.66	483.57	484.52	334598.0
2024-10-08 09:30:00	QQQ	ETF	484.66	485.88	483.845	485.86	2417078.0
2024-10-08 10:00:00	QQQ	ETF	485.88	486.96	485.8	486.5325	2033072.0
2024-10-08 10:30:00	QQQ	ETF	486.54	488.65	486.42	487.83	2375313.0
2024-10-08 11:00:00	QQQ	ETF	487.87	488.34	487.16	487.65	1313840.0
2024-10-08 11:30:00	QQQ	ETF	487.7	488.29	487.3661	488.25	536687.0
2024-10-08 12:00:00	QQQ	ETF	488.24	488.245	486.9	487.775	760976.0
2024-10-08 12:30:00	QQQ	ETF	487.73	488.04	487.245	487.66	454095.0

> showing 50 of 34,208 rows — these rows as CSV

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