PREVIEW / etf_30min / 2022-06-15

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-15.parquet
  size:    682 KB
  rows:    27,589

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-15 04:00:00	SPY	ETF	375.74	377.13	375.57	376.7	33477.0
2022-06-15 04:30:00	SPY	ETF	376.77	377.07	376.06	376.19	29784.0
2022-06-15 05:00:00	SPY	ETF	376.01	376.01	375.2	375.72	18146.0
2022-06-15 05:30:00	SPY	ETF	375.62	376.25	375.45	376.0	14595.0
2022-06-15 06:00:00	SPY	ETF	375.81	375.9	375.19	375.19	29139.0
2022-06-15 06:30:00	SPY	ETF	375.3	375.81	374.96	375.32	21166.0
2022-06-15 07:00:00	SPY	ETF	375.55	376.63	374.83	376.63	307290.0
2022-06-15 07:30:00	SPY	ETF	376.64	377.5	376.16	377.37	215418.0
2022-06-15 08:00:00	SPY	ETF	375.1901	377.49	373.78	376.5	388519.0
2022-06-15 08:30:00	SPY	ETF	376.5	377.95	376.2	377.5	334435.0
2022-06-15 09:00:00	SPY	ETF	377.6	377.72	376.8	377.34	299694.0
2022-06-15 09:30:00	SPY	ETF	377.36	379.13	376.7	378.6	6718925.0
2022-06-15 10:00:00	SPY	ETF	378.61	379.5	378.1001	378.53	4761590.0
2022-06-15 10:30:00	SPY	ETF	378.54	378.6	376.4	377.2299	4170182.0
2022-06-15 11:00:00	SPY	ETF	377.25	377.49	376.05	376.681	3077742.0
2022-06-15 11:30:00	SPY	ETF	376.72	377.5099	376.435	377.405	2339254.0
2022-06-15 12:00:00	SPY	ETF	377.42	378.24	377.06	378.02	2518854.0
2022-06-15 12:30:00	SPY	ETF	378.02	378.31	376.0	376.15	2683667.0
2022-06-15 13:00:00	SPY	ETF	376.15	377.6	376.08	377.45	2639075.0
2022-06-15 13:30:00	SPY	ETF	377.47	378.68	376.16	378.138	3092170.0
2022-06-15 14:00:00	SPY	ETF	378.14	379.98	373.75	374.81	12192510.0
2022-06-15 14:30:00	SPY	ETF	374.79	382.64	372.12	378.13	17273155.0
2022-06-15 15:00:00	SPY	ETF	378.18	382.35	377.85	382.28	9722378.0
2022-06-15 15:30:00	SPY	ETF	382.29	383.9	378.3	379.13	17099065.0
2022-06-15 16:00:00	SPY	ETF	379.13	379.48	378.25	378.5	5611616.0
2022-06-15 16:30:00	SPY	ETF	378.56	379.44	378.53	379.03	199223.0
2022-06-15 17:00:00	SPY	ETF	379.21	379.45	379.03	379.4499	103765.0
2022-06-15 17:30:00	SPY	ETF	379.45	379.74	379.4	379.7	130708.0
2022-06-15 18:00:00	SPY	ETF	379.7	380.99	379.65	380.75	195499.0
2022-06-15 18:30:00	SPY	ETF	380.8	380.89	380.37	380.75	35010.0
2022-06-15 19:00:00	SPY	ETF	380.82	380.82	380.38	380.55	54471.0
2022-06-15 19:30:00	SPY	ETF	380.62	381.71	380.6	381.71	104538.0
2022-06-15 04:00:00	QQQ	ETF	277.87	278.55	277.56	278.4	45894.0
2022-06-15 04:30:00	QQQ	ETF	278.37	278.68	277.82	277.96	23713.0
2022-06-15 05:00:00	QQQ	ETF	277.7	277.79	277.28	277.64	41828.0
2022-06-15 05:30:00	QQQ	ETF	277.86	278.1	277.5	277.87	15724.0
2022-06-15 06:00:00	QQQ	ETF	277.91	277.97	277.44	277.44	16193.0
2022-06-15 06:30:00	QQQ	ETF	277.62	277.95	277.35	277.56	46350.0
2022-06-15 07:00:00	QQQ	ETF	277.77	278.57	277.29	278.57	96744.0
2022-06-15 07:30:00	QQQ	ETF	278.59	279.32	278.37	279.21	234654.0
2022-06-15 08:00:00	QQQ	ETF	277.5	279.24	276.116	278.42	489797.0
2022-06-15 08:30:00	QQQ	ETF	278.62	280.12	278.1704	279.62	589230.0
2022-06-15 09:00:00	QQQ	ETF	279.62	279.95	278.89	279.5096	474397.0
2022-06-15 09:30:00	QQQ	ETF	279.44	280.91	278.76	280.06	5440033.0
2022-06-15 10:00:00	QQQ	ETF	280.04	281.53	279.67	280.4	2830897.0
2022-06-15 10:30:00	QQQ	ETF	280.39	280.485	278.85	279.64	2231575.0
2022-06-15 11:00:00	QQQ	ETF	279.65	280.22	279.25	279.79	1922737.0
2022-06-15 11:30:00	QQQ	ETF	279.81	280.6	279.5	280.54	1522797.0
2022-06-15 12:00:00	QQQ	ETF	280.54	281.47	280.43	281.3	1265337.0
2022-06-15 12:30:00	QQQ	ETF	281.31	281.45	279.42	279.54	1563752.0

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

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