PREVIEW / etf_30min / 2023-01-19

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-19.parquet
  size:    692 KB
  rows:    27,563

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-01-19 04:00:00	SPY	ETF	390.22	390.62	390.04	390.04	53580.0
2023-01-19 04:30:00	SPY	ETF	390.05	390.19	389.82	389.95	29092.0
2023-01-19 05:00:00	SPY	ETF	389.96	390.26	389.56	389.56	112186.0
2023-01-19 05:30:00	SPY	ETF	389.56	389.64	389.37	389.64	43226.0
2023-01-19 06:00:00	SPY	ETF	389.66	389.66	388.84	388.86	235468.0
2023-01-19 06:30:00	SPY	ETF	388.85	389.15	388.71	388.95	79759.0
2023-01-19 07:00:00	SPY	ETF	389.0	389.02	388.47	388.75	159755.0
2023-01-19 07:30:00	SPY	ETF	388.73	388.77	388.17	388.34	201142.0
2023-01-19 08:00:00	SPY	ETF	388.85	391.19	388.11	388.6	305343.0
2023-01-19 08:30:00	SPY	ETF	388.18	389.019	387.83	388.93	603697.0
2023-01-19 09:00:00	SPY	ETF	388.94	389.35	388.5	389.34	498826.0
2023-01-19 09:30:00	SPY	ETF	389.35	390.43	388.6196	389.28	7067983.0
2023-01-19 10:00:00	SPY	ETF	389.28	389.88	388.4	389.0689	4555485.0
2023-01-19 10:30:00	SPY	ETF	389.06	389.06	387.56	387.936	4281981.0
2023-01-19 11:00:00	SPY	ETF	387.94	389.06	387.69	387.8	3478954.0
2023-01-19 11:30:00	SPY	ETF	387.8	388.03	387.26	387.8277	3084893.0
2023-01-19 12:00:00	SPY	ETF	387.8201	389.0374	387.81	388.34	3290236.0
2023-01-19 12:30:00	SPY	ETF	388.33	388.609	387.93	388.6	1856166.0
2023-01-19 13:00:00	SPY	ETF	388.5835	389.69	388.53	389.1182	3991194.0
2023-01-19 13:30:00	SPY	ETF	389.12	390.61	389.12	389.81	4799378.0
2023-01-19 14:00:00	SPY	ETF	389.8	390.91	389.25	390.67	5098925.0
2023-01-19 14:30:00	SPY	ETF	390.67	391.08	390.25	390.467	3185078.0
2023-01-19 15:00:00	SPY	ETF	390.4723	390.895	389.895	390.25	3441191.0
2023-01-19 15:30:00	SPY	ETF	390.26	390.31	388.5	388.68	11604687.0
2023-01-19 16:00:00	SPY	ETF	388.68	389.76	388.56	389.06	5429233.0
2023-01-19 16:30:00	SPY	ETF	389.06	389.33	388.99	389.14	175289.0
2023-01-19 17:00:00	SPY	ETF	389.04	389.2	388.87	389.08	73548.0
2023-01-19 17:30:00	SPY	ETF	389.12	389.39	389.12	389.34	22594.0
2023-01-19 18:00:00	SPY	ETF	389.37	389.52	388.64	389.27	48865.0
2023-01-19 18:30:00	SPY	ETF	389.25	389.29	388.85	388.95	65766.0
2023-01-19 19:00:00	SPY	ETF	388.88	389.42	388.64	389.41	111865.0
2023-01-19 19:30:00	SPY	ETF	389.36	389.55	389.25	389.38	35628.0
2023-01-19 04:00:00	QQQ	ETF	277.08	277.54	276.98	277.0	33414.0
2023-01-19 04:30:00	QQQ	ETF	276.98	277.06	276.65	276.71	12317.0
2023-01-19 05:00:00	QQQ	ETF	276.78	276.91	276.35	276.38	18244.0
2023-01-19 05:30:00	QQQ	ETF	276.36	276.4	276.17	276.39	38375.0
2023-01-19 06:00:00	QQQ	ETF	276.23	276.27	275.55	275.55	138616.0
2023-01-19 06:30:00	QQQ	ETF	275.61	275.84	275.5	275.71	41032.0
2023-01-19 07:00:00	QQQ	ETF	275.74	275.8	275.35	275.77	128734.0
2023-01-19 07:30:00	QQQ	ETF	275.75	275.8	275.07	275.23	134880.0
2023-01-19 08:00:00	QQQ	ETF	275.59	278.088	275.07	275.69	236076.0
2023-01-19 08:30:00	QQQ	ETF	275.51	275.98	274.8	275.84	382266.0
2023-01-19 09:00:00	QQQ	ETF	275.78	276.26	275.5	276.26	369864.0
2023-01-19 09:30:00	QQQ	ETF	276.24	277.225	274.85	275.98	6027241.0
2023-01-19 10:00:00	QQQ	ETF	275.99	276.5	275.0613	275.5899	3166578.0
2023-01-19 10:30:00	QQQ	ETF	275.58	275.81	274.2	274.535	2629660.0
2023-01-19 11:00:00	QQQ	ETF	274.54	275.67	274.32	274.45	2205152.0
2023-01-19 11:30:00	QQQ	ETF	274.45	274.55	273.89	274.39	1800686.0
2023-01-19 12:00:00	QQQ	ETF	274.39	275.4	274.37	274.76	1536704.0
2023-01-19 12:30:00	QQQ	ETF	274.73	275.1386	274.51	275.01	806361.0

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

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