PREVIEW / etf_30min / 2024-08-07

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-07.parquet
  size:    853 KB
  rows:    34,762

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-07 04:00:00	SPY	ETF	524.05	526.89	524.05	526.71	58580.0
2024-08-07 04:30:00	SPY	ETF	526.55	527.38	526.2	527.38	24140.0
2024-08-07 05:00:00	SPY	ETF	527.51	528.29	527.14	528.29	39739.0
2024-08-07 05:30:00	SPY	ETF	528.12	528.41	527.36	528.08	82497.0
2024-08-07 06:00:00	SPY	ETF	528.08	528.46	527.84	528.28	39601.0
2024-08-07 06:30:00	SPY	ETF	528.44	528.85	528.3	528.71	56842.0
2024-08-07 07:00:00	SPY	ETF	528.6	529.05	528.31	528.55	302620.0
2024-08-07 07:30:00	SPY	ETF	528.56	528.6	527.6	527.7	167592.0
2024-08-07 08:00:00	SPY	ETF	528.64	529.03	521.25	527.6	241915.0
2024-08-07 08:30:00	SPY	ETF	527.91	528.58	527.84	528.3	301463.0
2024-08-07 09:00:00	SPY	ETF	528.35	528.66	527.65	528.53	184822.0
2024-08-07 09:30:00	SPY	ETF	528.48	531.19	527.94	531.01	5564787.0
2024-08-07 10:00:00	SPY	ETF	531.04	531.59	528.28	528.75	3294045.0
2024-08-07 10:30:00	SPY	ETF	528.78	531.04	528.46	530.415	2370499.0
2024-08-07 11:00:00	SPY	ETF	530.47	531.15	528.88	529.51	1955964.0
2024-08-07 11:30:00	SPY	ETF	529.55	530.0	527.08	528.02	2054448.0
2024-08-07 12:00:00	SPY	ETF	528.03	528.08	525.82	527.66	2328410.0
2024-08-07 12:30:00	SPY	ETF	527.66	527.82	524.65	525.075	2548271.0
2024-08-07 13:00:00	SPY	ETF	525.065	525.38	522.29	523.65	3852332.0
2024-08-07 13:30:00	SPY	ETF	523.64	524.99	521.49	522.04	3045631.0
2024-08-07 14:00:00	SPY	ETF	522.03	522.21	519.435	520.66	4625048.0
2024-08-07 14:30:00	SPY	ETF	520.65	520.74	518.83	519.5066	3666714.0
2024-08-07 15:00:00	SPY	ETF	519.45	522.1	519.35	521.07	3866090.0
2024-08-07 15:30:00	SPY	ETF	521.04	521.79	518.0519	518.65	8514284.0
2024-08-07 16:00:00	SPY	ETF	518.65	522.9611	517.0	517.4	4716070.0
2024-08-07 16:30:00	SPY	ETF	517.45	517.72	515.55	516.16	567523.0
2024-08-07 17:00:00	SPY	ETF	516.18	518.66	515.75	516.64	539927.0
2024-08-07 17:30:00	SPY	ETF	516.59	516.67	516.5	516.57	25137.0
2024-08-07 18:00:00	SPY	ETF	516.68	517.5	516.25	517.48	175231.0
2024-08-07 18:30:00	SPY	ETF	517.5	517.67	516.59	517.1	40203.0
2024-08-07 19:00:00	SPY	ETF	516.94	517.27	515.41	515.52	22965.0
2024-08-07 19:30:00	SPY	ETF	515.61	516.0	514.14	515.95	129732.0
2024-08-07 04:00:00	QQQ	ETF	441.89	444.55	441.4	444.02	81617.0
2024-08-07 04:30:00	QQQ	ETF	444.08	445.0	443.7	445.0	78048.0
2024-08-07 05:00:00	QQQ	ETF	445.03	445.97	444.5	445.8	39757.0
2024-08-07 05:30:00	QQQ	ETF	445.83	446.21	444.9	445.47	20580.0
2024-08-07 06:00:00	QQQ	ETF	445.32	445.8	445.16	445.42	24357.0
2024-08-07 06:30:00	QQQ	ETF	445.68	446.41	445.44	446.19	49026.0
2024-08-07 07:00:00	QQQ	ETF	446.04	446.64	445.93	446.1	94177.0
2024-08-07 07:30:00	QQQ	ETF	446.13	446.2	444.71	445.0	115919.0
2024-08-07 08:00:00	QQQ	ETF	442.53	446.63	441.0	445.2	223965.0
2024-08-07 08:30:00	QQQ	ETF	445.3	446.42	445.26	445.99	138628.0
2024-08-07 09:00:00	QQQ	ETF	445.93	446.62	445.3	446.54	184158.0
2024-08-07 09:30:00	QQQ	ETF	446.51	449.0	446.15	448.11	4785911.0
2024-08-07 10:00:00	QQQ	ETF	448.12	448.98	445.31	445.98	3000574.0
2024-08-07 10:30:00	QQQ	ETF	446.04	448.69	445.56	447.88	1848740.0
2024-08-07 11:00:00	QQQ	ETF	447.93	448.76	446.08	446.8	1742869.0
2024-08-07 11:30:00	QQQ	ETF	446.79	447.29	443.8	445.2	1998521.0
2024-08-07 12:00:00	QQQ	ETF	445.23	445.31	442.33	444.7899	1871929.0
2024-08-07 12:30:00	QQQ	ETF	444.74	445.01	441.78	442.34	2016833.0

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

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