PREVIEW / etf_30min / 2023-10-24

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-24.parquet
  size:    729 KB
  rows:    28,763

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-10-24 04:00:00	SPY	ETF	421.88	422.09	421.5	421.81	13442.0
2023-10-24 04:30:00	SPY	ETF	421.77	422.22	421.26	422.2	18081.0
2023-10-24 05:00:00	SPY	ETF	422.15	422.52	422.05	422.5	7447.0
2023-10-24 05:30:00	SPY	ETF	422.55	422.74	422.5	422.57	52534.0
2023-10-24 06:00:00	SPY	ETF	422.77	422.85	422.36	422.5	26060.0
2023-10-24 06:30:00	SPY	ETF	422.41	422.87	422.41	422.84	43865.0
2023-10-24 07:00:00	SPY	ETF	422.81	423.23	422.2	423.22	232447.0
2023-10-24 07:30:00	SPY	ETF	423.2	423.24	422.9	423.05	86161.0
2023-10-24 08:00:00	SPY	ETF	423.2	423.23	421.2604	423.04	186349.0
2023-10-24 08:30:00	SPY	ETF	423.04	423.25	422.81	423.17	149518.0
2023-10-24 09:00:00	SPY	ETF	423.13	423.14	422.38	422.64	558615.0
2023-10-24 09:30:00	SPY	ETF	422.64	423.89	422.43	423.835	7397941.0
2023-10-24 10:00:00	SPY	ETF	423.83	424.44	422.55	424.43	5707782.0
2023-10-24 10:30:00	SPY	ETF	424.42	424.82	423.85	424.19	4400012.0
2023-10-24 11:00:00	SPY	ETF	424.18	424.23	422.86	422.96	3664554.0
2023-10-24 11:30:00	SPY	ETF	422.965	423.3	422.55	423.27	3908394.0
2023-10-24 12:00:00	SPY	ETF	423.27	423.56	421.35	421.56	3951138.0
2023-10-24 12:30:00	SPY	ETF	421.5799	421.77	420.74	421.25	3960129.0
2023-10-24 13:00:00	SPY	ETF	421.25	422.17	421.02	422.1399	3227049.0
2023-10-24 13:30:00	SPY	ETF	422.15	422.5899	421.81	422.16	3227828.0
2023-10-24 14:00:00	SPY	ETF	422.16	422.96	421.98	422.96	2594580.0
2023-10-24 14:30:00	SPY	ETF	422.96	423.7688	422.96	423.53	3359075.0
2023-10-24 15:00:00	SPY	ETF	423.54	424.15	423.22	424.0502	3327373.0
2023-10-24 15:30:00	SPY	ETF	424.05	424.18	423.51	423.62	9670616.0
2023-10-24 16:00:00	SPY	ETF	423.61	425.5	421.1579	423.62	3333505.0
2023-10-24 16:30:00	SPY	ETF	423.63	423.85	423.3	423.5	554095.0
2023-10-24 17:00:00	SPY	ETF	423.5691	423.6	423.28	423.31	67971.0
2023-10-24 17:30:00	SPY	ETF	423.3	423.3	422.97	423.3	88474.0
2023-10-24 18:00:00	SPY	ETF	423.28	423.74	422.38	423.0	218088.0
2023-10-24 18:30:00	SPY	ETF	423.0499	423.32	422.87	423.15	43384.0
2023-10-24 19:00:00	SPY	ETF	423.15	423.27	423.02	423.02	11367.0
2023-10-24 19:30:00	SPY	ETF	423.03	423.37	423.03	423.24	51570.0
2023-10-24 04:00:00	QQQ	ETF	357.66	357.87	357.1	357.42	48495.0
2023-10-24 04:30:00	QQQ	ETF	357.25	357.57	356.62	357.5	26452.0
2023-10-24 05:00:00	QQQ	ETF	357.45	357.88	357.44	357.88	10706.0
2023-10-24 05:30:00	QQQ	ETF	357.86	358.35	357.84	358.08	63853.0
2023-10-24 06:00:00	QQQ	ETF	358.32	358.32	357.58	357.69	23181.0
2023-10-24 06:30:00	QQQ	ETF	357.65	358.04	357.65	357.88	20430.0
2023-10-24 07:00:00	QQQ	ETF	357.9	358.46	357.8	358.45	74556.0
2023-10-24 07:30:00	QQQ	ETF	358.44	358.44	358.07	358.26	105904.0
2023-10-24 08:00:00	QQQ	ETF	357.83	358.49	355.936	358.1	167328.0
2023-10-24 08:30:00	QQQ	ETF	358.08	358.18	357.74	358.06	70973.0
2023-10-24 09:00:00	QQQ	ETF	358.06	358.08	357.22	357.49	252039.0
2023-10-24 09:30:00	QQQ	ETF	357.51	358.97	357.06	358.7	5806623.0
2023-10-24 10:00:00	QQQ	ETF	358.68	359.215	357.55	359.1995	3408097.0
2023-10-24 10:30:00	QQQ	ETF	359.19	359.91	358.78	359.1494	2861773.0
2023-10-24 11:00:00	QQQ	ETF	359.15	359.5	357.9	358.08	1972740.0
2023-10-24 11:30:00	QQQ	ETF	358.09	358.59	357.51	358.5399	1908190.0
2023-10-24 12:00:00	QQQ	ETF	358.56	358.86	356.51	356.67	2020472.0
2023-10-24 12:30:00	QQQ	ETF	356.67	356.845	355.79	356.21	2392440.0

> showing 50 of 28,763 rows — these rows as CSV

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