PREVIEW / etf_30min / 2021-12-01

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-01.parquet
  size:    677 KB
  rows:    26,957

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-01 04:00:00	SPY	ETF	460.0	461.51	460.0	461.41	42765.0
2021-12-01 04:30:00	SPY	ETF	461.43	462.12	461.33	461.77	24234.0
2021-12-01 05:00:00	SPY	ETF	461.77	461.78	461.28	461.55	15904.0
2021-12-01 05:30:00	SPY	ETF	461.45	461.83	461.45	461.74	20996.0
2021-12-01 06:00:00	SPY	ETF	461.77	461.82	461.11	461.5	78928.0
2021-12-01 06:30:00	SPY	ETF	461.52	462.02	461.35	461.95	57852.0
2021-12-01 07:00:00	SPY	ETF	461.96	462.45	461.63	462.23	196993.0
2021-12-01 07:30:00	SPY	ETF	462.18	462.28	461.85	462.05	188477.0
2021-12-01 08:00:00	SPY	ETF	461.67	462.42	455.901	461.42	414599.0
2021-12-01 08:30:00	SPY	ETF	461.4	462.25	461.4	461.75	189428.0
2021-12-01 09:00:00	SPY	ETF	461.75	462.0	461.47	461.64	259363.0
2021-12-01 09:30:00	SPY	ETF	461.64	461.83	460.24	461.45	6655667.0
2021-12-01 10:00:00	SPY	ETF	461.48	463.16	461.47	462.26	5598672.0
2021-12-01 10:30:00	SPY	ETF	462.27	463.54	461.23	463.46	4852814.0
2021-12-01 11:00:00	SPY	ETF	463.45	464.67	463.16	464.2485	4857201.0
2021-12-01 11:30:00	SPY	ETF	464.25	464.55	462.24	462.67	4657690.0
2021-12-01 12:00:00	SPY	ETF	462.68	463.81	462.4	462.605	3476687.0
2021-12-01 12:30:00	SPY	ETF	462.61	463.02	460.27	460.46	4128034.0
2021-12-01 13:00:00	SPY	ETF	460.49	461.18	458.78	460.2452	7974643.0
2021-12-01 13:30:00	SPY	ETF	460.25	460.38	457.38	459.12	6354156.0
2021-12-01 14:00:00	SPY	ETF	459.11	459.35	456.85	458.69	6092908.0
2021-12-01 14:30:00	SPY	ETF	458.67	459.38	457.33	457.5	4399475.0
2021-12-01 15:00:00	SPY	ETF	457.48	457.83	453.13	453.865	10107368.0
2021-12-01 15:30:00	SPY	ETF	453.83	455.38	450.29	450.51	22930522.0
2021-12-01 16:00:00	SPY	ETF	450.53	458.9585	449.5	450.61	9836490.0
2021-12-01 16:30:00	SPY	ETF	450.51	462.7558	449.9	450.47	575582.0
2021-12-01 17:00:00	SPY	ETF	450.47	450.75	450.42	450.73	169061.0
2021-12-01 17:30:00	SPY	ETF	450.77	451.05	450.75	451.0	95784.0
2021-12-01 18:00:00	SPY	ETF	451.05	451.88	450.5	450.97	180961.0
2021-12-01 18:30:00	SPY	ETF	450.5	452.49	450.5	452.35	183228.0
2021-12-01 19:00:00	SPY	ETF	452.4	452.77	451.95	452.73	102734.0
2021-12-01 19:30:00	SPY	ETF	452.73	452.9	451.46	451.98	147334.0
2021-12-01 04:00:00	QQQ	ETF	397.4	399.04	397.4	398.69	88226.0
2021-12-01 04:30:00	QQQ	ETF	398.79	399.29	398.79	399.28	24547.0
2021-12-01 05:00:00	QQQ	ETF	399.26	399.26	398.84	399.01	12264.0
2021-12-01 05:30:00	QQQ	ETF	399.06	399.15	398.83	398.98	20609.0
2021-12-01 06:00:00	QQQ	ETF	399.05	399.13	398.65	398.99	15046.0
2021-12-01 06:30:00	QQQ	ETF	399.15	399.49	399.1	399.43	41332.0
2021-12-01 07:00:00	QQQ	ETF	399.43	399.75	399.27	399.66	84946.0
2021-12-01 07:30:00	QQQ	ETF	399.59	399.59	399.19	399.25	86433.0
2021-12-01 08:00:00	QQQ	ETF	399.39	399.6501	394.115	398.84	211466.0
2021-12-01 08:30:00	QQQ	ETF	398.9	399.15	398.29	398.45	136618.0
2021-12-01 09:00:00	QQQ	ETF	398.43	398.94	398.28	398.33	220077.0
2021-12-01 09:30:00	QQQ	ETF	398.29	398.66	396.6305	398.09	5644086.0
2021-12-01 10:00:00	QQQ	ETF	398.11	399.25	397.44	397.61	3761523.0
2021-12-01 10:30:00	QQQ	ETF	397.63	399.17	396.79	399.1	3099901.0
2021-12-01 11:00:00	QQQ	ETF	399.1	400.48	398.62	399.9623	2609300.0
2021-12-01 11:30:00	QQQ	ETF	399.98	400.28	397.98	398.29	2817151.0
2021-12-01 12:00:00	QQQ	ETF	398.29	399.22	397.95	398.12	1910886.0
2021-12-01 12:30:00	QQQ	ETF	398.12	398.555	395.79	395.99	2637964.0

> showing 50 of 26,957 rows — these rows as CSV

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