PREVIEW / etf_30min / 2024-06-05

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-05.parquet
  size:    811 KB
  rows:    32,308

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-06-05 04:00:00	SPY	ETF	528.91	529.18	528.75	528.84	4804.0
2024-06-05 04:30:00	SPY	ETF	528.99	529.19	528.99	529.15	10269.0
2024-06-05 05:00:00	SPY	ETF	529.2	529.36	529.17	529.25	25812.0
2024-06-05 05:30:00	SPY	ETF	529.27	529.56	529.25	529.51	4196.0
2024-06-05 06:00:00	SPY	ETF	529.49	529.73	529.48	529.62	6918.0
2024-06-05 06:30:00	SPY	ETF	529.58	529.64	529.41	529.45	14273.0
2024-06-05 07:00:00	SPY	ETF	529.5	529.67	528.92	529.67	174627.0
2024-06-05 07:30:00	SPY	ETF	529.67	530.13	529.67	530.05	37938.0
2024-06-05 08:00:00	SPY	ETF	529.44	530.2	528.72	529.88	155323.0
2024-06-05 08:30:00	SPY	ETF	529.78	530.49	529.57	530.49	114985.0
2024-06-05 09:00:00	SPY	ETF	530.5	530.85	530.45	530.77	140631.0
2024-06-05 09:30:00	SPY	ETF	530.77	530.82	529.51	530.08	3606899.0
2024-06-05 10:00:00	SPY	ETF	530.09	530.41	528.7254	530.265	3012005.0
2024-06-05 10:30:00	SPY	ETF	530.28	531.1198	530.28	530.96	2296917.0
2024-06-05 11:00:00	SPY	ETF	530.95	532.185	530.95	531.915	2408088.0
2024-06-05 11:30:00	SPY	ETF	531.91	532.44	531.86	532.03	1673754.0
2024-06-05 12:00:00	SPY	ETF	532.025	532.225	531.73	532.1303	1105170.0
2024-06-05 12:30:00	SPY	ETF	532.13	532.81	532.08	532.645	1266046.0
2024-06-05 13:00:00	SPY	ETF	532.65	532.98	532.15	532.73	1381151.0
2024-06-05 13:30:00	SPY	ETF	532.73	533.3	532.62	533.26	1302786.0
2024-06-05 14:00:00	SPY	ETF	533.25	533.49	533.015	533.4801	1388271.0
2024-06-05 14:30:00	SPY	ETF	533.49	534.0	533.435	533.85	2059215.0
2024-06-05 15:00:00	SPY	ETF	533.86	534.17	533.64	533.7	1803660.0
2024-06-05 15:30:00	SPY	ETF	533.69	534.69	533.24	534.65	6632307.0
2024-06-05 16:00:00	SPY	ETF	534.64	534.67	533.6	534.61	3247462.0
2024-06-05 16:30:00	SPY	ETF	534.65	534.79	534.56	534.56	71978.0
2024-06-05 17:00:00	SPY	ETF	534.6787	534.6787	534.32	534.44	73967.0
2024-06-05 17:30:00	SPY	ETF	534.52	534.67	534.36	534.62	14254.0
2024-06-05 18:00:00	SPY	ETF	534.53	534.63	534.3597	534.46	37874.0
2024-06-05 18:30:00	SPY	ETF	534.49	535.0	534.46	534.95	34725.0
2024-06-05 19:00:00	SPY	ETF	535.0	535.19	534.96	534.96	9763.0
2024-06-05 19:30:00	SPY	ETF	534.97	534.99	534.9	534.98	33997.0
2024-06-05 04:00:00	QQQ	ETF	455.17	455.66	455.1	455.29	14689.0
2024-06-05 04:30:00	QQQ	ETF	455.48	455.85	455.48	455.72	9806.0
2024-06-05 05:00:00	QQQ	ETF	455.78	456.3	455.73	456.09	29272.0
2024-06-05 05:30:00	QQQ	ETF	456.2	456.51	455.94	456.47	29032.0
2024-06-05 06:00:00	QQQ	ETF	456.5	456.72	456.29	456.47	25995.0
2024-06-05 06:30:00	QQQ	ETF	456.67	456.67	456.24	456.24	62654.0
2024-06-05 07:00:00	QQQ	ETF	456.31	456.56	456.0	456.56	46753.0
2024-06-05 07:30:00	QQQ	ETF	456.56	457.18	456.56	456.99	76445.0
2024-06-05 08:00:00	QQQ	ETF	456.3103	457.2	454.6	456.67	153050.0
2024-06-05 08:30:00	QQQ	ETF	456.65	457.48	456.37	457.43	127531.0
2024-06-05 09:00:00	QQQ	ETF	457.43	458.05	457.39	458.0	118181.0
2024-06-05 09:30:00	QQQ	ETF	457.98	458.25	457.14	458.21	2670852.0
2024-06-05 10:00:00	QQQ	ETF	458.21	459.06	456.77	459.03	2424562.0
2024-06-05 10:30:00	QQQ	ETF	459.03	460.11	459.03	459.75	1791132.0
2024-06-05 11:00:00	QQQ	ETF	459.75	461.16	459.74	460.77	1997019.0
2024-06-05 11:30:00	QQQ	ETF	460.77	461.3	460.67	460.76	1338119.0
2024-06-05 12:00:00	QQQ	ETF	460.76	461.16	460.53	460.97	663088.0
2024-06-05 12:30:00	QQQ	ETF	460.96	461.8	460.785	461.7	874500.0

> showing 50 of 32,308 rows — these rows as CSV

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