PREVIEW / etf_30min / 2024-01-03

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-03.parquet
  size:    809 KB
  rows:    32,356

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-01-03 04:00:00	SPY	ETF	472.07	472.18	471.76	471.9	9401.0
2024-01-03 04:30:00	SPY	ETF	471.83	471.89	471.56	471.57	17801.0
2024-01-03 05:00:00	SPY	ETF	471.44	471.72	471.44	471.47	14110.0
2024-01-03 05:30:00	SPY	ETF	471.65	471.9	471.64	471.64	5217.0
2024-01-03 06:00:00	SPY	ETF	471.72	471.75	471.37	471.37	11942.0
2024-01-03 06:30:00	SPY	ETF	471.2	471.32	471.1	471.29	39391.0
2024-01-03 07:00:00	SPY	ETF	471.3	471.3	470.78	470.83	51135.0
2024-01-03 07:30:00	SPY	ETF	470.84	470.92	470.62	470.69	86230.0
2024-01-03 08:00:00	SPY	ETF	470.99	472.53	470.54	471.1	226530.0
2024-01-03 08:30:00	SPY	ETF	471.04	471.24	470.59	470.63	160091.0
2024-01-03 09:00:00	SPY	ETF	470.68	470.8	470.26	470.42	246956.0
2024-01-03 09:30:00	SPY	ETF	470.43	470.53	469.65	469.97	7339208.0
2024-01-03 10:00:00	SPY	ETF	469.95	470.96	469.22	469.5	6820748.0
2024-01-03 10:30:00	SPY	ETF	469.49	469.66	468.71	469.39	5473891.0
2024-01-03 11:00:00	SPY	ETF	469.39	469.93	469.38	469.71	4672570.0
2024-01-03 11:30:00	SPY	ETF	469.7	469.83	469.1299	469.2601	2670101.0
2024-01-03 12:00:00	SPY	ETF	469.26	469.59	468.97	469.58	2442667.0
2024-01-03 12:30:00	SPY	ETF	469.58	470.39	469.4205	470.3	2869983.0
2024-01-03 13:00:00	SPY	ETF	470.29	470.77	470.2631	470.33	2600561.0
2024-01-03 13:30:00	SPY	ETF	470.34	470.43	469.86	470.0825	2425833.0
2024-01-03 14:00:00	SPY	ETF	470.08	471.19	468.95	470.94	6696241.0
2024-01-03 14:30:00	SPY	ETF	470.95	471.18	470.18	470.2283	4339798.0
2024-01-03 15:00:00	SPY	ETF	470.23	470.29	468.97	469.26	4641918.0
2024-01-03 15:30:00	SPY	ETF	469.275	469.795	468.17	468.73	14749843.0
2024-01-03 16:00:00	SPY	ETF	468.73	468.82	468.51	468.73	3724081.0
2024-01-03 16:30:00	SPY	ETF	468.7	468.97	468.63	468.94	298951.0
2024-01-03 17:00:00	SPY	ETF	468.93	469.19	468.79	468.79	71618.0
2024-01-03 17:30:00	SPY	ETF	469.08	469.14	469.01	469.13	12341.0
2024-01-03 18:00:00	SPY	ETF	469.14	469.34	469.03	469.08	59512.0
2024-01-03 18:30:00	SPY	ETF	469.12	469.12	469.0	469.06	11906.0
2024-01-03 19:00:00	SPY	ETF	469.07	469.18	468.811	469.1594	51260.0
2024-01-03 19:30:00	SPY	ETF	469.14	469.36	469.08	469.35	45607.0
2024-01-03 04:00:00	QQQ	ETF	401.48	402.06	401.17	401.48	38728.0
2024-01-03 04:30:00	QQQ	ETF	401.45	401.45	400.71	400.72	20009.0
2024-01-03 05:00:00	QQQ	ETF	400.6	401.18	400.6	400.98	23280.0
2024-01-03 05:30:00	QQQ	ETF	400.99	401.45	400.99	401.1	23118.0
2024-01-03 06:00:00	QQQ	ETF	401.16	401.27	400.78	400.78	6537.0
2024-01-03 06:30:00	QQQ	ETF	400.71	400.9	400.61	400.88	23530.0
2024-01-03 07:00:00	QQQ	ETF	400.85	400.85	400.01	400.13	194969.0
2024-01-03 07:30:00	QQQ	ETF	400.1	400.12	399.8	399.9	161947.0
2024-01-03 08:00:00	QQQ	ETF	400.81	402.65	399.66	400.65	287491.0
2024-01-03 08:30:00	QQQ	ETF	400.65	400.8	400.07	400.09	162204.0
2024-01-03 09:00:00	QQQ	ETF	400.14	400.4	399.51	399.92	379371.0
2024-01-03 09:30:00	QQQ	ETF	399.93	400.76	399.26	400.07	6172470.0
2024-01-03 10:00:00	QQQ	ETF	400.03	401.0	398.71	399.25	4626798.0
2024-01-03 10:30:00	QQQ	ETF	399.25	399.71	398.4	399.6201	3519043.0
2024-01-03 11:00:00	QQQ	ETF	399.63	400.18	399.3623	399.52	2447841.0
2024-01-03 11:30:00	QQQ	ETF	399.51	399.78	398.74	398.84	1776549.0
2024-01-03 12:00:00	QQQ	ETF	398.85	399.265	398.53	399.26	1661180.0
2024-01-03 12:30:00	QQQ	ETF	399.25	399.87	399.0999	399.76	1291682.0

> showing 50 of 32,356 rows — these rows as CSV

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