PREVIEW / etf_30min / 2022-06-30

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-30.parquet
  size:    672 KB
  rows:    27,184

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
2022-06-30 04:00:00	SPY	ETF	377.48	377.48	375.89	376.12	46782.0
2022-06-30 04:30:00	SPY	ETF	375.93	377.01	375.81	376.02	66019.0
2022-06-30 05:00:00	SPY	ETF	376.08	376.19	374.7	374.71	77017.0
2022-06-30 05:30:00	SPY	ETF	374.72	375.88	374.6	375.82	48679.0
2022-06-30 06:00:00	SPY	ETF	375.8	375.99	375.01	375.01	66823.0
2022-06-30 06:30:00	SPY	ETF	375.06	375.55	374.67	375.51	72309.0
2022-06-30 07:00:00	SPY	ETF	375.55	375.61	375.1	375.56	112775.0
2022-06-30 07:30:00	SPY	ETF	375.54	375.54	374.54	375.01	204502.0
2022-06-30 08:00:00	SPY	ETF	375.5001	379.4	374.56	375.38	328539.0
2022-06-30 08:30:00	SPY	ETF	375.33	376.87	375.31	375.31	782141.0
2022-06-30 09:00:00	SPY	ETF	375.31	376.54	375.07	376.24	413944.0
2022-06-30 09:30:00	SPY	ETF	376.24	377.0	373.05	373.3421	8539567.0
2022-06-30 10:00:00	SPY	ETF	373.36	374.08	372.56	373.53	4901179.0
2022-06-30 10:30:00	SPY	ETF	373.5201	375.9	373.27	375.775	5387042.0
2022-06-30 11:00:00	SPY	ETF	375.74	377.84	374.84	377.28	4049444.0
2022-06-30 11:30:00	SPY	ETF	377.28	378.43	376.435	378.3413	4700201.0
2022-06-30 12:00:00	SPY	ETF	378.345	379.9	376.9	379.84	4007485.0
2022-06-30 12:30:00	SPY	ETF	379.84	380.6582	379.06	379.59	3772986.0
2022-06-30 13:00:00	SPY	ETF	379.585	380.1439	377.71	379.02	3902243.0
2022-06-30 13:30:00	SPY	ETF	379.02	380.48	378.6	379.835	3678826.0
2022-06-30 14:00:00	SPY	ETF	379.83	380.12	377.86	378.73	3792883.0
2022-06-30 14:30:00	SPY	ETF	378.765	379.03	376.74	377.23	3933859.0
2022-06-30 15:00:00	SPY	ETF	377.25	377.54	375.09	377.4599	6278664.0
2022-06-30 15:30:00	SPY	ETF	377.44	378.7	375.48	377.285	18066549.0
2022-06-30 16:00:00	SPY	ETF	377.285	380.5345	376.18	376.94	6465597.0
2022-06-30 16:30:00	SPY	ETF	376.93	377.0	376.45	376.48	245749.0
2022-06-30 17:00:00	SPY	ETF	376.56	376.65	376.48	376.6	52609.0
2022-06-30 17:30:00	SPY	ETF	376.63	377.25	376.52	376.57	164912.0
2022-06-30 18:00:00	SPY	ETF	376.55	376.64	375.72	375.9	97883.0
2022-06-30 18:30:00	SPY	ETF	376.08	376.4	375.91	376.1	37827.0
2022-06-30 19:00:00	SPY	ETF	376.15	376.86	375.97	376.86	21479.0
2022-06-30 19:30:00	SPY	ETF	376.79	377.49	376.59	377.37	80346.0
2022-06-30 04:00:00	QQQ	ETF	280.84	280.95	280.0	280.08	72707.0
2022-06-30 04:30:00	QQQ	ETF	280.0	280.72	279.78	279.91	66535.0
2022-06-30 05:00:00	QQQ	ETF	279.92	279.97	278.42	278.54	108603.0
2022-06-30 05:30:00	QQQ	ETF	278.59	279.48	278.51	279.47	73935.0
2022-06-30 06:00:00	QQQ	ETF	279.47	279.53	279.01	279.03	30716.0
2022-06-30 06:30:00	QQQ	ETF	278.97	279.55	278.76	279.35	67176.0
2022-06-30 07:00:00	QQQ	ETF	279.43	279.82	279.14	279.75	134248.0
2022-06-30 07:30:00	QQQ	ETF	279.7	279.7	278.87	279.17	259074.0
2022-06-30 08:00:00	QQQ	ETF	279.4913	282.9	278.5204	279.6	435504.0
2022-06-30 08:30:00	QQQ	ETF	279.7	281.28	279.61	279.75	960856.0
2022-06-30 09:00:00	QQQ	ETF	279.73	280.89	279.59	280.75	468563.0
2022-06-30 09:30:00	QQQ	ETF	280.75	281.5196	276.81	276.92	8362024.0
2022-06-30 10:00:00	QQQ	ETF	276.93	277.17	275.78	276.72	6036335.0
2022-06-30 10:30:00	QQQ	ETF	276.7	279.24	276.5011	279.1	5232662.0
2022-06-30 11:00:00	QQQ	ETF	279.1199	281.73	278.35	281.17	4484179.0
2022-06-30 11:30:00	QQQ	ETF	281.18	282.18	280.31	282.1097	3581532.0
2022-06-30 12:00:00	QQQ	ETF	282.065	283.26	280.365	283.09	3365963.0
2022-06-30 12:30:00	QQQ	ETF	283.1099	283.89	282.29	282.69	3424732.0

> showing 50 of 27,184 rows — these rows as CSV

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