PREVIEW / etf_30min / 2024-10-16

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-16.parquet
  size:    860 KB
  rows:    33,868

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-16 04:00:00	SPY	ETF	580.14	580.23	579.6	579.96	12382.0
2024-10-16 04:30:00	SPY	ETF	579.86	580.02	579.8	579.8	14241.0
2024-10-16 05:00:00	SPY	ETF	580.0	580.17	579.8	579.8	14931.0
2024-10-16 05:30:00	SPY	ETF	580.02	580.1	579.86	580.04	8031.0
2024-10-16 06:00:00	SPY	ETF	580.06	580.11	579.85	580.09	12457.0
2024-10-16 06:30:00	SPY	ETF	580.04	580.21	580.0	580.21	11699.0
2024-10-16 07:00:00	SPY	ETF	580.14	580.39	580.11	580.36	112512.0
2024-10-16 07:30:00	SPY	ETF	580.34	580.5	580.12	580.42	59299.0
2024-10-16 08:00:00	SPY	ETF	580.1516	580.5	579.5	580.24	91540.0
2024-10-16 08:30:00	SPY	ETF	580.3	580.31	579.88	579.89	96154.0
2024-10-16 09:00:00	SPY	ETF	579.92	580.25	579.6	579.75	159940.0
2024-10-16 09:30:00	SPY	ETF	579.78	579.96	578.96	579.15	2481571.0
2024-10-16 10:00:00	SPY	ETF	579.1401	581.1501	579.07	580.81	2201758.0
2024-10-16 10:30:00	SPY	ETF	580.82	581.0299	579.47	580.0999	1079867.0
2024-10-16 11:00:00	SPY	ETF	580.12	580.73	579.78	580.6	874842.0
2024-10-16 11:30:00	SPY	ETF	580.5967	580.9	580.04	580.24	979246.0
2024-10-16 12:00:00	SPY	ETF	580.235	580.96	580.2	580.8299	582899.0
2024-10-16 12:30:00	SPY	ETF	580.85	581.4	580.695	581.39	786959.0
2024-10-16 13:00:00	SPY	ETF	581.4	581.62	580.935	581.17	802428.0
2024-10-16 13:30:00	SPY	ETF	581.18	581.69	581.14	581.635	550593.0
2024-10-16 14:00:00	SPY	ETF	581.63	582.755	581.48	582.6192	1229953.0
2024-10-16 14:30:00	SPY	ETF	582.61	582.83	582.24	582.4	1065297.0
2024-10-16 15:00:00	SPY	ETF	582.42	582.65	582.11	582.36	1255184.0
2024-10-16 15:30:00	SPY	ETF	582.36	582.53	582.1	582.24	4738090.0
2024-10-16 16:00:00	SPY	ETF	582.24	582.3415	582.02	582.22	2575076.0
2024-10-16 16:30:00	SPY	ETF	582.2495	582.3	581.93	581.93	91371.0
2024-10-16 17:00:00	SPY	ETF	582.0	582.3	581.92	582.05	27119.0
2024-10-16 17:30:00	SPY	ETF	582.03	582.04	581.9	582.0	8825.0
2024-10-16 18:00:00	SPY	ETF	582.0	582.04	581.73	581.82	28747.0
2024-10-16 18:30:00	SPY	ETF	581.78	581.9	581.77	581.86	7351.0
2024-10-16 19:00:00	SPY	ETF	581.88	581.88	581.699	581.73	7102.0
2024-10-16 19:30:00	SPY	ETF	581.73	581.73	581.5	581.54	16623.0
2024-10-16 04:00:00	QQQ	ETF	491.97	492.08	490.7	491.28	25768.0
2024-10-16 04:30:00	QQQ	ETF	491.19	491.4	490.88	491.38	16619.0
2024-10-16 05:00:00	QQQ	ETF	491.33	491.77	491.12	491.24	12256.0
2024-10-16 05:30:00	QQQ	ETF	491.2	491.45	491.19	491.34	21362.0
2024-10-16 06:00:00	QQQ	ETF	491.41	491.42	491.05	491.35	21573.0
2024-10-16 06:30:00	QQQ	ETF	491.3	491.49	491.24	491.4	4351.0
2024-10-16 07:00:00	QQQ	ETF	491.37	491.85	491.22	491.82	34113.0
2024-10-16 07:30:00	QQQ	ETF	491.76	491.87	491.5	491.64	23636.0
2024-10-16 08:00:00	QQQ	ETF	491.73	492.13	490.482	491.28	171267.0
2024-10-16 08:30:00	QQQ	ETF	491.35	491.39	490.88	491.13	301469.0
2024-10-16 09:00:00	QQQ	ETF	491.09	491.74	491.02	491.1	116268.0
2024-10-16 09:30:00	QQQ	ETF	491.18	491.23	487.79	487.9999	3136916.0
2024-10-16 10:00:00	QQQ	ETF	487.97	491.02	487.57	490.6	1975739.0
2024-10-16 10:30:00	QQQ	ETF	490.6	490.87	488.52	489.155	1520860.0
2024-10-16 11:00:00	QQQ	ETF	489.195	490.4099	488.98	490.14	775745.0
2024-10-16 11:30:00	QQQ	ETF	490.13	490.5	489.1016	489.22	788598.0
2024-10-16 12:00:00	QQQ	ETF	489.2	490.02	489.12	489.895	768313.0
2024-10-16 12:30:00	QQQ	ETF	489.9	490.7	489.69	490.645	665364.0

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

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