PREVIEW / etf_30min / 2023-08-24

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-24.parquet
  size:    694 KB
  rows:    27,795

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
2023-08-24 04:00:00	SPY	ETF	445.8	446.36	445.75	446.13	29410.0
2023-08-24 04:30:00	SPY	ETF	446.12	446.13	445.64	445.69	15068.0
2023-08-24 05:00:00	SPY	ETF	445.77	445.79	445.26	445.33	24727.0
2023-08-24 05:30:00	SPY	ETF	445.24	445.24	444.66	444.97	26173.0
2023-08-24 06:00:00	SPY	ETF	444.95	445.72	444.9	445.6	34169.0
2023-08-24 06:30:00	SPY	ETF	445.59	445.8	445.42	445.73	9814.0
2023-08-24 07:00:00	SPY	ETF	445.72	446.0	445.53	445.65	105153.0
2023-08-24 07:30:00	SPY	ETF	445.63	445.82	445.2	445.29	189881.0
2023-08-24 08:00:00	SPY	ETF	446.0	446.6	444.7301	445.01	419063.0
2023-08-24 08:30:00	SPY	ETF	444.99	445.23	444.6	444.83	229313.0
2023-08-24 09:00:00	SPY	ETF	444.83	446.15	444.61	444.68	191394.0
2023-08-24 09:30:00	SPY	ETF	444.69	445.05	443.48	444.95	7609190.0
2023-08-24 10:00:00	SPY	ETF	444.955	445.22	442.16	442.1699	5626031.0
2023-08-24 10:30:00	SPY	ETF	442.16	442.28	441.06	441.12	6303972.0
2023-08-24 11:00:00	SPY	ETF	441.125	441.16	440.14	440.6899	5345464.0
2023-08-24 11:30:00	SPY	ETF	440.685	440.685	439.185	439.2	4268302.0
2023-08-24 12:00:00	SPY	ETF	439.21	440.46	439.1101	440.0	3626644.0
2023-08-24 12:30:00	SPY	ETF	440.0	440.818	439.86	439.89	3819126.0
2023-08-24 13:00:00	SPY	ETF	439.89	440.08	439.02	439.13	3622597.0
2023-08-24 13:30:00	SPY	ETF	439.14	439.69	439.06	439.3399	2781504.0
2023-08-24 14:00:00	SPY	ETF	439.35	439.9	439.01	439.1534	2787977.0
2023-08-24 14:30:00	SPY	ETF	439.15	439.4	438.52	439.065	3535349.0
2023-08-24 15:00:00	SPY	ETF	439.075	439.33	438.5599	438.69	3793028.0
2023-08-24 15:30:00	SPY	ETF	438.685	438.92	436.855	436.92	15224935.0
2023-08-24 16:00:00	SPY	ETF	436.92	437.21	436.45	436.48	3494553.0
2023-08-24 16:30:00	SPY	ETF	436.4603	437.0001	436.29	436.76	280840.0
2023-08-24 17:00:00	SPY	ETF	436.78	436.95	436.6501	436.77	61500.0
2023-08-24 17:30:00	SPY	ETF	436.73	436.89	436.71	436.88	13611.0
2023-08-24 18:00:00	SPY	ETF	436.81	437.26	436.8	437.2	55549.0
2023-08-24 18:30:00	SPY	ETF	437.2	437.41	437.18	437.41	41148.0
2023-08-24 19:00:00	SPY	ETF	437.41	437.42	436.89	437.21	28062.0
2023-08-24 19:30:00	SPY	ETF	437.26	437.36	437.15	437.21	39528.0
2023-08-24 04:00:00	QQQ	ETF	373.46	374.58	373.46	374.14	122530.0
2023-08-24 04:30:00	QQQ	ETF	374.16	374.21	373.53	373.7	88566.0
2023-08-24 05:00:00	QQQ	ETF	373.72	373.75	373.38	373.46	14761.0
2023-08-24 05:30:00	QQQ	ETF	373.46	373.46	372.82	373.09	60668.0
2023-08-24 06:00:00	QQQ	ETF	373.18	373.73	373.18	373.67	60001.0
2023-08-24 06:30:00	QQQ	ETF	373.66	373.83	373.5	373.63	43720.0
2023-08-24 07:00:00	QQQ	ETF	373.66	374.09	373.58	373.7	98422.0
2023-08-24 07:30:00	QQQ	ETF	373.66	373.78	373.27	373.39	77484.0
2023-08-24 08:00:00	QQQ	ETF	373.62	374.64	369.386	372.8	309959.0
2023-08-24 08:30:00	QQQ	ETF	372.8	373.11	372.37	372.78	372531.0
2023-08-24 09:00:00	QQQ	ETF	372.71	374.28	372.51	372.68	358042.0
2023-08-24 09:30:00	QQQ	ETF	372.64	372.74	369.0201	369.94	8719197.0
2023-08-24 10:00:00	QQQ	ETF	369.96	370.22	366.29	366.31	5611990.0
2023-08-24 10:30:00	QQQ	ETF	366.31	366.61	365.26	365.485	5302099.0
2023-08-24 11:00:00	QQQ	ETF	365.5	365.51	364.331	364.979	4156635.0
2023-08-24 11:30:00	QQQ	ETF	364.98	364.98	363.1891	363.3701	3256188.0
2023-08-24 12:00:00	QQQ	ETF	363.38	364.81	363.31	364.39	3206399.0
2023-08-24 12:30:00	QQQ	ETF	364.39	365.51	364.33	364.51	2419710.0

> showing 50 of 27,795 rows — these rows as CSV

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