PREVIEW / etf_30min / 2024-08-06

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-06.parquet
  size:    861 KB
  rows:    35,593

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-06 04:00:00	SPY	ETF	523.91	523.91	520.42	521.62	29443.0
2024-08-06 04:30:00	SPY	ETF	521.94	522.31	521.14	521.43	9776.0
2024-08-06 05:00:00	SPY	ETF	521.23	521.23	518.97	520.4	55569.0
2024-08-06 05:30:00	SPY	ETF	520.01	520.1	518.5	519.88	35771.0
2024-08-06 06:00:00	SPY	ETF	519.5	520.51	519.0	520.35	18403.0
2024-08-06 06:30:00	SPY	ETF	520.49	522.17	520.49	521.82	49040.0
2024-08-06 07:00:00	SPY	ETF	521.88	522.51	521.74	522.5	252955.0
2024-08-06 07:30:00	SPY	ETF	522.73	523.12	520.41	521.54	189739.0
2024-08-06 08:00:00	SPY	ETF	522.49	525.5	518.8096	520.78	198293.0
2024-08-06 08:30:00	SPY	ETF	520.84	520.85	519.0	519.45	333274.0
2024-08-06 09:00:00	SPY	ETF	519.46	520.39	518.72	519.22	501976.0
2024-08-06 09:30:00	SPY	ETF	519.22	522.44	517.87	521.8858	8068900.0
2024-08-06 10:00:00	SPY	ETF	521.89	524.29	521.18	522.93	4315784.0
2024-08-06 10:30:00	SPY	ETF	523.0	526.51	522.15	525.39	3793613.0
2024-08-06 11:00:00	SPY	ETF	525.39	525.85	522.39	522.42	2685637.0
2024-08-06 11:30:00	SPY	ETF	522.46	526.03	522.41	525.9	2613425.0
2024-08-06 12:00:00	SPY	ETF	525.9	526.955	525.55	525.98	1845209.0
2024-08-06 12:30:00	SPY	ETF	526.02	528.05	525.51	527.63	1951391.0
2024-08-06 13:00:00	SPY	ETF	527.63	528.1562	527.06	527.8501	1697292.0
2024-08-06 13:30:00	SPY	ETF	527.88	528.45	527.15	527.93	2087445.0
2024-08-06 14:00:00	SPY	ETF	527.92	528.91	526.9	528.8903	2496505.0
2024-08-06 14:30:00	SPY	ETF	528.9	529.75	527.47	527.47	2986310.0
2024-08-06 15:00:00	SPY	ETF	527.51	527.65	525.01	526.7204	5229864.0
2024-08-06 15:30:00	SPY	ETF	526.75	527.03	521.97	522.19	14106731.0
2024-08-06 16:00:00	SPY	ETF	522.19	523.68	521.22	522.5	4633997.0
2024-08-06 16:30:00	SPY	ETF	522.5	522.5	519.6	520.57	830157.0
2024-08-06 17:00:00	SPY	ETF	520.53	520.95	519.8	520.3	79307.0
2024-08-06 17:30:00	SPY	ETF	520.24	520.24	519.08	519.45	78863.0
2024-08-06 18:00:00	SPY	ETF	519.45	521.84	519.45	521.04	222069.0
2024-08-06 18:30:00	SPY	ETF	521.04	521.1	520.37	520.71	28228.0
2024-08-06 19:00:00	SPY	ETF	520.71	521.23	519.82	520.04	27007.0
2024-08-06 19:30:00	SPY	ETF	520.0	520.2	519.712	519.94	50053.0
2024-08-06 04:00:00	QQQ	ETF	442.7	442.7	438.6	439.94	118438.0
2024-08-06 04:30:00	QQQ	ETF	439.81	440.69	439.0	439.61	37040.0
2024-08-06 05:00:00	QQQ	ETF	439.22	439.22	436.8	438.37	76649.0
2024-08-06 05:30:00	QQQ	ETF	438.17	438.18	435.8	437.47	72107.0
2024-08-06 06:00:00	QQQ	ETF	437.75	438.68	436.68	438.49	31698.0
2024-08-06 06:30:00	QQQ	ETF	438.67	439.84	438.66	439.46	90227.0
2024-08-06 07:00:00	QQQ	ETF	439.52	440.67	439.5	440.51	145771.0
2024-08-06 07:30:00	QQQ	ETF	440.7	441.53	438.38	440.05	121994.0
2024-08-06 08:00:00	QQQ	ETF	440.48	445.25	435.044	439.079	198196.0
2024-08-06 08:30:00	QQQ	ETF	438.843	438.89	436.77	437.42	317588.0
2024-08-06 09:00:00	QQQ	ETF	437.42	438.55	437.0	437.29	613654.0
2024-08-06 09:30:00	QQQ	ETF	437.3	439.6	434.56	438.8	6211646.0
2024-08-06 10:00:00	QQQ	ETF	438.78	440.93	437.89	439.32	3975056.0
2024-08-06 10:30:00	QQQ	ETF	439.34	443.62	438.51	442.7099	3602412.0
2024-08-06 11:00:00	QQQ	ETF	442.7	443.53	439.83	439.89	2346363.0
2024-08-06 11:30:00	QQQ	ETF	439.92	443.84	439.87	443.68	2216201.0
2024-08-06 12:00:00	QQQ	ETF	443.69	444.59	443.0507	443.46	1888196.0
2024-08-06 12:30:00	QQQ	ETF	443.49	446.17	443.07	445.74	2102163.0

> showing 50 of 35,593 rows — these rows as CSV

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