PREVIEW / etf_30min / 2023-06-05

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-05.parquet
  size:    721 KB
  rows:    29,090

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-06-05 04:00:00	SPY	ETF	427.98	428.18	427.78	427.9	11351.0
2023-06-05 04:30:00	SPY	ETF	428.1	428.1	427.76	427.84	4855.0
2023-06-05 05:00:00	SPY	ETF	427.84	427.95	427.72	427.93	4677.0
2023-06-05 05:30:00	SPY	ETF	427.9	427.93	427.81	427.81	4629.0
2023-06-05 06:00:00	SPY	ETF	427.8	427.86	427.71	427.86	7909.0
2023-06-05 06:30:00	SPY	ETF	427.88	428.15	427.88	428.14	7985.0
2023-06-05 07:00:00	SPY	ETF	428.12	428.24	427.98	428.02	43848.0
2023-06-05 07:30:00	SPY	ETF	428.07	428.1	427.93	428.01	27189.0
2023-06-05 08:00:00	SPY	ETF	428.1212	428.24	427.29	428.0	88615.0
2023-06-05 08:30:00	SPY	ETF	427.91	428.21	427.86	427.93	99439.0
2023-06-05 09:00:00	SPY	ETF	427.94	428.4	427.94	428.33	409202.0
2023-06-05 09:30:00	SPY	ETF	428.3	429.67	427.89	428.2799	3547148.0
2023-06-05 10:00:00	SPY	ETF	428.26	429.46	427.63	427.88	3942677.0
2023-06-05 10:30:00	SPY	ETF	427.885	428.9101	427.7828	428.58	3934481.0
2023-06-05 11:00:00	SPY	ETF	428.575	429.01	428.38	428.9	2444135.0
2023-06-05 11:30:00	SPY	ETF	428.8801	429.16	428.63	428.934	2702069.0
2023-06-05 12:00:00	SPY	ETF	428.95	429.47	428.51	429.2787	2382193.0
2023-06-05 12:30:00	SPY	ETF	429.29	429.5699	429.095	429.5603	1602682.0
2023-06-05 13:00:00	SPY	ETF	429.56	429.62	428.29	428.5101	3149398.0
2023-06-05 13:30:00	SPY	ETF	428.545	428.565	428.04	428.4999	3177807.0
2023-06-05 14:00:00	SPY	ETF	428.51	428.56	427.68	427.9989	3244327.0
2023-06-05 14:30:00	SPY	ETF	428.0	428.0699	426.38	427.65	5703812.0
2023-06-05 15:00:00	SPY	ETF	427.66	427.79	426.37	427.1899	4467027.0
2023-06-05 15:30:00	SPY	ETF	427.18	427.7	426.98	427.1	8271193.0
2023-06-05 16:00:00	SPY	ETF	427.08	427.3234	427.04	427.22	1864326.0
2023-06-05 16:30:00	SPY	ETF	427.2	427.38	427.05	427.05	291392.0
2023-06-05 17:00:00	SPY	ETF	427.02	427.27	427.01	427.17	95656.0
2023-06-05 17:30:00	SPY	ETF	427.17	427.23	427.11	427.11	22960.0
2023-06-05 18:00:00	SPY	ETF	427.11	427.11	426.74	426.82	78280.0
2023-06-05 18:30:00	SPY	ETF	426.83	426.85	426.62	426.7	17730.0
2023-06-05 19:00:00	SPY	ETF	426.69	426.89	426.69	426.78	8458.0
2023-06-05 19:30:00	SPY	ETF	426.81	426.84	426.5	426.64	13600.0
2023-06-05 04:00:00	QQQ	ETF	353.52	354.65	353.52	353.94	14685.0
2023-06-05 04:30:00	QQQ	ETF	353.87	353.87	353.69	353.7	4450.0
2023-06-05 05:00:00	QQQ	ETF	353.79	353.92	353.62	353.92	4711.0
2023-06-05 05:30:00	QQQ	ETF	353.94	353.94	353.55	353.64	6990.0
2023-06-05 06:00:00	QQQ	ETF	353.6	353.73	353.5	353.69	13496.0
2023-06-05 06:30:00	QQQ	ETF	353.82	354.05	353.82	354.02	16946.0
2023-06-05 07:00:00	QQQ	ETF	354.03	354.33	353.96	354.1	65608.0
2023-06-05 07:30:00	QQQ	ETF	354.08	354.18	353.86	354.15	71735.0
2023-06-05 08:00:00	QQQ	ETF	354.05	354.32	353.1	354.06	169316.0
2023-06-05 08:30:00	QQQ	ETF	354.05	354.4498	353.98	354.2	107429.0
2023-06-05 09:00:00	QQQ	ETF	354.25	354.915	354.18	354.44	194400.0
2023-06-05 09:30:00	QQQ	ETF	354.43	356.45	354.43	355.1301	5331609.0
2023-06-05 10:00:00	QQQ	ETF	355.21	356.2	354.97	355.375	3275733.0
2023-06-05 10:30:00	QQQ	ETF	355.38	356.935	355.17	356.765	3267349.0
2023-06-05 11:00:00	QQQ	ETF	356.79	357.1	356.27	356.955	1748192.0
2023-06-05 11:30:00	QQQ	ETF	356.96	357.34	356.822	356.8799	1689597.0
2023-06-05 12:00:00	QQQ	ETF	356.89	357.44	356.365	357.115	1849633.0
2023-06-05 12:30:00	QQQ	ETF	357.14	357.42	356.885	357.41	1387728.0

> showing 50 of 29,090 rows — these rows as CSV

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