PREVIEW / etf_30min / 2022-10-24

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-24.parquet
  size:    688 KB
  rows:    27,507

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-10-24 04:00:00	SPY	ETF	373.95	374.45	371.72	371.9	109517.0
2022-10-24 04:30:00	SPY	ETF	371.79	373.24	371.63	372.85	72886.0
2022-10-24 05:00:00	SPY	ETF	372.86	373.16	372.26	372.3	16405.0
2022-10-24 05:30:00	SPY	ETF	372.3	374.69	372.2	374.61	75659.0
2022-10-24 06:00:00	SPY	ETF	374.51	375.58	374.02	375.28	85979.0
2022-10-24 06:30:00	SPY	ETF	375.27	376.01	374.85	376.0	67566.0
2022-10-24 07:00:00	SPY	ETF	375.99	376.5	375.26	376.36	187384.0
2022-10-24 07:30:00	SPY	ETF	376.35	378.11	376.21	377.11	455851.0
2022-10-24 08:00:00	SPY	ETF	375.94	378.08	371.6896	376.06	515671.0
2022-10-24 08:30:00	SPY	ETF	376.02	377.32	375.53	377.15	382623.0
2022-10-24 09:00:00	SPY	ETF	377.15	377.22	375.72	375.9	469018.0
2022-10-24 09:30:00	SPY	ETF	375.9	378.76	375.09	377.68	10226739.0
2022-10-24 10:00:00	SPY	ETF	377.69	377.71	373.11	374.605	6653982.0
2022-10-24 10:30:00	SPY	ETF	374.62	376.81	374.15	376.615	5033746.0
2022-10-24 11:00:00	SPY	ETF	376.62	377.0299	375.46	376.745	3491873.0
2022-10-24 11:30:00	SPY	ETF	376.77	378.2	376.2	378.08	3531873.0
2022-10-24 12:00:00	SPY	ETF	378.09	378.679	377.44	378.09	3104840.0
2022-10-24 12:30:00	SPY	ETF	378.07	378.3799	377.45	377.69	2071038.0
2022-10-24 13:00:00	SPY	ETF	377.7	377.82	376.68	377.0325	2120257.0
2022-10-24 13:30:00	SPY	ETF	377.02	377.56	376.61	377.16	2446755.0
2022-10-24 14:00:00	SPY	ETF	377.17	378.24	377.05	378.03	2500147.0
2022-10-24 14:30:00	SPY	ETF	378.01	379.5	377.985	379.34	3158977.0
2022-10-24 15:00:00	SPY	ETF	379.35	380.06	379.22	379.64	4311483.0
2022-10-24 15:30:00	SPY	ETF	379.64	379.75	378.13	378.84	9493398.0
2022-10-24 16:00:00	SPY	ETF	378.84	378.89	378.5	378.62	4519134.0
2022-10-24 16:30:00	SPY	ETF	378.62	378.65	378.21	378.4	324977.0
2022-10-24 17:00:00	SPY	ETF	378.37	378.75	378.35	378.65	143306.0
2022-10-24 17:30:00	SPY	ETF	378.63	378.7	378.47	378.47	47366.0
2022-10-24 18:00:00	SPY	ETF	378.47	378.7499	378.3	378.59	99615.0
2022-10-24 18:30:00	SPY	ETF	378.64	379.24	378.51	379.24	51632.0
2022-10-24 19:00:00	SPY	ETF	379.23	379.44	379.04	379.05	71920.0
2022-10-24 19:30:00	SPY	ETF	379.15	379.18	378.71	378.86	36530.0
2022-10-24 04:00:00	QQQ	ETF	275.1	275.19	273.32	273.51	104930.0
2022-10-24 04:30:00	QQQ	ETF	273.37	274.37	273.25	274.08	38781.0
2022-10-24 05:00:00	QQQ	ETF	273.99	274.39	273.6	273.93	26144.0
2022-10-24 05:30:00	QQQ	ETF	273.68	275.57	273.58	275.42	72368.0
2022-10-24 06:00:00	QQQ	ETF	275.37	276.06	274.81	275.59	70293.0
2022-10-24 06:30:00	QQQ	ETF	275.6	276.35	275.21	276.25	101797.0
2022-10-24 07:00:00	QQQ	ETF	276.2	276.76	275.71	276.67	120226.0
2022-10-24 07:30:00	QQQ	ETF	276.7	277.8	276.54	276.96	253024.0
2022-10-24 08:00:00	QQQ	ETF	276.0505	277.8	273.3796	276.16	434126.0
2022-10-24 08:30:00	QQQ	ETF	276.11	277.0	275.55	276.69	502457.0
2022-10-24 09:00:00	QQQ	ETF	276.67	276.72	275.59	275.66	832370.0
2022-10-24 09:30:00	QQQ	ETF	275.69	277.27	274.23	275.71	10284540.0
2022-10-24 10:00:00	QQQ	ETF	275.73	275.75	271.97	273.01	5118476.0
2022-10-24 10:30:00	QQQ	ETF	273.02	275.66	272.65	275.49	4137061.0
2022-10-24 11:00:00	QQQ	ETF	275.49	276.14	274.725	275.9101	2602784.0
2022-10-24 11:30:00	QQQ	ETF	275.95	277.13	275.31	277.065	2825539.0
2022-10-24 12:00:00	QQQ	ETF	277.07	277.95	276.4601	277.325	3179861.0
2022-10-24 12:30:00	QQQ	ETF	277.33	277.78	276.79	277.3	1938673.0

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

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