PREVIEW / etf_30min / 2024-01-23

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-23.parquet
  size:    801 KB
  rows:    31,641

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-23 04:00:00	SPY	ETF	483.35	483.76	483.35	483.65	5298.0
2024-01-23 04:30:00	SPY	ETF	483.61	483.67	483.58	483.67	1828.0
2024-01-23 05:00:00	SPY	ETF	483.64	483.64	483.32	483.49	2099.0
2024-01-23 05:30:00	SPY	ETF	483.55	483.6	483.45	483.53	4025.0
2024-01-23 06:00:00	SPY	ETF	483.51	483.67	483.46	483.47	1995.0
2024-01-23 06:30:00	SPY	ETF	483.43	483.72	483.43	483.72	13412.0
2024-01-23 07:00:00	SPY	ETF	483.69	483.88	483.65	483.73	52866.0
2024-01-23 07:30:00	SPY	ETF	483.76	483.94	483.67	483.93	35401.0
2024-01-23 08:00:00	SPY	ETF	483.84	484.32	483.29	484.32	87806.0
2024-01-23 08:30:00	SPY	ETF	484.32	484.62	484.14	484.27	119156.0
2024-01-23 09:00:00	SPY	ETF	484.27	484.28	483.77	484.03	134285.0
2024-01-23 09:30:00	SPY	ETF	484.02	484.3737	483.54	483.96	3481754.0
2024-01-23 10:00:00	SPY	ETF	483.95	484.23	483.44	483.8495	2790825.0
2024-01-23 10:30:00	SPY	ETF	483.85	483.86	483.06	483.265	3299092.0
2024-01-23 11:00:00	SPY	ETF	483.27	483.69	482.92	483.06	2704021.0
2024-01-23 11:30:00	SPY	ETF	483.06	483.54	482.89	483.505	1933297.0
2024-01-23 12:00:00	SPY	ETF	483.5	483.5475	483.0779	483.23	1217381.0
2024-01-23 12:30:00	SPY	ETF	483.22	483.98	483.08	483.91	1571435.0
2024-01-23 13:00:00	SPY	ETF	483.91	483.99	483.65	483.7509	1830980.0
2024-01-23 13:30:00	SPY	ETF	483.76	484.03	483.5613	483.97	1528043.0
2024-01-23 14:00:00	SPY	ETF	483.9701	484.06	483.625	483.81	1417790.0
2024-01-23 14:30:00	SPY	ETF	483.81	484.48	483.64	484.33	2091658.0
2024-01-23 15:00:00	SPY	ETF	484.33	484.95	484.19	484.65	3056539.0
2024-01-23 15:30:00	SPY	ETF	484.65	485.105	484.33	484.88	7083604.0
2024-01-23 16:00:00	SPY	ETF	484.88	485.36	483.083	485.34	2835648.0
2024-01-23 16:30:00	SPY	ETF	485.35	485.58	485.3	485.51	311225.0
2024-01-23 17:00:00	SPY	ETF	485.47	485.55	485.29	485.49	113537.0
2024-01-23 17:30:00	SPY	ETF	485.45	485.49	485.43	485.45	2598.0
2024-01-23 18:00:00	SPY	ETF	485.47	485.9	485.47	485.85	126728.0
2024-01-23 18:30:00	SPY	ETF	485.84	485.92	485.81	485.9	27596.0
2024-01-23 19:00:00	SPY	ETF	485.84	485.87	485.78	485.78	11490.0
2024-01-23 19:30:00	SPY	ETF	485.78	485.99	485.75	485.97	27427.0
2024-01-23 04:00:00	QQQ	ETF	421.68	421.93	421.25	421.72	34558.0
2024-01-23 04:30:00	QQQ	ETF	421.71	421.92	421.66	421.89	13823.0
2024-01-23 05:00:00	QQQ	ETF	421.84	421.84	421.24	421.69	22235.0
2024-01-23 05:30:00	QQQ	ETF	421.62	421.62	421.37	421.47	8133.0
2024-01-23 06:00:00	QQQ	ETF	421.5	421.79	421.5	421.55	7496.0
2024-01-23 06:30:00	QQQ	ETF	421.6	422.21	421.57	422.11	45434.0
2024-01-23 07:00:00	QQQ	ETF	422.13	422.27	422.0	422.03	29797.0
2024-01-23 07:30:00	QQQ	ETF	422.04	422.46	421.93	422.32	41450.0
2024-01-23 08:00:00	QQQ	ETF	422.37	422.9	420.97	422.9	103191.0
2024-01-23 08:30:00	QQQ	ETF	422.95	423.35	422.63	422.74	142461.0
2024-01-23 09:00:00	QQQ	ETF	422.72	422.77	422.16	422.5	153448.0
2024-01-23 09:30:00	QQQ	ETF	422.43	422.44	420.57	422.125	3966029.0
2024-01-23 10:00:00	QQQ	ETF	422.12	422.37	421.0	421.88	2388309.0
2024-01-23 10:30:00	QQQ	ETF	421.92	422.19	421.39	421.615	1910605.0
2024-01-23 11:00:00	QQQ	ETF	421.63	422.255	421.21	421.37	1544971.0
2024-01-23 11:30:00	QQQ	ETF	421.3677	421.99	421.03	421.97	1196394.0
2024-01-23 12:00:00	QQQ	ETF	421.9545	422.01	421.35	421.57	711119.0
2024-01-23 12:30:00	QQQ	ETF	421.564	422.6	421.41	422.505	997468.0

> showing 50 of 31,641 rows — these rows as CSV

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