PREVIEW / etf_30min / 2024-08-08

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-08.parquet
  size:    836 KB
  rows:    33,397

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-08-08 04:00:00	SPY	ETF	516.59	517.49	516.5	516.63	23422.0
2024-08-08 04:30:00	SPY	ETF	516.88	518.5	516.78	518.35	11654.0
2024-08-08 05:00:00	SPY	ETF	518.52	519.0	517.79	517.79	20471.0
2024-08-08 05:30:00	SPY	ETF	517.94	517.94	516.35	517.0	7277.0
2024-08-08 06:00:00	SPY	ETF	517.1	517.8	516.42	517.54	30625.0
2024-08-08 06:30:00	SPY	ETF	517.6	518.42	517.47	518.18	30236.0
2024-08-08 07:00:00	SPY	ETF	518.0	519.18	517.72	518.56	84638.0
2024-08-08 07:30:00	SPY	ETF	518.53	519.32	518.3	519.15	242430.0
2024-08-08 08:00:00	SPY	ETF	519.24	519.42	516.26	519.0	353649.0
2024-08-08 08:30:00	SPY	ETF	519.18	523.4498	518.66	522.5	1545332.0
2024-08-08 09:00:00	SPY	ETF	522.62	524.2812	522.16	523.98	577732.0
2024-08-08 09:30:00	SPY	ETF	523.9	525.05	521.84	525.04	5759334.0
2024-08-08 10:00:00	SPY	ETF	525.05	527.99	524.66	527.87	4195882.0
2024-08-08 10:30:00	SPY	ETF	527.82	528.45	527.2	528.2	2874353.0
2024-08-08 11:00:00	SPY	ETF	528.19	528.48	526.405	527.82	2129167.0
2024-08-08 11:30:00	SPY	ETF	527.81	528.45	526.85	527.675	1903998.0
2024-08-08 12:00:00	SPY	ETF	527.675	529.0162	527.58	528.3905	1872098.0
2024-08-08 12:30:00	SPY	ETF	528.4	528.42	526.65	527.85	1759342.0
2024-08-08 13:00:00	SPY	ETF	527.83	529.98	526.735	529.95	2508815.0
2024-08-08 13:30:00	SPY	ETF	529.96	530.52	529.69	530.24	1732993.0
2024-08-08 14:00:00	SPY	ETF	530.21	531.29	529.95	530.35	2518089.0
2024-08-08 14:30:00	SPY	ETF	530.36	530.91	529.51	530.13	2092619.0
2024-08-08 15:00:00	SPY	ETF	530.12	530.7299	529.03	529.31	2606414.0
2024-08-08 15:30:00	SPY	ETF	529.32	531.03	528.2	530.63	9175238.0
2024-08-08 16:00:00	SPY	ETF	530.64	531.82	530.42	531.15	5935279.0
2024-08-08 16:30:00	SPY	ETF	531.17	531.51	530.65	531.01	434919.0
2024-08-08 17:00:00	SPY	ETF	531.05	531.2	530.7	530.99	117680.0
2024-08-08 17:30:00	SPY	ETF	530.9987	530.9987	530.64	530.74	79998.0
2024-08-08 18:00:00	SPY	ETF	530.74	531.2	530.45	530.92	202879.0
2024-08-08 18:30:00	SPY	ETF	530.99	531.09	530.58	530.95	22491.0
2024-08-08 19:00:00	SPY	ETF	530.98	532.07	530.77	530.94	42027.0
2024-08-08 19:30:00	SPY	ETF	530.9995	531.7	530.9995	531.59	53716.0
2024-08-08 04:00:00	QQQ	ETF	434.78	434.78	433.29	433.63	72292.0
2024-08-08 04:30:00	QQQ	ETF	433.61	435.5	433.61	435.45	25852.0
2024-08-08 05:00:00	QQQ	ETF	435.5	435.94	434.8	435.04	18273.0
2024-08-08 05:30:00	QQQ	ETF	435.39	435.44	433.51	434.43	45653.0
2024-08-08 06:00:00	QQQ	ETF	434.46	435.3	433.67	435.02	34890.0
2024-08-08 06:30:00	QQQ	ETF	435.06	435.5	434.44	434.93	17665.0
2024-08-08 07:00:00	QQQ	ETF	434.86	435.74	434.14	435.19	139437.0
2024-08-08 07:30:00	QQQ	ETF	435.0	435.69	434.8	435.43	75637.0
2024-08-08 08:00:00	QQQ	ETF	434.66	436.68	433.13	435.1	271114.0
2024-08-08 08:30:00	QQQ	ETF	435.55	440.46	435.46	439.43	861676.0
2024-08-08 09:00:00	QQQ	ETF	439.5	441.64	439.17	441.0	468127.0
2024-08-08 09:30:00	QQQ	ETF	441.07	441.43	437.15	440.6025	4809472.0
2024-08-08 10:00:00	QQQ	ETF	440.68	444.93	440.19	444.75	3414655.0
2024-08-08 10:30:00	QQQ	ETF	444.79	446.09	444.14	445.49	2438852.0
2024-08-08 11:00:00	QQQ	ETF	445.53	445.64	443.37	444.78	1918787.0
2024-08-08 11:30:00	QQQ	ETF	444.8	445.7	444.14	445.32	1460190.0
2024-08-08 12:00:00	QQQ	ETF	445.32	446.85	445.19	446.1	1369715.0
2024-08-08 12:30:00	QQQ	ETF	446.12	446.13	444.28	445.37	1334976.0

> showing 50 of 33,397 rows — these rows as CSV

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