PREVIEW / etf_30min / 2021-11-30

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-30.parquet
  size:    683 KB
  rows:    27,167

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-11-30 04:00:00	SPY	ETF	460.2	460.2	458.56	458.98	90457.0
2021-11-30 04:30:00	SPY	ETF	458.73	460.0	458.6	460.0	33250.0
2021-11-30 05:00:00	SPY	ETF	460.0	460.09	459.17	459.49	31249.0
2021-11-30 05:30:00	SPY	ETF	459.76	460.3	459.5	460.22	32774.0
2021-11-30 06:00:00	SPY	ETF	460.19	460.5	459.36	460.26	64724.0
2021-11-30 06:30:00	SPY	ETF	460.54	460.58	459.88	460.1	83214.0
2021-11-30 07:00:00	SPY	ETF	460.0	461.6	459.99	461.47	555748.0
2021-11-30 07:30:00	SPY	ETF	461.47	461.49	460.1	460.71	326933.0
2021-11-30 08:00:00	SPY	ETF	460.74	465.03	458.33	460.48	468950.0
2021-11-30 08:30:00	SPY	ETF	460.44	462.2	460.03	462.15	772047.0
2021-11-30 09:00:00	SPY	ETF	462.15	462.43	461.53	461.99	513566.0
2021-11-30 09:30:00	SPY	ETF	462.0	463.0	461.11	462.44	8776725.0
2021-11-30 10:00:00	SPY	ETF	462.44	463.905	462.15	462.82	4971011.0
2021-11-30 10:30:00	SPY	ETF	462.83	464.03	457.98	458.035	10873251.0
2021-11-30 11:00:00	SPY	ETF	458.03	459.89	457.14	458.65	9166544.0
2021-11-30 11:30:00	SPY	ETF	458.64	459.15	456.21	457.29	7169143.0
2021-11-30 12:00:00	SPY	ETF	457.28	457.84	455.8237	457.68	5778053.0
2021-11-30 12:30:00	SPY	ETF	457.665	458.05	456.74	457.12	3895026.0
2021-11-30 13:00:00	SPY	ETF	457.13	457.38	456.4	457.11	4442958.0
2021-11-30 13:30:00	SPY	ETF	457.13	458.96	456.98	458.91	3955879.0
2021-11-30 14:00:00	SPY	ETF	458.9	459.32	458.36	458.43	3702513.0
2021-11-30 14:30:00	SPY	ETF	458.42	458.9199	456.9	457.35	5235276.0
2021-11-30 15:00:00	SPY	ETF	457.34	457.6699	456.31	456.5	6445867.0
2021-11-30 15:30:00	SPY	ETF	456.47	457.58	455.3	455.84	23881506.0
2021-11-30 16:00:00	SPY	ETF	455.87	457.9804	455.56	457.74	7787077.0
2021-11-30 16:30:00	SPY	ETF	457.74	458.15	455.56	458.13	872658.0
2021-11-30 17:00:00	SPY	ETF	458.13	458.13	457.99	458.02	32126.0
2021-11-30 17:30:00	SPY	ETF	458.05	458.14	457.95	458.14	42970.0
2021-11-30 18:00:00	SPY	ETF	458.2	459.1	458.18	458.36	163044.0
2021-11-30 18:30:00	SPY	ETF	455.56	458.6	455.56	457.96	113723.0
2021-11-30 19:00:00	SPY	ETF	458.06	458.72	456.86	457.1	100710.0
2021-11-30 19:30:00	SPY	ETF	457.15	457.87	456.77	457.4	79334.0
2021-11-30 04:00:00	QQQ	ETF	398.05	398.05	396.7	396.92	53209.0
2021-11-30 04:30:00	QQQ	ETF	396.97	397.9	396.57	397.87	35902.0
2021-11-30 05:00:00	QQQ	ETF	397.88	397.95	397.15	397.42	14125.0
2021-11-30 05:30:00	QQQ	ETF	397.54	397.82	397.26	397.72	23974.0
2021-11-30 06:00:00	QQQ	ETF	397.72	397.89	397.24	397.59	45204.0
2021-11-30 06:30:00	QQQ	ETF	397.72	397.92	396.93	397.19	61806.0
2021-11-30 07:00:00	QQQ	ETF	397.15	398.21	397.11	398.13	159627.0
2021-11-30 07:30:00	QQQ	ETF	398.1	398.13	397.48	397.76	241371.0
2021-11-30 08:00:00	QQQ	ETF	397.8	399.989	396.0	397.56	243696.0
2021-11-30 08:30:00	QQQ	ETF	397.62	398.82	397.15	398.81	260662.0
2021-11-30 09:00:00	QQQ	ETF	398.7	399.25	398.4	398.78	436975.0
2021-11-30 09:30:00	QQQ	ETF	398.78	400.25	397.85	399.98	5864882.0
2021-11-30 10:00:00	QQQ	ETF	399.99	401.19	399.24	400.14	4044049.0
2021-11-30 10:30:00	QQQ	ETF	400.16	400.7	393.52	393.5801	9048495.0
2021-11-30 11:00:00	QQQ	ETF	393.59	395.42	392.78	394.12	7514684.0
2021-11-30 11:30:00	QQQ	ETF	394.13	394.695	392.01	393.09	6159224.0
2021-11-30 12:00:00	QQQ	ETF	393.08	393.63	391.75	393.41	4709569.0
2021-11-30 12:30:00	QQQ	ETF	393.4191	393.95	392.76	393.06	3272139.0

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

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