PREVIEW / etf_30min / 2023-10-03

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-03.parquet
  size:    733 KB
  rows:    29,511

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-10-03 04:00:00	SPY	ETF	427.46	428.46	427.45	428.37	32358.0
2023-10-03 04:30:00	SPY	ETF	428.34	428.4	428.03	428.05	8929.0
2023-10-03 05:00:00	SPY	ETF	428.05	428.05	427.6	427.86	12916.0
2023-10-03 05:30:00	SPY	ETF	427.77	427.9	427.48	427.71	4128.0
2023-10-03 06:00:00	SPY	ETF	427.67	427.93	427.44	427.88	6500.0
2023-10-03 06:30:00	SPY	ETF	428.0	428.12	427.26	427.26	18777.0
2023-10-03 07:00:00	SPY	ETF	427.13	427.22	425.4	425.84	452154.0
2023-10-03 07:30:00	SPY	ETF	425.86	426.07	425.08	425.39	409773.0
2023-10-03 08:00:00	SPY	ETF	425.89	428.2896	424.83	425.38	656807.0
2023-10-03 08:30:00	SPY	ETF	425.29	425.31	424.24	424.39	368350.0
2023-10-03 09:00:00	SPY	ETF	424.39	425.21	424.22	425.06	480672.0
2023-10-03 09:30:00	SPY	ETF	425.06	426.65	424.85	426.29	5968037.0
2023-10-03 10:00:00	SPY	ETF	426.29	426.34	422.39	422.52	12191288.0
2023-10-03 10:30:00	SPY	ETF	422.52	423.14	421.46	421.763	7491738.0
2023-10-03 11:00:00	SPY	ETF	421.75	422.16	421.24	421.56	5477666.0
2023-10-03 11:30:00	SPY	ETF	421.52	421.82	420.76	421.199	4927417.0
2023-10-03 12:00:00	SPY	ETF	421.19	422.56	421.11	422.43	5680964.0
2023-10-03 12:30:00	SPY	ETF	422.45	422.58	421.8119	422.22	3450852.0
2023-10-03 13:00:00	SPY	ETF	422.21	422.83	421.61	421.82	4128186.0
2023-10-03 13:30:00	SPY	ETF	421.85	421.9099	420.74	420.89	4240051.0
2023-10-03 14:00:00	SPY	ETF	420.9	421.18	420.18	420.52	5481817.0
2023-10-03 14:30:00	SPY	ETF	420.52	421.55	420.43	421.14	3873785.0
2023-10-03 15:00:00	SPY	ETF	421.15	421.46	420.51	420.62	5242615.0
2023-10-03 15:30:00	SPY	ETF	420.61	421.74	420.29	421.67	12742063.0
2023-10-03 16:00:00	SPY	ETF	421.68	422.0713	421.5028	421.79	4138816.0
2023-10-03 16:30:00	SPY	ETF	421.75	421.76	421.27	421.2803	543221.0
2023-10-03 17:00:00	SPY	ETF	421.28	421.37	421.11	421.1715	94718.0
2023-10-03 17:30:00	SPY	ETF	421.17	421.2599	421.12	421.24	45374.0
2023-10-03 18:00:00	SPY	ETF	421.25	421.35	421.08	421.32	124006.0
2023-10-03 18:30:00	SPY	ETF	421.32	421.55	421.32	421.53	67148.0
2023-10-03 19:00:00	SPY	ETF	421.53	421.53	421.1	421.3	17570.0
2023-10-03 19:30:00	SPY	ETF	421.38	421.65	421.38	421.57	38991.0
2023-10-03 04:00:00	QQQ	ETF	361.16	362.34	361.16	362.21	25138.0
2023-10-03 04:30:00	QQQ	ETF	362.16	362.3	361.73	361.73	12671.0
2023-10-03 05:00:00	QQQ	ETF	361.75	361.75	361.15	361.38	9660.0
2023-10-03 05:30:00	QQQ	ETF	361.24	361.32	360.93	361.14	12302.0
2023-10-03 06:00:00	QQQ	ETF	361.39	361.49	361.05	361.49	6793.0
2023-10-03 06:30:00	QQQ	ETF	361.59	361.8	360.88	360.88	38136.0
2023-10-03 07:00:00	QQQ	ETF	360.86	360.87	359.42	359.64	126588.0
2023-10-03 07:30:00	QQQ	ETF	359.64	359.84	358.9	359.26	219402.0
2023-10-03 08:00:00	QQQ	ETF	359.23	362.3104	358.65	359.19	290034.0
2023-10-03 08:30:00	QQQ	ETF	359.16	359.16	358.0	358.1	338313.0
2023-10-03 09:00:00	QQQ	ETF	358.16	358.87	358.02	358.76	308636.0
2023-10-03 09:30:00	QQQ	ETF	358.78	361.01	358.605	360.44	4896326.0
2023-10-03 10:00:00	QQQ	ETF	360.45	360.51	356.15	356.29	8434251.0
2023-10-03 10:30:00	QQQ	ETF	356.3	357.12	355.46	355.59	3822125.0
2023-10-03 11:00:00	QQQ	ETF	355.58	355.8587	355.07	355.35	3087819.0
2023-10-03 11:30:00	QQQ	ETF	355.35	355.6705	354.7127	355.16	2685356.0
2023-10-03 12:00:00	QQQ	ETF	355.17	356.295	355.09	356.09	2818622.0
2023-10-03 12:30:00	QQQ	ETF	356.11	356.3	355.63	355.99	1874142.0

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

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