PREVIEW / etf_30min / 2021-11-24

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-24.parquet
  size:    620 KB
  rows:    24,116

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-24 04:00:00	SPY	ETF	468.02	468.2	467.6	468.08	5855.0
2021-11-24 04:30:00	SPY	ETF	468.08	468.08	466.57	466.88	17012.0
2021-11-24 05:00:00	SPY	ETF	466.82	467.36	466.82	467.18	3601.0
2021-11-24 05:30:00	SPY	ETF	467.21	467.26	466.48	466.48	5479.0
2021-11-24 06:00:00	SPY	ETF	466.46	467.22	466.33	466.95	21759.0
2021-11-24 06:30:00	SPY	ETF	466.98	467.7	466.93	467.12	27683.0
2021-11-24 07:00:00	SPY	ETF	467.13	467.38	466.81	467.03	39790.0
2021-11-24 07:30:00	SPY	ETF	466.95	467.19	466.49	466.7	59674.0
2021-11-24 08:00:00	SPY	ETF	466.73	468.25	466.57	466.97	111792.0
2021-11-24 08:30:00	SPY	ETF	466.93	467.42	465.73	465.98	381746.0
2021-11-24 09:00:00	SPY	ETF	465.97	466.33	465.6	466.06	375780.0
2021-11-24 09:30:00	SPY	ETF	466.06	466.705	465.19	466.26	6364887.0
2021-11-24 10:00:00	SPY	ETF	466.25	467.48	465.63	467.34	4730328.0
2021-11-24 10:30:00	SPY	ETF	467.34	467.65	466.71	467.41	3070517.0
2021-11-24 11:00:00	SPY	ETF	467.4	468.47	466.94	468.39	2686894.0
2021-11-24 11:30:00	SPY	ETF	468.42	468.705	467.85	468.05	3014562.0
2021-11-24 12:00:00	SPY	ETF	468.05	468.45	467.72	467.83	1647442.0
2021-11-24 12:30:00	SPY	ETF	467.82	468.6911	467.78	468.65	1281711.0
2021-11-24 13:00:00	SPY	ETF	468.65	469.02	468.51	468.83	1365661.0
2021-11-24 13:30:00	SPY	ETF	468.84	468.96	468.45	468.476	1216839.0
2021-11-24 14:00:00	SPY	ETF	468.47	469.1	467.31	467.87	3145836.0
2021-11-24 14:30:00	SPY	ETF	467.87	468.86	467.84	468.6201	2078450.0
2021-11-24 15:00:00	SPY	ETF	468.61	469.46	468.405	469.34	2616331.0
2021-11-24 15:30:00	SPY	ETF	469.34	469.57	468.86	469.37	9258421.0
2021-11-24 16:00:00	SPY	ETF	469.36	469.6	469.21	469.56	3760254.0
2021-11-24 16:30:00	SPY	ETF	469.52	469.73	469.5	469.55	91580.0
2021-11-24 17:00:00	SPY	ETF	469.5	469.57	469.5	469.55	12240.0
2021-11-24 17:30:00	SPY	ETF	469.55	469.65	469.48	469.61	18705.0
2021-11-24 18:00:00	SPY	ETF	469.63	469.82	469.6	469.72	14791.0
2021-11-24 18:30:00	SPY	ETF	469.77	469.77	469.6	469.76	5230.0
2021-11-24 19:00:00	SPY	ETF	469.77	469.95	469.7	469.9	8453.0
2021-11-24 19:30:00	SPY	ETF	469.91	470.27	469.91	470.22	23570.0
2021-11-24 04:00:00	QQQ	ETF	397.17	397.74	396.74	397.7	18967.0
2021-11-24 04:30:00	QQQ	ETF	397.69	397.69	396.25	396.65	17911.0
2021-11-24 05:00:00	QQQ	ETF	396.42	396.9	396.42	396.8	8021.0
2021-11-24 05:30:00	QQQ	ETF	396.72	396.72	395.64	395.64	26263.0
2021-11-24 06:00:00	QQQ	ETF	395.63	396.5	395.61	396.37	20942.0
2021-11-24 06:30:00	QQQ	ETF	396.38	397.13	396.38	396.46	57442.0
2021-11-24 07:00:00	QQQ	ETF	396.4	396.7	395.95	396.34	47936.0
2021-11-24 07:30:00	QQQ	ETF	396.24	396.36	395.7	395.9	73022.0
2021-11-24 08:00:00	QQQ	ETF	395.92	398.55	395.7196	396.18	145957.0
2021-11-24 08:30:00	QQQ	ETF	396.22	396.73	394.551	394.8	444141.0
2021-11-24 09:00:00	QQQ	ETF	394.78	395.1	394.3	394.92	461440.0
2021-11-24 09:30:00	QQQ	ETF	394.91	395.12	392.54	394.47	6717777.0
2021-11-24 10:00:00	QQQ	ETF	394.45	396.32	393.81	396.13	4811662.0
2021-11-24 10:30:00	QQQ	ETF	396.14	396.63	395.32	396.08	3157680.0
2021-11-24 11:00:00	QQQ	ETF	396.07	397.91	395.13	397.69	2880127.0
2021-11-24 11:30:00	QQQ	ETF	397.7	398.28	397.19	397.52	2418879.0
2021-11-24 12:00:00	QQQ	ETF	397.53	397.915	396.68	396.94	1483964.0
2021-11-24 12:30:00	QQQ	ETF	396.91	397.96	396.85	397.73	1101068.0

> showing 50 of 24,116 rows — these rows as CSV

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