PREVIEW / etf_30min / 2024-01-31

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-31.parquet
  size:    808 KB
  rows:    32,382

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-31 04:00:00	SPY	ETF	489.15	489.5	488.49	488.52	21206.0
2024-01-31 04:30:00	SPY	ETF	488.53	488.84	488.37	488.55	18924.0
2024-01-31 05:00:00	SPY	ETF	488.58	488.6	488.5	488.55	14152.0
2024-01-31 05:30:00	SPY	ETF	488.5	488.54	488.4	488.51	8878.0
2024-01-31 06:00:00	SPY	ETF	488.35	488.89	488.35	488.8	23209.0
2024-01-31 06:30:00	SPY	ETF	488.66	488.82	488.61	488.75	10677.0
2024-01-31 07:00:00	SPY	ETF	488.84	488.94	488.56	488.7	48929.0
2024-01-31 07:30:00	SPY	ETF	488.71	489.11	488.48	489.11	97938.0
2024-01-31 08:00:00	SPY	ETF	488.85	489.81	488.59	489.11	163641.0
2024-01-31 08:30:00	SPY	ETF	489.11	489.64	488.38	488.54	288751.0
2024-01-31 09:00:00	SPY	ETF	488.52	488.71	488.13	488.64	403787.0
2024-01-31 09:30:00	SPY	ETF	488.62	489.0813	487.52	487.7602	6189084.0
2024-01-31 10:00:00	SPY	ETF	487.73	487.83	487.18	487.3	3788664.0
2024-01-31 10:30:00	SPY	ETF	487.31	487.48	486.39	486.745	4358157.0
2024-01-31 11:00:00	SPY	ETF	486.74	487.48	486.72	487.03	2829316.0
2024-01-31 11:30:00	SPY	ETF	487.04	487.09	486.34	486.8399	2512724.0
2024-01-31 12:00:00	SPY	ETF	486.85	487.41	486.81	487.3383	1919822.0
2024-01-31 12:30:00	SPY	ETF	487.34	487.36	486.56	487.34	2063025.0
2024-01-31 13:00:00	SPY	ETF	487.345	487.71	487.06	487.2	2199295.0
2024-01-31 13:30:00	SPY	ETF	487.21	487.65	487.03	487.43	2020157.0
2024-01-31 14:00:00	SPY	ETF	487.43	487.83	485.63	486.14	8375692.0
2024-01-31 14:30:00	SPY	ETF	486.15	489.0	485.83	486.484	10210427.0
2024-01-31 15:00:00	SPY	ETF	486.5	486.62	483.68	484.685	12621357.0
2024-01-31 15:30:00	SPY	ETF	484.685	484.8	482.89	482.92	24067261.0
2024-01-31 16:00:00	SPY	ETF	482.915	487.3909	482.69	482.98	7275592.0
2024-01-31 16:30:00	SPY	ETF	482.98	483.26	482.95	483.26	272800.0
2024-01-31 17:00:00	SPY	ETF	483.25	483.32	482.88	483.16	79669.0
2024-01-31 17:30:00	SPY	ETF	483.14	483.4	483.06	483.4	21300.0
2024-01-31 18:00:00	SPY	ETF	483.45	483.77	483.31	483.77	61889.0
2024-01-31 18:30:00	SPY	ETF	483.72	483.76	483.59	483.72	11412.0
2024-01-31 19:00:00	SPY	ETF	483.71	484.16	483.71	484.16	51068.0
2024-01-31 19:30:00	SPY	ETF	484.15	484.3	483.96	484.02	72700.0
2024-01-31 04:00:00	QQQ	ETF	422.01	422.02	419.8	419.92	74687.0
2024-01-31 04:30:00	QQQ	ETF	420.0	420.52	419.5	420.38	95632.0
2024-01-31 05:00:00	QQQ	ETF	420.37	420.42	420.04	420.24	33144.0
2024-01-31 05:30:00	QQQ	ETF	420.26	420.38	419.8	419.8	31594.0
2024-01-31 06:00:00	QQQ	ETF	419.81	420.45	419.25	420.44	59849.0
2024-01-31 06:30:00	QQQ	ETF	420.33	420.73	420.26	420.73	68592.0
2024-01-31 07:00:00	QQQ	ETF	420.69	421.08	420.52	420.82	243158.0
2024-01-31 07:30:00	QQQ	ETF	420.82	421.59	420.52	421.55	163217.0
2024-01-31 08:00:00	QQQ	ETF	420.63	424.982	419.6296	421.5	291454.0
2024-01-31 08:30:00	QQQ	ETF	421.52	422.17	420.89	421.02	405769.0
2024-01-31 09:00:00	QQQ	ETF	421.03	421.03	420.35	420.84	341470.0
2024-01-31 09:30:00	QQQ	ETF	420.85	421.53	419.62	420.15	5948676.0
2024-01-31 10:00:00	QQQ	ETF	420.15	420.47	418.915	419.04	3018664.0
2024-01-31 10:30:00	QQQ	ETF	419.04	419.23	418.06	418.52	3167489.0
2024-01-31 11:00:00	QQQ	ETF	418.51	419.69	418.49	419.37	2351532.0
2024-01-31 11:30:00	QQQ	ETF	419.37	419.7	418.95	419.44	1608583.0
2024-01-31 12:00:00	QQQ	ETF	419.44	420.15	419.38	419.855	1527519.0
2024-01-31 12:30:00	QQQ	ETF	419.855	420.18	419.26	420.1601	1497593.0

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

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