PREVIEW / etf_30min / 2023-10-02

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-02.parquet
  size:    728 KB
  rows:    29,105

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-02 04:00:00	SPY	ETF	429.0	430.18	429.0	429.79	25841.0
2023-10-02 04:30:00	SPY	ETF	429.7	430.05	429.49	429.5	6733.0
2023-10-02 05:00:00	SPY	ETF	429.42	429.5	428.67	428.67	29405.0
2023-10-02 05:30:00	SPY	ETF	428.79	428.87	427.55	427.72	30491.0
2023-10-02 06:00:00	SPY	ETF	427.64	427.75	427.31	427.46	26067.0
2023-10-02 06:30:00	SPY	ETF	427.38	427.56	427.32	427.48	47381.0
2023-10-02 07:00:00	SPY	ETF	427.48	427.75	427.35	427.69	85891.0
2023-10-02 07:30:00	SPY	ETF	427.7	427.72	426.75	426.87	204254.0
2023-10-02 08:00:00	SPY	ETF	427.47	430.19	426.22	426.6	195720.0
2023-10-02 08:30:00	SPY	ETF	426.6	426.85	426.27	426.44	166296.0
2023-10-02 09:00:00	SPY	ETF	426.41	426.69	425.85	426.61	600428.0
2023-10-02 09:30:00	SPY	ETF	426.62	427.75	426.195	426.7238	6590365.0
2023-10-02 10:00:00	SPY	ETF	426.68	428.0973	426.41	426.785	6715170.0
2023-10-02 10:30:00	SPY	ETF	426.79	427.26	425.91	426.365	4663384.0
2023-10-02 11:00:00	SPY	ETF	426.39	428.47	426.33	428.34	4588264.0
2023-10-02 11:30:00	SPY	ETF	428.3282	428.6	425.5	425.8096	5648140.0
2023-10-02 12:00:00	SPY	ETF	425.81	426.07	424.96	425.55	4458886.0
2023-10-02 12:30:00	SPY	ETF	425.55	425.8	424.46	424.82	4305430.0
2023-10-02 13:00:00	SPY	ETF	424.82	425.79	424.575	425.63	3551721.0
2023-10-02 13:30:00	SPY	ETF	425.64	426.0	425.24	425.4973	2985219.0
2023-10-02 14:00:00	SPY	ETF	425.5	426.78	424.88	424.9187	4659654.0
2023-10-02 14:30:00	SPY	ETF	424.92	425.52	424.55	425.1299	4218438.0
2023-10-02 15:00:00	SPY	ETF	425.11	426.15	424.515	425.7794	5579323.0
2023-10-02 15:30:00	SPY	ETF	425.785	427.37	425.6138	427.36	10252159.0
2023-10-02 16:00:00	SPY	ETF	427.36	427.76	425.1785	427.52	2251639.0
2023-10-02 16:30:00	SPY	ETF	427.55	427.66	427.31	427.5	184898.0
2023-10-02 17:00:00	SPY	ETF	427.61	427.61	427.26	427.35	89051.0
2023-10-02 17:30:00	SPY	ETF	427.34	427.37	427.25	427.25	18784.0
2023-10-02 18:00:00	SPY	ETF	427.36	427.69	427.31	427.68	74709.0
2023-10-02 18:30:00	SPY	ETF	427.65	427.651	427.31	427.32	18066.0
2023-10-02 19:00:00	SPY	ETF	427.4	427.45	427.09	427.11	44675.0
2023-10-02 19:30:00	SPY	ETF	427.16	427.63	427.16	427.4	48047.0
2023-10-02 04:00:00	QQQ	ETF	361.28	361.54	360.85	361.11	30824.0
2023-10-02 04:30:00	QQQ	ETF	360.89	361.35	360.74	360.75	18543.0
2023-10-02 05:00:00	QQQ	ETF	360.7	360.72	360.2	360.22	56491.0
2023-10-02 05:30:00	QQQ	ETF	360.25	360.35	359.0	359.18	98416.0
2023-10-02 06:00:00	QQQ	ETF	359.16	359.36	358.73	359.02	57048.0
2023-10-02 06:30:00	QQQ	ETF	358.86	359.14	358.8	358.88	27801.0
2023-10-02 07:00:00	QQQ	ETF	358.97	359.3	358.85	359.26	145388.0
2023-10-02 07:30:00	QQQ	ETF	359.27	359.27	358.41	358.56	118528.0
2023-10-02 08:00:00	QQQ	ETF	358.9784	361.69	357.88	358.27	231976.0
2023-10-02 08:30:00	QQQ	ETF	358.25	358.6	357.94	358.06	198363.0
2023-10-02 09:00:00	QQQ	ETF	358.0	358.56	357.4	358.56	373145.0
2023-10-02 09:30:00	QQQ	ETF	358.54	360.63	357.92	359.6599	4781064.0
2023-10-02 10:00:00	QQQ	ETF	359.65	361.4	359.33	359.96	4913705.0
2023-10-02 10:30:00	QQQ	ETF	359.97	360.92	359.3386	359.97	3090891.0
2023-10-02 11:00:00	QQQ	ETF	359.97	362.68	359.93	362.5	3329325.0
2023-10-02 11:30:00	QQQ	ETF	362.535	362.6691	359.41	359.63	3840940.0
2023-10-02 12:00:00	QQQ	ETF	359.64	360.01	358.84	359.4901	2432760.0
2023-10-02 12:30:00	QQQ	ETF	359.48	359.82	358.7138	358.95	1681929.0

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

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