PREVIEW / etf_30min / 2024-10-01

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-01.parquet
  size:    888 KB
  rows:    35,420

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-10-01 04:00:00	SPY	ETF	573.5	573.81	573.14	573.28	11409.0
2024-10-01 04:30:00	SPY	ETF	573.56	573.57	573.12	573.16	3250.0
2024-10-01 05:00:00	SPY	ETF	573.17	573.32	573.0	573.32	6371.0
2024-10-01 05:30:00	SPY	ETF	573.34	573.41	573.14	573.41	5090.0
2024-10-01 06:00:00	SPY	ETF	573.33	573.84	573.33	573.84	12140.0
2024-10-01 06:30:00	SPY	ETF	573.84	574.27	573.72	574.16	81884.0
2024-10-01 07:00:00	SPY	ETF	574.15	574.38	573.75	573.76	73342.0
2024-10-01 07:30:00	SPY	ETF	573.84	573.84	573.34	573.62	24104.0
2024-10-01 08:00:00	SPY	ETF	574.25	574.352	572.88	573.46	51539.0
2024-10-01 08:30:00	SPY	ETF	573.38	573.55	573.21	573.53	30160.0
2024-10-01 09:00:00	SPY	ETF	573.51	573.69	573.05	573.38	136470.0
2024-10-01 09:30:00	SPY	ETF	573.4	573.46	568.53	569.56	7501380.0
2024-10-01 10:00:00	SPY	ETF	569.5	570.32	566.77	567.46	6397678.0
2024-10-01 10:30:00	SPY	ETF	567.48	568.79	566.61	568.03	3534997.0
2024-10-01 11:00:00	SPY	ETF	568.05	568.1	566.0	567.92	3247597.0
2024-10-01 11:30:00	SPY	ETF	567.91	569.47	567.66	568.37	3710940.0
2024-10-01 12:00:00	SPY	ETF	568.3202	569.6	568.0599	568.77	1716651.0
2024-10-01 12:30:00	SPY	ETF	568.76	568.9	566.57	568.37	4064248.0
2024-10-01 13:00:00	SPY	ETF	568.3486	568.39	566.27	566.44	3530613.0
2024-10-01 13:30:00	SPY	ETF	566.44	569.37	566.27	569.34	3500278.0
2024-10-01 14:00:00	SPY	ETF	569.32	570.6999	569.28	570.48	2851870.0
2024-10-01 14:30:00	SPY	ETF	570.49	570.93	569.88	570.4	2502764.0
2024-10-01 15:00:00	SPY	ETF	570.38	570.49	569.58	570.26	1957613.0
2024-10-01 15:30:00	SPY	ETF	570.275	570.275	568.38	568.69	5245993.0
2024-10-01 16:00:00	SPY	ETF	568.69	569.33	568.57	568.6704	2493398.0
2024-10-01 16:30:00	SPY	ETF	568.6504	568.74	568.4	568.45	120803.0
2024-10-01 17:00:00	SPY	ETF	568.42	568.66	568.42	568.55	24577.0
2024-10-01 17:30:00	SPY	ETF	568.55	568.69	568.4	568.69	24538.0
2024-10-01 18:00:00	SPY	ETF	568.73	568.98	567.49	567.86	131690.0
2024-10-01 18:30:00	SPY	ETF	567.6	568.14	567.19	567.64	66175.0
2024-10-01 19:00:00	SPY	ETF	567.47	567.96	566.98	567.29	87233.0
2024-10-01 19:30:00	SPY	ETF	567.25	568.07	567.2	567.76	146848.0
2024-10-01 04:00:00	QQQ	ETF	487.75	488.78	487.75	487.93	9568.0
2024-10-01 04:30:00	QQQ	ETF	487.89	488.35	487.86	488.1	4882.0
2024-10-01 05:00:00	QQQ	ETF	488.04	488.28	487.78	488.28	5990.0
2024-10-01 05:30:00	QQQ	ETF	488.24	488.33	488.15	488.33	7560.0
2024-10-01 06:00:00	QQQ	ETF	488.3	488.73	488.23	488.73	8074.0
2024-10-01 06:30:00	QQQ	ETF	488.79	489.24	488.7	489.17	25474.0
2024-10-01 07:00:00	QQQ	ETF	489.15	489.36	488.38	488.41	64926.0
2024-10-01 07:30:00	QQQ	ETF	488.41	488.5	487.8	488.1	29505.0
2024-10-01 08:00:00	QQQ	ETF	489.12	489.35	487.0	488.05	76852.0
2024-10-01 08:30:00	QQQ	ETF	488.097	488.17	487.75	488.1613	31679.0
2024-10-01 09:00:00	QQQ	ETF	488.199	488.32	487.42	487.63	133513.0
2024-10-01 09:30:00	QQQ	ETF	487.7	488.0	481.25	482.74	5389876.0
2024-10-01 10:00:00	QQQ	ETF	482.74	483.59	478.94	479.53	4014798.0
2024-10-01 10:30:00	QQQ	ETF	479.51	480.89	478.57	479.94	2441095.0
2024-10-01 11:00:00	QQQ	ETF	479.98	480.04	477.4	479.215	2125254.0
2024-10-01 11:30:00	QQQ	ETF	479.2	481.12	478.9	479.87	1738499.0
2024-10-01 12:00:00	QQQ	ETF	479.83	481.62	479.57	480.615	1185658.0
2024-10-01 12:30:00	QQQ	ETF	480.56	480.79	478.22	480.1499	2271201.0

> showing 50 of 35,420 rows — these rows as CSV

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