PREVIEW / etf_30min / 2024-07-01

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-01.parquet
  size:    830 KB
  rows:    33,663

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-07-01 04:00:00	SPY	ETF	544.85	545.35	544.77	545.35	22638.0
2024-07-01 04:30:00	SPY	ETF	545.48	545.48	544.45	544.63	14207.0
2024-07-01 05:00:00	SPY	ETF	544.52	544.59	544.18	544.2	11041.0
2024-07-01 05:30:00	SPY	ETF	544.29	544.8	544.29	544.8	93012.0
2024-07-01 06:00:00	SPY	ETF	545.0	545.0	544.77	544.8	9899.0
2024-07-01 06:30:00	SPY	ETF	544.7	545.2	544.64	545.15	24371.0
2024-07-01 07:00:00	SPY	ETF	545.11	545.4	544.76	545.25	179281.0
2024-07-01 07:30:00	SPY	ETF	545.26	545.57	545.26	545.46	85912.0
2024-07-01 08:00:00	SPY	ETF	545.1295	546.02	544.2304	545.44	140813.0
2024-07-01 08:30:00	SPY	ETF	545.43	545.5	544.95	545.37	100363.0
2024-07-01 09:00:00	SPY	ETF	545.4	545.65	544.81	545.63	146393.0
2024-07-01 09:30:00	SPY	ETF	545.63	545.8599	544.095	544.77	4174619.0
2024-07-01 10:00:00	SPY	ETF	544.77	545.47	542.6	544.33	3405683.0
2024-07-01 10:30:00	SPY	ETF	544.32	544.4	542.52	543.35	1900701.0
2024-07-01 11:00:00	SPY	ETF	543.34	544.25	542.88	544.22	1368362.0
2024-07-01 11:30:00	SPY	ETF	544.21	544.5	543.65	544.475	1158123.0
2024-07-01 12:00:00	SPY	ETF	544.47	545.25	543.96	545.21	1666549.0
2024-07-01 12:30:00	SPY	ETF	545.23	545.37	544.83	545.0295	1144713.0
2024-07-01 13:00:00	SPY	ETF	545.02	545.24	544.6	545.05	811817.0
2024-07-01 13:30:00	SPY	ETF	545.05	545.25	544.8	544.92	543412.0
2024-07-01 14:00:00	SPY	ETF	544.92	545.67	544.55	544.8	1444075.0
2024-07-01 14:30:00	SPY	ETF	544.8	544.96	544.45	544.755	805920.0
2024-07-01 15:00:00	SPY	ETF	544.75	545.15	543.82	544.33	1501970.0
2024-07-01 15:30:00	SPY	ETF	544.35	545.88	544.2895	545.37	5342554.0
2024-07-01 16:00:00	SPY	ETF	545.37	545.47	544.7126	545.26	2999847.0
2024-07-01 16:30:00	SPY	ETF	545.217	545.34	545.15	545.19	31141.0
2024-07-01 17:00:00	SPY	ETF	545.15	545.43	545.03	545.2	577488.0
2024-07-01 17:30:00	SPY	ETF	545.19	545.3	545.15	545.3	17261.0
2024-07-01 18:00:00	SPY	ETF	545.23	545.44	545.19	545.22	30648.0
2024-07-01 18:30:00	SPY	ETF	545.22	545.22	544.99	544.99	8408.0
2024-07-01 19:00:00	SPY	ETF	545.03	545.05	544.8	544.95	13272.0
2024-07-01 19:30:00	SPY	ETF	544.83	544.9189	544.73	544.9	16467.0
2024-07-01 04:00:00	QQQ	ETF	479.46	480.3	479.46	480.19	42274.0
2024-07-01 04:30:00	QQQ	ETF	480.2	480.21	478.87	479.1	29499.0
2024-07-01 05:00:00	QQQ	ETF	479.03	479.14	478.4	478.71	23795.0
2024-07-01 05:30:00	QQQ	ETF	478.52	479.3	478.52	479.28	14851.0
2024-07-01 06:00:00	QQQ	ETF	479.27	479.51	479.17	479.17	21150.0
2024-07-01 06:30:00	QQQ	ETF	479.13	479.79	479.1	479.71	32312.0
2024-07-01 07:00:00	QQQ	ETF	479.69	480.22	479.63	479.96	108984.0
2024-07-01 07:30:00	QQQ	ETF	480.06	480.37	480.01	480.28	39456.0
2024-07-01 08:00:00	QQQ	ETF	479.79	481.14	478.5504	480.26	141448.0
2024-07-01 08:30:00	QQQ	ETF	480.28	480.4601	479.91	480.26	97507.0
2024-07-01 09:00:00	QQQ	ETF	480.34	480.55	479.61	480.05	120237.0
2024-07-01 09:30:00	QQQ	ETF	480.04	480.4	476.945	478.09	3134844.0
2024-07-01 10:00:00	QQQ	ETF	478.12	479.42	476.255	479.21	2571774.0
2024-07-01 10:30:00	QQQ	ETF	479.24	479.55	477.5	478.545	1562774.0
2024-07-01 11:00:00	QQQ	ETF	478.52	479.72	478.03	479.5806	1008806.0
2024-07-01 11:30:00	QQQ	ETF	479.56	480.21	478.935	480.18	862151.0
2024-07-01 12:00:00	QQQ	ETF	480.18	481.23	479.76	481.17	1365061.0
2024-07-01 12:30:00	QQQ	ETF	481.15	481.41	480.81	481.0856	833581.0

> showing 50 of 33,663 rows — these rows as CSV

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