PREVIEW / etf_30min / 2023-08-02

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-02.parquet
  size:    737 KB
  rows:    29,730

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-08-02 04:00:00	SPY	ETF	452.78	454.7	451.74	452.12	75488.0
2023-08-02 04:30:00	SPY	ETF	452.15	452.74	451.88	452.73	16525.0
2023-08-02 05:00:00	SPY	ETF	452.7	453.28	452.3	452.87	140278.0
2023-08-02 05:30:00	SPY	ETF	452.86	453.23	452.65	453.09	63020.0
2023-08-02 06:00:00	SPY	ETF	453.13	453.46	453.11	453.2	25287.0
2023-08-02 06:30:00	SPY	ETF	453.39	454.37	453.31	454.37	96015.0
2023-08-02 07:00:00	SPY	ETF	454.37	454.8	454.25	454.42	221016.0
2023-08-02 07:30:00	SPY	ETF	454.46	454.54	454.13	454.251	67629.0
2023-08-02 08:00:00	SPY	ETF	454.55	454.8	451.8604	453.95	247156.0
2023-08-02 08:30:00	SPY	ETF	454.05	454.13	453.49	453.67	220486.0
2023-08-02 09:00:00	SPY	ETF	453.64	453.65	453.06	453.23	276131.0
2023-08-02 09:30:00	SPY	ETF	453.25	453.52	452.34	452.98	8183613.0
2023-08-02 10:00:00	SPY	ETF	452.99	453.085	451.6	451.96	7103899.0
2023-08-02 10:30:00	SPY	ETF	451.97	452.29	450.44	450.63	5319862.0
2023-08-02 11:00:00	SPY	ETF	450.63	451.31	450.525	451.1201	5233802.0
2023-08-02 11:30:00	SPY	ETF	451.12	451.67	450.29	450.31	3780226.0
2023-08-02 12:00:00	SPY	ETF	450.3	450.67	449.98	450.2396	4124548.0
2023-08-02 12:30:00	SPY	ETF	450.23	451.0964	450.075	450.85	2984576.0
2023-08-02 13:00:00	SPY	ETF	450.845	451.2	450.71	451.11	2287551.0
2023-08-02 13:30:00	SPY	ETF	451.11	451.435	450.455	450.57	2787864.0
2023-08-02 14:00:00	SPY	ETF	450.58	451.08	450.525	450.795	2164356.0
2023-08-02 14:30:00	SPY	ETF	450.78	450.925	450.2601	450.6182	2752928.0
2023-08-02 15:00:00	SPY	ETF	450.62	450.9	449.38	449.41	4173795.0
2023-08-02 15:30:00	SPY	ETF	449.4177	450.69	449.3499	450.14	11431716.0
2023-08-02 16:00:00	SPY	ETF	450.16	450.46	449.96	450.27	2512319.0
2023-08-02 16:30:00	SPY	ETF	450.3	450.3	449.72	449.98	576161.0
2023-08-02 17:00:00	SPY	ETF	449.99	450.05	449.85	450.05	66973.0
2023-08-02 17:30:00	SPY	ETF	450.01	450.05	449.9	449.91	21640.0
2023-08-02 18:00:00	SPY	ETF	449.99	450.6	449.98	450.6	67843.0
2023-08-02 18:30:00	SPY	ETF	450.56	450.72	450.4	450.72	21005.0
2023-08-02 19:00:00	SPY	ETF	450.74	450.89	450.73	450.75	40251.0
2023-08-02 19:30:00	SPY	ETF	450.76	450.91	450.68	450.9	61723.0
2023-08-02 04:00:00	QQQ	ETF	378.23	379.0	377.43	377.8	95210.0
2023-08-02 04:30:00	QQQ	ETF	377.84	378.45	377.48	378.43	31377.0
2023-08-02 05:00:00	QQQ	ETF	378.49	378.87	378.09	378.36	52250.0
2023-08-02 05:30:00	QQQ	ETF	378.37	378.68	378.2	378.64	24829.0
2023-08-02 06:00:00	QQQ	ETF	378.68	379.09	378.65	378.98	59359.0
2023-08-02 06:30:00	QQQ	ETF	378.88	379.83	378.65	379.81	92581.0
2023-08-02 07:00:00	QQQ	ETF	379.8	380.48	379.8	380.12	138177.0
2023-08-02 07:30:00	QQQ	ETF	380.2	380.36	379.91	379.98	118642.0
2023-08-02 08:00:00	QQQ	ETF	380.06	383.077	377.5796	379.64	325214.0
2023-08-02 08:30:00	QQQ	ETF	379.7	380.01	379.09	379.53	287745.0
2023-08-02 09:00:00	QQQ	ETF	379.52	379.52	378.94	379.22	385599.0
2023-08-02 09:30:00	QQQ	ETF	379.24	379.26	377.21	377.7	7086674.0
2023-08-02 10:00:00	QQQ	ETF	377.69	377.865	375.8301	376.315	4991151.0
2023-08-02 10:30:00	QQQ	ETF	376.3	376.63	374.8801	375.02	3530221.0
2023-08-02 11:00:00	QQQ	ETF	375.02	375.79	374.88	375.315	3956889.0
2023-08-02 11:30:00	QQQ	ETF	375.31	375.77	373.95	373.96	4372299.0
2023-08-02 12:00:00	QQQ	ETF	373.97	374.09	373.13	373.48	4499759.0
2023-08-02 12:30:00	QQQ	ETF	373.48	374.845	373.35	374.735	2627481.0

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

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