PREVIEW / etf_30min / 2024-10-03

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-03.parquet
  size:    847 KB
  rows:    34,177

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-03 04:00:00	SPY	ETF	567.78	567.78	566.11	566.48	31773.0
2024-10-03 04:30:00	SPY	ETF	566.52	567.11	566.46	566.86	4348.0
2024-10-03 05:00:00	SPY	ETF	566.94	567.17	566.65	567.0	4536.0
2024-10-03 05:30:00	SPY	ETF	567.07	567.2	566.97	567.1	4568.0
2024-10-03 06:00:00	SPY	ETF	567.2	567.2	566.8	567.17	3306.0
2024-10-03 06:30:00	SPY	ETF	567.16	567.48	566.99	567.47	19059.0
2024-10-03 07:00:00	SPY	ETF	567.58	567.88	567.3	567.7	40388.0
2024-10-03 07:30:00	SPY	ETF	567.68	568.35	567.66	568.34	37445.0
2024-10-03 08:00:00	SPY	ETF	568.38	568.43	565.9	568.29	78615.0
2024-10-03 08:30:00	SPY	ETF	568.38	568.73	567.35	567.37	154051.0
2024-10-03 09:00:00	SPY	ETF	567.41	567.66	567.18	567.42	198205.0
2024-10-03 09:30:00	SPY	ETF	567.36	568.29	566.82	567.84	2662663.0
2024-10-03 10:00:00	SPY	ETF	567.81	569.8025	566.77	567.1699	4123829.0
2024-10-03 10:30:00	SPY	ETF	567.15	568.49	566.24	566.68	2218518.0
2024-10-03 11:00:00	SPY	ETF	566.67	567.97	566.24	567.4749	1365765.0
2024-10-03 11:30:00	SPY	ETF	567.44	568.9799	567.44	568.44	925592.0
2024-10-03 12:00:00	SPY	ETF	568.46	569.16	568.33	568.7	671832.0
2024-10-03 12:30:00	SPY	ETF	568.7082	568.71	565.86	566.4	2561717.0
2024-10-03 13:00:00	SPY	ETF	566.4	567.45	565.49	566.47	2591672.0
2024-10-03 13:30:00	SPY	ETF	566.46	567.3	566.0501	567.089	1078376.0
2024-10-03 14:00:00	SPY	ETF	567.0609	567.42	566.47	567.01	1042866.0
2024-10-03 14:30:00	SPY	ETF	566.99	567.25	566.7	566.76	740478.0
2024-10-03 15:00:00	SPY	ETF	566.77	566.85	566.05	566.53	2145549.0
2024-10-03 15:30:00	SPY	ETF	566.55	568.27	566.44	567.78	4800744.0
2024-10-03 16:00:00	SPY	ETF	567.8	568.26	567.7	567.85	2209437.0
2024-10-03 16:30:00	SPY	ETF	567.83	567.83	567.3	567.32	112341.0
2024-10-03 17:00:00	SPY	ETF	567.45	567.53	567.34	567.36	25030.0
2024-10-03 17:30:00	SPY	ETF	567.4	567.5	567.32	567.4994	27354.0
2024-10-03 18:00:00	SPY	ETF	567.28	567.29	567.0	567.24	24467.0
2024-10-03 18:30:00	SPY	ETF	567.24	568.1	567.24	567.79	55846.0
2024-10-03 19:00:00	SPY	ETF	567.78	567.92	567.51	567.55	16966.0
2024-10-03 19:30:00	SPY	ETF	567.67	567.89	567.55	567.8001	23433.0
2024-10-03 04:00:00	QQQ	ETF	479.2	479.83	479.03	479.67	31523.0
2024-10-03 04:30:00	QQQ	ETF	479.45	480.12	479.28	479.73	8102.0
2024-10-03 05:00:00	QQQ	ETF	479.69	480.0	479.43	479.85	18363.0
2024-10-03 05:30:00	QQQ	ETF	479.9	480.1	479.62	479.89	7330.0
2024-10-03 06:00:00	QQQ	ETF	479.97	480.1	479.6	480.04	10149.0
2024-10-03 06:30:00	QQQ	ETF	480.05	480.55	479.84	480.55	16287.0
2024-10-03 07:00:00	QQQ	ETF	480.58	480.99	480.2	480.76	34083.0
2024-10-03 07:30:00	QQQ	ETF	480.58	481.29	480.44	481.26	55007.0
2024-10-03 08:00:00	QQQ	ETF	480.82	481.43	478.49	481.2	150772.0
2024-10-03 08:30:00	QQQ	ETF	481.2	481.7	479.91	480.0	163909.0
2024-10-03 09:00:00	QQQ	ETF	479.96	480.26	479.49	479.77	182330.0
2024-10-03 09:30:00	QQQ	ETF	479.74	482.99	479.37	482.46	1959119.0
2024-10-03 10:00:00	QQQ	ETF	482.41	484.545	480.35	481.0	3161033.0
2024-10-03 10:30:00	QQQ	ETF	480.97	482.6	479.8087	480.44	1875582.0
2024-10-03 11:00:00	QQQ	ETF	480.44	482.14	480.13	481.695	1310723.0
2024-10-03 11:30:00	QQQ	ETF	481.665	483.2525	481.65	482.7913	1021380.0
2024-10-03 12:00:00	QQQ	ETF	482.79	483.09	482.33	482.6	550535.0
2024-10-03 12:30:00	QQQ	ETF	482.63	482.63	479.54	479.97	1856743.0

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

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