PREVIEW / etf_30min / 2024-01-24

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-24.parquet
  size:    825 KB
  rows:    32,386

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-24 04:00:00	SPY	ETF	486.86	487.07	486.81	487.0	17007.0
2024-01-24 04:30:00	SPY	ETF	486.9	487.15	486.86	487.15	4677.0
2024-01-24 05:00:00	SPY	ETF	487.15	487.26	486.76	486.88	10656.0
2024-01-24 05:30:00	SPY	ETF	486.94	486.99	486.88	486.92	26701.0
2024-01-24 06:00:00	SPY	ETF	487.07	487.2	487.0	487.07	45186.0
2024-01-24 06:30:00	SPY	ETF	487.12	487.12	487.0	487.03	2689.0
2024-01-24 07:00:00	SPY	ETF	487.07	487.14	486.81	487.04	75864.0
2024-01-24 07:30:00	SPY	ETF	487.03	487.26	486.97	487.13	51716.0
2024-01-24 08:00:00	SPY	ETF	487.0406	487.88	486.08	487.87	242598.0
2024-01-24 08:30:00	SPY	ETF	487.85	487.92	487.3	487.46	91057.0
2024-01-24 09:00:00	SPY	ETF	487.45	487.8	487.38	487.79	315147.0
2024-01-24 09:30:00	SPY	ETF	487.81	487.83	486.95	487.09	5483075.0
2024-01-24 10:00:00	SPY	ETF	487.09	487.57	486.4099	487.51	4655087.0
2024-01-24 10:30:00	SPY	ETF	487.52	488.61	487.37	487.95	5334067.0
2024-01-24 11:00:00	SPY	ETF	487.96	488.24	487.48	487.97	3476871.0
2024-01-24 11:30:00	SPY	ETF	487.97	488.4	487.68	488.32	2437059.0
2024-01-24 12:00:00	SPY	ETF	488.31	488.505	487.82	488.33	2237052.0
2024-01-24 12:30:00	SPY	ETF	488.34	488.77	488.325	488.7105	2230996.0
2024-01-24 13:00:00	SPY	ETF	488.7101	488.735	487.44	488.03	4589512.0
2024-01-24 13:30:00	SPY	ETF	488.03	488.05	486.92	487.3103	3920822.0
2024-01-24 14:00:00	SPY	ETF	487.32	487.38	485.9695	486.22	4220878.0
2024-01-24 14:30:00	SPY	ETF	486.22	487.07	486.0	486.55	3463363.0
2024-01-24 15:00:00	SPY	ETF	486.55	486.89	485.4	485.51	4794192.0
2024-01-24 15:30:00	SPY	ETF	485.52	486.4	485.01	485.32	12704252.0
2024-01-24 16:00:00	SPY	ETF	485.32	487.9175	484.41	484.74	3974707.0
2024-01-24 16:30:00	SPY	ETF	484.73	485.62	484.73	485.61	335693.0
2024-01-24 17:00:00	SPY	ETF	485.55	485.58	485.39	485.5	48467.0
2024-01-24 17:30:00	SPY	ETF	485.45	485.69	485.38	485.4	24315.0
2024-01-24 18:00:00	SPY	ETF	485.44	485.48	485.26	485.2891	211558.0
2024-01-24 18:30:00	SPY	ETF	485.26	485.4792	485.22	485.43	13808.0
2024-01-24 19:00:00	SPY	ETF	485.42	485.43	485.13	485.26	24190.0
2024-01-24 19:30:00	SPY	ETF	485.39	485.47	485.27	485.47	17060.0
2024-01-24 04:00:00	QQQ	ETF	425.62	426.8	425.59	426.65	53105.0
2024-01-24 04:30:00	QQQ	ETF	426.62	426.84	426.54	426.73	18101.0
2024-01-24 05:00:00	QQQ	ETF	426.71	426.81	426.4	426.46	10461.0
2024-01-24 05:30:00	QQQ	ETF	426.43	426.55	426.32	426.49	19218.0
2024-01-24 06:00:00	QQQ	ETF	426.5	426.66	426.32	426.41	33486.0
2024-01-24 06:30:00	QQQ	ETF	426.4	426.52	426.09	426.33	18092.0
2024-01-24 07:00:00	QQQ	ETF	426.31	426.58	426.23	426.47	57253.0
2024-01-24 07:30:00	QQQ	ETF	426.5	426.91	426.49	426.77	48795.0
2024-01-24 08:00:00	QQQ	ETF	426.25	427.4	423.797	427.37	251109.0
2024-01-24 08:30:00	QQQ	ETF	427.32	427.43	426.59	426.85	136027.0
2024-01-24 09:00:00	QQQ	ETF	426.76	427.49	426.73	427.42	220613.0
2024-01-24 09:30:00	QQQ	ETF	427.44	427.54	426.12	426.91	4421407.0
2024-01-24 10:00:00	QQQ	ETF	426.92	428.09	426.17	428.03	3154933.0
2024-01-24 10:30:00	QQQ	ETF	428.07	429.22	427.86	428.49	3269133.0
2024-01-24 11:00:00	QQQ	ETF	428.52	428.7	427.3631	427.84	2000946.0
2024-01-24 11:30:00	QQQ	ETF	427.879	428.92	427.6897	428.83	1648466.0
2024-01-24 12:00:00	QQQ	ETF	428.83	429.38	428.49	429.13	1710643.0
2024-01-24 12:30:00	QQQ	ETF	429.1699	429.85	429.165	429.66	1723650.0

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

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