PREVIEW / etf_30min / 2024-11-12

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-12.parquet
  size:    926 KB
  rows:    36,913

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-11-12 04:00:00	SPY	ETF	598.57	598.71	598.0	598.06	19284.0
2024-11-12 04:30:00	SPY	ETF	598.06	598.31	597.64	597.64	8536.0
2024-11-12 05:00:00	SPY	ETF	597.65	597.69	596.91	597.12	27313.0
2024-11-12 05:30:00	SPY	ETF	597.14	597.65	596.99	597.5	40727.0
2024-11-12 06:00:00	SPY	ETF	597.44	597.95	597.44	597.79	17599.0
2024-11-12 06:30:00	SPY	ETF	597.9	598.02	597.52	597.79	15102.0
2024-11-12 07:00:00	SPY	ETF	597.79	598.09	597.75	597.98	105874.0
2024-11-12 07:30:00	SPY	ETF	597.94	598.34	597.8	598.0	55557.0
2024-11-12 08:00:00	SPY	ETF	598.12	598.74	597.75	598.23	79170.0
2024-11-12 08:30:00	SPY	ETF	598.26	598.74	598.18	598.64	88476.0
2024-11-12 09:00:00	SPY	ETF	598.69	598.75	598.25	598.67	164945.0
2024-11-12 09:30:00	SPY	ETF	598.7	599.29	598.37	598.95	2652635.0
2024-11-12 10:00:00	SPY	ETF	598.95	599.015	597.79	597.9534	1941390.0
2024-11-12 10:30:00	SPY	ETF	597.965	598.3799	597.2	597.23	1291395.0
2024-11-12 11:00:00	SPY	ETF	597.2299	597.578	596.98	597.18	1119911.0
2024-11-12 11:30:00	SPY	ETF	597.1798	597.3499	596.324	596.445	1274808.0
2024-11-12 12:00:00	SPY	ETF	596.435	596.7176	596.04	596.4925	974393.0
2024-11-12 12:30:00	SPY	ETF	596.49	596.67	594.57	594.67	1314724.0
2024-11-12 13:00:00	SPY	ETF	594.67	595.9	594.37	595.8234	1604181.0
2024-11-12 13:30:00	SPY	ETF	595.81	597.78	595.8	597.425	1512537.0
2024-11-12 14:00:00	SPY	ETF	597.41	598.28	597.3315	597.98	1605995.0
2024-11-12 14:30:00	SPY	ETF	597.98	598.4	597.84	598.01	1376812.0
2024-11-12 15:00:00	SPY	ETF	598.015	598.2	597.18	597.39	1598327.0
2024-11-12 15:30:00	SPY	ETF	597.39	597.57	596.51	596.87	5032362.0
2024-11-12 16:00:00	SPY	ETF	596.87	597.5	596.77	597.26	2112182.0
2024-11-12 16:30:00	SPY	ETF	597.2599	597.29	596.89	596.9	177583.0
2024-11-12 17:00:00	SPY	ETF	596.84	597.05	596.8	596.8802	144066.0
2024-11-12 17:30:00	SPY	ETF	596.9	596.9	596.71	596.79	18285.0
2024-11-12 18:00:00	SPY	ETF	596.83	596.9	596.07	596.16	56874.0
2024-11-12 18:30:00	SPY	ETF	596.19	596.44	596.04	596.44	41251.0
2024-11-12 19:00:00	SPY	ETF	596.39	596.45	595.94	596.03	10247.0
2024-11-12 19:30:00	SPY	ETF	596.1	596.2804	596.0	596.1152	18388.0
2024-11-12 04:00:00	QQQ	ETF	514.12	514.12	513.21	513.7	45511.0
2024-11-12 04:30:00	QQQ	ETF	513.54	513.85	513.0	513.05	19178.0
2024-11-12 05:00:00	QQQ	ETF	512.92	512.93	511.76	511.85	77612.0
2024-11-12 05:30:00	QQQ	ETF	511.93	512.7	511.76	512.68	82879.0
2024-11-12 06:00:00	QQQ	ETF	512.66	513.13	512.66	512.86	35159.0
2024-11-12 06:30:00	QQQ	ETF	513.0	513.17	512.57	512.77	68212.0
2024-11-12 07:00:00	QQQ	ETF	512.78	513.54	512.78	513.09	86773.0
2024-11-12 07:30:00	QQQ	ETF	513.1	513.65	512.9	513.191	35194.0
2024-11-12 08:00:00	QQQ	ETF	513.2496	514.18	511.7796	513.55	94278.0
2024-11-12 08:30:00	QQQ	ETF	513.5	514.15	513.42	513.91	90871.0
2024-11-12 09:00:00	QQQ	ETF	513.95	514.01	513.34	513.7499	103845.0
2024-11-12 09:30:00	QQQ	ETF	513.75	514.66	512.93	514.29	1586113.0
2024-11-12 10:00:00	QQQ	ETF	514.28	514.42	512.9	513.75	1335601.0
2024-11-12 10:30:00	QQQ	ETF	513.76	514.22	512.8238	512.9799	1103989.0
2024-11-12 11:00:00	QQQ	ETF	512.96	513.47	512.51	512.8601	928569.0
2024-11-12 11:30:00	QQQ	ETF	512.8734	513.18	511.98	512.245	1017782.0
2024-11-12 12:00:00	QQQ	ETF	512.23	512.6	511.69	512.3325	935973.0
2024-11-12 12:30:00	QQQ	ETF	512.325	512.6	510.1	510.1	998850.0

> showing 50 of 36,913 rows — these rows as CSV

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