PREVIEW / etf_30min / 2023-05-24

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-24.parquet
  size:    697 KB
  rows:    28,228

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-24 04:00:00	SPY	ETF	413.85	413.85	412.86	413.26	26722.0
2023-05-24 04:30:00	SPY	ETF	413.25	414.02	413.25	414.0	12701.0
2023-05-24 05:00:00	SPY	ETF	413.91	414.16	413.5	413.51	26670.0
2023-05-24 05:30:00	SPY	ETF	413.51	413.56	413.33	413.36	108848.0
2023-05-24 06:00:00	SPY	ETF	413.34	413.6	412.59	412.68	32405.0
2023-05-24 06:30:00	SPY	ETF	412.67	412.96	412.52	412.9	291509.0
2023-05-24 07:00:00	SPY	ETF	412.89	413.05	412.6	412.79	166306.0
2023-05-24 07:30:00	SPY	ETF	412.79	412.87	412.4	412.46	87003.0
2023-05-24 08:00:00	SPY	ETF	413.02	414.87	412.38	412.86	129084.0
2023-05-24 08:30:00	SPY	ETF	412.82	412.84	412.21	412.29	185348.0
2023-05-24 09:00:00	SPY	ETF	412.28	412.53	412.14	412.4	272151.0
2023-05-24 09:30:00	SPY	ETF	412.42	412.49	410.97	411.135	6764544.0
2023-05-24 10:00:00	SPY	ETF	411.13	411.39	410.3	410.66	5920121.0
2023-05-24 10:30:00	SPY	ETF	410.66	411.2	410.3	410.46	4340433.0
2023-05-24 11:00:00	SPY	ETF	410.47	411.93	410.1501	411.21	5130105.0
2023-05-24 11:30:00	SPY	ETF	411.215	411.375	410.21	410.43	4670703.0
2023-05-24 12:00:00	SPY	ETF	410.43	410.98	409.8795	410.01	3002106.0
2023-05-24 12:30:00	SPY	ETF	410.02	410.7	409.89	410.61	2421752.0
2023-05-24 13:00:00	SPY	ETF	410.61	410.98	409.9901	410.47	2368602.0
2023-05-24 13:30:00	SPY	ETF	410.46	411.54	410.425	411.2	2899937.0
2023-05-24 14:00:00	SPY	ETF	411.2	411.57	410.18	410.3	2713251.0
2023-05-24 14:30:00	SPY	ETF	410.295	411.01	410.13	410.45	2669638.0
2023-05-24 15:00:00	SPY	ETF	410.46	412.31	410.17	411.98	5647813.0
2023-05-24 15:30:00	SPY	ETF	411.98	412.82	410.74	411.09	13220521.0
2023-05-24 16:00:00	SPY	ETF	411.085	413.23	410.8	412.54	4784558.0
2023-05-24 16:30:00	SPY	ETF	412.55	413.48	412.49	413.48	580944.0
2023-05-24 17:00:00	SPY	ETF	413.41	413.52	413.0	413.35	277521.0
2023-05-24 17:30:00	SPY	ETF	413.33	413.8	413.2	413.5	100253.0
2023-05-24 18:00:00	SPY	ETF	413.54	414.07	413.02	413.02	99836.0
2023-05-24 18:30:00	SPY	ETF	413.01	413.08	411.62	412.58	208093.0
2023-05-24 19:00:00	SPY	ETF	412.66	412.92	412.54	412.55	36948.0
2023-05-24 19:30:00	SPY	ETF	412.62	413.1504	412.62	412.9	91420.0
2023-05-24 04:00:00	QQQ	ETF	332.73	333.21	332.6	332.69	35000.0
2023-05-24 04:30:00	QQQ	ETF	332.75	333.31	332.75	333.25	15976.0
2023-05-24 05:00:00	QQQ	ETF	333.21	333.46	333.05	333.18	14369.0
2023-05-24 05:30:00	QQQ	ETF	333.21	333.21	333.07	333.17	5965.0
2023-05-24 06:00:00	QQQ	ETF	333.15	333.2	332.35	332.35	27808.0
2023-05-24 06:30:00	QQQ	ETF	332.45	332.55	332.27	332.48	30236.0
2023-05-24 07:00:00	QQQ	ETF	332.52	332.63	331.94	332.09	144836.0
2023-05-24 07:30:00	QQQ	ETF	332.09	332.2	331.85	331.99	103333.0
2023-05-24 08:00:00	QQQ	ETF	332.0899	333.97	331.88	332.08	258677.0
2023-05-24 08:30:00	QQQ	ETF	332.02	332.03	331.42	331.47	274045.0
2023-05-24 09:00:00	QQQ	ETF	331.44	331.49	331.03	331.38	390072.0
2023-05-24 09:30:00	QQQ	ETF	331.37	332.19	330.86	331.39	5805525.0
2023-05-24 10:00:00	QQQ	ETF	331.4	331.58	330.03	330.15	4039972.0
2023-05-24 10:30:00	QQQ	ETF	330.13	330.525	329.64	329.885	3320573.0
2023-05-24 11:00:00	QQQ	ETF	329.9	331.21	329.56	330.73	3507607.0
2023-05-24 11:30:00	QQQ	ETF	330.73	330.93	330.03	330.29	2623430.0
2023-05-24 12:00:00	QQQ	ETF	330.285	330.93	329.78	329.9382	1706453.0
2023-05-24 12:30:00	QQQ	ETF	329.95	330.5	329.84	330.42	1186012.0

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

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