PREVIEW / etf_30min / 2021-12-20

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-20.parquet
  size:    696 KB
  rows:    27,023

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
2021-12-20 04:00:00	SPY	ETF	453.6	458.1	451.76	452.02	182079.0
2021-12-20 04:30:00	SPY	ETF	452.12	452.82	452.12	452.82	46510.0
2021-12-20 05:00:00	SPY	ETF	453.34	454.39	453.29	454.08	78893.0
2021-12-20 05:30:00	SPY	ETF	454.03	454.78	453.58	454.59	45979.0
2021-12-20 06:00:00	SPY	ETF	454.4	454.7	454.01	454.55	89598.0
2021-12-20 06:30:00	SPY	ETF	454.64	455.34	454.45	455.29	55788.0
2021-12-20 07:00:00	SPY	ETF	455.37	455.87	454.78	454.91	342406.0
2021-12-20 07:30:00	SPY	ETF	454.87	455.18	454.33	454.33	141042.0
2021-12-20 08:00:00	SPY	ETF	454.29	460.214	451.8596	454.07	394006.0
2021-12-20 08:30:00	SPY	ETF	454.06	454.51	453.8	454.25	430387.0
2021-12-20 09:00:00	SPY	ETF	454.25	455.05	454.21	454.44	513238.0
2021-12-20 09:30:00	SPY	ETF	454.44	454.947	452.54	454.09	11205633.0
2021-12-20 10:00:00	SPY	ETF	454.06	454.37	452.25	452.36	7139649.0
2021-12-20 10:30:00	SPY	ETF	452.36	453.31	451.63	451.9301	4699718.0
2021-12-20 11:00:00	SPY	ETF	451.92	452.49	451.33	451.8081	4737448.0
2021-12-20 11:30:00	SPY	ETF	451.78	452.93	451.14	452.87	3655921.0
2021-12-20 12:00:00	SPY	ETF	452.87	453.44	452.21	452.7915	2911160.0
2021-12-20 12:30:00	SPY	ETF	452.78	452.8	451.75	451.85	2737460.0
2021-12-20 13:00:00	SPY	ETF	451.84	452.77	451.55	452.56	2717590.0
2021-12-20 13:30:00	SPY	ETF	452.54	454.055	452.04	453.41	4143909.0
2021-12-20 14:00:00	SPY	ETF	453.38	454.39	453.28	453.56	3755597.0
2021-12-20 14:30:00	SPY	ETF	453.55	454.32	452.89	453.6213	3437660.0
2021-12-20 15:00:00	SPY	ETF	453.64	454.86	453.62	454.3534	5260183.0
2021-12-20 15:30:00	SPY	ETF	454.35	455.4	453.44	454.98	13451202.0
2021-12-20 16:00:00	SPY	ETF	454.98	456.3	454.61	456.18	7819648.0
2021-12-20 16:30:00	SPY	ETF	456.23	456.29	455.95	456.02	133039.0
2021-12-20 17:00:00	SPY	ETF	456.05	456.11	455.95	456.0	67645.0
2021-12-20 17:30:00	SPY	ETF	456.08	456.08	456.0	456.06	30273.0
2021-12-20 18:00:00	SPY	ETF	456.06	456.64	455.97	456.64	150821.0
2021-12-20 18:30:00	SPY	ETF	454.98	457.13	454.98	456.9	114123.0
2021-12-20 19:00:00	SPY	ETF	456.86	456.92	456.26	456.27	42320.0
2021-12-20 19:30:00	SPY	ETF	456.27	456.69	456.09	456.46	51081.0
2021-12-20 04:00:00	QQQ	ETF	382.05	382.05	377.73	378.02	192553.0
2021-12-20 04:30:00	QQQ	ETF	378.04	378.89	378.04	378.86	73848.0
2021-12-20 05:00:00	QQQ	ETF	378.86	379.24	378.71	378.88	58193.0
2021-12-20 05:30:00	QQQ	ETF	378.86	379.46	378.45	379.29	62763.0
2021-12-20 06:00:00	QQQ	ETF	379.2	379.58	378.87	379.47	43691.0
2021-12-20 06:30:00	QQQ	ETF	379.41	379.93	379.2	379.85	42527.0
2021-12-20 07:00:00	QQQ	ETF	379.96	380.5	379.52	379.56	195081.0
2021-12-20 07:30:00	QQQ	ETF	379.55	379.96	379.21	379.22	88063.0
2021-12-20 08:00:00	QQQ	ETF	380.1	380.79	377.8696	378.83	367440.0
2021-12-20 08:30:00	QQQ	ETF	378.91	379.57	378.5	379.2	324261.0
2021-12-20 09:00:00	QQQ	ETF	379.2	380.04	379.11	379.54	379545.0
2021-12-20 09:30:00	QQQ	ETF	379.59	381.5	378.69	380.81	7492504.0
2021-12-20 10:00:00	QQQ	ETF	380.81	381.1296	379.06	379.54	4942014.0
2021-12-20 10:30:00	QQQ	ETF	379.55	380.84	378.34	378.73	3671540.0
2021-12-20 11:00:00	QQQ	ETF	378.7	379.05	377.88	378.23	3012514.0
2021-12-20 11:30:00	QQQ	ETF	378.23	379.42	377.47	379.37	2834892.0
2021-12-20 12:00:00	QQQ	ETF	379.37	380.08	378.54	379.16	1872800.0
2021-12-20 12:30:00	QQQ	ETF	379.13	379.1578	378.01	378.1	1520149.0

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

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