PREVIEW / etf_30min / 2023-08-15

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-15.parquet
  size:    716 KB
  rows:    28,191

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-15 04:00:00	SPY	ETF	446.03	447.72	445.66	445.99	60766.0
2023-08-15 04:30:00	SPY	ETF	446.0	446.67	445.74	446.64	61633.0
2023-08-15 05:00:00	SPY	ETF	446.55	446.6	445.94	446.39	71053.0
2023-08-15 05:30:00	SPY	ETF	446.36	446.6	446.15	446.17	16378.0
2023-08-15 06:00:00	SPY	ETF	446.13	446.39	445.15	445.3	54963.0
2023-08-15 06:30:00	SPY	ETF	445.22	445.58	445.13	445.41	119096.0
2023-08-15 07:00:00	SPY	ETF	445.68	445.72	445.02	445.69	247895.0
2023-08-15 07:30:00	SPY	ETF	445.68	445.84	444.72	445.0	240139.0
2023-08-15 08:00:00	SPY	ETF	445.6792	448.92	444.69	445.34	241493.0
2023-08-15 08:30:00	SPY	ETF	445.36	445.68	444.56	445.06	230839.0
2023-08-15 09:00:00	SPY	ETF	445.0	446.29	444.94	446.25	359897.0
2023-08-15 09:30:00	SPY	ETF	446.27	446.64	445.0	445.25	6098856.0
2023-08-15 10:00:00	SPY	ETF	445.24	445.27	443.7101	444.02	6103125.0
2023-08-15 10:30:00	SPY	ETF	444.035	444.575	443.47	443.93	4397354.0
2023-08-15 11:00:00	SPY	ETF	443.941	445.02	443.93	444.845	2954251.0
2023-08-15 11:30:00	SPY	ETF	444.84	445.1897	444.625	445.105	2347533.0
2023-08-15 12:00:00	SPY	ETF	445.12	445.35	444.2127	444.6692	2925970.0
2023-08-15 12:30:00	SPY	ETF	444.67	444.785	443.81	444.1227	2106206.0
2023-08-15 13:00:00	SPY	ETF	444.14	444.69	443.87	444.515	2196956.0
2023-08-15 13:30:00	SPY	ETF	444.52	444.57	443.67	444.04	2925304.0
2023-08-15 14:00:00	SPY	ETF	444.05	444.2	443.72	443.88	1866505.0
2023-08-15 14:30:00	SPY	ETF	443.89	444.62	443.868	444.26	2383047.0
2023-08-15 15:00:00	SPY	ETF	444.255	444.36	442.64	442.66	3185223.0
2023-08-15 15:30:00	SPY	ETF	442.66	443.39	442.3	442.94	13818923.0
2023-08-15 16:00:00	SPY	ETF	442.94	444.11	442.72	442.97	4284757.0
2023-08-15 16:30:00	SPY	ETF	442.97	442.98	442.85	442.89	195710.0
2023-08-15 17:00:00	SPY	ETF	442.9	444.11	442.86	442.97	268203.0
2023-08-15 17:30:00	SPY	ETF	442.99	443.04	442.92	442.93	38089.0
2023-08-15 18:00:00	SPY	ETF	442.93	443.14	442.9	443.02	46316.0
2023-08-15 18:30:00	SPY	ETF	443.04	443.07	442.87	443.04	13423.0
2023-08-15 19:00:00	SPY	ETF	443.08	443.18	443.03	443.18	12598.0
2023-08-15 19:30:00	SPY	ETF	443.18	443.27	443.11	443.2	20520.0
2023-08-15 04:00:00	QQQ	ETF	368.96	370.27	368.47	368.91	115229.0
2023-08-15 04:30:00	QQQ	ETF	368.9	369.52	368.74	369.45	102633.0
2023-08-15 05:00:00	QQQ	ETF	369.45	369.5	368.83	369.26	17316.0
2023-08-15 05:30:00	QQQ	ETF	369.37	369.54	369.01	369.05	38745.0
2023-08-15 06:00:00	QQQ	ETF	369.03	369.18	367.91	368.02	86880.0
2023-08-15 06:30:00	QQQ	ETF	367.98	368.33	367.78	368.33	121012.0
2023-08-15 07:00:00	QQQ	ETF	368.36	368.68	367.82	368.67	84119.0
2023-08-15 07:30:00	QQQ	ETF	368.6	368.75	367.84	368.04	91211.0
2023-08-15 08:00:00	QQQ	ETF	368.3581	371.72	367.8	368.65	213873.0
2023-08-15 08:30:00	QQQ	ETF	368.75	368.83	367.6	368.4	352049.0
2023-08-15 09:00:00	QQQ	ETF	368.31	369.62	368.241	369.37	353031.0
2023-08-15 09:30:00	QQQ	ETF	369.36	370.169	368.1399	368.3091	4190576.0
2023-08-15 10:00:00	QQQ	ETF	368.3	368.32	366.64	367.2	4981051.0
2023-08-15 10:30:00	QQQ	ETF	367.2	367.81	366.53	367.2	3170549.0
2023-08-15 11:00:00	QQQ	ETF	367.2	368.3	367.2	368.0619	1871112.0
2023-08-15 11:30:00	QQQ	ETF	368.06	368.66	367.865	368.625	1457431.0
2023-08-15 12:00:00	QQQ	ETF	368.64	368.93	367.865	368.3399	1615244.0
2023-08-15 12:30:00	QQQ	ETF	368.35	368.44	367.48	367.83	1343779.0

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

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