PREVIEW / etf_30min / 2023-12-06

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-06.parquet
  size:    772 KB
  rows:    30,514

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-12-06 04:00:00	SPY	ETF	457.62	457.85	457.48	457.55	8101.0
2023-12-06 04:30:00	SPY	ETF	457.63	457.64	457.4	457.5	3015.0
2023-12-06 05:00:00	SPY	ETF	457.52	457.62	457.47	457.54	13536.0
2023-12-06 05:30:00	SPY	ETF	457.68	457.96	457.62	457.96	6294.0
2023-12-06 06:00:00	SPY	ETF	457.85	457.85	457.48	457.5	18492.0
2023-12-06 06:30:00	SPY	ETF	457.39	457.52	457.29	457.52	16236.0
2023-12-06 07:00:00	SPY	ETF	457.46	457.47	457.14	457.22	72552.0
2023-12-06 07:30:00	SPY	ETF	457.25	457.54	457.25	457.54	31084.0
2023-12-06 08:00:00	SPY	ETF	457.37	458.07	457.17	457.78	196411.0
2023-12-06 08:30:00	SPY	ETF	457.79	458.69	457.79	458.58	407228.0
2023-12-06 09:00:00	SPY	ETF	458.5502	458.94	458.5502	458.81	298047.0
2023-12-06 09:30:00	SPY	ETF	458.81	458.84	457.82	458.01	4684685.0
2023-12-06 10:00:00	SPY	ETF	458.01	458.4	456.76	457.1201	4756508.0
2023-12-06 10:30:00	SPY	ETF	457.13	457.55	456.9605	457.19	2782853.0
2023-12-06 11:00:00	SPY	ETF	457.2	457.47	456.61	456.84	2500445.0
2023-12-06 11:30:00	SPY	ETF	456.84	456.86	456.01	456.76	3729305.0
2023-12-06 12:00:00	SPY	ETF	456.76	456.86	456.13	456.265	2107812.0
2023-12-06 12:30:00	SPY	ETF	456.27	456.75	455.8	455.862	2572532.0
2023-12-06 13:00:00	SPY	ETF	455.87	456.469	455.6	456.39	2573375.0
2023-12-06 13:30:00	SPY	ETF	456.4	456.5985	456.065	456.47	1815452.0
2023-12-06 14:00:00	SPY	ETF	456.47	456.55	455.87	455.9	1978641.0
2023-12-06 14:30:00	SPY	ETF	455.91	456.38	455.82	455.83	1884037.0
2023-12-06 15:00:00	SPY	ETF	455.83	455.9	454.84	454.995	4322858.0
2023-12-06 15:30:00	SPY	ETF	454.99	455.209	454.31	454.71	11381627.0
2023-12-06 16:00:00	SPY	ETF	454.69	457.2052	454.58	454.63	4430201.0
2023-12-06 16:30:00	SPY	ETF	454.62	454.78	454.62	454.75	285213.0
2023-12-06 17:00:00	SPY	ETF	454.76	454.8	454.7	454.75	16643.0
2023-12-06 17:30:00	SPY	ETF	454.73	454.73	454.45	454.55	199183.0
2023-12-06 18:00:00	SPY	ETF	454.55	454.72	454.35	454.63	236092.0
2023-12-06 18:30:00	SPY	ETF	454.65	454.72	454.45	454.6	15630.0
2023-12-06 19:00:00	SPY	ETF	454.61	454.7099	454.44	454.44	23941.0
2023-12-06 19:30:00	SPY	ETF	454.57	454.74	454.5	454.51	20160.0
2023-12-06 04:00:00	QQQ	ETF	388.32	388.97	388.32	388.6	32081.0
2023-12-06 04:30:00	QQQ	ETF	388.59	388.64	388.16	388.38	7397.0
2023-12-06 05:00:00	QQQ	ETF	388.5	388.59	388.37	388.56	10029.0
2023-12-06 05:30:00	QQQ	ETF	388.57	388.84	388.55	388.84	8745.0
2023-12-06 06:00:00	QQQ	ETF	388.83	388.83	388.19	388.27	7068.0
2023-12-06 06:30:00	QQQ	ETF	388.05	388.33	387.9	388.2	13672.0
2023-12-06 07:00:00	QQQ	ETF	388.21	388.23	387.61	387.78	122296.0
2023-12-06 07:30:00	QQQ	ETF	387.77	388.11	387.72	388.07	57974.0
2023-12-06 08:00:00	QQQ	ETF	388.3	389.16	387.58	388.42	161089.0
2023-12-06 08:30:00	QQQ	ETF	388.5	389.9	388.5	389.82	385594.0
2023-12-06 09:00:00	QQQ	ETF	389.84	390.36	389.84	390.27	469666.0
2023-12-06 09:30:00	QQQ	ETF	390.27	390.37	387.965	388.27	4550354.0
2023-12-06 10:00:00	QQQ	ETF	388.24	388.84	386.52	387.0	3743343.0
2023-12-06 10:30:00	QQQ	ETF	387.01	388.19	386.96	387.9418	2241307.0
2023-12-06 11:00:00	QQQ	ETF	387.95	388.2898	387.13	387.3	1743872.0
2023-12-06 11:30:00	QQQ	ETF	387.32	387.5	386.215	387.4896	2384264.0
2023-12-06 12:00:00	QQQ	ETF	387.48	387.68	386.87	387.0	1200823.0
2023-12-06 12:30:00	QQQ	ETF	387.01	387.43	386.23	386.3223	1188540.0

> showing 50 of 30,514 rows — these rows as CSV

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