PREVIEW / etf_30min / 2024-04-02

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-02.parquet
  size:    834 KB
  rows:    33,043

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-04-02 04:00:00	SPY	ETF	521.79	522.36	521.79	522.27	4586.0
2024-04-02 04:30:00	SPY	ETF	522.2	522.22	521.57	521.74	6550.0
2024-04-02 05:00:00	SPY	ETF	521.78	522.05	521.78	521.99	2958.0
2024-04-02 05:30:00	SPY	ETF	521.84	521.94	521.67	521.67	1465.0
2024-04-02 06:00:00	SPY	ETF	521.5	521.5	521.18	521.4	10495.0
2024-04-02 06:30:00	SPY	ETF	521.44	521.44	520.8	521.2	18565.0
2024-04-02 07:00:00	SPY	ETF	521.17	521.22	520.57	520.8	72928.0
2024-04-02 07:30:00	SPY	ETF	520.69	520.83	520.24	520.25	68502.0
2024-04-02 08:00:00	SPY	ETF	521.68	522.3996	520.05	520.29	103239.0
2024-04-02 08:30:00	SPY	ETF	520.29	520.3	518.8	518.89	369725.0
2024-04-02 09:00:00	SPY	ETF	518.9	518.99	517.89	518.25	668560.0
2024-04-02 09:30:00	SPY	ETF	518.25	518.46	516.85	517.6	7014962.0
2024-04-02 10:00:00	SPY	ETF	517.61	518.01	516.48	517.17	5650918.0
2024-04-02 10:30:00	SPY	ETF	517.17	517.63	516.7613	516.965	2987130.0
2024-04-02 11:00:00	SPY	ETF	516.96	517.82	516.86	517.62	2264084.0
2024-04-02 11:30:00	SPY	ETF	517.625	517.865	516.99	517.1276	2051342.0
2024-04-02 12:00:00	SPY	ETF	517.125	517.465	516.9	517.435	2100834.0
2024-04-02 12:30:00	SPY	ETF	517.44	518.0	517.305	517.97	2076472.0
2024-04-02 13:00:00	SPY	ETF	517.98	518.12	517.48	517.67	1923384.0
2024-04-02 13:30:00	SPY	ETF	517.67	517.94	517.35	517.75	2129116.0
2024-04-02 14:00:00	SPY	ETF	517.76	518.12	517.66	517.905	1658109.0
2024-04-02 14:30:00	SPY	ETF	517.91	518.14	517.64	517.79	2050664.0
2024-04-02 15:00:00	SPY	ETF	517.79	518.59	517.73	518.43	3432933.0
2024-04-02 15:30:00	SPY	ETF	518.44	518.98	518.28	518.85	12784476.0
2024-04-02 16:00:00	SPY	ETF	518.85	519.05	518.6518	519.04	2964592.0
2024-04-02 16:30:00	SPY	ETF	519.03	519.12	518.167	519.011	300693.0
2024-04-02 17:00:00	SPY	ETF	519.0	519.04	518.97	519.02	50142.0
2024-04-02 17:30:00	SPY	ETF	519.01	519.14	518.84	519.12	29482.0
2024-04-02 18:00:00	SPY	ETF	519.07	519.09	518.87	518.94	46892.0
2024-04-02 18:30:00	SPY	ETF	518.94	519.0	518.73	518.73	33520.0
2024-04-02 19:00:00	SPY	ETF	518.76	518.83	518.71	518.83	10011.0
2024-04-02 19:30:00	SPY	ETF	518.81	518.81	518.7	518.72	17456.0
2024-04-02 04:00:00	QQQ	ETF	444.62	445.32	444.4	445.22	15798.0
2024-04-02 04:30:00	QQQ	ETF	445.13	445.24	444.42	444.51	9655.0
2024-04-02 05:00:00	QQQ	ETF	444.65	444.73	444.58	444.68	6361.0
2024-04-02 05:30:00	QQQ	ETF	444.58	444.79	444.23	444.23	10394.0
2024-04-02 06:00:00	QQQ	ETF	444.0	444.18	443.79	444.0	20169.0
2024-04-02 06:30:00	QQQ	ETF	444.12	444.12	443.23	443.75	24092.0
2024-04-02 07:00:00	QQQ	ETF	443.65	443.784	442.96	443.26	52598.0
2024-04-02 07:30:00	QQQ	ETF	443.24	443.38	442.73	442.8	62083.0
2024-04-02 08:00:00	QQQ	ETF	442.84	445.3704	442.64	443.0	137703.0
2024-04-02 08:30:00	QQQ	ETF	443.04	443.08	441.09	441.3	257028.0
2024-04-02 09:00:00	QQQ	ETF	441.27	441.3	439.67	440.08	620142.0
2024-04-02 09:30:00	QQQ	ETF	440.09	440.19	438.55	439.33	5412651.0
2024-04-02 10:00:00	QQQ	ETF	439.32	439.79	438.03	438.91	3917727.0
2024-04-02 10:30:00	QQQ	ETF	438.915	439.22	438.18	438.3851	2520293.0
2024-04-02 11:00:00	QQQ	ETF	438.39	439.72	438.3	439.6199	1706550.0
2024-04-02 11:30:00	QQQ	ETF	439.61	440.02	438.69	438.78	2172284.0
2024-04-02 12:00:00	QQQ	ETF	438.77	439.29	438.74	439.2799	1222472.0
2024-04-02 12:30:00	QQQ	ETF	439.27	440.15	439.21	440.13	1505020.0

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

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