PREVIEW / etf_30min / 2023-08-17

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-17.parquet
  size:    723 KB
  rows:    28,437

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-17 04:00:00	SPY	ETF	440.16	440.7	440.16	440.52	10594.0
2023-08-17 04:30:00	SPY	ETF	440.53	440.85	440.32	440.44	9771.0
2023-08-17 05:00:00	SPY	ETF	440.45	440.67	440.34	440.47	12475.0
2023-08-17 05:30:00	SPY	ETF	440.43	440.8	440.24	440.77	16917.0
2023-08-17 06:00:00	SPY	ETF	440.75	440.96	440.75	440.79	14280.0
2023-08-17 06:30:00	SPY	ETF	440.76	440.78	440.38	440.61	35427.0
2023-08-17 07:00:00	SPY	ETF	440.54	440.97	440.45	440.775	379403.0
2023-08-17 07:30:00	SPY	ETF	440.78	440.99	440.7	440.96	95604.0
2023-08-17 08:00:00	SPY	ETF	440.8112	441.01	439.48	440.86	197535.0
2023-08-17 08:30:00	SPY	ETF	440.86	441.5	440.78	441.4	418206.0
2023-08-17 09:00:00	SPY	ETF	441.42	441.42	440.95	441.15	275304.0
2023-08-17 09:30:00	SPY	ETF	441.16	441.43	439.8	440.3803	6055593.0
2023-08-17 10:00:00	SPY	ETF	440.4	440.74	439.96	440.15	4076264.0
2023-08-17 10:30:00	SPY	ETF	440.15	440.58	439.39	439.9699	3896428.0
2023-08-17 11:00:00	SPY	ETF	439.97	440.075	439.3	439.31	3613908.0
2023-08-17 11:30:00	SPY	ETF	439.33	439.64	438.97	439.571	3652349.0
2023-08-17 12:00:00	SPY	ETF	439.58	440.6	438.98	440.37	2664732.0
2023-08-17 12:30:00	SPY	ETF	440.38	440.52	439.7	440.495	2264134.0
2023-08-17 13:00:00	SPY	ETF	440.495	440.61	439.17	439.31	2659257.0
2023-08-17 13:30:00	SPY	ETF	439.31	439.31	438.5099	438.82	3168059.0
2023-08-17 14:00:00	SPY	ETF	438.825	438.885	438.05	438.52	3335098.0
2023-08-17 14:30:00	SPY	ETF	438.52	438.545	436.99	437.2	4490753.0
2023-08-17 15:00:00	SPY	ETF	437.185	437.44	435.75	436.802	7401121.0
2023-08-17 15:30:00	SPY	ETF	436.81	437.22	435.98	436.26	11789601.0
2023-08-17 16:00:00	SPY	ETF	436.25	437.05	435.82	435.96	5117571.0
2023-08-17 16:30:00	SPY	ETF	435.95	436.29	435.72	435.8	209425.0
2023-08-17 17:00:00	SPY	ETF	435.8	435.93	435.79	435.82	78399.0
2023-08-17 17:30:00	SPY	ETF	435.82	435.9	435.75	435.83	21243.0
2023-08-17 18:00:00	SPY	ETF	435.88	436.19	435.55	435.7	102290.0
2023-08-17 18:30:00	SPY	ETF	435.75	435.8	435.54	435.769	26235.0
2023-08-17 19:00:00	SPY	ETF	435.8	436.1	435.8	436.03	30528.0
2023-08-17 19:30:00	SPY	ETF	436.12	436.34	436.04	436.06	45827.0
2023-08-17 04:00:00	QQQ	ETF	362.94	363.5	362.83	363.32	32530.0
2023-08-17 04:30:00	QQQ	ETF	363.39	363.6	363.1	363.2	12348.0
2023-08-17 05:00:00	QQQ	ETF	363.2	363.54	363.16	363.23	18216.0
2023-08-17 05:30:00	QQQ	ETF	363.34	363.58	363.14	363.52	12381.0
2023-08-17 06:00:00	QQQ	ETF	363.54	363.73	363.48	363.58	40325.0
2023-08-17 06:30:00	QQQ	ETF	363.57	363.6	363.03	363.16	32239.0
2023-08-17 07:00:00	QQQ	ETF	363.18	363.53	363.0	363.38	120096.0
2023-08-17 07:30:00	QQQ	ETF	363.36	363.77	363.29	363.73	188524.0
2023-08-17 08:00:00	QQQ	ETF	363.3601	363.95	362.12	363.88	254556.0
2023-08-17 08:30:00	QQQ	ETF	363.96	364.52	363.66	364.36	274300.0
2023-08-17 09:00:00	QQQ	ETF	364.32	364.45	363.73	363.95	236219.0
2023-08-17 09:30:00	QQQ	ETF	363.95	364.31	361.87	362.3899	5759178.0
2023-08-17 10:00:00	QQQ	ETF	362.385	362.739	361.25	361.4	4099485.0
2023-08-17 10:30:00	QQQ	ETF	361.37	362.185	360.65	361.44	3587420.0
2023-08-17 11:00:00	QQQ	ETF	361.46	361.71	360.78	360.93	2706774.0
2023-08-17 11:30:00	QQQ	ETF	360.95	361.875	360.69	361.81	2636695.0
2023-08-17 12:00:00	QQQ	ETF	361.82	362.81	361.09	362.655	2753876.0
2023-08-17 12:30:00	QQQ	ETF	362.66	362.97	362.06	362.96	2128265.0

> showing 50 of 28,437 rows — these rows as CSV

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