PREVIEW / etf_30min / 2021-11-16

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-16.parquet
  size:    638 KB
  rows:    24,654

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-16 04:00:00	SPY	ETF	467.0	467.03	466.81	466.97	11460.0
2021-11-16 04:30:00	SPY	ETF	466.98	467.23	466.98	467.23	1589.0
2021-11-16 05:00:00	SPY	ETF	467.14	467.16	466.63	466.68	5256.0
2021-11-16 05:30:00	SPY	ETF	466.88	466.96	466.84	466.89	15049.0
2021-11-16 06:00:00	SPY	ETF	466.87	467.28	466.87	467.28	62023.0
2021-11-16 06:30:00	SPY	ETF	467.27	467.86	467.27	467.85	7412.0
2021-11-16 07:00:00	SPY	ETF	467.84	467.91	467.56	467.56	44091.0
2021-11-16 07:30:00	SPY	ETF	467.59	467.62	467.35	467.48	47050.0
2021-11-16 08:00:00	SPY	ETF	467.6201	467.9	466.8996	467.66	52545.0
2021-11-16 08:30:00	SPY	ETF	467.72	468.05	467.17	467.43	135838.0
2021-11-16 09:00:00	SPY	ETF	467.37	467.39	466.9	467.12	134845.0
2021-11-16 09:30:00	SPY	ETF	467.16	469.01	467.07	468.5	3910235.0
2021-11-16 10:00:00	SPY	ETF	468.52	469.08	468.08	468.09	2250552.0
2021-11-16 10:30:00	SPY	ETF	468.1	468.57	468.05	468.39	1517920.0
2021-11-16 11:00:00	SPY	ETF	468.39	469.905	468.39	469.74	2231219.0
2021-11-16 11:30:00	SPY	ETF	469.75	469.94	469.445	469.69	2051937.0
2021-11-16 12:00:00	SPY	ETF	469.69	469.8717	469.52	469.66	1505737.0
2021-11-16 12:30:00	SPY	ETF	469.653	470.19	469.585	469.967	1427492.0
2021-11-16 13:00:00	SPY	ETF	469.9628	470.31	469.88	470.07	1451855.0
2021-11-16 13:30:00	SPY	ETF	470.08	470.4	470.08	470.35	984368.0
2021-11-16 14:00:00	SPY	ETF	470.345	470.485	469.91	470.115	1787073.0
2021-11-16 14:30:00	SPY	ETF	470.11	470.16	469.81	469.88	1425993.0
2021-11-16 15:00:00	SPY	ETF	469.88	469.9693	469.53	469.69	2038899.0
2021-11-16 15:30:00	SPY	ETF	469.685	469.98	468.98	469.24	8115478.0
2021-11-16 16:00:00	SPY	ETF	469.25	469.49	469.01	469.41	4044507.0
2021-11-16 16:30:00	SPY	ETF	469.41	469.41	469.07	469.1699	654010.0
2021-11-16 17:00:00	SPY	ETF	469.18	469.28	469.1	469.18	35894.0
2021-11-16 17:30:00	SPY	ETF	469.19	469.25	469.14	469.2	37510.0
2021-11-16 18:00:00	SPY	ETF	469.19	469.27	469.03	469.17	43415.0
2021-11-16 18:30:00	SPY	ETF	469.28	469.46	469.1596	469.43	20565.0
2021-11-16 19:00:00	SPY	ETF	469.43	469.48	469.28	469.3	14056.0
2021-11-16 19:30:00	SPY	ETF	469.28	469.39	469.2	469.35	15274.0
2021-11-16 04:00:00	QQQ	ETF	394.2	394.51	394.2	394.29	25947.0
2021-11-16 04:30:00	QQQ	ETF	394.3	394.43	394.24	394.42	30141.0
2021-11-16 05:00:00	QQQ	ETF	394.38	394.39	393.72	393.83	74428.0
2021-11-16 05:30:00	QQQ	ETF	393.9	394.05	393.87	394.03	9262.0
2021-11-16 06:00:00	QQQ	ETF	394.05	394.51	393.91	394.51	22288.0
2021-11-16 06:30:00	QQQ	ETF	394.49	394.98	394.49	394.91	88127.0
2021-11-16 07:00:00	QQQ	ETF	394.9	395.0	394.61	394.63	120672.0
2021-11-16 07:30:00	QQQ	ETF	394.64	394.76	394.35	394.6	65578.0
2021-11-16 08:00:00	QQQ	ETF	394.7701	394.91	393.7204	394.53	58125.0
2021-11-16 08:30:00	QQQ	ETF	394.8	395.23	394.04	394.19	313271.0
2021-11-16 09:00:00	QQQ	ETF	394.16	394.28	393.55	393.9	200054.0
2021-11-16 09:30:00	QQQ	ETF	393.87	396.19	393.66	395.52	3767135.0
2021-11-16 10:00:00	QQQ	ETF	395.51	396.38	394.8773	394.89	1949219.0
2021-11-16 10:30:00	QQQ	ETF	394.9001	395.8	394.81	395.69	1204258.0
2021-11-16 11:00:00	QQQ	ETF	395.66	397.53	395.65	397.305	1924529.0
2021-11-16 11:30:00	QQQ	ETF	397.32	397.58	396.94	397.07	960229.0
2021-11-16 12:00:00	QQQ	ETF	397.08	397.46	396.83	397.115	816818.0
2021-11-16 12:30:00	QQQ	ETF	397.11	397.42	396.975	397.2	664129.0

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

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