PREVIEW / etf_30min / 2023-05-23

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-23.parquet
  size:    691 KB
  rows:    27,507

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-05-23 04:00:00	SPY	ETF	418.53	418.98	418.39	418.47	30472.0
2023-05-23 04:30:00	SPY	ETF	418.42	418.59	418.41	418.45	24362.0
2023-05-23 05:00:00	SPY	ETF	418.44	418.5	418.09	418.29	8833.0
2023-05-23 05:30:00	SPY	ETF	418.34	418.43	418.09	418.19	12248.0
2023-05-23 06:00:00	SPY	ETF	418.17	418.49	418.05	418.39	12910.0
2023-05-23 06:30:00	SPY	ETF	418.59	418.79	418.52	418.57	16210.0
2023-05-23 07:00:00	SPY	ETF	418.53	418.59	418.18	418.43	188223.0
2023-05-23 07:30:00	SPY	ETF	418.4	418.4	417.5	417.5	113077.0
2023-05-23 08:00:00	SPY	ETF	418.2183	419.53	417.47	417.93	135735.0
2023-05-23 08:30:00	SPY	ETF	417.91	418.03	417.5215	417.6	76287.0
2023-05-23 09:00:00	SPY	ETF	417.59	417.78	416.91	417.08	260980.0
2023-05-23 09:30:00	SPY	ETF	417.08	418.07	416.84	417.66	5631488.0
2023-05-23 10:00:00	SPY	ETF	417.65	418.13	416.96	417.73	3712501.0
2023-05-23 10:30:00	SPY	ETF	417.73	418.02	417.15	417.382	2605866.0
2023-05-23 11:00:00	SPY	ETF	417.38	417.93	417.32	417.88	1813248.0
2023-05-23 11:30:00	SPY	ETF	417.89	418.03	417.585	417.68	2285381.0
2023-05-23 12:00:00	SPY	ETF	417.68	417.9301	417.15	417.23	2213389.0
2023-05-23 12:30:00	SPY	ETF	417.24	417.34	415.89	416.313	6001846.0
2023-05-23 13:00:00	SPY	ETF	416.32	416.94	415.71	415.79	3559228.0
2023-05-23 13:30:00	SPY	ETF	415.79	416.18	415.2	415.68	4636321.0
2023-05-23 14:00:00	SPY	ETF	415.69	416.25	413.68	414.345	6632841.0
2023-05-23 14:30:00	SPY	ETF	414.35	414.86	413.965	414.71	3814447.0
2023-05-23 15:00:00	SPY	ETF	414.73	414.9068	413.885	414.75	4539677.0
2023-05-23 15:30:00	SPY	ETF	414.76	415.08	414.05	414.09	11592455.0
2023-05-23 16:00:00	SPY	ETF	414.09	416.282	414.01	414.1	3791538.0
2023-05-23 16:30:00	SPY	ETF	414.18	414.41	414.09	414.32	143571.0
2023-05-23 17:00:00	SPY	ETF	414.319	414.48	414.24	414.37	14373.0
2023-05-23 17:30:00	SPY	ETF	414.33	414.34	414.24	414.34	2008.0
2023-05-23 18:00:00	SPY	ETF	414.24	414.68	414.22	414.62	36339.0
2023-05-23 18:30:00	SPY	ETF	414.66	414.66	414.59	414.62	8852.0
2023-05-23 19:00:00	SPY	ETF	414.64	414.68	414.58	414.61	10415.0
2023-05-23 19:30:00	SPY	ETF	414.62	414.78	414.57	414.73	25985.0
2023-05-23 04:00:00	QQQ	ETF	337.77	337.93	337.57	337.72	25410.0
2023-05-23 04:30:00	QQQ	ETF	337.71	337.85	337.6	337.76	15557.0
2023-05-23 05:00:00	QQQ	ETF	337.75	337.82	337.45	337.58	16165.0
2023-05-23 05:30:00	QQQ	ETF	337.64	337.64	337.14	337.18	7135.0
2023-05-23 06:00:00	QQQ	ETF	337.17	337.59	337.11	337.5	51367.0
2023-05-23 06:30:00	QQQ	ETF	337.53	337.61	337.2	337.46	75413.0
2023-05-23 07:00:00	QQQ	ETF	337.47	337.62	337.05	337.39	97253.0
2023-05-23 07:30:00	QQQ	ETF	337.27	337.27	336.37	336.45	92890.0
2023-05-23 08:00:00	QQQ	ETF	336.9991	338.45	336.37	336.84	153520.0
2023-05-23 08:30:00	QQQ	ETF	336.84	336.84	336.1	336.16	162598.0
2023-05-23 09:00:00	QQQ	ETF	336.14	336.39	335.8	335.86	394247.0
2023-05-23 09:30:00	QQQ	ETF	335.89	337.0338	335.7	336.7	4254738.0
2023-05-23 10:00:00	QQQ	ETF	336.7	337.06	336.11	336.49	2834230.0
2023-05-23 10:30:00	QQQ	ETF	336.49	336.73	335.95	336.27	2066732.0
2023-05-23 11:00:00	QQQ	ETF	336.27	336.88	336.24	336.81	1231998.0
2023-05-23 11:30:00	QQQ	ETF	336.82	336.91	336.36	336.61	1577197.0
2023-05-23 12:00:00	QQQ	ETF	336.6	336.82	335.91	335.9986	1625574.0
2023-05-23 12:30:00	QQQ	ETF	336.01	336.079	334.57	335.03	3555675.0

> showing 50 of 27,507 rows — these rows as CSV

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