PREVIEW / etf_30min / 2023-11-02

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-02.parquet
  size:    762 KB
  rows:    30,246

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-11-02 04:00:00	SPY	ETF	423.94	424.72	423.8	424.69	35557.0
2023-11-02 04:30:00	SPY	ETF	424.65	425.0	424.48	424.75	13574.0
2023-11-02 05:00:00	SPY	ETF	424.84	425.11	424.84	425.1	121555.0
2023-11-02 05:30:00	SPY	ETF	425.1	425.23	424.85	424.95	93459.0
2023-11-02 06:00:00	SPY	ETF	424.95	424.95	424.61	424.71	233869.0
2023-11-02 06:30:00	SPY	ETF	424.66	425.06	424.6	425.0	34821.0
2023-11-02 07:00:00	SPY	ETF	424.9	425.17	424.88	425.09	61724.0
2023-11-02 07:30:00	SPY	ETF	425.1	425.41	424.95	425.23	155240.0
2023-11-02 08:00:00	SPY	ETF	424.94	425.93	423.52	425.84	289920.0
2023-11-02 08:30:00	SPY	ETF	425.85	426.98	425.85	426.81	561234.0
2023-11-02 09:00:00	SPY	ETF	426.8	426.83	426.28	426.58	551520.0
2023-11-02 09:30:00	SPY	ETF	426.58	428.03	426.56	427.49	9001142.0
2023-11-02 10:00:00	SPY	ETF	427.49	428.41	426.7601	428.22	5594907.0
2023-11-02 10:30:00	SPY	ETF	428.225	429.32	428.17	429.32	5254396.0
2023-11-02 11:00:00	SPY	ETF	429.31	429.34	428.17	428.69	4844375.0
2023-11-02 11:30:00	SPY	ETF	428.68	429.3	428.55	428.78	2944792.0
2023-11-02 12:00:00	SPY	ETF	428.77	428.9501	428.43	428.73	2571188.0
2023-11-02 12:30:00	SPY	ETF	428.74	429.56	428.62	429.12	3462536.0
2023-11-02 13:00:00	SPY	ETF	429.12	429.82	428.92	429.62	4539857.0
2023-11-02 13:30:00	SPY	ETF	429.64	430.52	429.635	430.275	3830853.0
2023-11-02 14:00:00	SPY	ETF	430.275	430.305	429.75	430.1409	3482470.0
2023-11-02 14:30:00	SPY	ETF	430.1699	430.47	430.0	430.25	2558576.0
2023-11-02 15:00:00	SPY	ETF	430.25	430.52	430.08	430.265	3406388.0
2023-11-02 15:30:00	SPY	ETF	430.26	430.915	430.22	430.75	13530151.0
2023-11-02 16:00:00	SPY	ETF	430.75	430.8	427.5834	430.35	4989428.0
2023-11-02 16:30:00	SPY	ETF	430.31	431.04	429.74	430.45	707896.0
2023-11-02 17:00:00	SPY	ETF	430.47	430.63	429.9	430.1	153025.0
2023-11-02 17:30:00	SPY	ETF	430.1	430.22	429.75	429.75	76442.0
2023-11-02 18:00:00	SPY	ETF	429.83	430.37	429.83	430.25	74226.0
2023-11-02 18:30:00	SPY	ETF	430.18	430.23	430.01	430.04	12308.0
2023-11-02 19:00:00	SPY	ETF	430.02	430.15	429.96	430.02	35808.0
2023-11-02 19:30:00	SPY	ETF	430.0	430.04	429.85	429.91	27196.0
2023-11-02 04:00:00	QQQ	ETF	359.11	359.61	358.79	359.52	66744.0
2023-11-02 04:30:00	QQQ	ETF	359.54	359.7	359.24	359.6	16368.0
2023-11-02 05:00:00	QQQ	ETF	359.64	359.98	359.59	359.97	23643.0
2023-11-02 05:30:00	QQQ	ETF	359.99	360.1	359.69	359.77	64545.0
2023-11-02 06:00:00	QQQ	ETF	359.8	359.99	359.76	359.88	21246.0
2023-11-02 06:30:00	QQQ	ETF	359.86	360.24	359.81	360.1	37457.0
2023-11-02 07:00:00	QQQ	ETF	360.14	360.3	359.97	360.18	56467.0
2023-11-02 07:30:00	QQQ	ETF	360.19	360.7	360.08	360.48	150739.0
2023-11-02 08:00:00	QQQ	ETF	360.08	361.37	357.227	361.14	379729.0
2023-11-02 08:30:00	QQQ	ETF	361.19	362.33	361.18	362.17	783316.0
2023-11-02 09:00:00	QQQ	ETF	362.15	362.19	361.41	361.54	429777.0
2023-11-02 09:30:00	QQQ	ETF	361.54	362.31	361.05	361.4203	7029004.0
2023-11-02 10:00:00	QQQ	ETF	361.42	361.9	360.3	361.73	4397571.0
2023-11-02 10:30:00	QQQ	ETF	361.73	362.62	361.31	362.465	2999086.0
2023-11-02 11:00:00	QQQ	ETF	362.48	362.76	361.78	362.01	3157890.0
2023-11-02 11:30:00	QQQ	ETF	362.03	362.5468	361.702	362.02	2291156.0
2023-11-02 12:00:00	QQQ	ETF	362.037	362.16	361.6	362.0	1674980.0
2023-11-02 12:30:00	QQQ	ETF	362.03	362.71	361.8	362.32	1818933.0

> showing 50 of 30,246 rows — these rows as CSV

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